query_analyze_slow
Find performance bottlenecks in slow SQL queries by analyzing query structure and table schema, helping optimize database operations.
Instructions
Analyze slow database queries and identify performance bottlenecks
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": {
"query": "<query>"
},
"name": "query_analyze_slow"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | The SQL query to analyze | |
| api_key | No | API key for authentication | |
| database | No | Database engine | postgresql |
| table_info | No | Table schema info including existing indexes |