PostgREST

postgrest.org

Turns your PostgreSQL database directly into a RESTful API

Visit
PostgREST screenshot
/ About /

PostgREST is a standalone web server that automatically generates a RESTful API from a PostgreSQL database, using the database's own structure, constraints, and permissions to define endpoints. It eliminates the need for manual CRUD programming and ORM layers by treating the database as the single source of truth. It is used in production by companies like Supabase, Catarse, and others.

/ How it works /

PostgREST reads the PostgreSQL schema, constraints, and role permissions at runtime to automatically expose them as RESTful HTTP endpoints.

/ Who it's for /

backend developers and database administrators

/ More info /

Background.

Status
launched
Business model
open-source
/ Discovered patterns /

Similar projects.

Coming soonSpektrail’s read on Dev Tools

Editorial take on the space this project sits in — momentum signals, adjacent moves, our call on whether the wedge is real. Get pinged when we publish a new read or when the landscape shifts.

Coming soon

Have a take on this space?

Tell us what you’d build differently, where you think the incumbents miss, or what we’ve gotten wrong about this project. Comments + reactions are coming soon.