PostgREST
PostgREST is an approach (and tool) that turns a PostgreSQL database directly into a RESTful API, generating endpoints from your schema and enforcing access with database permissions.
PostgREST and PostgREST-style APIs expose your PostgreSQL tables and views as REST endpoints automatically. Querying, filtering, ordering, and pagination are driven by the URL, so you don't write CRUD controllers.
Security stays in the database: PostgreSQL roles and row-level security policies determine what each request can read or write, rather than scattering permission checks across application code.
This pattern dramatically reduces backend boilerplate while keeping standard SQL as the single source of truth for both data and access control.
Related terms
PostgREST in Kolaybase
See it in practice
Kolaybase gives you PostgreSQL, auth, storage, and a REST API in minutes.