Every table and view in public is available over HTTP as soon as you create it, together with your functions.
Querying
Select rows, related rows and counts.
Filtering and pagination
Operators, ordering and ranges.
Insert, update and delete
Write data with JSON bodies, upsert.
Functions (RPC)
Call Postgres functions over HTTP.
#Authentication
Send your key in the apikey header. To act as a signed-in user, also send their access token as a bearer token.
Terminal
curl 'https://<project-ref>.p.stitchdb.com/rest/v1/todos?select=id,task&is_complete=eq.false' \
-H "apikey: <anon-key>" \
-H "Authorization: Bearer <user-access-token>"Row Level Security runs on every request. Requests without a valid key get 401 Invalid API key.
#API docs in Studio
Studio → API shows generated docs for each of your tables and functions with ready-to-copy JavaScript and cURL, and API → Keys lists your keys.
#Schema changes
The API reloads its schema automatically when you create or change tables, views or functions.