pgmcp
Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
MCP server · by pascalallen
About
pgmcp is an MCP server published by pascalallen. Marketplaces we read that list it: 1 (Official MCP Registry). We first saw it on 2026-10-11 and have recorded no change since. As of our marketplace pass on 2026-10-12.
What it asks for
- Runs on your machine
- Secrets: 1
- Settings: 1
What it declares, asks for and runs, in full
Only install plugins from developers you trust. We list what marketplaces publish and do not test plugins.
Connect
Commands and configs built only from what its marketplaces declare. We do not run them for you and do not test plugins.
As a local MCP server: Docker image
Built from what Official MCP Registry declares.
claude mcp add --env "PGMCP_DATABASE_URL=<YOUR_PGMCP_DATABASE_URL>" --transport stdio pgmcp -- docker run -i --rm -e PGMCP_DATABASE_URL ghcr.io/pascalallen/pgmcp:1.1.0[mcp_servers.pgmcp]
command = "docker"
args = ["run", "-i", "--rm", "-e", "PGMCP_DATABASE_URL", "ghcr.io/pascalallen/pgmcp:1.1.0"]
[mcp_servers.pgmcp.env]
PGMCP_DATABASE_URL = "<YOUR_PGMCP_DATABASE_URL>"{
"mcpServers": {
"pgmcp": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"PGMCP_DATABASE_URL",
"ghcr.io/pascalallen/pgmcp:1.1.0"
],
"env": {
"PGMCP_DATABASE_URL": "<YOUR_PGMCP_DATABASE_URL>"
}
}
}
}docker run -i --rm -e "PGMCP_DATABASE_URL=<YOUR_PGMCP_DATABASE_URL>" ghcr.io/pascalallen/pgmcp:1.1.0Replace the values in angle brackets with your own. We show the names of the settings, never values.
We do not store launch arguments. If the server needs any, its own documentation names them.
Where it is published
| Marketplace | Status | Version | Figures | Verified | First seen |
|---|---|---|---|---|---|
| Official MCP Registry (Open the registry record) | Listed | 1.1.0 | Forks (GitHub): 0 Stars (GitHub): 0 |
Not marked |
Each figure is the marketplace's own and is never added up across marketplaces. A marketplace that publishes no figure shows none: no number is not zero.
What changed
Nothing has moved on this plugin since we started watching it.
Similar plugins
Products whose own names, descriptions, tools and skills are closest in meaning to this one, on every marketplace we read. Closeness is ranked within this list only.
-
mcpg io.github.devopam/mcpg
Production-grade PostgreSQL MCP server — 254 tools for query, tuning & ops, read-only by default.
-
Hosted MCP server for PostgreSQL diagnostics: slow queries, missing indexes, connection pressure.
-
PostgreSQL MCP server for schema, query, health, security, and performance analysis.
-
Read-only MCP server for evidence-based PostgreSQL performance auditing.
-
postgres io.github.ofershap/postgres
PostgreSQL MCP — query databases, inspect schemas, explain queries.
-
Governed PostgreSQL DBA ops: slow-query RCA, bloat/vacuum & blocking-lock analysis; 35 MCP tools.
-
PostgreSQL DBA tools over MCP, scoped to one database and one schema.
-
PostgreSQL MCP Server — 27 tools for queries, schema, CRUD, DBA, HA & server management
-
postgres-mcp io.github.sparta2025/postgres-mcp
PostgreSQL MCP server with 15 tools (SQL, EXPLAIN, health, indexes) plus a Gradio UI with LLM chat.
-
Enterprise PostgreSQL MCP server with 63 tools, 10 resources, 10 prompts for AI-native operations
Similar plugins by marketplace
The same question asked of one marketplace at a time: is there an analog of this plugin there?
Has a listing on Claude Code: claude-plugins-community (5)
-
Zero-config MCP server for searchable documentation. SQLite or PostgreSQL.
-
Create, connect, and interact with an AlloyDB for PostgreSQL database and data.
-
Prisma MCP integration for Postgres database management, schema migrations, SQL queries, and connection string management. Provision Prisma Postgres databases, run migrations, and…
-
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database…
-
Database management tools for Claude Code. Query databases, explore schemas, analyze data quality, and get optimization recommendations. Supports PostgreSQL, MySQL/MariaDB…
Has a listing on Claude Code: claude-plugins-official (5)
-
Create, connect, and interact with an AlloyDB for PostgreSQL database and data.
-
Prisma MCP integration for Postgres database management, schema migrations, SQL queries, and connection string management. Provision Prisma Postgres databases, run migrations, and…
-
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database…
-
Connect Claude to your ClickHouse Cloud databases. Browse organizations, services, databases, and table schemas. Run read-only SQL queries against your data and get instant…
-
An authenticated hosted MCP server that accesses your PlanetScale organizations, databases, branches, schema, and Insights data. Query against your data, surface slow queries, and…
Has a listing on Claude: knowledge-work-plugins (5)
-
Prisma MCP integration for Postgres database management, schema migrations, SQL queries, and connection string management. Provision Prisma Postgres databases, run migrations, and…
-
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database…
-
Connect Claude to your ClickHouse Cloud databases. Browse organizations, services, databases, and table schemas. Run read-only SQL queries against your data and get instant…
-
An authenticated hosted MCP server that accesses your PlanetScale organizations, databases, branches, schema, and Insights data. Query against your data, surface slow queries, and…
-
Official SigNoz plugin for MCP setup, docs, queries, dashboards, and alerts
Has a listing on Codex: openai-curated (openai/plugins) (5)
-
Manage Supabase projects directly through ChatGPT. Execute SQL queries on PostgreSQL databases, design and modify table schemas, deploy serverless edge functions, and configure…
-
Available for US1 customers only. Analyze, investigate, and act on your Datadog telemetry directly from ChatGPT using natural language. Ask questions about your production…
-
PostHog gives your AI agent direct access to your product analytics, feature flags, experiments, error tracking, surveys, logs, and LLM analytics. Ask questions about your data…
-
Cloudflare platform plugin with curated skills for Workers, Wrangler, and Agents SDK plus the official Cloudflare API MCP server.
-
Inspect recent issues and events in Sentry from Codex.
Has a listing on Community GitHub marketplaces (5)
-
Read-only SQL querying + schema introspection over Postgres & SQLite, with a gated write mode.
-
Create, connect, and interact with an AlloyDB for PostgreSQL database and data.
-
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database…
-
Local and cloud workflows for running Postgres with clickhousectl — local Docker-backed Postgres for development (start, psql client, .env wiring, lifecycle) and managed…
-
Dynatrace observability skills: DQL query patterns, application and infrastructure monitoring, log analysis, problem investigation, and incident response workflows, with the…
Has a listing on Copilot CLI: github/awesome-copilot (5)
-
Database administration, SQL optimization, and data management tools for PostgreSQL, SQL Server, and general database development best practices.
-
Connect GitHub Copilot to your CockroachDB clusters: run and explore SQL through MCP, with DBA/Developer/Operator agents, CockroachDB best-practice skills, and safety hooks that…
-
Expert PostgreSQL guidance and live database tools for Postgres anywhere, including local, self-hosted, containers, on-premises, AWS, Google Cloud, Azure Database for PostgreSQL…
-
Use Datadog directly in Copilot / VS Code through a preconfigured Datadog MCP server. Query logs, metrics, traces, dashboards, and more through natural conversation.
-
Safe BLE diagnostics, evidence workflows, and guarded automation for AI agents.
Has a listing on Copilot CLI: github/copilot-plugins (5)
-
mcp-apps
Generate MCP App widgets for MCP tools. Produces self-contained HTML widgets using the MCP Apps protocol.
-
Build Power Apps Canvas Apps using the Canvas Authoring MCP server.
-
model-apps
Build and deploy Power Apps generative pages for model-driven apps with specialist agents for planning, entity creation, and parallel code generation. Requires PAC CLI >= 2.7.0…
-
Toolkit for building Microsoft 365 Copilot declarative agents — scaffolding, JSON manifest development, and capability configuration.
-
workiq
Query Microsoft 365 data with natural language — emails, meetings, documents, Teams messages, and more.
Has a listing on Cursor: cursor/plugins (5)
-
Work with PostHog from chat: query product analytics and run SQL, manage feature flags and experiments, triage error tracking issues, and review session replays, surveys, and…
-
Inspect and manage feature gates, experiments, dynamic configs, and metrics.
-
Explore datasets and tables and run SQL queries.
-
CLI-backed repo compatibility scans plus agents that audit startup, validation, and docs against reality.
-
Search docs, read pages, and update tables.
Has a listing on Docker MCP Catalog (5)
-
Enable AI agents to manage, monitor, and query CockroachDB using natural language. Perform complex database operations, cluster management, and query execution seamlessly through…
-
Database interaction and business intelligence capabilities.
-
MCP server for SQLite, PostgreSQL, and MySQL with natural language to SQL and direct SQL tooling.
-
Connect to Oracle databases via MCP, providing secure read-only access with support for schema exploration, query execution, and metadata inspection.
-
schemacrawler-ai io.github.schemacrawler/schemacrawler-ai
Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast
Has a listing on Official MCP Registry (5)
-
mcpg io.github.devopam/mcpg
Production-grade PostgreSQL MCP server — 254 tools for query, tuning & ops, read-only by default.
-
Hosted MCP server for PostgreSQL diagnostics: slow queries, missing indexes, connection pressure.
-
PostgreSQL MCP server for schema, query, health, security, and performance analysis.
-
Read-only MCP server for evidence-based PostgreSQL performance auditing.
-
postgres io.github.ofershap/postgres
PostgreSQL MCP — query databases, inspect schemas, explain queries.
Found by meaning, not by shared code or a shared repository: similar plugins stay separate products, and this is not a review or a recommendation.
Is this your plugin?
Prove you maintain it with a file in its repository, a file on your domain or a DNS record. You get alerts when a marketplace lists it, drops it, changes its verified mark or what it asks for, and can put its remote endpoint on monitoring as a web service.
Data comes from the Official MCP Registry (registry.modelcontextprotocol.io), CC0 1.0. Figures come from our own regular passes over the marketplaces, last read on . We publish no contact details for plugin publishers.