PostgREST

smithery.ai/node2flow/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)