Open SourceDatabase27k
PostgREST
Serve a full REST API straight out of any Postgres database.
PostgREST is a standalone web server that turns a PostgreSQL database directly into a RESTful API, deriving endpoints and routes automatically from the database schema. Authorization is delegated to the database via roles and row-level security, so the API surface stays in sync with the schema without a separate application tier.
Repository
PostgREST/postgrestLanguage
HaskellWhat you'd build with it
- Expose a Postgres schema as a REST API with no backend code (the pattern Supabase's data API is built on)
- Build a thin data layer for an app where access control is enforced through Postgres roles and RLS
- Quickly prototype CRUD endpoints over a relational schema for an AI agent or tool to call
Tags
restpostgresapi