Skip to content
MCP server

MySQL Legacy MCP

Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0.

Runs locallyStatus and history
Install
Pricing
Open source
Runs
Locally
Version
0.2.1
Listing updated
4 days ago

About MySQL Legacy MCP

MySQL Legacy MCP is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.

Install

Run in a terminal

claude mcp add mysql-legacy-mcp --env MYSQL_LEGACY_HOST='<MYSQL_LEGACY_HOST>' --env MYSQL_LEGACY_USER='<MYSQL_LEGACY_USER>' --env MYSQL_LEGACY_PASSWORD='<MYSQL_LEGACY_PASSWORD>' -- npx -y mysql-legacy-mcp

Add to claude_desktop_config.json

{
  "mcpServers": {
    "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>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "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>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "mysql-legacy-mcp": {
      "type": "stdio",
      "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>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "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>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "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>"
      }
    }
  }
}

Configuration

  • MYSQL_LEGACY_HOSTDatabase host or local tunnel endpointRequired
  • MYSQL_LEGACY_USERDedicated database reader accountRequired
  • MYSQL_LEGACY_PASSWORDNonempty database account passwordRequired
  • MYSQL_LEGACY_PORTTCP port, 1–65535
  • MYSQL_LEGACY_DATABASEOptional default database
  • MYSQL_LEGACY_HIDE_SYSTEM_DATABASESHide mysql and information_schema from listings
  • MYSQL_LEGACY_QUERY_TIMEOUTDriver query timeout, 100–60000 milliseconds
  • MYSQL_LEGACY_MAX_ROWSSELECT response row limit, 1–1000
  • MYSQL_LEGACY_MAX_RESULT_BYTESSELECT row-data JSON byte limit, 1024–1048576
  • MYSQL_LEGACY_CONNECT_TIMEOUTConnection-establishment timeout, 100–60000 milliseconds
  • MYSQL_LEGACY_POOL_SIZEPooled connection limit, 1–50
  • MYSQL_LEGACY_ALLOW_INSERTEnable the mysql_legacy_insert tool
  • MYSQL_LEGACY_ALLOW_UPDATEEnable the mysql_legacy_update tool (WHERE clause always required)
  • MYSQL_LEGACY_ALLOW_DELETEEnable the mysql_legacy_delete tool (WHERE clause always required)
  • MYSQL_LEGACY_ALLOW_DDLEnable the mysql_legacy_ddl tool (table-level statements only)
  • MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONSDisable the read-only transaction wrap around mysql_legacy_select on MySQL 5.6.5+

Pricing

Open source

MySQL Legacy MCP FAQ

Is MySQL Legacy MCP free?

Yes. MySQL Legacy MCP is open source, so you can use and self-host it for free.

How do I add MySQL Legacy MCP to Claude Code?

Run this command in your terminal: claude mcp add mysql-legacy-mcp --env MYSQL_LEGACY_HOST='<MYSQL_LEGACY_HOST>' --env MYSQL_LEGACY_USER='<MYSQL_LEGACY_USER>' --env MYSQL_LEGACY_PASSWORD='<MYSQL_LEGACY_PASSWORD>' -- npx -y mysql-legacy-mcp

What are the best alternatives to MySQL Legacy MCP?

The closest alternatives to MySQL Legacy MCP are Midplane, PlatypusDB, Lorebase, Sovaria and model2data studio.

Alternatives to MySQL Legacy MCP

  1. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  2. PlatypusDB

    MCP server

    Gives MCP clients access to your PlatypusDB database connections, scoped per agent

    Runs locally
    • Open source
    • Databases
  3. Lorebase

    MCP server

    Lets agents read and change a governed, versioned Postgres knowledge graph

    Runs locally
    • Open source
    • Knowledge and memory
  4. Sovaria

    MCP server

    Manage a Sovaria backend (Postgres, auth, storage, functions) from an AI assistant

    Not checked yet
    • 4 tools
    • Remote
    • Freemium
    • Databases
  5. Generate realistic connected test data, dbt projects and dashboards from a schema

    • Remote
    • Freemium
    • Databases
  6. semlayer

    MCP server

    Infers a semantic layer from your data warehouse and serves it to agents

    Runs locally
    • Free
    • Databases