Read-only Postgres bloat verdicts: blockers, timelines, REINDEX proof.
Connect Runs on your machine
claude mcp add pg-bloat-detective -e BLOAT_DSN=<BLOAT_DSN> -e BLOAT_DB=<BLOAT_DB> -- uvx pg-bloat-detective==0.1.6
{
"mcpServers": {
"pg-bloat-detective": {
"command": "uvx",
"args": [
"pg-bloat-detective==0.1.6"
],
"env": {
"BLOAT_DSN": "<BLOAT_DSN>",
"BLOAT_DB": "<BLOAT_DB>"
}
}
}
}
{
"mcpServers": {
"pg-bloat-detective": {
"command": "uvx",
"args": [
"pg-bloat-detective==0.1.6"
],
"env": {
"BLOAT_DSN": "<BLOAT_DSN>",
"BLOAT_DB": "<BLOAT_DB>"
}
}
}
}
{
"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
| Name | Description |
|---|---|
BLOAT_DSNOptional | Postgres DSN (read-only enforced: 5s statement timeout, read-only tx) |
BLOAT_DBOptional | SQLite timeline file written by bloatdetective collect |
Details
| Package | [email protected] (PYPI, stdio) |
| First published | 12 Oct 2026 |
| Last updated | 12 Oct 2026 |
| Registry name | io.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.
