postgrest.org

PostgREST is an open-source server that turns a PostgreSQL database schema into a RESTful API. It uses database roles and permissions to control what API clients can access.

2 integrations · REST · CLI

PostgREST exposes a self-hosted HTTP REST API per deployment, with a generated OpenAPI document at each server’s root path, plus a local `postgrest` CLI binary; no GraphQL or MCP surfaces were found.

discovered 2mo ago

REST · OpenAPI1

PostgREST HTTP APIdiscoveredrest

CLI1

postgrest CLIdiscoveredpostgrest

Credentials

JWT bearer token for a PostgREST APIjwt

PostgREST does not issue tokens itself; the database administrator configures JWT verification and clients use a JWT generated either from inside the database or by an external service, as described in Authentication. The token must contain a role claim matching a PostgreSQL role the configured authenticator can SET ROLE into.

conventions · 0/8 published

integrations.json✗/.well-known/integrations.json
llms.txt✗/llms.txt
API catalog✗/.well-known/api-catalog
OpenAPI document✗/api/schema/, /openapi.json, /swagger.json, /api/openapi.json, or /v1/openapi.json
MCP server card✗/.well-known/mcp/server-card.json
OAuth protected resource✗/.well-known/oauth-protected-resource
Agent card✗/.well-known/agent-card.json
Agent skills✗/.well-known/agent-skills/index.json

Publish these signals → /publishing