---
title: "Lists SQL snippets for the logged in user"
method: GET
path: "/v1/snippets"
tags: ["Database"]
---

# Lists SQL snippets for the logged in user

`GET /v1/snippets`

## Query parameters

- `project_ref` string
- `cursor` string
- `limit` string
- `sort_by` 'name' | 'inserted_at'
- `sort_order` 'asc' | 'desc'

## Response `200`

- SnippetList
  - `data` object[], required
    - `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
  - `cursor` string

## Other responses

- `401` — Unauthorized
- `403` — Forbidden action
- `429` — Rate limit exceeded
- `500` — Failed to list user's SQL snippets

---

[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)