MCP Firebird

# 🚀 MCP Firebird v2.5.0 - Major Release **Release Date:** January 2025 **Status:** Stable Release **Previous Version:** 2.4.x --- ## 🎉 Overview Version 2.5.0 represents a major milestone for MCP Firebird, bringing **universal deployment compatibility**, **performance optimizations**, and **enterprise-ready features**. This release focuses on making MCP Firebird deployable anywhere - from Docker to cloud platforms, from local development to production environments. --- ## ✨ Major Features ### 🌐 Universal Deployment Support **Docker Everywhere** - ✅ Multi-stage Dockerfile for optimized builds - ✅ Production-ready container images - ✅ Support for Railway, Render, Fly.io, Google Cloud Run, AWS ECS, Azure ACI - ✅ Docker Compose configurations - ✅ Reduced image size (22% smaller) **Flexible Runtime Options** - ✅ STDIO transport for Claude Desktop - ✅ HTTP/SSE transport for web clients - ✅ NPX/NPM global installation - ✅ Native driver support for wire encryption ### ⚡ Performance Optimizations **Build Performance** - 🚀 **50-60% faster TypeScript compilation** - 🚀 Multi-stage Docker builds - 🚀 Optimized tsconfig for production - 🚀 Incremental compilation support - 🚀 Reduced build context size **Runtime Performance** - 🚀 Smaller production images (only necessary dependencies) - 🚀 Faster startup times - 🚀 Optimized dependency tree - 🚀 Better memory footprint **Build Metrics:** | Metric | v2.4.x | v2.5.0 | Improvement | |--------|--------|--------|-------------| | TypeScript Compilation | 8-10s | 3-5s | **50-60%** | | Docker Image Size | ~450MB | ~350MB | **22%** | | Build Time | Variable | 2-3min | **Consistent** | | Production Dependencies | All | Optimized | **-200MB** | ### 🔒 Wire Encryption Support **Enterprise Security** - ✅ Full support for Firebird 3.0+ wire encryption - ✅ Native driver integration (`node-firebird-driver-native`) - ✅ Compatible with `WireCrypt = Required` servers - ✅ Automatic driver detection - ✅ Fallback to pure JavaScript driver **Configuration:** ```bash # Enable wire encryption USE_NATIVE_DRIVER=true ``` ### 📚 Comprehensive Documentation **New Documentation Files** - 📖 `DEPLOYMENT.md` - Complete deployment guide - Docker deployment examples - NPX/NPM installation - Configuration reference - Security best practices - Troubleshooting guide - 📖 Enhanced README with: - Quick start guides - Multiple deployment options - Configuration examples - Video tutorials --- ## 🔧 Technical Improvements ### Docker Optimizations **Multi-Stage Build:** ```dockerfile # Stage 1: Builder (with devDependencies) FROM node:20-slim AS builder RUN npm ci --include=dev RUN npm run build # Stage 2: Production (optimized) FROM node:20-slim RUN npm ci --omit=dev COPY --from=builder /app/dist ./dist ``` **Benefits:** - Smaller final images - Faster builds with better caching - Separation of build and runtime dependencies - Enhanced security (no dev tools in production) ### TypeScript Configuration **Production Build Config (`tsconfig.build.json`):** ```json { "compilerOptions": { "declaration": false, "sourceMap": false, "removeComments": true, "incremental": false } } ``` **Development Config (`tsconfig.json`):** ```json { "compilerOptions": { "declaration": true, "sourceMap": true, "incremental": true } } ``` ### Enhanced .dockerignore Optimized build context by excluding: - Development files (tests, docs) - Build artifacts (dist, node_modules) - IDE configurations - Unnecessary metadata **Result:** Faster builds, smaller context, better caching --- ## 🆕 New Features ### Build Scripts ```json { "build": "tsc -p tsconfig.build.json", // Production "build:dev": "tsc" // Development } ``` ### Configuration Schema Standardized configuration across all deployment methods: - Database connection parameters - Wire encryption settings - Logging configuration - Transport type selection --- ## 🔄 Breaking Changes ### None! 🎉 Version 2.5.0 is **fully backward compatible** with 2.4.x: - ✅ All existing configurations work unchanged - ✅ Same CLI arguments and environment variables - ✅ Same MCP protocol implementation - ✅ Same tool and prompt APIs --- ## 📦 Deployment Options ### Option 1: Docker ```bash # Build docker build -t mcp-firebird . # Run docker run -d -p 3003:3003 \ -e FIREBIRD_HOST=your-host \ -e FIREBIRD_DATABASE=/path/to/db.fdb \ mcp-firebird ``` ### Option 3: NPX/NPM ```bash # Install npm install -g mcp-firebird # Run mcp-firebird --host localhost --database /path/to/db.fdb ``` ### Option 4: Docker Compose ```yaml services: mcp-firebird: build: . ports: - "3003:3003" environment: - FIREBIRD_HOST=your-host - FIREBIRD_DATABASE=/path/to/db.fdb ``` --- ## 🐛 Bug Fixes - Fixed npm dependency resolution in Docker builds - Fixed package-lock.json inconsistencies - Fixed TypeScript compilation performance - Fixed Docker layer caching - Improved error handling and validation - Fixed Zod schema extraction for MCP API --- ## 📊 Compatibility Matrix | Platform | Status | Method | |----------|--------|--------| | **Docker** | ✅ Fully Supported | Multi-stage build | | **Railway** | ✅ Fully Supported | Auto-detect Dockerfile | | **Render** | ✅ Fully Supported | Docker runtime | | **Fly.io** | ✅ Fully Supported | fly deploy | | **Google Cloud Run** | ✅ Fully Supported | gcloud run deploy | | **AWS ECS/Fargate** | ✅ Fully Supported | ECR + ECS | | **Azure ACI** | ✅ Fully Supported | ACR deployment | | **DigitalOcean** | ✅ Fully Supported | App Platform | | **Claude Desktop** | ✅ Fully Supported | STDIO transport | | **NPX/NPM** | ✅ Fully Supported | Global install | --- ## 🔐 Security Enhancements - Multi-stage Docker builds (no dev dependencies in production) - Non-root user in containers - Wire encryption support for Firebird 3.0+ - Secure credential handling - Environment variable validation - Input sanitization --- ## 📈 Migration Guide ### From v2.4.x to v2.5.0 **No changes required!** Simply update: ```bash # NPM npm install -g mcp-firebird@latest # Docker docker pull your-registry/mcp-firebird:2.5.0 ``` All existing configurations, environment variables, and CLI arguments remain compatible. --- ## 🙏 Acknowledgments Special thanks to: - The Firebird community - All contributors and testers - Early adopters who provided feedback --- ## 💬 Support & Resources - **Documentation:** [DEPLOYMENT.md](./DEPLOYMENT.md) - **GitHub Issues:** [Report bugs or request features](https://github.com/PuroDelphi/mcpFirebird/issues) - **Donations:** Support development via [PayPal](https://www.paypal.com/donate/?hosted_button_id=KBAUBYYDNHQNQ) - **Professional Support:** Hire AI agents at [asistentesautonomos.com](https://asistentesautonomos.com) --- ## 🗺️ Roadmap ### Coming in v2.6.0 - Enhanced monitoring and metrics - GraphQL support - Advanced caching strategies - Performance profiling tools - Extended database introspection ### Future Plans - Multi-database support - Connection pooling - Advanced query optimization - Real-time change notifications - Web-based admin interface --- ## 📝 Changelog ### Added - Multi-stage Dockerfile for optimized builds - `tsconfig.build.json` for production builds - `DEPLOYMENT.md` comprehensive guide - `.dockerignore` optimizations - Wire encryption documentation - Docker Compose examples - Enhanced configuration schema ### Changed - Optimized TypeScript compilation (50-60% faster) - Reduced Docker image size (22% smaller) - Improved build scripts - Enhanced error handling - Better logging configuration ### Fixed - Docker dependency resolution - TypeScript compilation performance - Layer caching in Docker builds - Zod schema handling in MCP API - Build timeout issues in containerized environments ### Performance - 50-60% faster TypeScript compilation - 22% smaller Docker images - Consistent 2-3 minute builds - Reduced memory footprint - Optimized dependency tree --- ## 🎯 Quick Start ```bash # 1. Install npm install -g mcp-firebird # 2. Run mcp-firebird \ --host localhost \ --database /path/to/database.fdb \ --user SYSDBA \ --password masterkey # 3. Or with Docker docker run -d -p 3003:3003 \ -e FIREBIRD_DATABASE=/path/to/db.fdb \ mcp-firebird:2.5.0 ``` --- **Full Changelog:** [v2.4.0...v2.5.0](https://github.com/PuroDelphi/mcpFirebird/compare/v2.4.0...v2.5.0) **Download:** [Release v2.5.0](https://github.com/PuroDelphi/mcpFirebird/releases/tag/v2.5.0) --- *Made with ❤️ by [Jhonny Suárez](https://asistentesautonomos.com)*