# 🚀 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)*
