execute-query

Run SQL queries on Firebird databases using FIRST/ROWS for pagination, with parameterized inputs to ensure security and prevent SQL injection. Enables efficient data retrieval and manipulation.

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"
}

MCP Firebird

execute-query

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from MCP Firebird

Related Tools