MCP Firebird

by PuroDelphi
Verified
MIT License
2,147
4
  • Apple
  • Linux

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

NameRequiredDescriptionDefault
iterationsNoNumber of times to run the query for averaging performance
paramsNoParameters for parameterized queries
sqlYesSQL 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" }
ID: jh98erzet6