Firebird SQL

MCP Firebird

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

Example Usage

https://github.com/user-attachments/assets/e68e873f-f87b-4afd-874f-157086e223af

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, SSE (Server-Sent Events), and Streamable HTTP transports
• Modern Protocol Support: Full support for MCP Streamable HTTP (2025-03-26) and legacy SSE
• Unified Server: Automatic protocol detection and backwards compatibility
• Claude Integration: Works seamlessly with Claude Desktop and other MCP clients
• VSCode Integration: Works with GitHub Copilot in Visual Studio Code
• Session Management: Robust session handling with automatic cleanup and configurable timeouts
• Security: Includes SQL query validation and security configuration options
• Dual Driver Support: Choose between simple installation (default) or native driver with wire encryption support

🚀 Quick Start with Smithery (Recommended for Cloud Deployment)

Deploy MCP Firebird to the cloud in under 5 minutes!

Smithery is the easiest way to deploy MCP Firebird to production:

✅ One-click deployment - No infrastructure setup required ✅ Automatic scaling - Handles traffic spikes automatically ✅ Built-in monitoring - Track usage and performance ✅ Secure credentials - Encrypted environment variables ✅ Auto-updates - Always running the latest version ✅ Global CDN - Low latency worldwide

How to Deploy on Smithery

1. Visit smithery.ai
2. Connect your GitHub account
3. Select the mcpFirebird repository
4. Configure your Firebird database connection:

   host: "your-firebird-server.com"
   port: 3050
   database: "/path/to/database.fdb"
   user: "SYSDBA"
   password: "your-secure-password"
   useNativeDriver: true  # Enable wire encryption (optional)
   logLevel: "info"
   

5. Click Deploy - Done! ✨

Your MCP Firebird server will be available at:

https://server.smithery.ai/your-username/mcp-firebird

Using with AI Clients

import { Client } from "@modelcontextprotocol/sdk/client/index.js";
import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp.js";

const transport = new StreamableHTTPClientTransport(
  "https://server.smithery.ai/your-username/mcp-firebird"
);

const client = new Client({
  name: "my-ai-app",
  version: "1.0.0"
});

await client.connect(transport);

📚 For detailed Smithery deployment instructions, see SMITHERY_DEPLOYMENT.md

🔒 Wire Encryption Support

MCP Firebird supports two driver options:

Driver	Installation	Wire Encryption	Use Case
Pure JavaScript (default)	✅ Simple (npx)	❌ No	Most users, quick setup
Native Driver (optional)	⚠️ Complex (requires build tools)	✅ Yes	Enterprise, security required

Quick Start (Default - No Wire Encryption)

npx mcp-firebird@alpha --database=/path/to/database.fdb

Advanced (With Wire Encryption Support)

⚠️ CRITICAL: npx does NOT work with the native driver. You MUST install globally.

⚠️ IMPORTANT: Wire encryption must be configured on the Firebird server (firebird.conf), not on the client.

Server Configuration (required first):

# In firebird.conf on the server
WireCrypt = Required  # or Enabled

Client Installation (MUST be global):

# Step 1: Install build tools
# Windows: Visual Studio Build Tools (https://visualstudio.microsoft.com/downloads/)
# Linux: sudo apt-get install build-essential python3 firebird-dev
# macOS: xcode-select --install && brew install firebird

# Step 2: Install MCP Firebird globally
npm install -g mcp-firebird@alpha

# Step 3: Install native driver globally
npm install -g node-firebird-driver-native

# Step 4: Run directly (WITHOUT npx)
mcp-firebird --use-native-driver \
  --database=/path/to/database.fdb \
  --host=localhost \
  --user=SYSDBA \
  --password=masterkey

Why not npx? When npx runs a package from its temporary cache, it cannot access globally installed modules like node-firebird-driver-native. Both packages must be installed globally in the same location.

📚 For detailed installation instructions, see:

• Smithery CLI Installation Guide - ⭐ Recommended for local setup
• Native Driver Installation Guide - Step-by-step for Windows/Linux/macOS
• Wire Encryption Guide
• Advanced Installation Guide

🖥️ Local Installation with Smithery CLI

⭐ Recommended for local AI clients (Claude Desktop, Cursor, etc.)

The Smithery CLI provides the easiest way to install and configure MCP Firebird for local use:

Quick Install

# Interactive installation (prompts for configuration)
npx -y @smithery/cli@latest install mcp-firebird --client claude

# Pre-configured installation (skip prompts)
npx -y @smithery/cli@latest install mcp-firebird --client claude --config '{
  "database": "/path/to/database.fdb",
  "user": "SYSDBA",
  "password": "masterkey",
  "useNativeDriver": false
}'

Features

• ✅ One-command installation - No manual configuration needed
• ✅ Multiple clients - Works with Claude Desktop, Cursor, and more
• ✅ Interactive setup - Prompts for all required settings
• ✅ Auto-configuration - Automatically configures your AI client
• ✅ Easy management - List, inspect, and uninstall servers easily

Common Commands

# List installed servers
npx @smithery/cli list servers --client claude

# Inspect server configuration
npx @smithery/cli inspect mcp-firebird

# Uninstall server
npx @smithery/cli uninstall mcp-firebird --client claude

📖 Full Guide: Smithery CLI Installation Guide

Manual Installation

Stable Version

# Global installation (stable)
npm install -g mcp-firebird

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

# Or use specific stable version
npm install -g [email protected]

Stable Features (v2.2.3):

• 🐛 FIXED: SSE JSON parsing bug - resolves "Invalid message: [object Object]" errors
• ✨ Streamable HTTP transport support (MCP 2025-03-26)
• 🔄 Unified server with automatic protocol detection
• 📊 Enhanced session management and monitoring
• 🛠️ Modern MCP SDK integration (v1.13.2)
• 🔧 Improved error handling and logging
• 🧪 Comprehensive test suite with 9+ tests for SSE functionality

Alpha Version (Latest Features)

# Install alpha version with latest features
npm install -g mcp-firebird@alpha

# Or use specific alpha version
npm install -g [email protected]

Alpha Features (v2.4.0-alpha.0):

• � NEW: Ready for next development cycle
• ✨ All stable features from v2.2.3 included
• 🔄 Unified server with automatic protocol detection
• 📊 Enhanced session management and monitoring
• 🛠️ Modern MCP SDK integration (v1.13.2)
• 🔧 Improved error handling and logging
• 🧪 Comprehensive test suite with 9+ tests for SSE functionality
• 📚 Enhanced documentation with troubleshooting guides

Note: The SSE JSON parsing bug fix is now available in stable v2.2.3

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

Transport Configuration

MCP Firebird supports multiple transport protocols to accommodate different client needs and deployment scenarios.

STDIO Transport (Default)

The STDIO transport is the standard method for Claude Desktop integration:

{
  "mcpServers": {
    "mcp-firebird": {
      "command": "npx",
      "args": [
        "mcp-firebird",
        "--database", "C:\\path\\to\\database.fdb",
        "--user", "SYSDBA",
        "--passw

---

*README truncated. [View full README on GitHub](https://github.com/purodelphi/mcpfirebird).*