analyze_query_indexes
Evaluate up to 10 SQL queries and recommend optimal indexes for improved query performance, considering user-defined constraints like maximum index size.
Instructions
Analyze a list of (up to 10) SQL queries and recommend optimal indexes
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| max_index_size_mb | No | Max index size in MB | |
| queries | Yes | List of Query strings to analyze |
Input Schema (JSON Schema)
{
"properties": {
"max_index_size_mb": {
"default": 10000,
"description": "Max index size in MB",
"title": "Max Index Size Mb",
"type": "integer"
},
"queries": {
"description": "List of Query strings to analyze",
"items": {
"type": "string"
},
"title": "Queries",
"type": "array"
}
},
"required": [
"queries"
],
"title": "analyze_query_indexesArguments",
"type": "object"
}