protogrid
Sign inAdd to your agent

Search / io.github.Rufflet/mysql-legacy-mcp

MySQL Legacy MCP

L0· runs locally

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

v0.2.1 · active · repository · website · descriptor JSON · versions

Runs on your machine: something must execute the package.Only local packages are published (npm, PyPI, OCI, …). The registry never executes them, so tools are unknown until you run it.
Quality–not scored
Trust91of 100
Packages1
Tools seen0

Connect

8 clients · secrets stay placeholders
{
  "mcpServers": {
    "mysql-legacy-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "${MYSQL_LEGACY_HOST}",
        "MYSQL_LEGACY_USER": "${MYSQL_LEGACY_USER}",
        "MYSQL_LEGACY_PASSWORD": "${MYSQL_LEGACY_PASSWORD}",
        "MYSQL_LEGACY_PORT": "3306",
        "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "true",
        "MYSQL_LEGACY_QUERY_TIMEOUT": "10000",
        "MYSQL_LEGACY_MAX_ROWS": "200",
        "MYSQL_LEGACY_MAX_RESULT_BYTES": "262144",
        "MYSQL_LEGACY_CONNECT_TIMEOUT": "10000",
        "MYSQL_LEGACY_POOL_SIZE": "5",
        "MYSQL_LEGACY_ALLOW_INSERT": "false",
        "MYSQL_LEGACY_ALLOW_UPDATE": "false",
        "MYSQL_LEGACY_ALLOW_DELETE": "false",
        "MYSQL_LEGACY_ALLOW_DDL": "false",
        "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "false"
      }
    }
  }
}
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}" -e "MYSQL_LEGACY_PORT=3306" -e "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES=true" -e "MYSQL_LEGACY_QUERY_TIMEOUT=10000" -e "MYSQL_LEGACY_MAX_ROWS=200" -e "MYSQL_LEGACY_MAX_RESULT_BYTES=262144" -e "MYSQL_LEGACY_CONNECT_TIMEOUT=10000" -e "MYSQL_LEGACY_POOL_SIZE=5" -e "MYSQL_LEGACY_ALLOW_INSERT=false" -e "MYSQL_LEGACY_ALLOW_UPDATE=false" -e "MYSQL_LEGACY_ALLOW_DELETE=false" -e "MYSQL_LEGACY_ALLOW_DDL=false" -e "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS=false" -- npx -y [email protected]
[mcp_servers.mysql-legacy-mcp]
command = "npx"
args = ["-y", "[email protected]"]
env = { "MYSQL_LEGACY_HOST" = "${MYSQL_LEGACY_HOST}", "MYSQL_LEGACY_USER" = "${MYSQL_LEGACY_USER}", "MYSQL_LEGACY_PASSWORD" = "${MYSQL_LEGACY_PASSWORD}", "MYSQL_LEGACY_PORT" = "3306", "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES" = "true", "MYSQL_LEGACY_QUERY_TIMEOUT" = "10000", "MYSQL_LEGACY_MAX_ROWS" = "200", "MYSQL_LEGACY_MAX_RESULT_BYTES" = "262144", "MYSQL_LEGACY_CONNECT_TIMEOUT" = "10000", "MYSQL_LEGACY_POOL_SIZE" = "5", "MYSQL_LEGACY_ALLOW_INSERT" = "false", "MYSQL_LEGACY_ALLOW_UPDATE" = "false", "MYSQL_LEGACY_ALLOW_DELETE" = "false", "MYSQL_LEGACY_ALLOW_DDL" = "false", "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS" = "false" }

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "mysql-legacy-mcp": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "[email protected]"
      ],
      "enabled": true,
      "environment": {
        "MYSQL_LEGACY_HOST": "{env:MYSQL_LEGACY_HOST}",
        "MYSQL_LEGACY_USER": "{env:MYSQL_LEGACY_USER}",
        "MYSQL_LEGACY_PASSWORD": "{env:MYSQL_LEGACY_PASSWORD}",
        "MYSQL_LEGACY_PORT": "3306",
        "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "true",
        "MYSQL_LEGACY_QUERY_TIMEOUT": "10000",
        "MYSQL_LEGACY_MAX_ROWS": "200",
        "MYSQL_LEGACY_MAX_RESULT_BYTES": "262144",
        "MYSQL_LEGACY_CONNECT_TIMEOUT": "10000",
        "MYSQL_LEGACY_POOL_SIZE": "5",
        "MYSQL_LEGACY_ALLOW_INSERT": "false",
        "MYSQL_LEGACY_ALLOW_UPDATE": "false",
        "MYSQL_LEGACY_ALLOW_DELETE": "false",
        "MYSQL_LEGACY_ALLOW_DDL": "false",
        "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "false"
      }
    }
  }
}
{
  "mcpServers": {
    "mysql-legacy-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "${MYSQL_LEGACY_HOST}",
        "MYSQL_LEGACY_USER": "${MYSQL_LEGACY_USER}",
        "MYSQL_LEGACY_PASSWORD": "${MYSQL_LEGACY_PASSWORD}",
        "MYSQL_LEGACY_PORT": "3306",
        "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "true",
        "MYSQL_LEGACY_QUERY_TIMEOUT": "10000",
        "MYSQL_LEGACY_MAX_ROWS": "200",
        "MYSQL_LEGACY_MAX_RESULT_BYTES": "262144",
        "MYSQL_LEGACY_CONNECT_TIMEOUT": "10000",
        "MYSQL_LEGACY_POOL_SIZE": "5",
        "MYSQL_LEGACY_ALLOW_INSERT": "false",
        "MYSQL_LEGACY_ALLOW_UPDATE": "false",
        "MYSQL_LEGACY_ALLOW_DELETE": "false",
        "MYSQL_LEGACY_ALLOW_DDL": "false",
        "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "false"
      }
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=mysql-legacy-mcp&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsIm15c3FsLWxlZ2FjeS1tY3BAMC4yLjEiXSwiZW52Ijp7Ik1ZU1FMX0xFR0FDWV9IT1NUIjoiJHtNWVNRTF9MRUdBQ1lfSE9TVH0iLCJNWVNRTF9MRUdBQ1lfVVNFUiI6IiR7TVlTUUxfTEVHQUNZX1VTRVJ9IiwiTVlTUUxfTEVHQUNZX1BBU1NXT1JEIjoiJHtNWVNRTF9MRUdBQ1lfUEFTU1dPUkR9IiwiTVlTUUxfTEVHQUNZX1BPUlQiOiIzMzA2IiwiTVlTUUxfTEVHQUNZX0hJREVfU1lTVEVNX0RBVEFCQVNFUyI6InRydWUiLCJNWVNRTF9MRUdBQ1lfUVVFUllfVElNRU9VVCI6IjEwMDAwIiwiTVlTUUxfTEVHQUNZX01BWF9ST1dTIjoiMjAwIiwiTVlTUUxfTEVHQUNZX01BWF9SRVNVTFRfQllURVMiOiIyNjIxNDQiLCJNWVNRTF9MRUdBQ1lfQ09OTkVDVF9USU1FT1VUIjoiMTAwMDAiLCJNWVNRTF9MRUdBQ1lfUE9PTF9TSVpFIjoiNSIsIk1ZU1FMX0xFR0FDWV9BTExPV19JTlNFUlQiOiJmYWxzZSIsIk1ZU1FMX0xFR0FDWV9BTExPV19VUERBVEUiOiJmYWxzZSIsIk1ZU1FMX0xFR0FDWV9BTExPV19ERUxFVEUiOiJmYWxzZSIsIk1ZU1FMX0xFR0FDWV9BTExPV19EREwiOiJmYWxzZSIsIk1ZU1FMX0xFR0FDWV9ESVNBQkxFX1JFQURfT05MWV9UUkFOU0FDVElPTlMiOiJmYWxzZSJ9fQ%3D%3D"
}
{
  "servers": {
    "mysql-legacy-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "${MYSQL_LEGACY_HOST}",
        "MYSQL_LEGACY_USER": "${MYSQL_LEGACY_USER}",
        "MYSQL_LEGACY_PASSWORD": "${MYSQL_LEGACY_PASSWORD}",
        "MYSQL_LEGACY_PORT": "3306",
        "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "true",
        "MYSQL_LEGACY_QUERY_TIMEOUT": "10000",
        "MYSQL_LEGACY_MAX_ROWS": "200",
        "MYSQL_LEGACY_MAX_RESULT_BYTES": "262144",
        "MYSQL_LEGACY_CONNECT_TIMEOUT": "10000",
        "MYSQL_LEGACY_POOL_SIZE": "5",
        "MYSQL_LEGACY_ALLOW_INSERT": "false",
        "MYSQL_LEGACY_ALLOW_UPDATE": "false",
        "MYSQL_LEGACY_ALLOW_DELETE": "false",
        "MYSQL_LEGACY_ALLOW_DDL": "false",
        "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "false"
      }
    }
  }
}
{
  "mcpServers": {
    "mysql-legacy-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MYSQL_LEGACY_HOST": "${MYSQL_LEGACY_HOST}",
        "MYSQL_LEGACY_USER": "${MYSQL_LEGACY_USER}",
        "MYSQL_LEGACY_PASSWORD": "${MYSQL_LEGACY_PASSWORD}",
        "MYSQL_LEGACY_PORT": "3306",
        "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "true",
        "MYSQL_LEGACY_QUERY_TIMEOUT": "10000",
        "MYSQL_LEGACY_MAX_ROWS": "200",
        "MYSQL_LEGACY_MAX_RESULT_BYTES": "262144",
        "MYSQL_LEGACY_CONNECT_TIMEOUT": "10000",
        "MYSQL_LEGACY_POOL_SIZE": "5",
        "MYSQL_LEGACY_ALLOW_INSERT": "false",
        "MYSQL_LEGACY_ALLOW_UPDATE": "false",
        "MYSQL_LEGACY_ALLOW_DELETE": "false",
        "MYSQL_LEGACY_ALLOW_DDL": "false",
        "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "false"
      }
    }
  }
}
extensions:
  "mysql-legacy-mcp":
    enabled: true
    name: "mysql-legacy-mcp"
    type: stdio
    cmd: "npx"
    args:
      - "-y"
      - "[email protected]"
    envs:
      "MYSQL_LEGACY_HOST": "${MYSQL_LEGACY_HOST}"
      "MYSQL_LEGACY_USER": "${MYSQL_LEGACY_USER}"
      "MYSQL_LEGACY_PASSWORD": "${MYSQL_LEGACY_PASSWORD}"
      "MYSQL_LEGACY_PORT": "3306"
      "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "true"
      "MYSQL_LEGACY_QUERY_TIMEOUT": "10000"
      "MYSQL_LEGACY_MAX_ROWS": "200"
      "MYSQL_LEGACY_MAX_RESULT_BYTES": "262144"
      "MYSQL_LEGACY_CONNECT_TIMEOUT": "10000"
      "MYSQL_LEGACY_POOL_SIZE": "5"
      "MYSQL_LEGACY_ALLOW_INSERT": "false"
      "MYSQL_LEGACY_ALLOW_UPDATE": "false"
      "MYSQL_LEGACY_ALLOW_DELETE": "false"
      "MYSQL_LEGACY_ALLOW_DDL": "false"
      "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "false"
    timeout: 300

