@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.
不止于 CSS
Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea
Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep
DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.
Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code
评论