analyze_query_indexes
Identify optimal database indexes by analyzing up to 10 SQL queries, offering index recommendations to improve query performance.
Instructions
Analyze a list of (up to 10) SQL queries and recommend optimal indexes
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"queries": "<queries>"
},
"name": "analyze_query_indexes"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| method | No | Method to use for analysis | dta |
| queries | Yes | List of Query strings to analyze | |
| database | No | Optional. Alias of the configured database to query. Omit it when the server has only one database configured. When several are configured this parameter is required - call list_databases first to learn the valid aliases. | |
| max_index_size_mb | No | Max index size in MB |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |