10 tools from the Postgrest MCP Server, categorised by risk level.
View the Postgrest policy →pg_call_function Call a PostgreSQL function/procedure via RPC. Use POST (default) for volatile functions, GET for immutable/stable functions. Parameters are passed ... pg_count_records Count records in a table/view matching optional filters. Returns count using exact (precise but slower), planned (fast estimate from query planner)... pg_describe_table Get detailed column information for a table/view — column names, types, formats, required fields, defaults, and constraints. Parsed from the OpenAP... pg_get_schema Get the PostgREST OpenAPI schema — lists all available tables, views, functions, and their columns/types. Use this first to discover the database s... pg_list_records List records from a table/view with filtering, column selection, ordering, and pagination.
Filter syntax (PostgREST operators):
age=gt.18 ... pg_insert_records Insert one or more records into a table. Pass a single object or array of objects. Use return="representation" to get the created records back. 2/5 pg_replace_record Full replace (PUT) a single record matching a filter. All columns must be specified including the primary key. Creates the record if it does not ex... 2/5 pg_update_records Update records matching a filter. IMPORTANT: filter is required to prevent accidental full-table updates. Use return="representation" to see update... 2/5 pg_upsert_records Insert or update records (upsert). Uses "merge-duplicates" (update existing) or "ignore-duplicates" (skip existing) resolution. Conflict detection ... 2/5 The Postgrest MCP server exposes 10 tools across 3 categories: Read, Write, Destructive.
Use Intercept, the open-source MCP proxy. Write YAML rules for each tool — rate limits, argument validation, or deny rules — then run Intercept in front of the Postgrest server.
Postgrest tools are categorised as Read (5), Write (4), Destructive (1). Each category has a recommended default policy.
Open source. One binary. Zero dependencies.
npx -y @policylayer/intercept