Skip to content

Releases: designcomputer/mysql_mcp_server

Release v0.2.2

18 Apr 20:29
Compare
Choose a tag to compare

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

29 Mar 17:01
5cf9d7e
Compare
Choose a tag to compare

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

29 Mar 15:23
d586222
Compare
Choose a tag to compare

Docker Container Support

This release introduces local Docker container support for the MySQL MCP Server.

Key Changes:

  1. Dockerfile:

    • Added environment variables MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE.
    • Set PYTHONPATH for proper module loading.
    • Updated server startup command.
  2. 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.

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

22 Mar 23:36
3362a0f
Compare
Choose a tag to compare

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

12 Feb 18:54
Compare
Choose a tag to compare

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 and MYSQL_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

03 Dec 21:39
Compare
Choose a tag to compare

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