Developer · Local MCP server
pgmcp
Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
What the MCP Registry states
The entry as published to the official MCP Registry (read 2026-10-04), latest version.
- Registry name
io.github.pascalallen/pgmcp- Version
- 1.1.0
- Status
- Active
- Category
- developer
- Transport
- stdio (local process)
- Package
- OCI image (Docker), MCP Bundle (.mcpb)
- Published
- 2026-08-20
- Updated
- 2026-08-20
- Publisher
- pascalallen (GitHub)
- Namespace
- Namespace verified by the MCP Registry via GitHub (github.com/pascalallen) · how
- Listed under
- PostgreSQL MCP servers
- Website
- github.com/pascalallen/pgmcp
- Repository
- github.com/pascalallen/pgmcp
- Source
- Registry API entry
Packages
| Registry | Package | Version | Transport |
|---|---|---|---|
| OCI image (Docker) | ghcr.io/pascalallen/pgmcp:1.1.0 | - | stdio |
| MCP Bundle (.mcpb) | https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpbSHA-256 checksum stated | - | stdio |
How to connect pgmcp
pgmcp runs locally from a container image in an OCI registry such as Docker Hub or GitHub Container Registry: ghcr.io/pascalallen/pgmcp:1.1.0. It speaks MCP over stdio, so the client starts it as a program and talks to it through standard input and output. It needs Docker or another OCI container runtime; started with docker run - the usual command is docker run -i --rm -e PGMCP_DATABASE_URL ghcr.io/pascalallen/pgmcp:1.1.0. It reads the environment variable PGMCP_DATABASE_URL (required, secret); set it in the client's configuration for this server.
pgmcp runs locally from an MCP Bundle: a single downloadable archive holding a local server and a manifest that describes it: https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb. It speaks MCP over stdio, so the client starts it as a program and talks to it through standard input and output. It needs a client that installs MCP Bundles; the file is opened in, or added to, that client. It reads the environment variable PGMCP_DATABASE_URL (required, secret); set it in the client's configuration for this server.
In the mcpServers JSON format that many desktop and editor MCP clients read, the entry looks like this (placeholders in angle brackets):
{
"mcpServers": {
"pgmcp": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"PGMCP_DATABASE_URL",
"ghcr.io/pascalallen/pgmcp:1.1.0"
],
"env": {
"PGMCP_DATABASE_URL": "<secret>"
}
}
}
}Derived from the registry entry, not tested here. What the server does, and on what terms, is set by its publisher; check its repository or website before giving it access to your accounts or files. How to add an MCP server to an assistant · Before you connect
More developer servers
| Server | Runs |
|---|---|
| Pg AiguideComprehensive PostgreSQL documentation and best practices, including ecosystem tools. | Remote & Local · HTTP, stdioLive check: ✓ handshake |
| Pg Migration Lock LintNames every statement in a Rails, Django or raw SQL migration that takes a table-blocking Postgres l. | Local · stdio |
| Pg Readonly MCPA read-only Postgres MCP server that parses SQL rather than pattern-matching it. | Local · stdio |
| PGAuditorHosted MCP server for PostgreSQL diagnostics: slow queries, missing indexes, connection pressure. | Remote · HTTPLive check: ✗ no handshake |
| pgopsSafe, audited PostgreSQL operations for AI agents: queries, migrations, EXPLAIN, containers. | Local · stdio |
| pgvectorSimilarity search, hybrid search, and index management for pgvector-backed PostgreSQL tables. | Local · stdio |
| Phaedo MCPCarry your Phaedo cognitive fingerprint into any MCP client: inject, consult, escalate, sign. | Local · stdio |
| Phantom SecretsStop AI coding agents from leaking API keys. Local proxy swaps real secrets for phm_ tokens. | Local · stdio |