PostgREST

PostgREST is a standalone web server that turns a PostgreSQL database into a RESTful API. The structure and permissions inside the database decide which endpoints exist and what each one allows.

You describe tables, views and functions in the database, and PostgREST exposes them over HTTP. Authorization uses database roles and permissions, so you do not have to write guard code for each route. The project has a narrow focus and works well alongside tools such as Nginx.

• REST API generated from a PostgreSQL schema
• Permissions enforced by database roles
• Views and functions exposed as endpoints
• Joins handled by the database query planner
• Works well alongside Nginx and other web tools

Teams that want a fast CRUD API on top of Postgres without writing a custom server, and backend developers who prefer to keep business rules in SQL.

PostgREST is open source under the MIT licence and free to use. It runs as a separate process next to your database. Views and SQL functions have performance implications, so test queries on realistic data before launch.