suggest_missing_indexes
Identify tables with high sequential scan counts and unused indexes, then get actionable recommendations to create missing indexes and drop wasteful ones.
Instructions
Find tables with high sequential scan counts and zero index usage, cross-referenced with unused indexes wasting space. Provides actionable CREATE INDEX and DROP INDEX recommendations.
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": "suggest_missing_indexes"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Database schema to analyze (default: public) | public |
| timeout_ms | No | Connection timeout in milliseconds (default: 30000). Increase for slow or remote databases. |