pgmcp MCP Server

io.github.pascalallen/pgmcp

Repository Registry

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

{
  "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

Pascal 3D Editor

Create, inspect, validate, and save editable 3D building scenes with Pascal's hosted MCP server.

io.github.pasichDev/docket

Active

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

TypeScript

MIT

View repository →

io.github.pasichDev/todo-mcp

Active

Shared TODO list for AI agents across projects with claim tracking, web UI, and encrypted local storage.

TypeScript

MIT

View repository →

Pastea

Active

Search, read and re-copy your Mac clipboard history from Pastea. Local, pairs with one click.

TypeScript

MIT

View repository →

io.github.patchistry/patchistry-mcp-server

Maintained

DTC modular hat brand MCP server. 6 tools for AI agents: catalog, curated builds, shipping.

JavaScript

MIT

View repository →

Patchloom

Active

Parser-backed structured file edits for AI agents: JSON/YAML/TOML/Markdown/AST with dry-run, batch, and atomic rollback.

Rust

MIT

View repository →