MySQL MCP Server

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

claude mcp add mcp-mysql-client -- npx -y mcp-mysql-client

{
  "mcpServers": {
    "mcp-mysql-client": {
      "args": [
        "-y",
        "mcp-mysql-client"
      ],
      "command": "npx"
    }
  }
}

[mcp_servers.mcp-mysql-client]
command = "npx"
args = ["-y", "mcp-mysql-client"]

{
  "mcpServers": {
    "mcp-mysql-client": {
      "args": [
        "-y",
        "mcp-mysql-client"
      ],
      "command": "npx"
    }
  }
}

{
  "mcpServers": {
    "mcp-mysql-client": {
      "args": [
        "-y",
        "mcp-mysql-client"
      ],
      "command": "npx"
    }
  }
}

This one needs environment variables set before it will start: MYSQL_HOST (Database host.), MYSQL_PORT (Database port.), MYSQL_USER (MySQL user. Use one with the least privileges the task needs, never root.), MYSQL_PASS (Password for that user. Treat it as a secret; MYSQL_PASS_FILE reads it from a file instead.), MYSQL_DB (The one database this server is bound to. No tool can leave it.), MYSQL_SSL (Require a TLS connection to the server.), MYSQL_SSL_CA (Path to the CA bundle verifying the server certificate; implies MYSQL_SSL.), ALLOW_INSERT_OPERATION (Allow INSERT statements through the execute tool.), ALLOW_UPDATE_OPERATION (Allow UPDATE statements through the execute tool.), ALLOW_DELETE_OPERATION (Allow DELETE statements through the execute tool.), MYSQL_MAX_ROWS (Row cap for one read; the result is marked truncated when it is hit.), MYSQL_TIMEOUT_MS (Statement timeout in milliseconds; the connection is dropped on expiry.). The author declared them in the registry entry; get the values from the project itself.