MySQL MCP

stdio

MCP server for one MySQL database: schema, read-only queries and guarded writes.

Getting Started

npx @getmcp/cli add io.github.gistrec/mcp-mysql-client

Requires Node.js 18+. Community-contributed server. Review source before installing.

Claude Desktopguide →Vscodeguide →Cursorguide →Windsurfguide →

Required Environment Variables

MYSQL_USER
MySQL user. Use one with the least privileges the task needs, never root.
MYSQL_DB
The one database this server is bound to. No tool can leave it.

Configuration

Config file: ~/Library/Application Support/Claude/claude_desktop_config.json

JSON

{
  "mcpServers": {
    "io.github.gistrec/mcp-mysql-client": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-mysql-client"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "",
        "MYSQL_PASS": "",
        "MYSQL_DB": "",
        "MYSQL_SSL": "false",
        "MYSQL_SSL_CA": "",
        "ALLOW_INSERT_OPERATION": "false",
        "ALLOW_UPDATE_OPERATION": "false",
        "ALLOW_DELETE_OPERATION": "false",
        "MYSQL_MAX_ROWS": "1000",
        "MYSQL_TIMEOUT_MS": "30000"
      }
    }
  }
}

Claude Desktop MCP documentation