analyze-query-performance
Measure and optimize SQL query execution time by running it multiple times and averaging results. Supports parameterized queries and customizable iterations for Firebird databases.
Instructions
Analyzes the performance of a SQL query by executing it multiple times and measuring execution time
Input Schema
Name | Required | Description | Default |
---|---|---|---|
iterations | No | Number of times to run the query for averaging performance | |
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": {
"iterations": {
"default": 3,
"description": "Number of times to run the query for averaging performance",
"exclusiveMinimum": 0,
"type": "integer"
},
"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"
}