Placeholders to fill from your own secret store: ${MYSQL_LEGACY_PASSWORD}. The registry never accepts secret values.

This is a local package: the command runs on your machine.

Quality – / 100not scored

Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.

protocoln/a · weight 25
  • n/a
    protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)
authorizationn/a · weight 15
  • n/a
    auth.prm, auth.as_metadata, auth.cimdno remote uses OAuth
  • n/a
    auth.secret_in_urlno templated URL
tool hygienen/a · weight 30
  • n/a
    tools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)
stabilityn/a · weight 15
  • n/a
    stability.changes, stability.rug_pulltool list unknown
dependencies67 · weight 15
  • pass
    deps.known_vulnsno known advisory in 111 resolved packages
  • fail
    deps.mcp_sdk_version@modelcontextprotocol/sdk 1.30.1 has 1 known advisory (GHSA-6qxp-vccf-f47h); update @modelcontextprotocol/sdk to 1.31.0 or later
  • pass
    deps.resolvable[email protected] resolved: 111 packages

Tool list unknown · checked 2026-10-19 20:06 UTC

Tool changes

No tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.

Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.

Trust 91 / 100

provenance90
livenessn/a
freshness85
hygiene100

+repository +namespace-matches-repo +website ~liveness-unmeasured ~updated-35d-ago

Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.

