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)