Supabase · Example Payload

Supabase Select Rows Example

Query rows from a database table via the Supabase PostgREST API with filtering and ordering

Backend-as-a-ServicePostgreSQLOpen-SourceAuthenticationReal-TimeStorageEdge FunctionsDatabase

Supabase Select Rows Example is an example object payload from Supabase, with 4 top-level fields. It illustrates the shape of data this provider's APIs accept or return.

Top-level fields

operationdescriptionrequestresponse

Example Payload

Raw ↑
{
  "operation": "selectRows",
  "description": "Query rows from a database table via the Supabase PostgREST API with filtering and ordering",
  "request": {
    "method": "GET",
    "url": "https://abcdefghijklmnop.supabase.co/rest/v1/todos?select=id,title,completed,created_at&completed=eq.false&order=created_at.desc&limit=20",
    "headers": {
      "apikey": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.anon_key_here",
      "Authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.user_jwt_here",
      "Content-Type": "application/json",
      "Prefer": "count=exact"
    }
  },
  "response": {
    "statusCode": 200,
    "headers": {
      "Content-Range": "0-1/2",
      "Content-Type": "application/json; charset=utf-8"
    },
    "body": [
      {
        "id": 1,
        "title": "Build the API",
        "completed": false,
        "created_at": "2026-05-02T09:00:00Z"
      },
      {
        "id": 2,
        "title": "Write documentation",
        "completed": false,
        "created_at": "2026-05-01T14:30:00Z"
      }
    ]
  }
}

Work with this as data

Every example here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for examples

4 MCP tools reach this
  • find_examplesBrowse and filter every example in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This example
curl "https://apis.io/api/v1/examples/supabase-select-rows-example"
All examples
curl "https://apis.io/api/v1/examples?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.