Firebird MCP Server: Secure SQL Query & Schema Exploration

Firebird MCP Server empowers secure, read-only SQL querying and intuitive schema exploration for Firebird databases—streamlining data access without compromising integrity.

Visit Repository

✨ Research And Data

4.7(61 reviews)

91 saves

42 comments

47% of users reported increased productivity after just one week

About Firebird MCP Server

What is Firebird MCP Server: Secure SQL Query & Schema Exploration?

Firebird MCP Server is a Model Context Protocol (MCP) implementation that provides secure, read-only access to Firebird databases. Designed for integration with large language models (LLMs), it enables automated inspection of database schemas and execution of SQL queries within strict transactional constraints. This server acts as a bridge between AI systems and legacy or production databases, ensuring data integrity while facilitating analysis and exploration.

Key Features of Firebird MCP Server: Secure SQL Query & Schema Exploration?

Read-Only Transactions: All SQL operations are confined to read-only transactions to prevent accidental data modification.
Automatic Schema Discovery: Exposes table structures via standardized URLs (e.g., firebird://host/table/schema), including column names, data types, and constraints.
Security-first Design: Enforces access controls through environment variables, supporting encrypted connections and restricted authentication methods.
Platform Compatibility: Works seamlessly with Docker deployments and direct Node.js configurations via the NPX toolchain.

Firebird MCP Server Features

How to Use Firebird MCP Server: Configuration Examples

Docker Deployment

docker run -e DB_USER=readonly -e DB_PASSWORD=securepass \
-e DB_HOST=localhost -e DB_NAME=mydb \
-p 5000:5000 firebird-mcp:latest

Modify environment variables to match your database credentials and network settings.

NPX Setup

npx firebird-mcp --config ./custom-config.json

Custom configurations can define schema paths, query rate limits, and logging behaviors.

Common Use Cases

Data Migration Validation: Verify schema compatibility between systems without altering source databases.
AI-Driven Reporting: Power automated report generation by extracting structured data through LLM queries.
Development Environments: Safely expose production schemas to test environments while maintaining data security.

Firebird MCP Server FAQ

Frequently Asked Questions (FAQ)

Why do I get a "Connection Refused" error?

Check firewall rules and ensure the Firebird database service is running. Verify the DB_HOST and DB_PORT match your network configuration.

Can I customize query permissions?

Yes. Use the QUERY_WHITELIST environment variable to restrict allowed SQL operations to specific tables or functions.

What licensing applies?

Released under the MIT License, allowing free use in commercial and open-source projects. Attribution to the maintainers is recommended but not required.

Content

Firebird MCP Server

A Model Context Protocol server that provides read-only access to Firebird databases. This server enables LLMs to inspect database schemas and execute read-only queries.

Components

Tools

query
- Execute read-only SQL queries against the connected database
- Input: sql (string): The SQL query to execute
- All queries are executed within a READ ONLY transaction

Resources

The server provides schema information for each table in the database:

Table Schemas (firebird://<host>/<table>/schema)
- JSON schema information for each table
- Includes column names and data types
- Automatically discovered from database metadata

Usage with Claude Desktop

To use this server with the Claude Desktop app, add the following configuration to the "mcpServers" section of your claude_desktop_config.json:

Docker

When running docker on macos, use host.docker.internal if the server is running on the host network (eg localhost)
username/password can be added to the firebird url with firebird://SYSDBA:masterkey@host:3051/test_db

{
"mcpServers": {
"firebird": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/firebird",
"firebird://host.docker.internal:3051/test_db"
]
}
}
}

NPX

{
  "mcpServers": {
    "firebird": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-firebird",
        "firebird://localhost:3051/test_db"
      ]
    }
  }
}

Replace /test_db with your database name.

Development Setup

Docker Environment Variables

Required environment variables for the Firebird container:

DATABASE: Path to the database file (e.g., /firebird/data/test_db.fdb)
FIREBIRD_USER: Database user (default: SYSDBA)
FIREBIRD_PASSWORD: Database password (default: masterkey)
EnableLegacyClientAuth: Enable legacy client authentication (default: "true")
EnableWireCrypt: Enable wire encryption (default: "false")
CreateDb: Allow database creation (default: "true")

Building

Docker:

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

Troubleshooting

Common issues:

Container startup failures:

* Ensure the DATABASE environment variable is properly set
* Check permissions on the firebird_data volume
* Allow sufficient time for the Firebird server to initialize

Database initialization:

* The server uses several initialization scripts (init.sql, test_db.sql)
* Ensure these files have correct permissions

License

This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.