Everything you need to build APIs

Postrust provides a complete solution for exposing your PostgreSQL database as a secure, high-performance REST and GraphQL API.

REST API

PostgREST-compatible REST API with advanced querying capabilities

CRUD Operations

Full create, read, update, delete support on tables and views

Advanced Filtering

eq, neq, gt, lt, gte, lte, like, ilike, in, is, not operators

Full-Text Search

fts, plfts, phfts, wfts operators with language support

Resource Embedding

Automatic JOINs via foreign keys with nested resources

Pagination

Limit, offset, and Range header support

Column Selection

Select specific columns with aliasing and computed fields

GraphQL API

Full GraphQL support with automatic schema generation

Dynamic Schema

GraphQL schema automatically generated from your database

Queries & Mutations

Read and write operations with full filtering support

Nested Relationships

Query related data in a single request

Introspection

Full schema introspection for tooling support

GraphQL Playground

Built-in interactive IDE at /admin/graphql

Same RLS

Same Row-Level Security enforcement as REST

Security

Enterprise-grade security with PostgreSQL Row-Level Security

JWT Authentication

HS256, HS384, HS512 signature verification

Row-Level Security

PostgreSQL RLS policies enforced on every request

Role-Based Access

Map JWT claims to PostgreSQL roles

Custom Claims

Access JWT claims in your SQL policies

Anonymous Role

Configurable unauthenticated access

Audience Validation

Optional JWT audience claim verification

Developer Experience

Built-in tools for development and debugging

Admin Dashboard

Central hub with links to all dev tools

Swagger UI

Interactive API documentation and testing

Scalar Docs

Modern, beautiful API documentation

OpenAPI Spec

Auto-generated OpenAPI 3.0 specification

Structured Logging

JSON logs with request tracing

Health Checks

/_/health and /_/ready endpoints

Deployment

Deploy anywhere with native serverless support

Docker

Official container image ready to use

AWS Lambda

Native Lambda adapter with connection pooling

Cloudflare Workers

Edge deployment with Hyperdrive support

Kubernetes

Production-ready with health checks

Single Binary

~5MB binary with no dependencies

Any Platform

Fly.io, Railway, Render, DigitalOcean, etc.

Extensibility

Extend Postrust with custom Rust code

Custom Routes

Add your own endpoints in Rust

Webhook Handlers

Process Stripe, GitHub, and other webhooks

RPC Functions

Call PostgreSQL stored procedures

Middleware

Add custom request/response processing

Type Safety

Compile-time guarantees with Rust

Async Runtime

Built on Tokio for high concurrency

Ready to get started?

Set up your PostgreSQL API in under 5 minutes.

Read the Documentation