MySQL MCP Server is a Model Context Protocol implementation that connects AI coding assistants to MySQL databases through a secure, controlled interface. It enables structured database exploration and analysis while maintaining proper security through environment-based authentication. Key features of MySQL MCP Server: - Browse and list available database tables as resources - Query and read table contents - Execute arbitrary SQL queries with error handling and logging - Secure connection management via environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD) - Integration support for Claude Desktop, Visual Studio Code, and other MCP-compatible AI applications

[](https://smithery.ai/server/mysql-mcp-server) [](https://mseep.ai/app/designcomputer-mysql-mcp-server)

MySQL MCP Server

> Note: MySQL MCP Server is not designed to be used as a standalone server, but rather as a communication protocol implementation between AI applications and MySQL databases.

Features

Installation

Manual Installation

pip install mysql-mcp-server

Installing via Smithery

npx -y @smithery/cli install mysql-mcp-server --client claude

Configuration

MYSQL_HOST=localhost     # Database host
MYSQL_PORT=3306         # Optional: Database port (defaults to 3306 if not specified)
MYSQL_USER=your_username
MYSQL_PASSWORD=your_password
MYSQL_DATABASE=your_database

Usage

With Claude Desktop

{
  "mcpServers": {
    "mysql": {
      "command": "uv",
      "args": [
        "--directory",
        "path/to/mysql_mcp_server",
        "run",
        "mysql_mcp_server"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_username",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

With Visual Studio Code

{
  "servers": {
      "mysql": {
            "type": "stdio",
            "command": "uvx",
            "args": [
                "--from",
                "mysql-mcp-server",
                "mysql_mcp_server"
            ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_username",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

Debugging with MCP Inspector

The MCP Inspector provides a convenient way to test and debug your MCP implementation:

# Install dependencies
pip install -r requirements.txt
Use the MCP Inspector for debugging (do not run directly with Python)

The MySQL MCP Server is designed to be integrated with AI applications like Claude Desktop and should not be run directly as a standalone Python program.

Development

# Clone the repository
git clone https://github.com/designcomputer/mysql_mcp_server.git
cd mysql_mcp_server
Create virtual environment
python -m venv venv
source venv/bin/activate  # or venv\Scripts\activate on Windows
Install development dependencies
pip install -r requirements-dev.txt
Run tests
pytest

Security Considerations

Security Best Practices

See MySQL Security Configuration Guide for detailed instructions on:

⚠️ IMPORTANT: Always follow the principle of least privilege when configuring database access.

License

Contributing