MySQL Legacy 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 mysql-legacy-mcp -e 'MYSQL_LEGACY_HOST=<MYSQL_LEGACY_HOST>' -e 'MYSQL_LEGACY_USER=<MYSQL_LEGACY_USER>' -e 'MYSQL_LEGACY_PASSWORD=<MYSQL_LEGACY_PASSWORD>' -- npx -y mysql-legacy-mcp

{
  "mcpServers": {
    "mysql-legacy-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-legacy-mcp"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "<MYSQL_LEGACY_HOST>",
        "MYSQL_LEGACY_PASSWORD": "<MYSQL_LEGACY_PASSWORD>",
        "MYSQL_LEGACY_USER": "<MYSQL_LEGACY_USER>"
      }
    }
  }
}

[mcp_servers.mysql-legacy-mcp]
command = "npx"
args = ["-y", "mysql-legacy-mcp"]
env = { MYSQL_LEGACY_HOST = "<MYSQL_LEGACY_HOST>", MYSQL_LEGACY_USER = "<MYSQL_LEGACY_USER>", MYSQL_LEGACY_PASSWORD = "<MYSQL_LEGACY_PASSWORD>" }

{
  "mcpServers": {
    "mysql-legacy-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-legacy-mcp"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "<MYSQL_LEGACY_HOST>",
        "MYSQL_LEGACY_PASSWORD": "<MYSQL_LEGACY_PASSWORD>",
        "MYSQL_LEGACY_USER": "<MYSQL_LEGACY_USER>"
      }
    }
  }
}

{
  "servers": {
    "mysql-legacy-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mysql-legacy-mcp"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "<MYSQL_LEGACY_HOST>",
        "MYSQL_LEGACY_PASSWORD": "<MYSQL_LEGACY_PASSWORD>",
        "MYSQL_LEGACY_USER": "<MYSQL_LEGACY_USER>"
      }
    }
  }
}

Put your own values in place of <MYSQL_LEGACY_HOST> (Database host or local tunnel endpoint), <MYSQL_LEGACY_USER> (Dedicated database reader account), <MYSQL_LEGACY_PASSWORD> (Nonempty database account password). The author’s registry entry marks them as required.

Optional settings from the registry entry, left out of the block above: MYSQL_LEGACY_PORT (TCP port, 1–65535), MYSQL_LEGACY_DATABASE (Optional default database), MYSQL_LEGACY_HIDE_SYSTEM_DATABASES (Hide mysql and information_schema from listings), MYSQL_LEGACY_QUERY_TIMEOUT (Driver query timeout, 100–60000 milliseconds), MYSQL_LEGACY_MAX_ROWS (SELECT response row limit, 1–1000), MYSQL_LEGACY_MAX_RESULT_BYTES (SELECT row-data JSON byte limit, 1024–1048576), MYSQL_LEGACY_CONNECT_TIMEOUT (Connection-establishment timeout, 100–60000 milliseconds), MYSQL_LEGACY_POOL_SIZE (Pooled connection limit, 1–50), MYSQL_LEGACY_ALLOW_INSERT (Enable the mysql_legacy_insert tool), MYSQL_LEGACY_ALLOW_UPDATE (Enable the mysql_legacy_update tool (WHERE clause always required)), MYSQL_LEGACY_ALLOW_DELETE (Enable the mysql_legacy_delete tool (WHERE clause always required)), MYSQL_LEGACY_ALLOW_DDL (Enable the mysql_legacy_ddl tool (table-level statements only)), MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS (Disable the read-only transaction wrap around mysql_legacy_select on MySQL 5.6.5+).