@PuroDelphi
基本情報
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 対応クライアントに追加してください。
{
"mcpServers": {
"mcp-firebird": {
"command": "npx",
"type": "stdio",
"args": [
"mcp-firebird",
"--host",
"localhost",
"--port",
"3050",
"--database",
"C:\\Databases\\example.fdb",
"--user",
"SYSDBA",
"--password",
"masterkey"
]
}
}
}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).
Returns all indexes for a table, including ordered columns, uniqueness, direction, and segment count.
Returns PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, and CHECK constraints for a table, including constrained columns and references.
Returns only the triggers associated with a table, including source, description, sequence, type, and active state.
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.
Reports wire-encryption configuration; does not verify negotiated encryption on an active database connection.
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
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.
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.
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.
It requires Node.js and npm to install and run. The server is launched as a child process using `npx`.
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.
Authentication is handled via a Firebird username and password (`FIREBIRD_USER` / `FIREBIRD_PASSWORD`). An optional `FIREBIRD_ROLE` can also be set.
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.
Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40
A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi
This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,
Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov
Hindsight: Agent Memory That Learns
コメント