PG Bloat Detective MCP Server

by r69shabh Your server? Claim it

local only

PG Bloat Detective runs on your own machine — the client starts it, so there is no endpoint to ping. 148 installs a week from pypi. Last commit 12 Oct 2026.

Read-only Postgres bloat verdicts: blockers, timelines, REINDEX proof.

Installs per day peak 415 · avg 56 · +85% w/w

a month agotoday

148

Installs / week

pypi · pg-bloat-detective

Stars

0 open issues

12 Oct 2026

Last commit

from GitHub

MIT

License

Python

Nothing serious here today

Today is the operative word: we check PG Bloat Detective every 15 minutes and re-read its code on every release. Watch it and you find out the day that stops being true.

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

Claude Code Claude Desktop Codex Cursor VS Code

run in your terminal

claude mcp add pg-bloat-detective -- uvx pg-bloat-detective

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "pg-bloat-detective": {
      "command": "uvx",
      "args": [
        "pg-bloat-detective"
      ]
    }
  }
}

~/.codex/config.toml

[mcp_servers.pg-bloat-detective]
command = "uvx"
args = ["pg-bloat-detective"]

.cursor/mcp.json

{
  "mcpServers": {
    "pg-bloat-detective": {
      "command": "uvx",
      "args": [
        "pg-bloat-detective"
      ]
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "pg-bloat-detective": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "pg-bloat-detective"
      ]
    }
  }
}

Optional settings from the registry entry, left out of the block above: BLOAT_DSN (Postgres DSN (read-only enforced: 5s statement timeout, read-only tx)), BLOAT_DB (SQLite timeline file written by bloatdetective collect).

Alternatives to PG Bloat Detective

same job, measured the same way

Database MCP Postgres

by arifulislamat

MCP server for PostgreSQL. Read-only by default, row caps, timeouts, secrets never logged.

137 installs/wk local only

pgmcp

by pascalallen

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

local only

DB Explorer

by ayush-148

Read-only SQL for PostgreSQL, MySQL and SQLite: schema, safe SELECTs, EXPLAIN, index advice

134 installs/wk local only

Pgport

by cloudcorprecords

Read-only SQL queries against a PostgreSQL database.

80 installs/wk local only

PostgreSQL Performance (read-only)

by gouranshul

Read-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions

local only

Mcpg

by devopam

Production-grade PostgreSQL MCP server — 279 tools for query, tuning & ops, read-only by default.

752 installs/wk local only

Postgres (read-only)

by contextflo

Read-only Postgres: drop-in for the archived server-postgres, with schema context.

288 installs/wk local only

Halfnine

by notinferred

PostgreSQL through Halfnine: describe, read-only queries, and changes you approve in the app.

local only

PG Bloat Detective — questions

Answers built from our own checks of this server.

Why is there no uptime for PG Bloat Detective?

PG Bloat Detective runs on your own machine over stdio — there is no network address to reach, so uptime cannot be measured for it by anyone. What can be measured is adoption: the pypi package pg-bloat-detective was installed 148 times last week.

How do I connect PG Bloat Detective?

Copy the ready config from this page. We generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each in the form that client actually reads. It runs locally, so the command pulls pg-bloat-detective straight from pypi; nothing to host, nothing to sign up for.

How many people use PG Bloat Detective?

The pypi package pg-bloat-detective was installed 148 times in the last week. Week over week that is +85%. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.

Is PG Bloat Detective open source?

Yes — it is published under the MIT licence, written in Python and 0 stars on GitHub. The source link is on this page, so you can read exactly what it does with your data before you connect it.