get-execution-plan
Analyze SQL queries to retrieve their execution plan, providing insights into how the Firebird database processes and optimizes the query structure.
Instructions
Gets the execution plan for a SQL query to understand how the database will execute it
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | No | Parameters for parameterized queries | |
| sql | Yes | SQL query to analyze |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"params": {
"description": "Parameters for parameterized queries",
"items": {
"anyOf": [
{
"anyOf": [
{
"type": [
"string",
"number"
]
},
{
"type": "boolean"
}
]
},
{
"type": "null"
}
]
},
"type": "array"
},
"sql": {
"description": "SQL query to analyze",
"minLength": 1,
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
}