MySQL MCP MCP配置与使用教程

{
  "id": "io.github.gistrec/mcp-mysql-client",
  "type": "mcp-server",
  "version": "1.0.0",
  "displayName": "MySQL MCP",
  "description": "MCP server for one MySQL database: schema, read-only queries and guarded writes.",
  "repository": {
    "url": "https://github.com/gistrec/mcp-mysql-client",
    "source": "github"
  },
  "homepage": "https://github.com/gistrec/mcp-mysql-client#readme",
  "distribution": {
    "packages": [
      {
        "registryType": "npm",
        "identifier": "mcp-mysql-client",
        "version": "1.0.0",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "MYSQL_HOST",
            "description": "Database host."
          },
          {
            "name": "MYSQL_PORT",
            "description": "Database port."
          },
          {
            "name": "MYSQL_USER",
            "description": "MySQL user. Use one with the least privileges the task needs, never root.",
            "isRequired": true
          },
          {
            "name": "MYSQL_PASS",
            "description": "Password for that user. Treat it as a secret; MYSQL_PASS_FILE reads it from a file instead.",
            "isSecret": true
          },
          {
            "name": "MYSQL_DB",
            "description": "The one database this server is bound to. No tool can leave it.",
            "isRequired": true
          },
          {
            "name": "MYSQL_SSL",
            "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",
            "description": "Allow INSERT statements through the execute tool."
          },
          {
            "name": "ALLOW_UPDATE_OPERATION",
            "description": "Allow UPDATE statements through the execute tool."
          },
          {
            "name": "ALLOW_DELETE_OPERATION",
            "description": "Allow DELETE statements through the execute tool."
          },
          {
            "name": "MYSQL_MAX_ROWS",
            "description": "Row cap for one read; the result is marked truncated when it is hit."
          },
          {
            "name": "MYSQL_TIMEOUT_MS",
            "description": "Statement timeout in milliseconds; the connection is dropped on expiry."
          }
        ]
      }
    ],
    "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.gistrec/mcp-mysql-client",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.gistrec%2Fmcp-mysql-client/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}