Fire in da houseTop Tip:Paying $100+ per month for Perplexity, MidJourney, Runway, ChatGPT and other tools is crazy - get all your AI tools in one site starting at $15 per month with Galaxy AI Fire in da houseCheck it out free

mcpFirebird

MCP.Pizza Chef: PuroDelphi

MCP Firebird is a server implementing Anthropic's Model Context Protocol for Firebird SQL databases. It enables LLMs like Claude to securely query, analyze schema, manage, and perform performance analysis on Firebird databases. This server facilitates controlled, real-time interaction between LLMs and Firebird data environments, supporting advanced database operations and insights.

Use This MCP server To

Execute SQL queries on Firebird databases via LLMs Retrieve detailed schema information for Firebird tables and columns Perform database backup and restore operations programmatically Validate Firebird database integrity through automated checks Analyze Firebird database performance metrics Enable LLM-driven data exploration and reporting for Firebird Integrate Firebird database management into AI workflows

README

MCP Firebird

smithery badge

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

Example Usage

ExampleResume.mp4

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

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

  1. Edit the Claude Desktop configuration:

    code $env:AppData\Claude\claude_desktop_config.json  # Windows
    code ~/Library/Application\ Support/Claude/claude_desktop_config.json  # macOS
  2. Add the MCP Firebird configuration:

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

With SSE Transport

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

Quick Installation via Smithery

To install MCP Firebird for Claude Desktop automatically via Smithery:

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

Documentation

For more detailed information, check the following documents:

  • Complete Installation
  • Configuration Options
  • Available Tools
  • Docker Configuration
  • Usage from Different Languages
  • Security
  • Troubleshooting
  • Use Cases and Examples

Support the Project

Donations

If you find MCP Firebird useful for your work or projects, please consider supporting its development through a donation. Your contributions help maintain and improve this tool.

image

Hire Our AI Agents

Another great way to support this project is by hiring our AI agents through Asistentes Autónomos. We offer specialized AI assistants for various business needs, helping you automate tasks and improve productivity.

Priority Support

Donors, sponsors, and clients receive priority support and assistance with issues, feature requests, and implementation guidance. While we strive to help all users, those who support the project financially will receive faster response times and dedicated assistance.

Your support is greatly appreciated and helps ensure the continued development of MCP Firebird!

License

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

mcpFirebird FAQ

How do I connect MCP Firebird to my Firebird database?
Configure the server with your Firebird connection string and credentials to enable secure access.
Can MCP Firebird execute complex SQL queries?
Yes, it supports executing a wide range of SQL queries on Firebird databases.
Is MCP Firebird compatible with LLMs other than Anthropic Claude?
While designed for Anthropic's MCP, it can work with any MCP-compliant LLM like OpenAI GPT-4 and Google Gemini.
How does MCP Firebird ensure secure database access?
It scopes LLM interactions with controlled permissions and secure connection handling.
Can MCP Firebird perform database maintenance tasks?
Yes, it supports backup, restore, and validation operations on Firebird databases.
Does MCP Firebird provide schema insights?
Yes, it offers detailed schema analysis including tables, columns, and relationships.
How do I deploy MCP Firebird?
Deploy it as a lightweight server alongside your Firebird instance, following the GitHub setup instructions.
What performance features does MCP Firebird offer?
It includes tools for analyzing query performance and database health metrics.