PG Bloat Detective
Read-only Postgres bloat verdicts: blockers, timelines, REINDEX proof.
MCP server · by r69shabh
About
PG Bloat Detective is an MCP server published by r69shabh. Marketplaces we read that list it: 1 (Official MCP Registry). The last change we recorded was on 2026-10-12. As of our marketplace pass on 2026-10-14.
What it asks for
- Runs on your machine
- Settings: 2
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.
Package
PyPI pg-bloat-detective (pg-bloat-detective on PyPI)
- PyPI downloads/week: 656 (2026-10-13)
- PyPI downloads/month: 0 (2026-10-13)
- Latest version on PyPI: 0.1.6, published 2026-10-12
No known vulnerabilities in OSV for 0.1.6 (checked 2026-10-13)
PyPI facts come from pypi.org, PyPI downloads from pypistats.org. Each figure is the registry's own and is never added to another. A registry that publishes no figure shows none: no number is not zero. Vulnerability records come from OSV.dev (CC BY 4.0) and concern the declared version only; a listing that declares no version gets no answer. We do not scan code.
Works with
- Claude Code
- Codex
- Cursor
- VS Code
- Copilot CLI
A one-click link opens the client, which asks you to confirm before it adds the server.
From the marketplaces that list it and the MCP transport it declares, as each client documents them. We 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: PyPI package
Built from what Official MCP Registry declares.
claude mcp add --transport stdio pg-bloat-detective -- uvx pg-bloat-detective[mcp_servers.pg-bloat-detective]
command = "uvx"
args = ["pg-bloat-detective"]{
"mcpServers": {
"pg-bloat-detective": {
"command": "uvx",
"args": [
"pg-bloat-detective"
]
}
}
}Optional settings it also lists: BLOAT_DB, BLOAT_DSN.
Where it is published
| Marketplace | Status | Version | Figures | Verified | First seen |
|---|---|---|---|---|---|
| Official MCP Registry (Open the registry record) | Listed | 0.1.6 | Downloads/month (PyPI): 0 Downloads/week (PyPI): 656 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
- Official MCP Registry: released version 0.1.6 (was 0.1.5)
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.
-
PostgreSQL Performance (read-only)
Read-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions
-
Hosted MCP server for PostgreSQL diagnostics: slow queries, missing indexes, connection pressure.
-
Governed PostgreSQL DBA ops: slow-query RCA, bloat/vacuum & blocking-lock analysis; 35 MCP tools.
-
PostgreSQL MCP server for schema, query, health, security, and performance analysis.
-
PostgreSQL performance Tuner MCP Server
provides AI-powered PostgreSQL performance tuning capabilities.
-
Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
-
Offline PostgreSQL query, migration and EXPLAIN diagnostics for AI agents.
-
postgres-scout-mcp io.github.bluwork/postgres-scout-mcp
Scout your PostgreSQL databases with AI - safety features, monitoring, and data quality
-
Read-only MCP server for evidence-based PostgreSQL performance auditing.
-
PostgreSQL DBA tools over MCP, scoped to one database and one schema.
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)
-
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…
-
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…
-
Create, connect, and interact with an AlloyDB for PostgreSQL database and data.
-
mongodb-mcp-server io.github.mongodb-js/mongodb-mcp-server
MongoDB Model Context Protocol Server
Has a listing on Claude Code: claude-plugins-official (5)
-
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…
-
Create, connect, and interact with an AlloyDB for PostgreSQL database and data.
-
mongodb-mcp-server io.github.mongodb-js/mongodb-mcp-server
MongoDB Model Context Protocol Server
-
Manage your Neon projects and databases with the neon-postgres agent skill and the Neon MCP Server.
Has a listing on Claude: knowledge-work-plugins (5)
-
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…
-
Prisma MCP integration for Postgres database management, schema migrations, SQL queries, and connection string management. Provision Prisma Postgres databases, run migrations, and…
-
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…
-
Inspect recent issues and events in Sentry from Codex.
-
Answer product and business questions with data
Has a listing on Community GitHub marketplaces (5)
-
PostgreSQL Performance (read-only)
Read-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions
-
Read-only SQL querying + schema introspection over Postgres & SQLite, with a gated write mode.
-
Comprehensive PostgreSQL documentation and best practices through semantic search and curated skills, including ecosystem tools like TimescaleDB and Tiger Cloud
-
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database…
-
Operations toolchain for SQLite, Cloudflare D1 & Turso: inspect, diff, migrate, monitor & repair.
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…
-
Safe BLE diagnostics, evidence workflows, and guarded automation for AI agents.
-
Use Datadog directly in Copilot / VS Code through a preconfigured Datadog MCP server. Query logs, metrics, traces, dashboards, and more through natural conversation.
Has a listing on Copilot CLI: github/copilot-plugins (5)
-
workiq
Query Microsoft 365 data with natural language — emails, meetings, documents, Teams messages, and more.
-
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…
-
Advanced Security plugin for GitHub Copilot.
-
Toolkit for building Microsoft 365 Copilot declarative agents — scaffolding, JSON manifest development, and capability configuration.
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…
-
Explore datasets and tables and run SQL queries.
-
Search docs, read pages, and update tables.
-
CLI-backed repo compatibility scans plus agents that audit startup, validation, and docs against reality.
-
Inspect and manage feature gates, experiments, dynamic configs, and metrics.
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.
-
mongodb-mcp-server io.github.mongodb-js/mongodb-mcp-server
MongoDB Model Context Protocol Server
-
schemacrawler-ai io.github.schemacrawler/schemacrawler-ai
Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast
-
MCP server for SQLite, PostgreSQL, and MySQL with natural language to SQL and direct SQL tooling.
Has a listing on Official MCP Registry (5)
-
PostgreSQL Performance (read-only)
Read-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions
-
Hosted MCP server for PostgreSQL diagnostics: slow queries, missing indexes, connection pressure.
-
Governed PostgreSQL DBA ops: slow-query RCA, bloat/vacuum & blocking-lock analysis; 35 MCP tools.
-
PostgreSQL MCP server for schema, query, health, security, and performance analysis.
-
PostgreSQL performance Tuner MCP Server
provides AI-powered PostgreSQL performance tuning capabilities.
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?
Add it to your projects and 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 its remote endpoint goes 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.