Flamerobin MCP Server
Access Firebird databases registered in FlameRobin: schema introspection, DDL/DML execution, execution plans and missing index analysis.
Install
The installation steps are in the documentation below. Documentation
Documentation
From the project's README on GitHub, refreshed weekly. Links open on GitHub.
Contents
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.csprojPublishing 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-singleThe 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=Noneenv 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 |
Frequently asked questions
What is Flamerobin MCP Server?
Access Firebird databases registered in FlameRobin: schema introspection, DDL/DML execution, execution plans and missing index analysis.
How do I install Flamerobin MCP Server?
Follow the installation steps in its documentation, shown on this page and in its repository.
Is Flamerobin MCP Server open source?
Yes. Its code is on GitHub under the MIT license.
Who maintains Flamerobin MCP Server?
It is published by Michael2150. AI.tn lists it but does not maintain or endorse it.
From the community awesome-mcp-servers lists and the project's GitHub repository. Listing is not an endorsement: review a server's code and permissions before giving it access to your data.