PostgREST

MCP server for PostgREST — REST API layer for PostgreSQL databases.

Features

• Discover database schema (tables, views, functions, columns)
• Query records with PostgREST filter syntax (eq, gt, like, in, fts, or)
• Resource embedding — JOIN related tables via select parameter
• Full CRUD operations (insert, update, upsert, delete, replace)
• Call stored PostgreSQL functions via RPC
• Count records with exact, planned, or estimated methods

10 Tools

Schema: get OpenAPI schema, describe table columns/types Read: list records with filters/select/order/pagination, count records, call functions (RPC) Write: insert, update, upsert (merge/ignore duplicates), delete, replace (PUT)

Configuration

• POSTGREST_URL — Your PostgREST server URL (e.g. http://localhost:3000)
• POSTGREST_TOKEN — JWT token for authenticated requests (optional)