What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
What is the pgmcp MCP server?
Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
How to install pgmcp
Copy-paste configuration for popular MCP clients.
PGMCP_DATABASE_URLrequiredsecretPostgres connection string (read-only role recommended)
{
"mcpServers": {
"pgmcp": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/pascalallen/pgmcp:1.1.0"
],
"env": {
"PGMCP_DATABASE_URL": "<YOUR_PGMCP_DATABASE_URL>"
}
}
}
}Related MCP servers

Grain
Run SQL queries and inspect database schemas through safe, visible MCP tools.
Proprietary B2B creator-velocity data: ranked board, live breakouts, and audience-growth curves.
View repository →Query your live AccountsOS books: balances, transactions, VAT, deadlines, invoices.

UK Property Data
UK property data in one package: Land Registry comps, EPC, Rightmove, yields, stamp duty, and Companies House.
Create, inspect, validate, and save editable 3D building scenes with Pascal's hosted MCP server.

One shared todo list every AI tool you use can write to — local-first, self-hostable, scoped per project.

