Michael2150/flamerobin-mcp-server

A Model Context Protocol (MCP) server for Firebird databases intended for **local use**. It reads connection details from FlameRobin's fr_databases.conf so no extra configuration is needed — if you have FlameRobin set up with your Firebird databases, this server works out of the box.
Compared to mcpFirebird
| | This project | mcpFirebird |
|---|---|---|
| **Credentials** | Read automatically from FlameRobin's config — no setup required | Must pass --user, --password, --host, --database on every launch |
| **Multi-database** | All FlameRobin-registered databases available in one session | Single database per server instance |
| **Wire encryption** | Supported (native Firebird .NET driver) | Not supported — requires WireCrypt = Disabled on the server |
| **Runtime** | .NET 9 self-contained executable | Node.js / npm |
| **Schema introspection** | Tables, views, procedures, triggers, generators, roles, FK/PK/constraints, execution plans, missing index analysis | Tables and basic schema |
| **DDL / DML / scripts** | Yes — ExecuteDdl, ExecuteDml, ExecuteScript | SQL execution only |
| **Deployment** | Local only — runs on your PC alongside FlameRobin | Cloud-deployable via Smithery, SSE/HTTP transports |
Building
Publishing a single self-contained executable
The output is publish-single\FirebirdMcp.exe. The publish-single\ folder is gitignored.
Claude Desktop configuration
Add to claude_desktop_config.json:
> **Important:** The Logging__LogLevel__Default=None env var is required. The server's startup log output is written to stdout, which Claude reads as part of the MCP handshake — any unexpected output causes Claude to fail to recognize the server.
Tools
| Tool | Description |
|------|-------------|
| ListDatabases | List all servers/databases registered in FlameRobin |
| ListObjects | List tables, views, or both — with optional regex filter |
| ListProcedures | List stored procedures — with optional regex filter |
| ListTriggers | List triggers — with optional regex filter |
| ListGenerators | List generators/sequences with current values |
| ListRoles | List roles — with optional regex filter |
| DescribeTable | Column definitions — supports brief mode and column filter |
| GetForeignKeys | FK relationships for a table (in, out, or all directions) |
| GetTableConstraints | PK, FK, UNIQUE, CHECK constraints for a table |
| GetProcedureSource | PSQL source of a stored procedure |