About Michael2150/flamerobin-mcp-server
Michael2150/flamerobin-mcp-server is an MCP server published by Michael2150 in the Blockchain category: no credential setup required. Access all locally registered databases in one session with full schema introspection, DDL/DML execution, execution plans, and missing index analysis.
The repository has 2 stars and 1 forks, with the last commit 4 months ago. Recent commit activity is the strongest signal that reported issues will get attention.
Install
git clone https://github.com/Michael2150/flamerobin-mcp-serverThis server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.
Tools (20)
AnalyzeMissingIndexesWhich columns lack indexes; optionally scoped to filter columns
Parameters not published.
DescribeTableColumn definitions — supports `brief` mode and column filter
Parameters not published.
ExecuteDdlExecute CREATE/ALTER/DROP and commit
Parameters not published.
ExecuteDmlExecute INSERT/UPDATE/DELETE and commit
Parameters not published.
ExecuteScriptExecute multiple semicolon-separated statements
Parameters not published.
GetDatabaseInfoODS version, page size, dialect, etc.
Parameters not published.
GetExecutionPlanExecution plan for a SELECT — shows index usage
Parameters not published.
GetForeignKeysFK relationships for a table (`in`, `out`, or `all` directions)
Parameters not published.
GetProcedureSourcePSQL source of a stored procedure
Parameters not published.
GetTableConstraintsPK, FK, UNIQUE, CHECK constraints for a table
Parameters not published.
Show all 20 tools
GetTriggerSourcePSQL source of a trigger
Parameters not published.
GetViewSourceSQL source of a view
Parameters not published.
ListActiveConnectionsActive connections to the database
Parameters not published.
ListDatabasesList all servers/databases registered in FlameRobin
Parameters not published.
ListGeneratorsList generators/sequences with current values
Parameters not published.
ListObjectsList tables, views, or both — with optional regex filter
Parameters not published.
ListProceduresList stored procedures — with optional regex filter
Parameters not published.
ListRolesList roles — with optional regex filter
Parameters not published.
ListTriggersList triggers — with optional regex filter
Parameters not published.
RunQueryExecute a SELECT — supports `maxRows` and `columns` projection
Parameters not published.
Ask AI
Ask AI about Michael2150/flamerobin-mcp-server
Powered by Claude · Grounded in docs
Security checks
- ✓README presentThe repository ships documentation.
5 checks have not been run yet.
README
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=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 |
README copy captured when this server was indexed; it may lag the repository. The original is authoritative.