PostgreSQL MCP
Execute SQL queries, inspect schema, and manage data in PostgreSQL databases. High blast-radius: scope to read-only roles where possible.
Overview
| Catalog ID | mcp-postgres |
| Category | database |
| Auth method | Bearer token |
| Blast radius | high |
| Trust | Verified — published by cendriix |
| Version | 1.2.0 |
| Regions | us-east-1, eu-west-1, ap-southeast-1 |
Tools
| Tool | Description |
|---|---|
run_query | Execute a SQL query against PostgreSQL. |
list_tables | List tables in the database. |
describe_table | Get the schema of a table. |
insert_row | Insert a row into a table. |
run_migration | Execute a SQL migration script. |
Tool parameters
run_query
Execute a SQL query against PostgreSQL.
| Parameter | Type | Description | |
|---|---|---|---|
query | string | required | SQL query |
params | array | optional | Query parameters |
list_tables
List tables in the database.
| Parameter | Type | Description | |
|---|---|---|---|
schema | string | optional | Schema name (default: public) |
describe_table
Get the schema of a table.
| Parameter | Type | Description | |
|---|---|---|---|
table_name | string | required | Table name |
schema | string | optional | Schema name |
insert_row
Insert a row into a table.
| Parameter | Type | Description | |
|---|---|---|---|
table_name | string | required | Table name |
data | object | required | Column-value pairs |
run_migration
Execute a SQL migration script.
| Parameter | Type | Description | |
|---|---|---|---|
sql | string | required | Migration SQL |
description | string | optional | Migration description |
Installing
- In Cendriix, go to Settings → MCPs
- Find PostgreSQL and click Install
- Provide a bearer/service token after installing. It is validated, then encrypted at rest in a secrets vault scoped to your tenant.
- Click Test Connection to run a health check and list available tools
Authentication. Provide a bearer/service token after installing. It is validated, then encrypted at rest in a secrets vault scoped to your tenant.
Blast radius
This MCP is classified high. This MCP can modify infrastructure or reach sensitive data. High-blast-radius tool calls require explicit approval when your organisation enables approval gates in Policies.
Every tool invocation is recorded in your Audit Log. You can remove this MCP at any time from Settings → MCPs, which revokes tool access immediately.
Further reading
- MCP Marketplace — browse and install MCPs
- Policies & Guardrails — approval gates and blast radius
- Audit Log — review tool invocations