review_query
Reviews application SQL queries for missing indexes, unbatched writes, and unsafe UPDATE/DELETE before execution, returning a safe/review/block verdict with line-specific fixes.
Instructions
Review queries an application will run (SELECT / UPDATE / DELETE / INSERT) for missing indexes, unbatched writes and unsafe UPDATE/DELETE. Pass schema for index checks.
Returns a verdict (safe / review / block) and findings with line, impact and fix.
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": {
"sql": "<sql>"
},
"name": "review_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| stats | No | ||
| schema | No | ||
| mysql_version | No |