analyze_query
Validate SQL syntax and detect anti-patterns like N+1 queries and duplicates. Optionally include EXPLAIN plans for deeper analysis.
Instructions
Validate SQL syntax, detect anti-patterns, N+1, duplicates.
LEVEL: Query (SQL statement analysis - no DB connection needed for basic parsing)
USE FOR: SQL validation, N+1 detection, batch analysis. DO NOT USE FOR: running queries (execute_query), write impact (analyze_impact).
Examples: analyze_query(query='SELECT * FROM users') analyze_query(query='SELECT * FROM users', schema='shipment', include_explain=True)
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | SQL string or JSON array [{"id":"q1","sql":"..."}] | |
| detect_duplicates | No | Detect duplicates in batch | |
| include_explain | No | Include EXPLAIN plan | |
| schema | No | Schema name for batch analysis context. Required for EXPLAIN. Use get_schema() to list available schemas. | |
| format | No | Output format | json |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |