MCP Firebird

Implementation of Anthropic's MCP (Model Context Protocol) for Firebird databases.

What is MCP Firebird?

MCP Firebird is a server that implements Anthropic's Model Context Protocol (MCP) for Firebird SQL databases. It allows Large Language Models (LLMs) like Claude to access, analyze, and manipulate data in Firebird databases securely and in a controlled manner.

Key Features

SQL Queries: Execute SQL queries on Firebird databases
Schema Analysis: Get detailed information about tables, columns, and relationships
Database Management: Perform backup, restore, and validation operations
Performance Analysis: Analyze query performance and suggest optimizations
Multiple Transports: Supports STDIO and SSE (Server-Sent Events) transports
Claude Integration: Works seamlessly with Claude Desktop and other MCP clients
VSCode Integration: Works with GitHub Copilot in Visual Studio Code
Security: Includes SQL query validation and security configuration options

Quick Installation

Installing via Smithery

To install MCP Firebird for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @PuroDelphi/mcpFirebird --client claude

Manual Installation

# Global installation
npm install -g mcp-firebird

# Run the server
npx mcp-firebird --database /path/to/database.fdb

For backup/restore operations, you'll need to install the Firebird client tools. See Complete Installation for more details.

For VSCode and GitHub Copilot integration, see VSCode Integration.

Basic Usage

With Claude Desktop

Edit the Claude Desktop configuration:

code $env:AppData\Claude\claude_desktop_config.json  # Windows
code ~/Library/Application\ Support/Claude/claude_desktop_config.json  # macOS

Add the MCP Firebird configuration:

{
  "mcpServers": {
    "mcp-firebird": {
      "command": "npx",
      "args": [
        "mcp-firebird",
        "--database",
        "C:\\path\\to\\database.fdb",
        "--host",
        "localhost"
        "--port 3050",
        "--database",
        "/path/to/database.fdb"
        "--user"
        "SYSDBA"
        "--password"
        "masterkey"
      ],
      "type": "stdio"
    }
  }
}

Restart Claude Desktop

With SSE Transport

# Start with SSE transport
npx mcp-firebird --transport-type sse --sse-port 3003 --database /path/to/database.fdb

Documentation

For more detailed information, check the following documents:

Recent Versions

Version 2.0.7-alpha.5

Improved detection of Firebird client tools
Updated Dockerfile to use Debian instead of Alpine
Fixed issues with backup/restore operations
Improved documentation and organization
Expanded security documentation with detailed examples
Translated documentation to English

Version 2.0.5

Added support for SSE transport
Improved compatibility with Claude Desktop
Added performance analysis tools
Fixed database connection issues

License

This project is licensed under the MIT License - see the LICENSE file for details.