{"id":"028679f7-5df9-4488-8a21-23f9ea976656","slug":"smithery-node2flow-postgrest","name":"PostgREST","description":"MCP server for PostgREST — REST API layer for PostgreSQL\n   databases.\n\n  ## Features\n  - Discover database schema (tables, views, functions,\n  columns)\n  - Query records with PostgREST filter syntax (eq, gt,\n  like, in, fts, or)\n  - Resource embedding — JOIN related tables via select\n  parameter\n  - Full CRUD operations (insert, update, upsert, delete,\n  replace)\n  - Call stored PostgreSQL functions via RPC\n  - Count records with exact, planned, or estimated\n  methods\n\n  ## 10 Tools\n\n  **Schema**: get OpenAPI schema, describe table\n  columns/types\n  **Read**: list records with\n  filters/select/order/pagination, count records, call\n  functions (RPC)\n  **Write**: insert, update, upsert (merge/ignore\n  duplicates), delete, replace (PUT)\n\n  ## Configuration\n  - POSTGREST_URL — Your PostgREST server URL (e.g.\n  http://localhost:3000)\n  - POSTGREST_TOKEN — JWT token for authenticated requests\n   (optional)","capabilities":[],"protocols":["MCP"],"safetyScore":86,"overallRank":36.5,"trustScore":null,"trust":null,"source":"SMITHERY","updatedAt":"2026-04-17T06:33:51.829Z"}