Mysql-mcp-server

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

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](https://github.com/designcomputer/mysql_mcp_server/pull/22).

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

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
json
{
"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 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