MCP Firebird is a server that allows Large Language Models (LLMs) to interact with Firebird databases securely and efficiently via the Model Context Protocol. With this server, you can:
- Execute SQL Queries: Run SQL queries with support for pagination and parameterized queries
- Schema Analysis: List tables, describe table schemas, and retrieve field descriptions
- Query Performance: Analyze query performance, get execution plans, and identify missing indexes
- Database Management: Perform backup, restore, and integrity validation operations
- Security: Validate SQL queries with built-in security features
- Connectivity: Test server connectivity and echo messages for debugging
- Integration: Works with Claude Desktop, GitHub Copilot, and VSCode
- Multiple Transports: Supports STDIO and SSE (Server-Sent Events) communication
Provides integration examples for Delphi applications to connect with the MCP Firebird server, allowing Delphi programs to execute SQL queries, list database tables, and generate SQL through the MCP protocol.
Offers Docker configuration for containerized deployment of the MCP Firebird server alongside a Firebird database, with detailed Dockerfile and docker-compose examples for production use.
Offers JavaScript client examples for integrating with the MCP Firebird server, allowing JavaScript applications to execute queries and manage Firebird database data.
Includes Python client examples for connecting to the MCP server, enabling Python applications to execute SQL queries and interact with Firebird databases through the MCP protocol.
Provides TypeScript client examples for integrating with the MCP server, enabling TypeScript applications to execute database queries and interact with Firebird databases through the MCP protocol.
Uses Zod for input validation as part of the server's security measures, ensuring that all inputs to the MCP server are properly validated before processing.
MCP Firebird
Implementation of Anthropic's MCP (Model Context Protocol) for Firebird databases.
Example Usage
https://github.com/user-attachments/assets/e68e873f-f87b-4afd-874f-157086e223af
What is MCP Firebird?
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.
Key Features
- SQL Queries: Execute SQL queries on Firebird databases
- Schema Analysis: Get detailed information about tables, columns, and relationships
- Database Management: Perform backup, restore, and validation operations
- Performance Analysis: Analyze query performance and suggest optimizations
- Multiple Transports: Supports STDIO and SSE (Server-Sent Events) transports
- Claude Integration: Works seamlessly with Claude Desktop and other MCP clients
- VSCode Integration: Works with GitHub Copilot in Visual Studio Code
- Security: Includes SQL query validation and security configuration options
Manual Installation
For backup/restore operations, you'll need to install the Firebird client tools. See Complete Installation for more details.
For VSCode and GitHub Copilot integration, see VSCode Integration.
Basic Usage
With Claude Desktop
- Edit the Claude Desktop configuration:
- Add the MCP Firebird configuration:
- Restart Claude Desktop
With SSE Transport
Quick Installation via Smithery
To install MCP Firebird for Claude Desktop automatically via Smithery:
Documentation
For more detailed information, check the following documents:
- Complete Installation
- Configuration Options
- Available Tools
- Docker Configuration
- Usage from Different Languages
- Security
- Troubleshooting
- Use Cases and Examples
Support the Project
Donations
If you find MCP Firebird useful for your work or projects, please consider supporting its development through a donation. Your contributions help maintain and improve this tool.
- GitHub Sponsors: Sponsor @PuroDelphi
- PayPal: Donate via PayPal
Hire Our AI Agents
Another great way to support this project is by hiring our AI agents through Asistentes Autónomos. We offer specialized AI assistants for various business needs, helping you automate tasks and improve productivity.
Priority Support
⭐ Donors, sponsors, and clients receive priority support and assistance with issues, feature requests, and implementation guidance. While we strive to help all users, those who support the project financially will receive faster response times and dedicated assistance.
Your support is greatly appreciated and helps ensure the continued development of MCP Firebird!
License
This project is licensed under the MIT License - see the LICENSE file for details.
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
Tools
A server implementing Anthropic's Model Context Protocol (MCP) for Firebird SQL databases, enabling Claude and other LLMs to securely access, analyze, and manipulate data in Firebird databases through natural language.
- Example Usage
- What is MCP Firebird?
- Key Features
- Basic Usage
- Quick Installation via Smithery
- Documentation
- Support the Project
- License
Related Resources
Related MCP Servers
- AsecurityAlicenseAqualityA powerful Model Context Protocol (MCP) tool for exploring and managing different types of databases including PostgreSQL, MySQL, and Firestore.Last updated -93TypeScriptMIT License
- AsecurityFlicenseAqualityA Model Context Protocol server that provides tools for programmatically managing Airtable bases, tables, fields, and records through Claude Desktop or other MCP clients.Last updated -1210519JavaScript
- -securityAlicense-qualityA tool that helps easily register Anthropic's Model Context Protocol (MCP) in Claude Desktop and Cursor, providing RAG functionality, Dify integration, and web search capabilities.Last updated -36PythonMIT License
- -securityAlicense-qualityA Model Context Protocol server that enables large language models like Claude to perform comprehensive interactions with Firebase Firestore databases, supporting full CRUD operations, complex queries, and advanced features like transactions and TTL management.Last updated -482JavaScriptMIT License