flamerobin-mcp-server

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

dotnet build FirebirdMcp.csproj

Publishing a single self-contained executable

dotnet publish FirebirdMcp.csproj -c Release -r win-x64 --self-contained true -p:PublishSingleFile=true -p:IncludeNativeLibrariesForSelfExtract=true -o publish-single

The output is publish-single\FirebirdMcp.exe. The publish-single\ folder is gitignored.

Claude Desktop configuration

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "firebird": {
      "command": "C:\\path\\to\\publish-single\\FirebirdMcp.exe",
      "env": {
        "Logging__LogLevel__Default": "None"
      }
    }
  }
}

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 | | GetTriggerSource | PSQL source of a trigger | | GetViewSource | SQL source of a view | | GetExecutionPlan | Execution plan for a SELECT — shows index usage | | AnalyzeMissingIndexes | Which columns lack indexes; optionally scoped to filter columns | | GetDatabaseInfo | ODS version, page size, dialect, etc. | | ListActiveConnections | Active connections to the database | | RunQuery | Execute a SELECT — supports maxRows and columns projection | | ExecuteDdl | Execute CREATE/ALTER/DROP and commit | | ExecuteDml | Execute INSERT/UPDATE/DELETE and commit | | ExecuteScript | Execute multiple semicolon-separated statements |