Dependencies

[email protected] npm110 dependencies, resolved · MCP SDK @modelcontextprotocol/sdk 1.30.1 · advisories checked 2026-10-19

advisoryseveritypackagefixed in
GHSA-6qxp-vccf-f47hMCP TypeScript SDK: OAuth client could send credentials to an authorization server chosen by the MCP serverhigh@modelcontextprotocol/[email protected]MCP SDK, directfixed in 1.31.0

Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.

Endpoints

packageregistryversionruntimesecrets
mysql-legacy-mcpnpm0.2.1–MYSQL_LEGACY_PASSWORD

Tools (0)

No tools observed. Local packages are never executed by the registry.

Schemas: list_tools.

Similar MCP servers

  • MySQL (security-first)L0
    io.github.Kurok1/mcp-server-mysql

    Security-first MySQL MCP server with AST validation, table whitelist, schema resources, and audit.

  • database-mcp-mysqlL0
    io.github.arifulislamat/database-mcp-mysql

    MCP server for MySQL. Read-only by default, row caps, statement timeouts, secrets never logged.

  • MySQL (read-only, switchable)L0
    io.github.shibbirweb/mcp-mysql-read-only

    Read-only MySQL access, with the database and server switchable mid-conversation.

  • Wikidata SparqlR0
    io.github.pipeworx-io/wikidata-sparql

    Wikidata SPARQL MCP — Wikidata Query Service

  • Devart MCP Server for MySQL (ADO.NET)L0
    com.devart/mcp-mysql

    Schema-aware read/write access to MySQL through Devart dotConnect ADO.NET data provider.

  • StackQL MCP ServerL0
    io.github.stackql/stackql-mcp

    SQL-native query and provisioning engine for cloud infrastructure, served over MCP.

