mcp-server-mysql

singh-as/mcp-server-mysql

3.1

If you are the rightful owner of mcp-server-mysql and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The MCP Server for MySQL is a specialized server designed to facilitate communication between model context protocols and MySQL databases, ensuring seamless data management and retrieval.

Quick Start

  1. Requirements:
    Ensure Python 3.10+ is installed

  2. Clone the Repository:

    git clone https://github.com/singh-as/mcp-server-mysql.git
cd mcp-server-mysql

  3. Set Up Virtual Environment and Install Dependencies:

    uv venv
source .venv/bin/activate
pip install -e .

Usage

With Claude Desktop or Visual Studio Code

Add this to your claude_desktop_config.json or mcp.json:

{
  "mcpServers": {
    "mcp-server-mysql": {
      "command": "uv",
      "args": [
        "--directory",
        "/path/to/gitclone/folder", 
        "run",
        "mcp-server-mysql"
      ],
      "env": {
            "MYSQL_HOST": "localhost",
            "MYSQL_PORT": "3306",
            "MYSQL_USER": "",
            "MYSQL_PASSWORD": "",
            "MYSQL_DATABASE": ""
      }
    }
  }
}