{"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)","canonicalUrl":"https://www.xpersona.co/mcp/smithery-node2flow-postgrest","sourceUrl":"https://github.com/node2flow-th/postgrest-mcp-community","homepage":"https://github.com/node2flow-th/postgrest-mcp-community","source":"SMITHERY","vendor":{"slug":"node2flow-th","label":"Node2flow Th","url":"https://github.com/node2flow-th/postgrest-mcp-community"},"protocols":["MCP"],"capabilities":[],"trustScore":null,"trustConfidence":"unknown","artifactCount":0,"benchmarkCount":0,"lastRelease":null,"freshnessAt":"2026-04-17T06:33:51.829Z","freshnessLabel":"Apr 17, 2026","securityReviewed":true,"openapiReady":false,"stats":[{"label":"Trust score","value":"Unknown"},{"label":"Compatibility","value":"MCP"},{"label":"Freshness","value":"Apr 17, 2026"},{"label":"Vendor","value":"Node2flow Th"},{"label":"Artifacts","value":"0"},{"label":"Benchmarks","value":"0"},{"label":"Last release","value":"Unpublished"}],"factsPreview":[{"factKey":"vendor","label":"Vendor","value":"Node2flow Th","category":"vendor","href":"https://github.com/node2flow-th/postgrest-mcp-community","sourceUrl":"https://github.com/node2flow-th/postgrest-mcp-community","sourceType":"profile","confidence":"medium","observedAt":"2026-04-16T06:45:16.863Z","isPublic":true,"metadata":{}},{"factKey":"protocols","label":"Protocol compatibility","value":"MCP","category":"compatibility","href":"https://xpersona.co/api/v1/agents/smithery-node2flow-postgrest/contract","sourceUrl":"https://xpersona.co/api/v1/agents/smithery-node2flow-postgrest/contract","sourceType":"contract","confidence":"medium","observedAt":"2026-04-16T06:45:16.863Z","isPublic":true,"metadata":{}},{"factKey":"docs_crawl","label":"Crawlable docs","value":"6 indexed pages on the official domain","category":"integration","href":"https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fopenclaw%2Fskills%2Ftree%2Fmain%2Fskills%2Fasleep123%2Fcaldav-calendar","sourceUrl":"https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fopenclaw%2Fskills%2Ftree%2Fmain%2Fskills%2Fasleep123%2Fcaldav-calendar","sourceType":"search_document","confidence":"medium","observedAt":"2026-04-15T05:03:46.393Z","isPublic":true,"metadata":{}},{"factKey":"handshake_status","label":"Handshake status","value":"UNKNOWN","category":"security","href":"https://xpersona.co/api/v1/agents/smithery-node2flow-postgrest/trust","sourceUrl":"https://xpersona.co/api/v1/agents/smithery-node2flow-postgrest/trust","sourceType":"trust","confidence":"medium","observedAt":null,"isPublic":true,"metadata":{}}],"highlights":["Trust evidence available"],"agentCard":{"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)","source":"SMITHERY","sourceId":"smithery:node2flow/postgrest","homepage":"https://github.com/node2flow-th/postgrest-mcp-community","repository":"https://github.com/node2flow-th/postgrest-mcp-community","documentation":"https://www.xpersona.co/mcp/smithery-node2flow-postgrest/agent/smithery-node2flow-postgrest","protocols":["MCP"]}}