PostgREST

Health v2 · maintenance only

Adoption not part of the score

27693 stars · 1229 forks observed · 2026-10-04

What it is AI-extracted, prompt v1, taxonomy v1, 2026-10-05, confidence 0.98

PostgREST is a standalone web server that automatically creates a fully RESTful API from any PostgreSQL database. It translates database schemas, views, and permissions directly into HTTP endpoints.

Use cases

• Expose an existing PostgreSQL database as a CRUD REST API without writing code
• Rapidly prototype a backend for a web or mobile app using only SQL definitions
• Create a data‑centric API layer that respects database permissions and constraints
• Serve geo‑JSON or other custom media types directly from PostGIS tables
• Deploy a lightweight API server in containers or on a VM for micro‑service architectures

When to choose

• You need a fast, standards‑compliant API generated directly from PostgreSQL
• You want to avoid writing boilerplate CRUD code or using an ORM
• Your data model is already defined in the database and you can express business rules with views and row‑level security
• You prefer a single source of truth (the database) for both data and API definitions

When to avoid

• You require complex business logic that cannot be expressed in SQL or database views
• You need support for databases other than PostgreSQL
• You need GraphQL, real‑time subscriptions, or extensive custom authentication beyond JWT/role‑based checks
• Your application relies heavily on server‑side code execution beyond simple CRUD operations

Facets

service · maturity active

http-server api-framework database-driver auth authorization web-development backend databases windows bsd self-hosted postgresql rest haskell no-orm jwt openapi docker-image linux macos docker

Member repositories

For agents

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