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)
Composite of vulnerability cleanliness, spec conformance, provenance, stability, and usage signals — scanned and weighted by Cognium. Human and agent signals are tracked separately. Last scanned 2026-09-28.
Scan details: Circle-IR · 2026-09-28 · Appeal
View full trust & usage report →Metadata
- Version
- 1.0.0
- Skill type
- atomic
- Execution layer
- mcp-remote
- Category
- database
- Source
- Smithery
- Author type
- human
- Last scanned
- 2026-09-28
- Updated
- 2026-09-28
Use via MCP
Resolve PostgREST from your agent
Streamable HTTP transport at https://api.skillsregistry.net/mcp. No auth for read tools. Discovery: .well-known/mcp.json.
One command in your shell — Claude Code wires it up and verifies the connection. Run /mcp in any session to confirm.
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp--scope user for --scope project to commit it to .mcp.json.