NestDaddy

PG Bloat Detective

io.github.r69shabh/pg-bloat-detective · v0.1.6

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

Connect Runs on your machine

Terminal
claude mcp add pg-bloat-detective -e BLOAT_DSN=<BLOAT_DSN> -e BLOAT_DB=<BLOAT_DB> -- uvx pg-bloat-detective==0.1.6
claude_desktop_config.json
{
  "mcpServers": {
    "pg-bloat-detective": {
      "command": "uvx",
      "args": [
        "pg-bloat-detective==0.1.6"
      ],
      "env": {
        "BLOAT_DSN": "<BLOAT_DSN>",
        "BLOAT_DB": "<BLOAT_DB>"
      }
    }
  }
}
~/.cursor/mcp.json
{
  "mcpServers": {
    "pg-bloat-detective": {
      "command": "uvx",
      "args": [
        "pg-bloat-detective==0.1.6"
      ],
      "env": {
        "BLOAT_DSN": "<BLOAT_DSN>",
        "BLOAT_DB": "<BLOAT_DB>"
      }
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "pg-bloat-detective": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "pg-bloat-detective==0.1.6"
      ],
      "env": {
        "BLOAT_DSN": "<BLOAT_DSN>",
        "BLOAT_DB": "<BLOAT_DB>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

NameDescription
BLOAT_DSN
Optional
Postgres DSN (read-only enforced: 5s statement timeout, read-only tx)
BLOAT_DB
Optional
SQLite timeline file written by bloatdetective collect

Details

Package[email protected] (PYPI, stdio)
First published12 Oct 2026
Last updated12 Oct 2026
Registry nameio.github.r69shabh/pg-bloat-detective

More databases servers See all

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.