MCP Server

MySQL MCP Server MCP Server

Name: MySQL MCP Server MCP Server
Author: io.github.musaddiq-dev

io.github.musaddiq-dev/mysql-mcp-server

Repository Registry

What is the MySQL MCP Server MCP server?

Python MCP server for MySQL database inspection and querying

How to install MySQL MCP Server

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

MYSQL_HOST
MySQL host
MYSQL_PORT
MySQL port
MYSQL_USER
MySQL username
MYSQL_PASSWORD
secret
MySQL password
MYSQL_DATABASE
required
MySQL database name
MYSQL_POOL_SIZE
MySQL connection pool size
LOG_LEVEL
Python logging level
MYSQL_READ_QUERY_LIMIT
Maximum rows returned by read queries

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "mysql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-mysql-mcp-server"
      ],
      "env": {
        "MYSQL_HOST": "<YOUR_MYSQL_HOST>",
        "MYSQL_PORT": "<YOUR_MYSQL_PORT>",
        "MYSQL_USER": "<YOUR_MYSQL_USER>",
        "MYSQL_PASSWORD": "<YOUR_MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<YOUR_MYSQL_DATABASE>",
        "MYSQL_POOL_SIZE": "<YOUR_MYSQL_POOL_SIZE>",
        "LOG_LEVEL": "<YOUR_LOG_LEVEL>",
        "MYSQL_READ_QUERY_LIMIT": "<YOUR_MYSQL_READ_QUERY_LIMIT>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "mysql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-mysql-mcp-server"
      ],
      "env": {
        "MYSQL_HOST": "<YOUR_MYSQL_HOST>",
        "MYSQL_PORT": "<YOUR_MYSQL_PORT>",
        "MYSQL_USER": "<YOUR_MYSQL_USER>",
        "MYSQL_PASSWORD": "<YOUR_MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<YOUR_MYSQL_DATABASE>",
        "MYSQL_POOL_SIZE": "<YOUR_MYSQL_POOL_SIZE>",
        "LOG_LEVEL": "<YOUR_LOG_LEVEL>",
        "MYSQL_READ_QUERY_LIMIT": "<YOUR_MYSQL_READ_QUERY_LIMIT>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "mysql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-mysql-mcp-server"
      ],
      "env": {
        "MYSQL_HOST": "<YOUR_MYSQL_HOST>",
        "MYSQL_PORT": "<YOUR_MYSQL_PORT>",
        "MYSQL_USER": "<YOUR_MYSQL_USER>",
        "MYSQL_PASSWORD": "<YOUR_MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<YOUR_MYSQL_DATABASE>",
        "MYSQL_POOL_SIZE": "<YOUR_MYSQL_POOL_SIZE>",
        "LOG_LEVEL": "<YOUR_LOG_LEVEL>",
        "MYSQL_READ_QUERY_LIMIT": "<YOUR_MYSQL_READ_QUERY_LIMIT>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "mysql-mcp-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mdev-mysql-mcp-server"
      ],
      "env": {
        "MYSQL_HOST": "<YOUR_MYSQL_HOST>",
        "MYSQL_PORT": "<YOUR_MYSQL_PORT>",
        "MYSQL_USER": "<YOUR_MYSQL_USER>",
        "MYSQL_PASSWORD": "<YOUR_MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<YOUR_MYSQL_DATABASE>",
        "MYSQL_POOL_SIZE": "<YOUR_MYSQL_POOL_SIZE>",
        "LOG_LEVEL": "<YOUR_LOG_LEVEL>",
        "MYSQL_READ_QUERY_LIMIT": "<YOUR_MYSQL_READ_QUERY_LIMIT>"
      }
    }
  }
}

Claude Code

claude mcp add mysql-mcp-server --env MYSQL_HOST=<YOUR_MYSQL_HOST> --env MYSQL_PORT=<YOUR_MYSQL_PORT> --env MYSQL_USER=<YOUR_MYSQL_USER> --env MYSQL_PASSWORD=<YOUR_MYSQL_PASSWORD> --env MYSQL_DATABASE=<YOUR_MYSQL_DATABASE> --env MYSQL_POOL_SIZE=<YOUR_MYSQL_POOL_SIZE> --env LOG_LEVEL=<YOUR_LOG_LEVEL> --env MYSQL_READ_QUERY_LIMIT=<YOUR_MYSQL_READ_QUERY_LIMIT> -- uvx mdev-mysql-mcp-server

Related MCP servers

AWS CLI MCP Server

Python MCP server for AWS CLI inspection and operations

View repository →

PostgreSQL MCP Server

Python MCP server for PostgreSQL database inspection and querying

View repository →