AgentHubAgentHub

MySQL

MCP ServerMCP Hub 中国

io.mcp-cn.benborla29/mcp-server-mysql · vlatest

MySQL数据库的MCP服务器,支持数据库操作和管理

概览

MySQL 是一个MCP Server,收录自 MCP Hub 中国。支持 stdio 传输。本页提供 Cursor、Claude Code 等客户端的安装配置片段。

数据库MySQL数据管理SQL

安装

选择你的平台查看安装方式

{
  "mcpServers": {
    "mcp-server-mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "<MYSQL_HOST>",
        "MYSQL_PORT": "<MYSQL_PORT>",
        "MYSQL_USER": "<MYSQL_USER>",
        "MYSQL_PASS": "<MYSQL_PASS>",
        "MYSQL_DB": "<MYSQL_DB>",
        "ALLOW_INSERT_OPERATION": "<ALLOW_INSERT_OPERATION>",
        "ALLOW_UPDATE_OPERATION": "<ALLOW_UPDATE_OPERATION>",
        "ALLOW_DELETE_OPERATION": "<ALLOW_DELETE_OPERATION>",
        "PATH": "<PATH>",
        "NODE_PATH": "<NODE_PATH>"
      }
    }
  }
}

环境变量

MYSQL_HOST必填

<YOUR_MYSQL_HOST>

MYSQL_PORT必填

3306

MYSQL_USER必填

<YOUR_MYSQL_USER>

MYSQL_PASS必填

<YOUR_MYSQL_PASSWORD>

MYSQL_DB必填

<YOUR_MYSQL_DATABASE>

ALLOW_INSERT_OPERATION必填

false

ALLOW_UPDATE_OPERATION必填

false

ALLOW_DELETE_OPERATION必填

false

PATH必填

<YOUR_PATH>

NODE_PATH必填

<YOUR_NODE_PATH>

相关资源

统一 Manifest

{
  "id": "io.mcp-cn.benborla29/mcp-server-mysql",
  "type": "mcp-server",
  "version": "latest",
  "displayName": "MySQL",
  "description": "MySQL数据库的MCP服务器,支持数据库操作和管理",
  "author": {
    "name": "Ben Borla"
  },
  "iconUrl": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTFPLXqRyw5PEl4ETnuzYuP5XhUI51sUdQzcg&s",
  "homepage": "https://mcp-cn.com/server/90",
  "distribution": {
    "packages": [
      {
        "registryType": "npm",
        "identifier": "@benborla29/mcp-server-mysql",
        "runtimeHint": "npx",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "MYSQL_HOST",
            "description": "<YOUR_MYSQL_HOST>",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "MYSQL_PORT",
            "description": "3306",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "MYSQL_USER",
            "description": "<YOUR_MYSQL_USER>",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "MYSQL_PASS",
            "description": "<YOUR_MYSQL_PASSWORD>",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "MYSQL_DB",
            "description": "<YOUR_MYSQL_DATABASE>",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "ALLOW_INSERT_OPERATION",
            "description": "false",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "ALLOW_UPDATE_OPERATION",
            "description": "false",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "ALLOW_DELETE_OPERATION",
            "description": "false",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "PATH",
            "description": "<YOUR_PATH>",
            "isRequired": true,
            "isSecret": false
          },
          {
            "name": "NODE_PATH",
            "description": "<YOUR_NODE_PATH>",
            "isRequired": true,
            "isSecret": false
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode"
  ],
  "keywords": [
    "use_count:44097",
    "数据库",
    "MySQL",
    "数据管理",
    "SQL"
  ],
  "provenance": {
    "origin": "mcp-cn",
    "originalId": "@benborla29/mcp-server-mysql",
    "originalUrl": "https://mcp-cn.com/server/90",
    "isOfficial": false,
    "status": "active"
  }
}
MySQL — MCP Server 安装与配置 · AgentHub