execute-query
Run SQL queries on Firebird databases with pagination using FIRST/ROWS syntax. Supports parameterized inputs to enhance security by preventing SQL injection risks.
Instructions
Executes a SQL query in the Firebird database. Uses FIRST/ROWS for pagination.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | No | Parameters for parameterized queries to prevent SQL injection | |
| sql | Yes | SQL query to execute (Firebird uses FIRST/ROWS for pagination instead of LIMIT) |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"params": {
"description": "Parameters for parameterized queries to prevent SQL injection",
"items": {
"anyOf": [
{
"anyOf": [
{
"type": [
"string",
"number"
]
},
{
"type": "boolean"
}
]
},
{
"type": "null"
}
]
},
"type": "array"
},
"sql": {
"description": "SQL query to execute (Firebird uses FIRST/ROWS for pagination instead of LIMIT)",
"minLength": 1,
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
}