postgrest
About postgrest
PostgREST is a standalone web server that turns any PostgreSQL database into a RESTful API. It automatically generates API endpoints based on the database schema, providing a standards-compliant interface for data access.
The server is written in Haskell and uses the Warp HTTP server for performance. It delegates many operations to PostgreSQL itself, including JSON serialization, data validation, and authorization checks. This approach maintains data integrity while offering efficient API access.
Key features
- Automatic generation of RESTful API endpoints from PostgreSQL schema
- Authentication via JSON Web Tokens with database role delegation
- Performance optimization through PostgreSQL binary protocol and connection pooling
- API versioning through database schemas
- OpenAPI standard documentation generation
- Data integrity enforcement through PostgreSQL constraints
Download v14.15
Jul 13, 2026WindowsWindows
Frequently asked questions
- Is postgrest free?
- Yes. postgrest is free and open-source software, distributed under the MIT license.
- Which platforms does postgrest support?
- postgrest provides downloads for Windows.
- What is the latest version of postgrest?
- The latest version is v14.15, released on Jul 13, 2026.
- How do I install PostgREST?
- Installation instructions are available in the documentation, including Docker installation options.
- What platforms does PostgREST support?
- PostgREST runs as a standalone server and can be installed on various platforms, with specific installation methods documented.
- How does PostgREST handle security?
- It uses JWT for authentication and delegates authorization to PostgreSQL role permissions, ensuring database-level security.
- Is PostgREST open source?
- Yes, PostgREST is an open source project with contributions welcomed under its GitHub repository.
More Data & Database
netdata
netdata
Netdata provides full stack observability with AI-powered insights, designed to be efficient and accessible for small teams. It focuses on delivering fast and comprehensive monitoring capabilities.
meilisearch
meilisearch
Meilisearch is a fast search engine API designed to integrate AI-powered hybrid search functionality into websites and applications. It focuses on delivering efficient and accurate search results for enhanced user experiences.
etcd
etcd-io
etcd is a distributed key-value store designed for reliably storing critical data in distributed systems. It provides consistent and highly available storage for configuration data, service discovery, and coordination.