Mcp Firebird

@PuroDelphi

About 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.

#mcp-firebird #database #mcp-protocol

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

Executes a SQL query in the Firebird database. Uses FIRST/ROWS for pagination.

Lists all user tables in the current Firebird database.

Gets the detailed schema (columns, types, etc.) of a specific table.

Gets the stored descriptions for fields of a specific table (if they exist).

Analyzes the performance of a SQL query by executing it multiple times and measuring execution time

Gets the execution plan for a SQL query to understand how the database will execute it

Analyzes a SQL query to identify missing indexes that could improve performance

Executes multiple SQL queries in parallel for improved performance.

Gets the detailed schema of multiple tables in parallel for improved performance.

Retrieves data from a specific table with optional filtering, pagination, and ordering.

Analyzes statistical information about a table including row count, column statistics, and data distribution.

Verifies if the current database connection is using wire encryption (requires native driver).

Retrieves general information about the connected Firebird database.

Gets information about the Firebird MCP server and its available tools

Lists all tools available on the MCP server

Gets detailed information about a specific tool

Checks system health and database connectivity

Lists native events (POST_EVENT) available in database triggers and procedures

Lists all database triggers with their associated table, trigger type, and status

Gets detailed information about a specific trigger, including its source code, type, sequence, and status

Lists all stored procedures in the database with input and output parameter information

Gets detailed information about a specific stored procedure, including its source code and parameters

Lists all functions in the database (UDFs and PSQL functions)

Gets detailed information about a specific function, including its source code (for PSQL functions)

Lists all packages in the database (available in Firebird 3.0+)

Gets detailed information about a specific package, including its header and body source

Subscribe to a Firebird event (POST_EVENT) to receive proactive notifications

Overview

What is Mcp Firebird?

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

How to use Mcp Firebird?

Install globally or locally via npm (npm install -g mcp-firebird or npm install mcp-firebird). Configure using environment variables (FIREBIRD_HOST, FIREBIRD_PORT, FIREBIRD_DATABASE, FIREBIRD_USER, FIREBIRD_PASSWORD, FIREBIRD_ROLE) or run directly with npx and command-line arguments (npx mcp-firebird --host localhost --port 3050 --database /path/to/database.fdb --user SYSDBA --password masterkey). For Claude Desktop, add the server configuration to claude_desktop_config.json using absolute paths.

Key features of Mcp Firebird

List all databases, tables, views, and stored procedures
Retrieve detailed table schemas and field descriptions
Execute arbitrary SQL queries with optional parameters
Four built-in prompts: query-data, analyze-table, optimize-query, generate-sql
Retrieve field comments from Firebird’s RDB$DESCRIPTION metadata

Use cases of Mcp Firebird

Query data using natural language instead of writing raw SQL
Analyze table structures and their purposes with semantic context
Optimize existing SQL queries for better performance
Generate SQL from a plain-language description (e.g., “get the 10 best-selling products”)
Build custom AI assistants that directly interact with Firebird databases

FAQ from Mcp Firebird

What is MCP and how does Mcp Firebird relate to it?

MCP (Model Context Protocol) is a protocol by Anthropic that allows LLMs to access external tools and data. Mcp Firebird implements this protocol specifically for Firebird databases, enabling LLMs like Claude to interact with the database.

What runtime dependencies does Mcp Firebird have?

It requires Node.js and npm to install and run. The server is launched as a child process using npx.

Where does the data live when using Mcp Firebird?

All data remains in the Firebird database specified via the --database argument or FIREBIRD_DATABASE environment variable. The server only reads and writes to that database.

What authentication is supported?

Authentication is handled via a Firebird username and password (FIREBIRD_USER / FIREBIRD_PASSWORD). An optional FIREBIRD_ROLE can also be set.

How does the server transport data?

The server communicates over standard input/output (stdin/stdout) as a child process, following the MCP transport contract. The README examples show usage with ChildProcessTransport in TypeScript and subprocess.Popen in Python.

Frequently asked questions

What is MCP and how does Mcp Firebird relate to it?

What runtime dependencies does Mcp Firebird have?

It requires Node.js and npm to install and run. The server is launched as a child process using `npx`.

Where does the data live when using Mcp Firebird?

All data remains in the Firebird database specified via the `--database` argument or `FIREBIRD_DATABASE` environment variable. The server only reads and writes to that database.

What authentication is supported?

Authentication is handled via a Firebird username and password (`FIREBIRD_USER` / `FIREBIRD_PASSWORD`). An optional `FIREBIRD_ROLE` can also be set.

How does the server transport data?

The server communicates over standard input/output (stdin/stdout) as a child process, following the MCP transport contract. The README examples show usage with `ChildProcessTransport` in TypeScript and `subprocess.Popen` in Python.