MCP server

pgmcp

io.github.pascalallen/pgmcp

Checked 25 Oct 2026, 21:10 UTC · Checked against OSV.dev for malware and vulnerabilities; never run by us

Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.

Website Source

At a glance

Type

MCP server

Publisher

Not verified

Status

Runs on your computer

Sets up in

Claude Code, Claude Desktop, Codex, Gemini CLI, Cursor, VS Code

Last checked

25 Oct 2026, 21:10 UTC

Connect it to your agent

Add to CursorAdd to VS CodeVS Code Insiders

Opens the app, which shows the server and asks you to confirm. It then runs the package on your computer with your permissions. For other apps, copy the setup below.

Claude Code

claude mcp add pgmcp --env PGMCP_DATABASE_URL=YOUR_VALUE -- docker run -i --rm -e PGMCP_DATABASE_URL ghcr.io/pascalallen/pgmcp:1.1.0

Claude Desktop

{"mcpServers":{"pgmcp":{"command":"docker","args":["run","-i","--rm","-e","PGMCP_DATABASE_URL","ghcr.io/pascalallen/pgmcp:1.1.0"],"env":{"PGMCP_DATABASE_URL":"YOUR_VALUE"}}}}

Codex (config.toml)

[mcp_servers.pgmcp]
command = "docker"
args = ["run","-i","--rm","-e","PGMCP_DATABASE_URL","ghcr.io/pascalallen/pgmcp:1.1.0"]
env = { PGMCP_DATABASE_URL = "YOUR_VALUE" }

Gemini CLI

{"mcpServers":{"pgmcp":{"command":"docker","args":["run","-i","--rm","-e","PGMCP_DATABASE_URL","ghcr.io/pascalallen/pgmcp:1.1.0"],"env":{"PGMCP_DATABASE_URL":"YOUR_VALUE"}}}}

Cursor

{"mcpServers":{"pgmcp":{"command":"docker","args":["run","-i","--rm","-e","PGMCP_DATABASE_URL","ghcr.io/pascalallen/pgmcp:1.1.0"],"env":{"PGMCP_DATABASE_URL":"YOUR_VALUE"}}}}

VS Code

{"servers":{"pgmcp":{"type":"stdio","command":"docker","args":["run","-i","--rm","-e","PGMCP_DATABASE_URL","ghcr.io/pascalallen/pgmcp:1.1.0"],"env":{"PGMCP_DATABASE_URL":"YOUR_VALUE"}}}}

Runs on your computer with your permissions: check the package and its source before installing. Replace YOUR_VALUE with your own PGMCP_DATABASE_URL.

Browse

• GitHub tools
• GitHub and code hosting
• Databases

Related MCP servers

• Floot
  Build and publish full-stack web and mobile apps on Floot from any MCP client. Building is free.
• Duvera Gateway
  Governed AI actions with signed, verifiable receipts: free keyless reads, human-approved writes.
• Veto — SQL Safety & Cost Oracle
  Deterministic safety, correctness & cost gate that vets Postgres SQL before your AI agent runs it.
• SumOffice — real Word and Excel for agents
  Real Word and Excel for agents: open your .docx/.xlsm, read, propose, apply, get it back intact.
• Phpray
  Ask an agent why a PHP site is slow: every request with its SQL, HTTP calls, errors and N+1.
• VibeKit
  Build, deploy, and operate hosted web apps on VibeKit (vibekit.bot) from any MCP client.
• Plug and Ship
  Search MCP servers, agent skills and coding-agent plugins: trending tools and best-of lists.
• PGAuditor
  Hosted MCP server for PostgreSQL diagnostics: slow queries, missing indexes, connection pressure.

Badge for your README

[![AptLynx](https://aptlynx.net/badge/io.github.pascalallen/pgmcp.svg)](https://aptlynx.net/servers/io.github.pascalallen/pgmcp)

Listing text is written by the maker; AptLynx lists tools and does not vouch for them. Find another tool · Browse by topic · For agents