MySQL MCP Server

Name: MySQL MCP Server
Author: wuwen1030

@wuwen1030

关于 MySQL MCP Server

A MySQL implementation of the Model Context Protocol (MCP) server. This server allows AI models to interact with MySQL databases through a standardized interface.

基本信息

分类

数据库

运行时

node

传输方式

stdio

发布者

wuwen1030

配置

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

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": [
        "/ABSOLUTE/PATH/TO/PARENT/FOLDER/mysql-mcp-server/dist/index.js"
      ],
      "env": {
        "MYSQL_HOST": "",
        "MYSQL_PORT": "",
        "MYSQL_USER": "",
        "MYSQL_PASSWORD": "",
        "MYSQL_DATABASE": ""
      }
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MySQL MCP Server?

A MySQL implementation of the Model Context Protocol (MCP) server that allows AI models to interact with MySQL databases through a standardized read-only interface.

How to use MySQL MCP Server?

Install with npm install and build with npm run build, then configure the server in your Claude Desktop app's claude_desktop_config.json by providing the absolute path to the built index.js and setting environment variables for MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE.

Key features of MySQL MCP Server

List available database tables
Get table schemas
Execute read-only SQL queries
Safe transaction handling with automatic rollback

Use cases of MySQL MCP Server

Explore a MySQL database schema through an AI assistant
Run read-only queries to retrieve data without risk of modification
Enable AI models to answer questions backed by live database content

FAQ from MySQL MCP Server

What dependencies or runtime does MySQL MCP Server require?

Node.js is required. After cloning, run npm install and npm run build to compile the server.

How is authentication handled?

Authentication is configured via environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE) passed to the server process.