analyze_query_indexes
Analyzes up to 10 SQL queries and recommends indexes to improve PostgreSQL query performance and reduce unnecessary table scans.
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 |
|---|---|---|---|
| queries | Yes | List of Query strings to analyze | |
| connection | No | Nome ou alias da conexão (veja list_connections). Se omitido, usa a conexão ativa ou a padrão. | |
| max_index_size_mb | No | Max index size in MB |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |