PostgREST

PostgREST is a server (originally Haskell, now with Rust experiments) that introspects a Postgres schema and exposes a standards-conformant REST API automatically. URLs map to tables: GET /rest/v1/posts?status=eq.published is a typed, RLS-protected query.

Why it matters: PostgREST is what makes Supabase work. The client SDK isn't a custom protocol; it's HTTP requests against PostgREST. Authentication is via JWT; PostgREST forwards the claims into Postgres GUCs so RLS can evaluate per-row authorization.

For AI agents, PostgREST is the cleanest schema-to-API surface in the industry. GET /rest/v1/ returns an OpenAPI document describing every table, column, type, and foreign key. One HTTP call, full schema, no driver-specific quirks.