Skip to content
MCP server

PG Bloat Detective

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

Runs locallyStatus and history
Install
Pricing
Open source
Runs
Locally
Version
0.1.6
Listing updated
5 days ago

About PG Bloat Detective

PG Bloat Detective is an open-source MCP server. It runs locally on your machine and is started by your AI client.

Install

Run in a terminal

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

Add to claude_desktop_config.json

{
  "mcpServers": {
    "pg-bloat-detective": {
      "command": "uvx",
      "args": [
        "pg-bloat-detective"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "pg-bloat-detective": {
      "command": "uvx",
      "args": [
        "pg-bloat-detective"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

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

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

Using several servers? Build one config file with the MCP config generator.

Configuration

  • BLOAT_DSNPostgres DSN (read-only enforced: 5s statement timeout, read-only tx)
  • BLOAT_DBSQLite timeline file written by bloatdetective collect

Pricing

Open source

More servers for the same service

PG Bloat Detective FAQ

Is PG Bloat Detective free?

Yes. PG Bloat Detective is open source, so you can use and self-host it for free.

How do I add PG Bloat Detective to Claude Code?

Run this command in your terminal: claude mcp add pg-bloat-detective -- uvx pg-bloat-detective

Where this comes from

  • Description: from the official MCP Registry entry.
  • Install steps: from the official MCP Registry entry.

How AIPoweredBot checks servers