bloat_collect
Captures a read-only Postgres bloat snapshot into timeline history, then returns fresh per-table and per-index verdicts with recommended actions for safe production diagnosis.
Instructions
Take a read-only Postgres snapshot into the timeline, then return fresh verdicts.
Safe on prod: read-only transaction, 5s statement timeout, needs only pg_stat_* views + optional pgstattuple extension. No writes, no agents. Args: dsn: Postgres DSN, e.g. 'dbname=app user=readonly host=db.internal'. Default: BLOAT_DSN env. Never logs the password. Returns: {snapshot: 'saved', db: path, findings: [...with action per table/index]}.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "bloat_collect"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dsn | No |