Mcpfirebird MCP Server

Schema exploration in mcpfirebird starts with user-table listings and column definitions, then extends to indexes, constraints, field comments, and table triggers. When present, descriptions from Firebird's RDB$DESCRIPTION metadata give models context about field meanings. Developers can also inspect procedures, functions, and package source, or retrieve table data with filters, ordering, and pagination. SQL execution accepts optional query parameters, while batch tools run queries or describe several tables in parallel. Included prompts cover natural-language data requests, table analysis, SQL generation, and query optimization.

For performance investigation, tools retrieve execution plans, time repeated query runs, look for missing indexes, and examine row counts, column statistics, and data distribution. Native POST_EVENT support includes discovering events in triggers and procedures and subscribing for proactive notifications. Database and server information, tool help, and health checks provide context about the connection and available operations. The wire-encryption tool reports configuration rather than confirming encryption negotiated on a live connection. Communication uses stdio, and the documentation includes Claude Desktop configuration and client examples in TypeScript/JavaScript, Python, and Delphi.