Skip to main content
Glama

MCP ファイアーバード

鍛冶屋のバッジ

Firebird データベース用の Anthropic の MCP (Model Context Protocol) の実装。

使用例

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

Related MCP server: MSSQL MCP Server

MCP Firebird とは何ですか?

MCP Firebirdは、Firebird SQLデータベース向けにAnthropicのモデルコンテキストプロトコル(MCP)を実装したサーバーです。これにより、Claudeのような大規模言語モデル(LLM)は、Firebirdデータベース内のデータに安全かつ制御された方法でアクセス、分析、操作できるようになります。

主な特徴

  • SQLクエリ: FirebirdデータベースでSQLクエリを実行する

  • スキーマ分析: テーブル、列、関係に関する詳細情報を取得します

  • データベース管理: バックアップ、復元、検証操作を実行する

  • パフォーマンス分析: クエリのパフォーマンスを分析し、最適化を提案します

  • 複数のトランスポート: STDIO および SSE (Server-Sent Events) トランスポートをサポート

  • Claude 統合: Claude Desktop およびその他の MCP クライアントとシームレスに連携します

  • VSCode 統合: Visual Studio Code で GitHub Copilot と連携

  • セキュリティ: SQLクエリ検証とセキュリティ構成オプションが含まれます

手動インストール

# Global installation
npm install -g mcp-firebird

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

バックアップ/復元操作を行うには、Firebirdクライアントツールをインストールする必要があります。詳細については、 「完全インストール」をご覧ください。

VSCode と GitHub Copilot の統合については、 「VSCode の統合」を参照してください。

基本的な使い方

