Releases: designcomputer/mysql_mcp_server
Release v0.2.2
Release v0.2.2
Overview
This release fixes issues with SQL commands that return result sets, including SHOW INDEX
, SHOW CREATE TABLE
, and DESCRIBE
. Previously, these commands would return an error: "Error executing query: Unread result found".
What's New
- Fixed Result Set Handling: Changed the condition from checking the query text to checking for result sets via
cursor.description
, allowing all result-returning commands to work properly - Improved Error Handling: Added robust error handling for result fetching operations
- Enhanced Debugging: Added additional debug output to aid in troubleshooting
Affected Components
server.py
: Modified result set handling logic
Testing
This release has been tested with:
- SELECT queries
- SHOW CREATE TABLE commands
- SHOW INDEX commands
- DESCRIBE commands
All tests passed successfully, demonstrating that the fix properly handles both SELECT and non-SELECT queries that return result sets.
v0.2.1 Release Notes
Update README to clarify MySQL MCP Server's usage
- Removed instructions for running server directly with Python
- Added section about using MCP Inspector for debugging
- Clarified that the server is not meant to be run standalone
- Emphasized integration with AI applications like Claude Desktop
- Updated terminology from "server" to "implementation" to better reflect the component's nature as a protocol implementation
v0.2.0 Release Notes
Docker Container Support
This release introduces local Docker container support for the MySQL MCP Server.
Key Changes:
-
Dockerfile:
- Added environment variables
MYSQL_HOST
,MYSQL_PORT
,MYSQL_USER
,MYSQL_PASSWORD
, andMYSQL_DATABASE
. - Set
PYTHONPATH
for proper module loading. - Updated server startup command.
- Added environment variables
-
smithery.yaml:
- Integrated Docker image
smithery/mysql-mcp-server:latest
. - Default MySQL host set to
host.docker.internal
. - Added optional MySQL port parameter with default value
3306
.
- Integrated Docker image
Commits:
update configuration to use host.docker.internal by default
Update dockerfile for proper server startup
Update smithery.yaml to use Docker container
For more details, view the pull request.
v0.1.2 Release Notes
Improvements
- Added Smithery configuration files for easier installation and setup
- Updated README with improved installation instructions for Smithery users
- Fixed version information in pyproject.toml for proper PyPI indexing
- Incorporated previously unreleased changes from v0.1.1
Installation
You can now install this package more easily using Smithery:
npx -y @smithery/cli@latest install mysql-mcp-server --client claude
v0.1.1
Bug Fix: MySQL Connection Configuration
Fixed
- Separated MySQL host and port configuration to allow proper connection handling
- Added explicit port configuration in environment variables
- Implemented proper port handling in server configuration
Changes
- Environment variables now require separate
MYSQL_HOST
andMYSQL_PORT
settings - Added default port (3306) fallback if
MYSQL_PORT
is not specified - Updated server configuration to properly parse port as integer
Configuration Example
{
"mcpServers": {
"mysql_mcp_server": {
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_PORT": "3306",
"MYSQL_USER": "user",
"MYSQL_PASSWORD": "password",
"MYSQL_DATABASE": "database"
}
}
}
}
Migration
Users need to update their configuration to split any combined host:port settings into separate MYSQL_HOST and MYSQL_PORT environment variables.
Initial Release
Initial release of MySQL MCP Server
Features:
- List available MySQL tables as resources
- Read table contents
- Execute SQL queries with proper error handling
- Secure database access through environment variables
- Comprehensive logging