{"data":{"slug":"postgrest","name":"PostgREST","tagline":"MIT instant REST API for any Postgres schema","category":"databases","categoryName":"Databases","url":"https://postgrest.org","github":"https://github.com/PostgREST/postgrest","pricing":"open-source","hook":"PostgREST turns your Postgres schema, views, and RLS into a standards-shaped REST API — no hand-rolled CRUD layer.","whatsGood":"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.","theCatch":"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.","addedAt":"2026-09-16","featured":false,"domain":"Databases","subSpecialty":"Data","subcategory":"Query Builders & Codegen","tags":["api","self-host","permissive","postgres","active"],"capabilities":["api"],"surfaces":["API","Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"OSS/MIT","githubStars":27722,"starsPerWeek":43,"access":"free","archived":false,"repo":{"createdAt":"2014-06-13","pushedAt":"2026-10-18","license":"MIT","archived":false,"checkedAt":"2026-10-19"}},"related":[{"slug":"supabase","name":"Supabase","tagline":"Open-source Firebase alternative built on Postgres"},{"slug":"turso","name":"Turso","tagline":"SQLite at the edge with libSQL"},{"slug":"redis","name":"Redis","tagline":"The in-memory data store everyone uses"},{"slug":"upstash","name":"Upstash","tagline":"Serverless Redis and Kafka"},{"slug":"pinecone","name":"Pinecone","tagline":"Vector database for AI applications"}],"links":{"self":"/api/gems/postgrest","html":"/gems/postgrest","markdown":"/gems/postgrest.md","category":"/api/gems?category=databases","categoryPage":"/stacks/databases"}}