MySQL MCP for Windsurf

io.github.gistrec/mcp-mysql-client

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

client:Windsurf transport:stdio runtime:npm

Install MySQL MCP in Windsurf

~/.codeium/windsurf/mcp_config.json · windows: %USERPROFILE%\.codeium\windsurf\mcp_config.json

MYSQL_HOST

MYSQL_PORT

MYSQL_USER

MYSQL_PASS

MYSQL_DB

MYSQL_SSL

MYSQL_SSL_CA

ALLOW_INSERT_OPERATION

ALLOW_UPDATE_OPERATION

ALLOW_DELETE_OPERATION

MYSQL_MAX_ROWS

MYSQL_TIMEOUT_MS

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

{
  "mcpServers": {
    "mcp-mysql-client": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-mysql-client"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASS": "<MYSQL_PASS>",
        "MYSQL_DB": "<MYSQL_DB>",
        "MYSQL_SSL": "<MYSQL_SSL>",
        "MYSQL_SSL_CA": "<MYSQL_SSL_CA>",
        "ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
        "MYSQL_MAX_ROWS": "<MYSQL_MAX_ROWS>",
        "MYSQL_TIMEOUT_MS": "<MYSQL_TIMEOUT_MS>"
      }
    }
  }
}

Global only — Windsurf has no per-project MCP config. Refresh Cascade after saving. Windsurf docs

MySQL MCP in other clients

MySQL MCP MCP server