English Français العربية

Flamerobin MCP Server

Communauté Données et bases de données

Access Firebird databases registered in FlameRobin: schema introspection, DDL/DML execution, execution plans and missing index analysis.

Code source Documentation

Installation

Les étapes d'installation sont dans la documentation ci-dessous. Documentation

Documentation

Tirée du README du projet sur GitHub, actualisée chaque semaine. Les liens ouvrent GitHub.

Sommaire
  1. flamerobin-mcp-server
  2. Compared to mcpFirebird
  3. Building
  4. Publishing a single self-contained executable
  5. Claude Desktop configuration
  6. Tools

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 projectmcpFirebird
CredentialsRead automatically from FlameRobin's config — no setup requiredMust pass --user, --password, --host, --database on every launch
Multi-databaseAll FlameRobin-registered databases available in one sessionSingle database per server instance
Wire encryptionSupported (native Firebird .NET driver)Not supported — requires WireCrypt = Disabled on the server
Runtime.NET 9 self-contained executableNode.js / npm
Schema introspectionTables, views, procedures, triggers, generators, roles, FK/PK/constraints, execution plans, missing index analysisTables and basic schema
DDL / DML / scriptsYes — ExecuteDdl, ExecuteDml, ExecuteScriptSQL execution only
DeploymentLocal only — runs on your PC alongside FlameRobinCloud-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

ToolDescription
ListDatabasesList all servers/databases registered in FlameRobin
ListObjectsList tables, views, or both — with optional regex filter
ListProceduresList stored procedures — with optional regex filter
ListTriggersList triggers — with optional regex filter
ListGeneratorsList generators/sequences with current values
ListRolesList roles — with optional regex filter
DescribeTableColumn definitions — supports brief mode and column filter
GetForeignKeysFK relationships for a table (in, out, or all directions)
GetTableConstraintsPK, FK, UNIQUE, CHECK constraints for a table
GetProcedureSourcePSQL source of a stored procedure
GetTriggerSourcePSQL source of a trigger
GetViewSourceSQL source of a view
GetExecutionPlanExecution plan for a SELECT — shows index usage
AnalyzeMissingIndexesWhich columns lack indexes; optionally scoped to filter columns
GetDatabaseInfoODS version, page size, dialect, etc.
ListActiveConnectionsActive connections to the database
RunQueryExecute a SELECT — supports maxRows and columns projection
ExecuteDdlExecute CREATE/ALTER/DROP and commit
ExecuteDmlExecute INSERT/UPDATE/DELETE and commit
ExecuteScriptExecute multiple semicolon-separated statements

Questions fréquentes

Qu'est-ce que Flamerobin MCP Server ?

Access Firebird databases registered in FlameRobin: schema introspection, DDL/DML execution, execution plans and missing index analysis.

Comment installer Flamerobin MCP Server ?

Suivez les étapes d'installation de sa documentation, affichée sur cette page et dans son dépôt.

Flamerobin MCP Server est-il open source ?

Oui. Son code est sur GitHub sous licence MIT.

Qui maintient Flamerobin MCP Server ?

Il est publié par Michael2150. AI.tn le référence sans le maintenir ni le recommander.

Issu des listes communautaires awesome-mcp-servers et du dépôt GitHub du projet. Être listé n'est pas une recommandation : vérifiez le code et les permissions d'un serveur avant de lui donner accès à vos données.