bird MCP Server, configure it with the Claude Desktop app or run it using Docker or NPX commands to connect to your Firebird database. ## key features of Firebird MCP Server? - Executes read-only SQL queries against Firebird databases. - Provides JSON schema information for each table in the database. - Supports integration with LLMs for database inspection. ## use cases of Firebird MCP Server? 1. Inspecting database schemas for development purposes. 2. Executing read-only queries for data analysis. 3. Integrating with AI models for enhanced database interactions. ## FAQ from Firebird MCP Server? - Can I modify data using Firebird MCP Server? > No, the server only allows read-only access to the database. - How do I set up the server with Docker? > You can set up the server by running a Docker command with the appropriate configuration for your database. - Is there a license for using Firebird MCP Server? > Yes, it is licensed under the MIT License, allowing free use, modification, and distribution.26:T6e3a,# MCP Firebird Implementation of Anthropic's MCP protocol for Firebird databases. ## What is MCP Firebird and what is it for? MCP Firebird is a server that implements Anthropic's [Model Context Protocol (MCP)](https://github.com/anthropics/anthropic-cookbook/tree/main/model_context_protocol) 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. You'll find use cases and examples below. ## Installation ```bash # Global installation npm install -g mcp-firebird # Project installation npm install mcp-firebird ``` ## Configuration ### Environment Variables You can configure the server using environment variables: ```bash # Basic configuration export FIREBIRD_HOST=localhost export FIREBIRD_PORT=3050 export FIREBIRD_DATABASE=/path/to/database.fdb export FIREBIRD_USER=SYSDBA export FIREBIRD_PASSWORD=masterkey export FIREBIRD_ROLE=undefined # Optional # Directory configuration (alternative) export FIREBIRD_DATABASE_DIR=/path/to/databases # Directory with databases ``` ### Using with npx You can run the server directly with npx: ```bash npx mcp-firebird --host localhost --port 3050 --database /path/to/database.fdb --user SYSDBA --password masterkey ``` ## Configuration with Claude Desktop To use the Firebird MCP server with Claude Desktop: ```bash code ~/Library/Application\ Support/Claude/claude_desktop_config.json ``` ```powershell code $env:AppData\Claude\claude_desktop_config.json ``` Add the following configuration: ```json { "mcpServers": { "mcp-firebird": { "command": "npx", "args": [ "mcp-firebird", "--host", "localhost", "--port", "3050", "--database", "C:\\Databases\\example.fdb", "--user", "SYSDBA", "--password", "masterkey" ] } } } ``` Make sure to use absolute paths in the configuration. After saving the file, you need to restart Claude Desktop completely. ## Resources and Features The MCP Firebird server offers: - **Databases**: List of all available databases - **Tables**: List of all tables in the database - **Views**: List of all views in the database - **Stored procedures**: Access to procedures in the database - **Table schemas**: Detailed structure of each table - **Data**: Access to table data ## Available Tools 1. **list-tables**: Lists all tables in the database ```json {} // No parameters required ``` 2. **describe-table**: Describes the structure of a table ```json { "tableName": "EMPLOYEES" } ``` 3. **execute-query**: Executes an SQL query in the database ```json { "sql": "SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = 10", "params": [] // Optional parameters for prepared queries } ``` 4. **get-field-descriptions**: Gets field

#firebird

Firebird MCP Server

Mcp Firebird