---
title: "Gets a specific SQL snippet"
method: GET
path: "/v1/snippets/{id}"
tags: ["Database"]
---

# Gets a specific SQL snippet

`GET /v1/snippets/{id}`

## Path parameters

- `id` string, uuid, required

## Response `200`

- SnippetResponse
  - `id` string, required
  - `inserted_at` string, required
  - `updated_at` string, required
  - `type` 'sql', required
  - `visibility` 'user' | 'project' | 'org' | 'public', required
  - `name` string, required
  - `description` string, nullable, required
  - `project` object, required
    - `id` number, required
    - `name` string, required
  - `owner` object, required
    - `id` number, required
    - `username` string, required
  - `updated_by` object, required
    - `id` number, required
    - `username` string, required
  - `favorite` boolean, required
  - `content` object, required
    - `favorite` boolean — Deprecated: Rely on root-level favorite property instead.
    - `schema_version` string, required
    - `sql` string, required

## Other responses

- `401` — Unauthorized
- `403` — Forbidden action
- `429` — Rate limit exceeded
- `500` — Failed to retrieve SQL snippet

---

[API](https://skmtc.dev/supabase/apis/management-api.md) · [All operations](https://skmtc.dev/supabase/apis/management-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/supabase/management-api/revisions/a7cb39418064/schema)