Query rows from a Supabase table via the Data REST API with column filters, logical operators, ordering, and pagination, including retrieving an exact or estimated row count.

Documented steps

1. Base request: GET https://<project_ref>.supabase.co/rest/v1/{table}?select=* with header 'apikey: <PUBLISHABLE_KEY>' (add 'Authorization: Bearer <user_access_token>' if querying as an authenticated user so RLS sees auth.uid()). Example: curl 'https://<ref>.supabase.co/rest/v1/leaderboard?select=*&order=score.desc' -H 'apikey: <PUBLISHABLE_KEY>'.
2. Filter with operator syntax appended after '=': eq. gt. gte. lt. lte. neq. like. ilike. in. is. fts./plfts./phfts./wfts. (full-text search), cs. cd. ov. and more. Examples: ?age=gte.18&student=is.true, ?status=in.(active,pending), ?name=ilike.*doe*. Use * as a shortcut for % in like/ilike to avoid URL-encoding %.
3. Combine conditions with logical operators: multiple query params AND together by default; use or=(cond1,cond2) for OR, e.g. ?or=(age.eq.14,and(age.gte.11,age.lte.17)); prefix any operator with not. to negate it, e.g. ?a=not.eq.2.
4. Order results with order=column.direction[.nullsfirst|.nullslast], comma-separated for multiple keys, e.g. ?order=age.desc,height.asc (defaults to ascending if direction omitted).
5. Paginate with limit and offset query params, e.g. ?limit=15&offset=30, OR with Range headers, e.g. -H 'Range-Unit: items' -H 'Range: 0-19' for the first 20 rows. Responses include a Content-Range header (e.g. 'Content-Range: 0-19/*') you can read to drive further pagination.
6. For a total row count, add 'Prefer: count=exact' (precise but counts the whole filtered set — slow on large tables), 'Prefer: count=planned' (fast, uses Postgres planner statistics, needs ANALYZE to stay accurate), or 'Prefer: count=estimated' (exact under the db-max-rows threshold, planned above it). The count appears in Content-Range, e.g. 'Content-Range: 0-24/3573458'.
7. Docs: https://docs.postgrest.org/en/latest/references/api/tables_views.html https://docs.postgrest.org/en/latest/references/api/pagination_count.html https://supabase.com/docs/guides/api/quickstart