protogrid
Sign inAdd to your agent

Search / io.github.gistrec/mcp-mysql-client

MySQL MCP

L0· runs locally

MCP server for one MySQL database: schema, read-only queries and guarded writes.

v1.0.0 · 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": {
    "mcp-mysql-client": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "${MYSQL_USER}",
        "MYSQL_PASS": "${MYSQL_PASS}",
        "MYSQL_DB": "${MYSQL_DB}",
        "MYSQL_SSL": "false",
        "ALLOW_INSERT_OPERATION": "false",
        "ALLOW_UPDATE_OPERATION": "false",
        "ALLOW_DELETE_OPERATION": "false",
        "MYSQL_MAX_ROWS": "1000",
        "MYSQL_TIMEOUT_MS": "30000"
      }
    }
  }
}
claude mcp add mcp-mysql-client -e "MYSQL_HOST=127.0.0.1" -e "MYSQL_PORT=3306" -e "MYSQL_USER=${MYSQL_USER}" -e "MYSQL_PASS=${MYSQL_PASS}" -e "MYSQL_DB=${MYSQL_DB}" -e "MYSQL_SSL=false" -e "ALLOW_INSERT_OPERATION=false" -e "ALLOW_UPDATE_OPERATION=false" -e "ALLOW_DELETE_OPERATION=false" -e "MYSQL_MAX_ROWS=1000" -e "MYSQL_TIMEOUT_MS=30000" -- npx -y [email protected]
[mcp_servers.mcp-mysql-client]
command = "npx"
args = ["-y", "[email protected]"]
env = { "MYSQL_HOST" = "127.0.0.1", "MYSQL_PORT" = "3306", "MYSQL_USER" = "${MYSQL_USER}", "MYSQL_PASS" = "${MYSQL_PASS}", "MYSQL_DB" = "${MYSQL_DB}", "MYSQL_SSL" = "false", "ALLOW_INSERT_OPERATION" = "false", "ALLOW_UPDATE_OPERATION" = "false", "ALLOW_DELETE_OPERATION" = "false", "MYSQL_MAX_ROWS" = "1000", "MYSQL_TIMEOUT_MS" = "30000" }

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "mcp-mysql-client": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "[email protected]"
      ],
      "enabled": true,
      "environment": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "{env:MYSQL_USER}",
        "MYSQL_PASS": "{env:MYSQL_PASS}",
        "MYSQL_DB": "{env:MYSQL_DB}",
        "MYSQL_SSL": "false",
        "ALLOW_INSERT_OPERATION": "false",
        "ALLOW_UPDATE_OPERATION": "false",
        "ALLOW_DELETE_OPERATION": "false",
        "MYSQL_MAX_ROWS": "1000",
        "MYSQL_TIMEOUT_MS": "30000"
      }
    }
  }
}
{
  "mcpServers": {
    "mcp-mysql-client": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "${MYSQL_USER}",
        "MYSQL_PASS": "${MYSQL_PASS}",
        "MYSQL_DB": "${MYSQL_DB}",
        "MYSQL_SSL": "false",
        "ALLOW_INSERT_OPERATION": "false",
        "ALLOW_UPDATE_OPERATION": "false",
        "ALLOW_DELETE_OPERATION": "false",
        "MYSQL_MAX_ROWS": "1000",
        "MYSQL_TIMEOUT_MS": "30000"
      }
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=mcp-mysql-client&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsIm1jcC1teXNxbC1jbGllbnRAMS4wLjAiXSwiZW52Ijp7Ik1ZU1FMX0hPU1QiOiIxMjcuMC4wLjEiLCJNWVNRTF9QT1JUIjoiMzMwNiIsIk1ZU1FMX1VTRVIiOiIke01ZU1FMX1VTRVJ9IiwiTVlTUUxfUEFTUyI6IiR7TVlTUUxfUEFTU30iLCJNWVNRTF9EQiI6IiR7TVlTUUxfREJ9IiwiTVlTUUxfU1NMIjoiZmFsc2UiLCJBTExPV19JTlNFUlRfT1BFUkFUSU9OIjoiZmFsc2UiLCJBTExPV19VUERBVEVfT1BFUkFUSU9OIjoiZmFsc2UiLCJBTExPV19ERUxFVEVfT1BFUkFUSU9OIjoiZmFsc2UiLCJNWVNRTF9NQVhfUk9XUyI6IjEwMDAiLCJNWVNRTF9USU1FT1VUX01TIjoiMzAwMDAifX0%3D"
}
{
  "servers": {
    "mcp-mysql-client": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "${MYSQL_USER}",
        "MYSQL_PASS": "${MYSQL_PASS}",
        "MYSQL_DB": "${MYSQL_DB}",
        "MYSQL_SSL": "false",
        "ALLOW_INSERT_OPERATION": "false",
        "ALLOW_UPDATE_OPERATION": "false",
        "ALLOW_DELETE_OPERATION": "false",
        "MYSQL_MAX_ROWS": "1000",
        "MYSQL_TIMEOUT_MS": "30000"
      }
    }
  }
}
{
  "mcpServers": {
    "mcp-mysql-client": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "${MYSQL_USER}",
        "MYSQL_PASS": "${MYSQL_PASS}",
        "MYSQL_DB": "${MYSQL_DB}",
        "MYSQL_SSL": "false",
        "ALLOW_INSERT_OPERATION": "false",
        "ALLOW_UPDATE_OPERATION": "false",
        "ALLOW_DELETE_OPERATION": "false",
        "MYSQL_MAX_ROWS": "1000",
        "MYSQL_TIMEOUT_MS": "30000"
      }
    }
  }
}
extensions:
  "mcp-mysql-client":
    enabled: true
    name: "mcp-mysql-client"
    type: stdio
    cmd: "npx"
    args:
      - "-y"
      - "[email protected]"
    envs:
      "MYSQL_HOST": "127.0.0.1"
      "MYSQL_PORT": "3306"
      "MYSQL_USER": "${MYSQL_USER}"
      "MYSQL_PASS": "${MYSQL_PASS}"
      "MYSQL_DB": "${MYSQL_DB}"
      "MYSQL_SSL": "false"
      "ALLOW_INSERT_OPERATION": "false"
      "ALLOW_UPDATE_OPERATION": "false"
      "ALLOW_DELETE_OPERATION": "false"
      "MYSQL_MAX_ROWS": "1000"
      "MYSQL_TIMEOUT_MS": "30000"
    timeout: 300

