Purpose
flamerobin-mcp-server is a Model Context Protocol (MCP) server for Firebird databases, designed for local scenarios. Its goal is to enable AI assistants (such as Claude Desktop) to access and operate Firebird databases through the MCP protocol, without the need to manually write connection configurations.
Main Capabilities
According to official information, the server supports the following features:
- Database schema introspection: view database structure information.
- Execute DDL/DML: run data definition language and data manipulation language statements.
- View execution plans.
- Missing index analysis.
Usage
The server directly reads the connection details from FlameRobin's configuration file fr_databases.conf, so as long as the user has already set up a Firebird database through FlameRobin, the server works "out of the box" with no additional configuration required.
The project can be published as a single self-contained executable, with the output path publish-single\FirebirdMcp.exe; this folder is ignored by gitignore.
When configuring in Claude Desktop, the relevant configuration needs to be added to claude_desktop_config.json. Official notes specifically state: the environment variable Logging__LogLevel__Default=None must be set, because the server's startup logs are written to stdout, and Claude reads standard output as part of the MCP handshake process; any unexpected output will cause Claude to fail to recognize the server.
Applicable Scenarios
Suitable for local development or operations environments where FlameRobin is already used to manage Firebird databases and where users want to directly perform database schema viewing, SQL execution, execution plan analysis, and index optimization suggestions through AI tools that support MCP, such as Claude Desktop.
Limitations
- The project is intended for local use.
- It depends on FlameRobin's configuration file, so an existing FlameRobin configuration is required.
- When used in Claude Desktop, a specific environment variable must be set, otherwise it cannot be recognized.
- The official information does not provide specific installation commands, source code details, system requirements, pricing information, or platform support scope; this content is not currently provided.