Official server.json
{
  "name": "io.github.Rufflet/mysql-legacy-mcp",
  "title": "MySQL Legacy MCP",
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "version": "0.2.1",
  "packages": [
    {
      "version": "0.2.1",
      "transport": {
        "type": "stdio"
      },
      "identifier": "mysql-legacy-mcp",
      "registryType": "npm",
      "environmentVariables": [
        {
          "name": "MYSQL_LEGACY_HOST",
          "isRequired": true,
          "description": "Database host or local tunnel endpoint"
        },
        {
          "name": "MYSQL_LEGACY_USER",
          "isRequired": true,
          "description": "Dedicated database reader account"
        },
        {
          "name": "MYSQL_LEGACY_PASSWORD",
          "isSecret": true,
          "isRequired": true,
          "description": "Nonempty database account password"
        },
        {
          "name": "MYSQL_LEGACY_PORT",
          "default": "3306",
          "description": "TCP port, 1–65535"
        },
        {
          "name": "MYSQL_LEGACY_DATABASE",
          "description": "Optional default database"
        },
        {
          "name": "MYSQL_LEGACY_HIDE_SYSTEM_DATABASES",
          "choices": [
            "true",
            "false"
          ],
          "default": "true",
          "description": "Hide mysql and information_schema from listings"
        },
        {
          "name": "MYSQL_LEGACY_QUERY_TIMEOUT",
          "default": "10000",
          "description": "Driver query timeout, 100–60000 milliseconds"
        },
        {
          "name": "MYSQL_LEGACY_MAX_ROWS",
          "default": "200",
          "description": "SELECT response row limit, 1–1000"
        },
        {
          "name": "MYSQL_LEGACY_MAX_RESULT_BYTES",
          "default": "262144",
          "description": "SELECT row-data JSON byte limit, 1024–1048576"
        },
        {
          "name": "MYSQL_LEGACY_CONNECT_TIMEOUT",
          "default": "10000",
          "description": "Connection-establishment timeout, 100–60000 milliseconds"
        },
        {
          "name": "MYSQL_LEGACY_POOL_SIZE",
          "default": "5",
          "description": "Pooled connection limit, 1–50"
        },
        {
          "name": "MYSQL_LEGACY_ALLOW_INSERT",
          "choices": [
            "true",
            "false"
          ],
          "default": "false",
          "description": "Enable the mysql_legacy_insert tool"
        },
        {
          "name": "MYSQL_LEGACY_ALLOW_UPDATE",
          "choices": [
            "true",
            "false"
          ],
          "default": "false",
          "description": "Enable the mysql_legacy_update tool (WHERE clause always required)"
        },
        {
          "name": "MYSQL_LEGACY_ALLOW_DELETE",
          "choices": [
            "true",
            "false"
          ],
          "default": "false",
          "description": "Enable the mysql_legacy_delete tool (WHERE clause always required)"
        },
        {
          "name": "MYSQL_LEGACY_ALLOW_DDL",
          "choices": [
            "true",
            "false"
          ],
          "default": "false",
          "description": "Enable the mysql_legacy_ddl tool (table-level statements only)"
        },
        {
          "name": "MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS",
          "choices": [
            "true",
            "false"
          ],
          "default": "false",
          "description": "Disable the read-only transaction wrap around mysql_legacy_select on MySQL 5.6.5+"
        }
      ]
    }
  ],
  "repository": {
    "id": "1363285083",
    "url": "https://github.com/Rufflet/mysql-legacy-mcp",
    "source": "github"
  },
  "websiteUrl": "https://github.com/Rufflet/mysql-legacy-mcp",
  "description": "Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0."
}