explain
Analyze SQLite query plans to identify index usage and performance bottlenecks. Optimize slow queries by inspecting execution steps.
Instructions
Explain the query plan for a SQL query (EXPLAIN QUERY PLAN). Helps analyze indexes and optimize query performance.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db | No | Optional path to SQLite database file. Defaults to configured default database. | |
| sql | Yes | The SQL query statement to analyze. | |
| params | No | Optional query parameters (positional list, named dict, or JSON string). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |