Documentation
Everything you need to build, deploy, and scale your PostgreSQL API with Postrust.
Quick Start
Get your PostgreSQL API running in under 5 minutes with Docker.
-e DATABASE_URL="..." \
postrust/postrust
Getting Started
Quick start guide to get your first API running in minutes
API Reference
Complete reference for REST endpoints, operators, and headers
GraphQL
Full GraphQL API with queries, mutations, subscriptions, and filtering
Realtime Subscriptions
Live data updates via GraphQL subscriptions and PostgreSQL LISTEN/NOTIFY
pgvector Integration
Vector similarity search for AI apps, semantic search, and RAG pipelines
Custom Routes
Define custom Rust handlers for webhooks, business logic, and more
SaaS Domains (Beta)
Multi-tenant custom domains with automatic SSL and dynamic routing
Authentication
JWT authentication and PostgreSQL Row-Level Security
Configuration
Environment variables and runtime configuration options
Deployment
Deploy to Docker, AWS Lambda, Kubernetes, and more
Cloudflare Workers
The REST API in a Worker over Hyperdrive, and every way it differs from the server
Benchmarks
Measured binary size, latency and memory, and the script that reproduces them
Conformance
How closely Postrust matches PostgREST and Hasura, measured against each by replaying its own test suite
PostgREST Conformance
The REST report: what agrees, and where the two differ on purpose
Hasura Conformance
The GraphQL report: what agrees, and where the two differ on purpose
Guides
Row-level security behind an API, GraphQL from a schema, and how the tools compare
Engineering Guides
Deep dives into generating REST and GraphQL APIs from PostgreSQL, enforcing Row-Level Security, and comparing API servers.
Build an API from PostgreSQL: REST and GraphQL in 2026
Three ways to build an API from PostgreSQL, what a generated API gives you, and a worked example serving REST and GraphQL with Postrust.
Row-Level Security for a PostgreSQL API
Engineering teams usually enforce API access control in PostgreSQL: a JWT picks the role, GRANTs pick the tables, RLS picks the rows.
PostgreSQL to GraphQL tools compared, 2026
Hasura, PostGraphile, Supabase pg_graphql, PostgREST and Postrust compared as of October 2026: permissions, REST, subscriptions, Federation, hosting.
How GraphQL APIs Are Generated from a PostgreSQL Schema
How a GraphQL API is generated from a PostgreSQL schema: catalogue introspection, type mapping, root fields, one-statement SQL and RLS.
Apollo Federation and Open-Source Subgraphs
What Apollo Federation is, what a subgraph must implement, and which open-source tools serve PostgreSQL as a subgraph, as of October 2026.
Languages Used to Build PostgreSQL API Servers
Which languages PostgreSQL API servers are written in, from Haskell to Rust, and what the runtime changes: memory, cold starts and deployment.