MCP Firebird

MIT License

962

Overview InspectNew Schema Related Servers Reviews Score

analyze-query-performance

Measure SQL query execution times by running queries multiple times to analyze performance, enabling optimization for Firebird databases via the MCP Firebird server.

Instructions

Analyzes the performance of a SQL query by executing it multiple times and measuring execution time

Input Schema

Name	Required	Description
`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"
}

You must be authenticated.

Other Tools from MCP Firebird

Related Tools

get-execution-plan
@PuroDelphi/mcpFirebird
execute-query
@PuroDelphi/mcpFirebird
analyze-missing-indexes
@PuroDelphi/mcpFirebird
describe-method
@PuroDelphi/mcpFirebird
get-methods
@PuroDelphi/mcpFirebird
get_execution_plan
@aliyun/alibabacloud-hologres-mcp-server

ID: jh98erzet6