MCP Firebird
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 の統合」を参照してください。
基本的な使い方
クロード・デスクトップ
Claude Desktop の構成を編集します。
code $env:AppData\Claude\claude_desktop_config.json # Windows code ~/Library/Application\ Support/Claude/claude_desktop_config.json # macOSMCP 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" } } }Claudeデスクトップを再起動します
SSEトランスポート
# Start with SSE transport
npx mcp-firebird --transport-type sse --sse-port 3003 --database /path/to/database.fdbSmitheryによるクイックインストール
Smithery経由で Claude Desktop 用の MCP Firebird を自動的にインストールするには:
npx -y @smithery/cli install @PuroDelphi/mcpFirebird --client claudeドキュメント
詳しい情報については、次のドキュメントを確認してください。
プロジェクトを支援する
寄付
MCP Firebird が仕事やプロジェクトに役立つと感じられた場合は、ぜひ寄付を通じて開発へのご支援をご検討ください。皆様のご寄付は、このツールの維持と改善に役立ちます。
GitHub スポンサー: @PuroDelphi をスポンサーする
PayPal : PayPal経由で寄付する
AIエージェントを雇う
このプロジェクトを支援するもう一つの素晴らしい方法は、 Aistentes Autónomosを通じて当社のAIエージェントを雇用することです。当社は、様々なビジネスニーズに特化したAIアシスタントを提供し、タスクの自動化と生産性向上を支援します。
優先サポート
⭐寄付者、スポンサー、そしてクライアントの皆様には、問題解決、機能リクエスト、実装ガイダンスなどに関する優先的なサポートと支援を提供いたします。私たちはすべてのユーザーの皆様を支援するよう努めておりますが、プロジェクトに資金的にご支援いただいた方には、より迅速な対応と専用のサポートを提供いたします。
皆様のサポートは大変ありがたく、MCP Firebird の継続的な開発に役立ちます。
ライセンス
このプロジェクトは MIT ライセンスに基づいてライセンスされています - 詳細についてはLICENSEファイルを参照してください。
Available Tools
32 toolsanalyze-missing-indexesanalyze-missing-indexesARead-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-performanceBDestructive
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 StatisticsBRead-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-tablesARead-onlyIdempotent
Gets the detailed schema of multiple tables in parallel for improved performance.
Inputs: tableNames (required), maxConcurrent. Returns: error, result, success
describe-functionDescribe FunctionARead-onlyIdempotent
Gets detailed information about a specific function, including its source code (for PSQL functions)
Inputs: functionName (required). Returns: error, result, success
describe-packageDescribe PackageARead-onlyIdempotent
Gets detailed information about a specific package, including its header and body source
Inputs: packageName (required). Returns: error, result, success
describe-procedureDescribe Stored ProcedureARead-onlyIdempotent
Gets detailed information about a specific stored procedure, including its source code and parameters
Inputs: procedureName (required). Returns: error, result, success
describe-tabledescribe-tableARead-onlyIdempotent
Gets the detailed schema (columns, types, etc.) of a specific table.
Inputs: tableName (required). Returns: error, result, success
describe-triggerDescribe TriggerARead-onlyIdempotent
Gets detailed information about a specific trigger, including its source code, type, sequence, and status
Inputs: triggerName (required). Returns: error, result, success
echoechoBRead-onlyIdempotent
Echoes the original message in structured data with markup-encoded display text
Inputs: message (required). Returns: error, result, success
execute-batch-queriesexecute-batch-queriesBDestructive
Executes multiple SQL queries in parallel for improved performance.
Inputs: queries (required), maxConcurrent. Returns: error, result, success
execute-queryexecute-queryCDestructive
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 InfoCRead-onlyIdempotent
Retrieves general information about the connected Firebird database.
Inputs: no named parameters. Returns: error, result, success
get-execution-planget-execution-planARead-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-descriptionsBRead-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 InformationBRead-onlyIdempotent
Gets information about the Firebird MCP server and its available tools
Inputs: no named parameters. Returns: error, result, success
get-table-constraintsget-table-constraintsARead-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 DataBRead-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-indexesARead-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-triggersARead-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 HelpCRead-onlyIdempotent
Gets detailed information about a specific tool
Inputs: toolName (required). Returns: error, result, success
list-available-eventsList Available EventsBRead-onlyIdempotent
Lists native events (POST_EVENT) available in database triggers and procedures
Inputs: no named parameters. Returns: error, result, success
list-available-toolsList Available ToolsCRead-onlyIdempotent
Lists all tools available on the MCP server
Inputs: category. Returns: error, result, success
list-functionsList FunctionsARead-onlyIdempotent
Lists all functions in the database (UDFs and PSQL functions)
Inputs: no named parameters. Returns: error, result, success
list-packagesList PackagesARead-onlyIdempotent
Lists all packages in the database (available in Firebird 3.0+)
Inputs: no named parameters. Returns: error, result, success
list-proceduresList Stored ProceduresARead-onlyIdempotent
Lists all stored procedures in the database with input and output parameter information
Inputs: no named parameters. Returns: error, result, success
list-tableslist-tablesARead-onlyIdempotent
Lists all user tables in the current Firebird database.
Inputs: no named parameters. Returns: error, result, success
list-triggersList TriggersBRead-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_eventBIdempotent
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 CheckARead-onlyIdempotent
Reports process health and runtime information; does not probe database connectivity
Inputs: no named parameters. Returns: error, result, success
unsubscribe_from_eventunsubscribe_from_eventAIdempotent
Release a Firebird event registration owned by this connection or HTTP application
Inputs: eventName (required). Returns: error, result, success
verify-wire-encryptionVerify Wire EncryptionARead-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
Scored across 32 tools
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.
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.
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.
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
Related MCP Connectors
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
MCP server unifying ERPs, CRMs, APIs and knowledge base for Claude, ChatGPT and Gemini.
Hosted PostgreSQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceThis 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
- FlicenseAqualityCmaintenanceA 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-
- AlicenseNot gradedqualityDmaintenanceEnables 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
- AlicenseAqualityCmaintenanceA 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.292MIT