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, SSE (Server-Sent Events), and Streamable HTTP transports
- Modern Protocol Support: Full support for MCP Streamable HTTP (2025-03-26) and legacy SSE
- Unified Server: Automatic protocol detection and backwards compatibility
- Claude Integration: Works seamlessly with Claude Desktop and other MCP clients
- VSCode Integration: Works with GitHub Copilot in Visual Studio Code
- Session Management: Robust session handling with automatic cleanup and configurable timeouts
- Security: Includes SQL query validation and security configuration options
Manual Installation
Stable Version
Stable Features (v2.2.3):
- 🐛 FIXED: SSE JSON parsing bug - resolves "Invalid message: [object Object]" errors
- ✨ Streamable HTTP transport support (MCP 2025-03-26)
- 🔄 Unified server with automatic protocol detection
- 📊 Enhanced session management and monitoring
- 🛠️ Modern MCP SDK integration (v1.13.2)
- 🔧 Improved error handling and logging
- 🧪 Comprehensive test suite with 9+ tests for SSE functionality
Alpha Version (Latest Features)
Alpha Features (v2.3.0-alpha.1):
- 🐛 FIXED: SSE JSON parsing bug - resolves "Invalid message: [object Object]" errors
- ✨ Streamable HTTP transport support (MCP 2025-03-26)
- 🔄 Unified server with automatic protocol detection
- 📊 Enhanced session management and monitoring
- 🛠️ Modern MCP SDK integration (v1.13.2)
- 🔧 Improved error handling and logging
- 🧪 Comprehensive test suite with 9+ tests for SSE functionality
- 📚 Enhanced documentation with troubleshooting guides
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
Transport Configuration
MCP Firebird supports multiple transport protocols to accommodate different client needs and deployment scenarios.
STDIO Transport (Default)
The STDIO transport is the standard method for Claude Desktop integration:
SSE Transport (Server-Sent Events)
SSE transport allows the server to run as a web service, useful for web applications and remote access:
Basic SSE Configuration
Environment Variables for SSE
SSE Client Connection
Once the SSE server is running, clients can connect to:
- SSE Endpoint:
http://localhost:3003/sse
- Messages Endpoint:
http://localhost:3003/messages
- Health Check:
http://localhost:3003/health
Streamable HTTP Transport (Modern)
The latest MCP protocol supporting bidirectional communication:
Unified Transport (Recommended)
Supports both SSE and Streamable HTTP protocols simultaneously with automatic detection:
Unified Server Endpoints
- SSE (Legacy):
http://localhost:3003/sse
- Streamable HTTP (Modern):
http://localhost:3003/mcp
- Auto-Detection:
http://localhost:3003/mcp-auto
- Health Check:
http://localhost:3003/health
Configuration Examples
Development Setup (SSE)
Production Setup (Unified)
Docker with SSE
Advanced SSE Configuration
Session Management
Configure session timeouts and limits:
CORS Configuration
For web applications, configure CORS settings:
SSL/TLS Support
For production deployments, use a reverse proxy like nginx:
Troubleshooting SSE
Common Issues
- Connection Refused
- Session Timeout
- CORS Errors
- Memory Issues
- JSON Parsing Issues (Fixed in v2.3.0-alpha.1+)Note: Versions prior to 2.3.0-alpha.1 had a bug where POST requests to
/messages
endpoint failed to parse JSON body correctly. This has been fixed with improved middleware handling for bothapplication/json
andtext/plain
content types.
Monitoring and Logging
Quick Installation via Smithery
To install MCP Firebird for Claude Desktop automatically via Smithery:
Documentation
For more detailed information, check the following documents:
Getting Started
Transport Protocols
Integration Guides
Advanced Topics
- Session Management
- Security
- Performance Tuning
- Troubleshooting
- SSE JSON Parsing Fix - Details about the v2.3.0-alpha.1 bug fix
Examples and Use Cases
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 -95MIT License
- -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 -184MIT 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 -54MIT License
- -securityFlicense-qualityA Model Context Protocol (MCP) server that converts natural language queries into SQL statements, allowing users to query MySQL databases using conversational language instead of writing SQL code.Last updated -3