MySQL MCP Release v2.0.0

Major New Features 🎉

Multi-DB Permission

• Added support for managing multiple databases through a single MCP server instance
• Detailed documentation available in MULTI-DB
• Special thanks to @saarthak-gupta-architect for this contribution
• Features include:
  • Dynamic database switching
  • Cross-database operations
  • Schema-specific permissions
  • Safe multi-DB mode with optional write protection

Improvements 🔧

Enhanced Logging System

• Added optional logging system controlled by ENABLE_LOGGING environment variable
• Log levels: info and error
• Improved debugging capabilities while maintaining clean output when needed
• Set ENABLE_LOGGING=1 to enable logging, leave unset or set to any other value to disable

Query Handling Improvements

• Standardized query case handling to prevent column case sensitivity issues
• All SQL queries are now automatically converted to lowercase before execution
• Improved reliability when working with different MySQL configurations
• Better handling of case-sensitive identifiers

Breaking Changes ⚠️

• Query handling now consistently uses lowercase, which might affect case-sensitive database configurations
• Logging output format has changed - applications parsing server output may need updates
• Multi-DB support introduces new configuration options that might require updates to existing deployment scripts

Migration Guide 🔄

1. Update Environment Variables:

   # Optional: Enable logging
   ENABLE_LOGGING=1
   
   # For Multi-DB support (optional)
   MULTI_DB_WRITE_MODE=true  # Enable write operations in multi-DB mode

2. Review any case-sensitive database operations in your queries

3. Update any scripts that parse server output to handle the new logging format

4. Check README-MULTI-DB.md for multi-database setup instructions if needed

Contributors 👥

Special thanks to:

• @saarthak-gupta-architect - Multi-DB Support
• @boyzoid - logging

MySQL MCP Release v.1.0.14

Enhanced Test Environment Support

• Added automatic database selection for test environments
• Improved test detection with better support for Vitest
• Added conditional process termination to prevent tests from exiting prematurely

Fixed Database Connection Issues

• Resolved "No database selected" error during integration tests
• Fixed authentication problems by providing consistent default credentials
• Enhanced error handling in test database setup for more resilient behavior

Improved Debugging and Troubleshooting

• Added comprehensive debug logging for database configuration in test mode
• Improved error messages to aid in troubleshooting
• Implemented better inline comments for test-specific configurations

Breaking Changes

None. This release maintains backward compatibility with previous versions.

Known Issues

No major known issues in this release.

Contributors

• Ben Borla (@benborla)
• Lucas Jeeves (@luca-jeeves)

Links

• Full Changelog
• NPM Package

MySQL MCP Release v.1.0.13

Added

• Complete write operations support through Smithery configuration
• Added environment variables for database write operations (ALLOW_INSERT_OPERATION, ALLOW_UPDATE_OPERATION, ALLOW_DELETE_OPERATION)
• New configuration options in Smithery schema for controlling write permissions
• Improved documentation for write operations configuration
• Support for enabling/disabling specific SQL operations via environment variables
• Enhanced error handling for unauthorized write operations
• SSL/TLS configuration options (Thank you @luca-jeeves )

Changed

• Updated Smithery configuration to include write operation settings
• Improved Smithery integration with clear security defaults
• Enhanced documentation with detailed configuration examples
• Restructured README with clearer installation instructions
• Better error reporting for database connection issues
• Improved transaction handling for write operations

Fixed

• Fixed error handling for database connection failures
• Improved error messages for unauthorized operations
• Better handling of MySQL 8.0+ authentication methods

Security

• All write operations (INSERT, UPDATE, DELETE) disabled by default
• Added clear documentation about security implications of enabling write operations
• Improved transaction isolation for write operations
• Enhanced error reporting that doesn't expose sensitive information

Documentation

• Updated README with comprehensive Smithery configuration instructions
• Added detailed examples for enabling specific write operations
• Improved troubleshooting section with common issues and solutions
• Better explanation of required MySQL permissions for different operation types
• Added clear security recommendations for production deployments

Release v1.0.8

Added support for Smithery
Added docker support

Release v1.0.7

updated readme

Release v1.0.5

updated package.json

Release v1.0.4

updated readme

Release v1.0.3

updated package.json

Release v1.0.2

Updated package.json readme

Release v1.0.1

Updated package.json readme