クロード・デスクトップ

  1. Claude Desktop の構成を編集します。

    code $env:AppData\Claude\claude_desktop_config.json  # Windows
    code ~/Library/Application\ Support/Claude/claude_desktop_config.json  # macOS
  2. MCP Firebird 構成を追加します。

    {
      "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. Claudeデスクトップを再起動します

SSEトランスポート

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

Smitheryによるクイックインストール

Smithery経由で Claude Desktop 用の MCP Firebird を自動的にインストールするには:

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

ドキュメント

詳しい情報については、次のドキュメントを確認してください。

プロジェクトを支援する

寄付

MCP Firebird が仕事やプロジェクトに役立つと感じられた場合は、ぜひ寄付を通じて開発へのご支援をご検討ください。皆様のご寄付は、このツールの維持と改善に役立ちます。

画像

AIエージェントを雇う

このプロジェクトを支援するもう一つの素晴らしい方法は、 Aistentes Autónomosを通じて当社のAIエージェントを雇用することです。当社は、様々なビジネスニーズに特化したAIアシスタントを提供し、タスクの自動化と生産性向上を支援します。

優先サポート

⭐寄付者、スポンサー、そしてクライアントの皆様には、問題解決、機能リクエスト、実装ガイダンスなどに関する優先的なサポートと支援を提供いたします。私たちはすべてのユーザーの皆様を支援するよう努めておりますが、プロジェクトに資金的にご支援いただいた方には、より迅速な対応と専用のサポートを提供いたします。

皆様のサポートは大変ありがたく、MCP Firebird の継続的な開発に役立ちます。

ライセンス

このプロジェクトは MIT ライセンスに基づいてライセンスされています - 詳細についてはLICENSEファイルを参照してください。

Available Tools

32 tools
analyze-missing-indexesanalyze-missing-indexesA
Read-onlyIdempotent

Suggests indexes for simple single-table SELECT predicates/order terms after checking existing catalog indexes, including primary keys. Heuristic advice only; never executes the query or applies index DDL.

Inputs: sql (required). Returns: error, result, success

analyze-query-performanceanalyze-query-performanceB
Destructive

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

Inputs: sql (required), params, iterations. Returns: error, result, success

analyze-table-statisticsAnalyze Table StatisticsB
Read-onlyIdempotent

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

Inputs: tableName (required). Returns: error, result, success

describe-batch-tablesdescribe-batch-tablesA
Read-onlyIdempotent

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

Inputs: tableNames (required), maxConcurrent. Returns: error, result, success

describe-functionDescribe FunctionA
Read-onlyIdempotent

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

Inputs: functionName (required). Returns: error, result, success

describe-packageDescribe PackageA
Read-onlyIdempotent

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

Inputs: packageName (required). Returns: error, result, success

describe-procedureDescribe Stored ProcedureA
Read-onlyIdempotent

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

Inputs: procedureName (required). Returns: error, result, success

describe-tabledescribe-tableA
Read-onlyIdempotent

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

Inputs: tableName (required). Returns: error, result, success

describe-triggerDescribe TriggerA
Read-onlyIdempotent

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

Inputs: triggerName (required). Returns: error, result, success

echoechoB
Read-onlyIdempotent

Echoes the original message in structured data with markup-encoded display text

Inputs: message (required). Returns: error, result, success

execute-batch-queriesexecute-batch-queriesB
Destructive

Executes multiple SQL queries in parallel for improved performance.

Inputs: queries (required), maxConcurrent. Returns: error, result, success

execute-queryexecute-queryC
Destructive

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

Inputs: sql (required), params. Returns: error, result, success

get-database-infoGet Database InfoC
Read-onlyIdempotent

Retrieves general information about the connected Firebird database.

Inputs: no named parameters. Returns: error, result, success

get-execution-planget-execution-planA
Read-onlyIdempotent

Prepares an authorized SELECT in a read-only transaction and retrieves its optimizer plan without executing it. Parameters are not bound; unavailable plans return an error, never an execution fallback.

Inputs: sql (required), params. Returns: error, result, success

get-field-descriptionsget-field-descriptionsB
Read-onlyIdempotent

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

Inputs: tableName (required). Returns: error, result, success

get-server-infoGet Server InformationB
Read-onlyIdempotent

Gets information about the Firebird MCP server and its available tools

Inputs: no named parameters. Returns: error, result, success

get-table-constraintsget-table-constraintsA
Read-onlyIdempotent

Returns PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, and CHECK constraints for a table, including constrained columns and references.

Inputs: tableName (required). Returns: error, result, success

get-table-dataGet Table DataB
Read-onlyIdempotent

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

Inputs: tableName (required), skip, first, filters, +1 more. Returns: error, result, success

get-table-indexesget-table-indexesA
Read-onlyIdempotent

Returns all indexes for a table, including ordered columns, uniqueness, direction, and segment count.

Inputs: tableName (required). Returns: error, result, success

get-table-triggersget-table-triggersA
Read-onlyIdempotent

Returns only the triggers associated with a table, including source, description, sequence, type, and active state.

Inputs: tableName (required). Returns: error, result, success

get-tool-helpGet Tool HelpC
Read-onlyIdempotent

Gets detailed information about a specific tool

Inputs: toolName (required). Returns: error, result, success

list-available-eventsList Available EventsB
Read-onlyIdempotent

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

Inputs: no named parameters. Returns: error, result, success

list-available-toolsList Available ToolsC
Read-onlyIdempotent

Lists all tools available on the MCP server

Inputs: category. Returns: error, result, success

list-functionsList FunctionsA
Read-onlyIdempotent

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

Inputs: no named parameters. Returns: error, result, success

list-packagesList PackagesA
Read-onlyIdempotent

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

Inputs: no named parameters. Returns: error, result, success

list-proceduresList Stored ProceduresA
Read-onlyIdempotent

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

Inputs: no named parameters. Returns: error, result, success

list-tableslist-tablesA
Read-onlyIdempotent

Lists all user tables in the current Firebird database.

Inputs: no named parameters. Returns: error, result, success

list-triggersList TriggersB
Read-onlyIdempotent

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

Inputs: no named parameters. Returns: error, result, success

subscribe_to_eventsubscribe_to_eventB
Idempotent

Register a Firebird POST_EVENT listener; MCP resource subscription is also required for notifications

Inputs: eventName (required). Returns: error, result, success

system-health-checkSystem Health CheckA
Read-onlyIdempotent

Reports process health and runtime information; does not probe database connectivity

Inputs: no named parameters. Returns: error, result, success

unsubscribe_from_eventunsubscribe_from_eventA
Idempotent

Release a Firebird event registration owned by this connection or HTTP application

Inputs: eventName (required). Returns: error, result, success

verify-wire-encryptionVerify Wire EncryptionA
Read-onlyIdempotent

Reports wire-encryption configuration; does not verify negotiated encryption on an active database connection.

Inputs: no named parameters. Returns: error, result, success

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.4/5.0

    Scored across 32 tools

    Disambiguation4/5

    Most tools target clearly distinct resources and actions, especially the table, trigger, procedure, function, package, and query-analysis families. There is some overlap among meta/introspection tools such as get-server-info vs list-available-tools, and between list-triggers, get-table-triggers, and describe-trigger, but descriptions generally make the intended use clear.

    Naming Consistency4/5

    Most tool names follow a predictable kebab-case verb_noun pattern such as list-tables, describe-table, get-table-indexes, and execute-query. The main deviations are subscribe_to_event and unsubscribe_from_event using snake_case, plus a few noun-only names like echo, but the overall convention remains readable and mostly consistent.

    Tool Count2/5

    With 32 tools, the server is well above the typical well-scoped range and includes several niche or overlapping meta tools such as list-available-tools, get-server-info, system-health-check, and batch variants. The breadth reflects a comprehensive Firebird surface, but the count feels heavy rather than tightly curated.

    Completeness4/5

    Core Firebird workflows are well covered: tables, schemas, data access, indexes, constraints, triggers, procedures, functions, packages, query execution, plans, performance analysis, events, and database/server metadata. Some object categories such as views, generators/sequences, and privileges lack dedicated list/describe tools, though agents can query system tables via execute-query as a workaround.

    Maintenance

    ActivityMaintained
    ResponsivenessOutdated data

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      This server enables Claude to directly interact with SQLite, SQL Server, PostgreSQL, and MySQL databases through the Model Context Protocol, allowing for query execution, table management, and data export capabilities.
      MIT
    • F
      license
      A
      quality
      C
      maintenance
      A Model Context Protocol server that enables LLMs like Claude to interact with Microsoft SQL Server databases through natural language, supporting queries, data manipulation, and table management.
      8
      -
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables Large Language Models like Claude to access, query, analyze, and manage Firebird SQL databases with support for schema inspection, performance analysis, and database operations through the Model Context Protocol.
      MIT
    • A
      license
      A
      quality
      C
      maintenance
      A Model Context Protocol (MCP) server for Firebird databases intended for local use. It reads connection details from FlameRobin's fr_databases.conf so no extra configuration is needed — if you have FlameRobin set up with your Firebird databases, this server works out of the box.
      29
      2
      MIT