mysqldb-mcp-server MCP server

A MySQL database MCP server project.

Installation

You can install the package using `uv`:

uv pip install mysqldb-mcp-server

Or using `pip`:

pip install mysqldb-mcp-server

Components

Tools

The server provides two tools:

• `connect_database`: Connects to a specific MySQL database
  • `database` parameter: Name of the database to connect to (string)
  • Returns a confirmation message when connection is successful

• `execute_query`: Executes MySQL queries
  • `query` parameter: SQL query/queries to execute (string)
  • Returns query results in JSON format
  • Multiple queries can be sent separated by semicolons

Configuration

The server uses the following environment variables:

• `MYSQL_HOST`: MySQL server address (default: "localhost")
• `MYSQL_USER`: MySQL username (default: "root")
• `MYSQL_PASSWORD`: MySQL password (default: "")
• `MYSQL_DATABASE`: Initial database (optional)
• `MYSQL_READONLY`: Read-only mode (set to 1/true to enable, default: false)

Quickstart

Installation

Claude Desktop

MacOS: `~/Library/Application\ Support/Claude/claude_desktop_config.json`

Windows: `%APPDATA%/Claude/claude_desktop_config.json`

Development/Unpublished Server Configuration

{
  "mcpServers": {
    "mysqldb-mcp-server": {
      "command": "uv",
      "args": [
        "--directory",
        "/Users/burakdirin/Projects/mysqldb-mcp-server",
        "run",
        "mysqldb-mcp-server"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "password",
        "MYSQL_DATABASE": "[optional]",
        "MYSQL_READONLY": "true"
      }
    }
  }
}

Published Server Configuration

{
  "mcpServers": {
    "mysqldb-mcp-server": {
      "command": "uvx",
      "args": [
        "mysqldb-mcp-server"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "password",
        "MYSQL_DATABASE": "[optional]",
        "MYSQL_READONLY": "true"
      }
    }
  }
}

Installing via Smithery

To install MySQL Database Integration Server for Claude Desktop automatically via Smithery:

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

Development

Building and Publishing

To prepare the package for distribution:

1. Sync dependencies and update lockfile:

uv sync

2. Build package distributions:

uv build

This will create source and wheel distributions in the `dist/` directory.

3. Publish to PyPI:

uv publish

Note: You'll need to set PyPI credentials via environment variables or command flags:

• Token: `--token` or `UV_PUBLISH_TOKEN`
• Or username/password: `--username`/`UV_PUBLISH_USERNAME` and `--password`/`UV_PUBLISH_PASSWORD`

Debugging

Since MCP servers run over stdio, debugging can be challenging. For the best debugging

experience, we strongly recommend using the MCP Inspector.

You can launch the MCP Inspector via `npm` with this command:

npx @modelcontextprotocol/inspector uv --directory /Users/burakdirin/Projects/mysqldb-mcp-server run mysqldb-mcp-server

Upon launching, the Inspector will display a URL that you can access in your browser to begin debugging.