Postgrest

PostgREST is a standalone web server that automatically transforms a PostgreSQL database into a RESTful API. It serves as an API gateway that translates HTTP requests into SQL queries, mapping the database schema directly to endpoints without the need for manual route definitions.

The system utilizes a JWT authentication layer to validate user identities and map incoming web requests to specific database roles. This allows the server to delegate authorization and permission enforcement to the internal PostgreSQL role system.

It includes a generator for OpenAPI specifications to provide standardized documentation for exploring and testing endpoints. The project also supports database schema versioning to allow the data interface to evolve without breaking existing client integrations.

Features

Database-to-REST Interfaces - Provides an automated system that transforms PostgreSQL database schemas directly into a RESTful API.

Database REST APIs - Automatically transforms a PostgreSQL database schema into a set of RESTful endpoints for programmatic data access.

HTTP Data Interfaces - Provides a direct way for frontend applications to query and modify Postgres data via HTTP requests.

Database Query Translators - Translates HTTP request parameters and filters into valid PostgreSQL SQL statements for data operations.

Database Schema Introspection Tools - Analyzes database system catalogs at runtime to automatically derive the API structure and available endpoints.

Database - Acts as a gateway that translates HTTP requests into SQL queries while enforcing database-level permissions.

Database Access Controls - Enforces granular access control by delegating permissions to the underlying database role system.

Identity-Based Authentication - Verifies incoming requests using signed JWTs to assign the appropriate database identity.

JWT Authentication - Uses a JWT authentication layer to validate identities and map them to database roles.

Role-Based Access Control - Delegates authorization to the PostgreSQL role system by executing queries under restricted database user roles.

Identity Mapping - Maps validated JWT claims to specific database roles to enforce request-level security policies.

Schema Versioning - Handles schema versioning to allow the data interface to evolve without impacting existing clients.

Automatic Specification Generators - Automatically derives OpenAPI specifications from the database schema to enable interactive testing.

API Documentation Generators - Produces standardized OpenAPI specifications to provide interactive documentation and testing guides for endpoints.

API Versioning Strategies - Supports API versioning by exposing different database schema versions to prevent breaking client integrations.

Stateless Architectures - Implements a stateless architecture that relies on the database for session and state management.

API Frameworks - Serves a RESTful API directly from a PostgreSQL database.

begriffspostgrest

Features

Star history