Placeholders to fill from your own secret store: ${MYSQL_PASS}. 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 106 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: 106 packages

Tool list unknown · checked 2026-10-20 12:45 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-58d-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] npm105 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
mcp-mysql-clientnpm1.0.0–MYSQL_PASS

Tools (0)

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

Schemas: list_tools.

Similar MCP servers

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

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

  • 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.

  • JDBC MCP ServerL0
    io.github.igorolv/jdbc-mcp-server

    Read-only SQL, plans, schema for AI agents: PostgreSQL, Oracle, SQL Server, Firebird, SQLite, JDBC

  • Secure Schema MCPL0
    io.github.Siddharth-coder13/secure-schema

    Read-only MCP server for exposing database schema metadata without row data.

  • SqlServerMcpL0
    io.github.Nithish1206/SqlServerMcp

    MCP server for SQL Server: schema inspection, safe read-only queries, query plan analysis

More from io.github.gistrec

  • Yandex DirectL0
    io.github.gistrec/mcp-yandex-direct

    MCP server for Yandex Direct API v5: manage PPC campaigns, ads, keywords, and statistics.

  • A1 Yandex KIT MCPL0
    io.github.gistrec/mcp-yandex-kit

    A1 Yandex KIT MCP server for the Yandex KIT e-commerce API: products, orders, discounts, webhooks.

Official server.json
{
  "name": "io.github.gistrec/mcp-mysql-client",
  "title": "MySQL MCP",
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "version": "1.0.0",
  "packages": [
    {
      "version": "1.0.0",
      "transport": {
        "type": "stdio"
      },
      "identifier": "mcp-mysql-client",
      "registryType": "npm",
      "registryBaseUrl": "https://registry.npmjs.org",
      "environmentVariables": [
        {
          "name": "MYSQL_HOST",
          "default": "127.0.0.1",
          "description": "Database host."
        },
        {
          "name": "MYSQL_PORT",
          "default": "3306",
          "description": "Database port."
        },
        {
          "name": "MYSQL_USER",
          "isRequired": true,
          "description": "MySQL user. Use one with the least privileges the task needs, never root."
        },
        {
          "name": "MYSQL_PASS",
          "isSecret": true,
          "description": "Password for that user. Treat it as a secret; MYSQL_PASS_FILE reads it from a file instead."
        },
        {
          "name": "MYSQL_DB",
          "isRequired": true,
          "description": "The one database this server is bound to. No tool can leave it."
        },
        {
          "name": "MYSQL_SSL",
          "default": "false",
          "description": "Require a TLS connection to the server."
        },
        {
          "name": "MYSQL_SSL_CA",
          "description": "Path to the CA bundle verifying the server certificate; implies MYSQL_SSL."
        },
        {
          "name": "ALLOW_INSERT_OPERATION",
          "default": "false",
          "description": "Allow INSERT statements through the execute tool."
        },
        {
          "name": "ALLOW_UPDATE_OPERATION",
          "default": "false",
          "description": "Allow UPDATE statements through the execute tool."
        },
        {
          "name": "ALLOW_DELETE_OPERATION",
          "default": "false",
          "description": "Allow DELETE statements through the execute tool."
        },
        {
          "name": "MYSQL_MAX_ROWS",
          "default": "1000",
          "description": "Row cap for one read; the result is marked truncated when it is hit."
        },
        {
          "name": "MYSQL_TIMEOUT_MS",
          "default": "30000",
          "description": "Statement timeout in milliseconds; the connection is dropped on expiry."
        }
      ]
    }
  ],
  "repository": {
    "url": "https://github.com/gistrec/mcp-mysql-client",
    "source": "github"
  },
  "websiteUrl": "https://github.com/gistrec/mcp-mysql-client#readme",
  "description": "MCP server for one MySQL database: schema, read-only queries and guarded writes."
}