Mysql MCP Server

Name: Mysql MCP Server
Author: midu2

@midu2

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

midu2

提交者

di zhou

关于 Mysql MCP Server

暂无概览

Mysql MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@kevinwatt/mysql-mcp"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "",
        "MYSQL_DB": "your_database"
      }
    }
  }
}

Mysql MCP Server 工具

Execute read-only SELECT queries against the MySQL database. - Maximum query length: 4096 characters - Maximum result rows: 1000 - Query timeout: 30 seconds

Execute data modification queries (INSERT/UPDATE/DELETE). - Returns affected rows count and insert ID - Supports parameterized queries - Automatic transaction handling

List all tables in current database

Show table structure