suggest_optimal_indexes
Analyzes a SQL query or table to generate precise CREATE INDEX recommendations, explaining the expected performance gains and indexing rationale.
Instructions
Analyzes a SQL query or table and generates precise CREATE INDEX recommendations with performance improvement rationale.
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_optimal_indexes"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sqlQuery | No | SQL query to analyze for index opportunities | |
| tableName | No | Table name to suggest indexes for |