PostgREST
postgrest.orgTurns your PostgreSQL database directly into a RESTful API
Dev Toolspostgresqlrest-apiopen-sourcebackenddatabaseapi-generationcrud
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.
Problem
Building RESTful APIs manually requires writing repetitive CRUD code that often duplicates or conflicts with the underlying database structure.
For
backend developers and database administrators
How it works
PostgREST reads the PostgreSQL schema, constraints, and role permissions at runtime to automatically expose them as RESTful HTTP endpoints.
Business model
open-source
Status
launched