PG Bloat Detective for VS Code
io.github.r69shabh/pg-bloat-detective
Read-only Postgres bloat verdicts: blockers, timelines, REINDEX proof.
client:VS Code
transport:stdio
runtime:pypi
Install PG Bloat Detective in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "bloat-dsn",
"description": "BLOAT_DSN",
"password": true
},
{
"type": "promptString",
"id": "bloat-db",
"description": "BLOAT_DB",
"password": true
}
],
"servers": {
"pg-bloat-detective": {
"type": "stdio",
"command": "uvx",
"args": [
"pg-bloat-detective"
],
"env": {
"BLOAT_DSN": "${input:bloat-dsn}",
"BLOAT_DB": "${input:bloat-db}"
}
}
}
}VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs