PostgREST/postgrest

Health v2 · maintenance only

Adoption not part of the score

27629 stars · 1228 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

PostgREST is a standalone web server that automatically exposes any existing PostgreSQL database as a fully RESTful HTTP API. Written in Haskell, it introspects the database schema and serves standards-compliant endpoints with filtering, pagination, and authentication support.

Use cases

• expose a postgres database as a rest api without writing backend code
• automatically generate an api from database tables
• build a crud api for an existing postgres schema
• replace a hand-written backend with a database-driven api
• serve json api endpoints with filtering and pagination from sql
• quickly prototype an api backed by postgres

When to choose

• you have a well-designed PostgreSQL schema and want a REST API immediately
• you want to avoid writing and maintaining boilerplate CRUD backend code
• you need a fast, standards-compliant API layer over Postgres
• you prefer database-level authorization (roles, RLS) over application logic

When to avoid

• you need complex custom business logic beyond what SQL functions can express
• you use a database other than PostgreSQL
• you need a GraphQL API rather than REST
• your API contract must diverge significantly from your database schema

Facets

service · maturity stable

http-server api-framework database routing auth databases apis backend web-development self-hosted windows self-hosted postgresql rest-api automatic-api haskell database-to-api linux macos docker web-server

Member repositories

For agents

markdown · JSON · MCP: product_card(name="PostgREST/postgrest")