MySQL Legacy MCP Setup & Guide

{
  "id": "io.github.Rufflet/mysql-legacy-mcp",
  "type": "mcp-server",
  "version": "0.2.1",
  "displayName": "MySQL Legacy MCP",
  "description": "Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0.",
  "repository": {
    "url": "https://github.com/Rufflet/mysql-legacy-mcp",
    "source": "github"
  },
  "homepage": "https://github.com/Rufflet/mysql-legacy-mcp",
  "distribution": {
    "packages": [
      {
        "registryType": "npm",
        "identifier": "mysql-legacy-mcp",
        "version": "0.2.1",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "MYSQL_LEGACY_HOST",
            "description": "Database host or local tunnel endpoint",
            "isRequired": true
          },
          {
            "name": "MYSQL_LEGACY_USER",
            "description": "Dedicated database reader account",
            "isRequired": true
          },
          {
            "name": "MYSQL_LEGACY_PASSWORD",
            "description": "Nonempty database account password",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "MYSQL_LEGACY_PORT",
            "description": "TCP port, 1–65535"
          },
          {
            "name": "MYSQL_LEGACY_DATABASE",
            "description": "Optional default database"
          },
          {
            "name": "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES",
            "description": "Hide mysql and information_schema from listings"
          },
          {
            "name": "MYSQL_LEGACY_QUERY_TIMEOUT",
            "description": "Driver query timeout, 100–60000 milliseconds"
          },
          {
            "name": "MYSQL_LEGACY_MAX_ROWS",
            "description": "SELECT response row limit, 1–1000"
          },
          {
            "name": "MYSQL_LEGACY_MAX_RESULT_BYTES",
            "description": "SELECT row-data JSON byte limit, 1024–1048576"
          },
          {
            "name": "MYSQL_LEGACY_CONNECT_TIMEOUT",
            "description": "Connection-establishment timeout, 100–60000 milliseconds"
          },
          {
            "name": "MYSQL_LEGACY_POOL_SIZE",
            "description": "Pooled connection limit, 1–50"
          },
          {
            "name": "MYSQL_LEGACY_ALLOW_INSERT",
            "description": "Enable the mysql_legacy_insert tool"
          },
          {
            "name": "MYSQL_LEGACY_ALLOW_UPDATE",
            "description": "Enable the mysql_legacy_update tool (WHERE clause always required)"
          },
          {
            "name": "MYSQL_LEGACY_ALLOW_DELETE",
            "description": "Enable the mysql_legacy_delete tool (WHERE clause always required)"
          },
          {
            "name": "MYSQL_LEGACY_ALLOW_DDL",
            "description": "Enable the mysql_legacy_ddl tool (table-level statements only)"
          },
          {
            "name": "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS",
            "description": "Disable the read-only transaction wrap around mysql_legacy_select on MySQL 5.6.5+"
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode",
    "trae",
    "cherry-studio",
    "lingma",
    "windsurf",
    "cline",
    "workbuddy"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.Rufflet/mysql-legacy-mcp",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.Rufflet%2Fmysql-legacy-mcp/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}