PluginBench
MCP Server
Active
MIT

pgmcp MCP Server

io.github.pascalallen/pgmcp

RepositoryRegistry
How to choose

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.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • PGMCP_DATABASE_URL
    required
    secret

    Postgres connection string (read-only role recommended)

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "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

GRGrain logo

Grain

Active

Run SQL queries and inspect database schemas through safe, visible MCP tools.

3
View repository →

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.

0
TypeScript
View repository →
UKUK Property Data logo

UK property data in one package: Land Registry comps, EPC, Rightmove, yields, stamp duty, and Companies House.

15
Python
MIT
View repository →

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.

10
TypeScript
MIT
View repository →