query_suggest_indexes
Analyzes table structure and query patterns to suggest database indexes. Identifies missing or existing indexes and recommends additions that optimize query performance.
Instructions
Suggest database indexes based on query patterns and table structure
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>",
"table_name": "<table_name>"
},
"name": "query_suggest_indexes"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| api_key | No | API key for authentication | |
| queries | Yes | Common queries to optimize with indexes | |
| table_name | Yes | Target table name | |
| existing_indexes | No | Already existing indexes |