NestDaddy

MySQL MCP Server

io.github.musaddiq-dev/mysql-mcp-server · v0.1.2

Python MCP server for MySQL database inspection and querying

Connect Runs on your machine

Terminal
claude mcp add mysql-mcp-server -e MYSQL_HOST=<MYSQL_HOST> -e MYSQL_PORT=<MYSQL_PORT> -e MYSQL_USER=<MYSQL_USER> -e MYSQL_PASSWORD=<MYSQL_PASSWORD> -e MYSQL_DATABASE=<MYSQL_DATABASE> -e MYSQL_POOL_SIZE=<MYSQL_POOL_SIZE> -e LOG_LEVEL=<LOG_LEVEL> -e MYSQL_READ_QUERY_LIMIT=<MYSQL_READ_QUERY_LIMIT> -- uvx mdev-mysql-mcp-server==0.1.2
claude_desktop_config.json
{
  "mcpServers": {
    "mysql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-mysql-mcp-server==0.1.2"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_POOL_SIZE": "<MYSQL_POOL_SIZE>",
        "LOG_LEVEL": "<LOG_LEVEL>",
        "MYSQL_READ_QUERY_LIMIT": "<MYSQL_READ_QUERY_LIMIT>"
      }
    }
  }
}
~/.cursor/mcp.json
{
  "mcpServers": {
    "mysql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-mysql-mcp-server==0.1.2"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_POOL_SIZE": "<MYSQL_POOL_SIZE>",
        "LOG_LEVEL": "<LOG_LEVEL>",
        "MYSQL_READ_QUERY_LIMIT": "<MYSQL_READ_QUERY_LIMIT>"
      }
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "mysql-mcp-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mdev-mysql-mcp-server==0.1.2"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
        "MYSQL_DATABASE": "<MYSQL_DATABASE>",
        "MYSQL_POOL_SIZE": "<MYSQL_POOL_SIZE>",
        "LOG_LEVEL": "<LOG_LEVEL>",
        "MYSQL_READ_QUERY_LIMIT": "<MYSQL_READ_QUERY_LIMIT>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

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

Details

Package[email protected] (PYPI, stdio)
First published23 May 2026
Last updated23 May 2026
Registry nameio.github.musaddiq-dev/mysql-mcp-server

More databases servers See all

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.