MCP Firebird: Transform your AI assistant into an operational Firebird DBA
No more assumptions about database performance.
MCP Firebird is the server based on the MCP (Model Context Protocol) protocol that allows modern AI assistants (such as Claude Desktop, Cursor, Gemini CLI, or Claude Code) to connect securely and in read-only mode to your Firebird database.
Artificial intelligence will no longer just “guess” issues, but will be able to directly diagnose the schema, execution plans, and server health, providing precise and actionable remedies.
Why choose MCP Firebird
- Real diagnostics, zero hallucinations: The AI has direct access to the schema and engine. If a query contains an error, the assistant receives the database’s native error message instead of generating empty or wrong reports.
- Total compatibility (from 2.5 to 5.0): Thoroughly tested on all major Firebird versions (2.5, 3.0, 4.0, and 5.0). The AI adapts its responses based on the specific version in use, avoiding the incorrect advice typical of generic models.
- Action- and measurement-oriented approach: Every issue detected by the assistant comes with the exact SQL statement to solve it and a method to immediately verify afterward whether the performance goal was met.
- Secure and non-invasive: The tool is a single native executable (written in Delphi) that communicates via standard input/output (stdio) with the AI client. It does not run as a background service and does not expose network ports.
The two available versions
The MCP Firebird suite is available in two distinct editions depending on the required level of diagnostic depth:
Free Edition (Internal Use)
Designed for schema and query diagnostics via standard read-only SQL connection. Includes 9 native tools, including:
- Automatic table documentation (columns, keys, indexes).
- Accurate execution plan analysis (e.g., identification of full NATURAL scans).
- Index suggestion and optimization (including reactivation of INACTIVE indexes or removal of duplicate indexes).
- Monitoring of transaction status and sweep.
Try the free edition directly on GitHub
Enterprise Edition (Paid)
The Enterprise edition connects to the Firebird server as an administrator via the Services Manager. This allows the AI to analyze what lies outside the database and what only the server knows, such as:
- fb_analyze_config & fb_analyze_host: Check of configuration files (firebird.conf and databases.conf) relative to real hardware (RAM vs. cache, cores vs. workers).
- fb_parse_log: Automatic analysis of the firebird.log file to detect corruption, bugchecks, or anomalies.
- fb_analyze_storage: Study of physical structure (index depth, page fill, record version chains).
- fb_capture_trace: Recording and tracking of real workload (from 60 seconds up to 2 hours in the background) to isolate the most expensive queries.
Comparison table: Free vs Enterprise
| Feature | Free | Enterprise |
|---|---|---|
| Engine version, architecture and capabilities (fb_info) | ||
| List of the tables (fb_list_tables) | ||
| Schema documentation: columns, keys, indexes (fb_generate_documentation) | ||
| Execution plan analysis for a query (fb_analyze_query) | ||
| Advice on indexes to create or reactivate (fb_suggest_indexes) | ||
| Duplicate or useless indexes to drop (fb_suggest_index_drops) | ||
| Table check: missing keys, stale statistics, too many indexes (fb_audit_table) | ||
| Goal verification: plan without full scans, or a time limit (fb_evaluate_goal) | ||
| Transaction and sweep status (fb_monitor_transactions) | ||
| Guided diagnosis path (fb_diagnose) | ||
| firebird.conf and databases.conf checked for your version and architecture (fb_analyze_config) | ||
| Physical structure: index depth, page fill, record-version chains (fb_analyze_storage) | ||
| firebird.log reading: corruption, bugchecks, sweeps that never ran (fb_parse_log) | ||
| Real workload recording: 60 seconds (fb_capture_trace) or up to 2 hours in background (fb_trace_start/status/stop) | ||
| Hardware against configuration: RAM vs cache, cores vs parallel workers (fb_analyze_host) | ||
| Before/after measurements of a change, with a verdict |
When is a Commercial License required?
The Free edition is released under the PolyForm Internal Use license: it is completely free for any internal operation or consulting within your company, regardless of scale.
A commercial license is required when the software leaves your hands, meaning if you wish to:
- Leave a copy of MCP Firebird installed on a client’s server after completing a job.
- Integrate it directly inside your software (e.g., inside an ERP to provide an “AI tuning” module).
- Offer it as an automated service to clients within a hosting platform.
Note: The commercial redistribution license and the Enterprise Edition are two distinct and separate products.
Would you like to unlock the power of the Enterprise Edition or integrate MCP Firebird into your commercial solutions?
Click the button below to request quotes for Enterprise licenses, dedicated support, or commercial redistribution agreements