firebird

This MCP server provides read-only access to a Firebird database, exposing two main capabilities: schema discovery and read-only query execution. The server automatically exposes table schemas via the Table Schemas endpoint (firebird://<host>/<table>/schema) which returns JSON schema information including column names and data types. The primary tool available is query, which executes input SQL within a READ ONLY transaction to retrieve data without modifying the database. When integrating with Claude Desktop or other tools, you point your MCP client at the server (for example via Docker or NPX) and supply the database URL (firebird://host:port/database) depending on your deployment. The server is designed to let LLMs inspect database metadata and run safe, read-only queries to inform reasoning or generate responses based on the data model.

Prerequisites:

• Docker installed and running (for the recommended Docker deployment)
• Optional: Node.js and NPX if you prefer the NPX deployment example

Installation steps (Docker deployment):

1. Build the Docker image (already provided in the repository as mcp/firebird):

docker build -t mcp/firebird -f src/firebird/Dockerfile .

2. Run the MCP server (example with a Firebird database at host.docker.internal:3051/test_db):

docker run -i --rm mcp/firebird firebird://host.docker.internal:3051/test_db

3. Verify the server is reachable by using the MCP client tooling or Claude Desktop configuration as described in the README.

Alternative NPX deployment (if you prefer Node/NPX):

1. Ensure Node.js and NPX are installed.
2. Start the server via NPX (example URL):

npx -y @modelcontextprotocol/server-firebird firebird://localhost:3051/test_db

3. Point your MCP client to the provided URL or host/port of the NPX instance.

Notes and tips:

• The server defaults to read-only mode for all queries to prevent data modification.
• In Docker setups, ensure the DATABASE path and any required initialization scripts are correctly configured inside the container.
• If you are using Claude Desktop, connect using the provided mcpServers block in claude_desktop_config.json and adjust the database URL as needed.
• If you encounter container startup issues, check that DATABASE environment variable is set correctly in any custom Docker deployment and allow adequate time for Firebird to initialize.
• The server exposes table schemas at firebird://<host>/<table>/schema to help LLMs understand the data structures prior to querying.