PostgREST
MIT instant REST API for any Postgres schema
Databases / Data · OSS/MIT · 27.7k
Reviewed 2026-09-16 · last push 2026-10-18 · repo checked 2026-10-19
What's Good
MIT (PostgREST/postgrest). Single binary: expose tables/views/functions over HTTP with JWT + Postgres RLS as the authz model. Battle-tested (~28k★); docs at postgrest.org. Pairs cleanly with Supabase-shaped stacks or bare Postgres.
The Catch
Vs Prisma/Drizzle (typed app ORMs) and Hasura (GraphQL instant API): PostgREST is REST-from-schema, not an ORM and not GraphQL. Complex business workflows still want app code; you lean on SQL views/RPCs and RLS design instead of controllers.
Verdict
MIT REST-for-Postgres. Schema+RLS as API vs ORM/GraphQL twins; SQL-first teams win.
Embed
Maintainer? Add the badge to your README. It is free, links to this review, and there is no paid version.
Markdown
[](https://stackgems.com/gems/postgrest)
HTML
<a href="https://stackgems.com/gems/postgrest"><img src="https://stackgems.com/badge/postgrest.svg" alt="PostgREST reviewed on Stack Gems" height="20"></a>