英文 |[中文文档]

---

有关中文文献，请参见 README.zh-CN.md

---

一个模型上下文协议服务器，提供MySQL数据库操作。该服务器使AI模型能够通过标准化接口与MySQL数据库交互。

安装

通过Smithery安装

通过Smithery自动安装Claude Desktop的MySQL Server：

手动安装

配置

服务器需要在你的MCP设置配置文件中设置以下环境变量：

推荐用途

正在进行评估

evals 包加载一个 mcp 客户端，然后运行 index.ts 文件，因此无需在测试间重建。你可以通过在 npx 命令前缀加载环境变量。完整文档可以在这里找到。

可用工具

1.connect_db

使用提供的凭证建立与MySQL数据库的连接。

2.查询

使用可选的预备语句参数执行SELECT查询。

3.执行

使用可选的预备语句参数执行INSERT、UPDATE或DELETE查询。

4.list_tables

列出连接数据库中的所有表。

5.describe_table

@fhuang/mcp-mysql-server

[English | 中文文档]

---

For Chinese documentation, please see README.zh-CN.md

---

A Model Context Protocol server that provides MySQL database operations. This server enables AI models to interact with MySQL databases through a standardized interface.

Installation

Installing via Smithery

To install MySQL Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @fhuang/mcp-mysql-server --client claude

Manual Installation

npx @fhuang/mcp-mysql-server

Configuration

The server requires the following environment variables to be set in your MCP settings configuration file:

recommended use

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@fhuang/mcp-mysql-server", "mysql://user:password@localhost:port/database"],
    }
  }
}

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@fhuang/mcp-mysql-server"],
      "env": {
        "MYSQL_HOST": "your_host",
        "MYSQL_USER": "your_user",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

Running evals

The evals package loads an mcp client that then runs the index.ts file, so there is no need to rebuild between tests. You can load environment variables by prefixing the npx command. Full documentation can be found here.

OPENAI_API_KEY=your-key  npx mcp-eval src/evals/evals.ts src/index.ts

Available Tools

1. connect_db

Establish connection to MySQL database using provided credentials.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "connect_db",
  arguments: {
    host: "localhost",
    user: "your_user",
    password: "your_password",
    database: "your_database"
  }
});

2. query

Execute SELECT queries with optional prepared statement parameters.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "query",
  arguments: {
    sql: "SELECT * FROM users WHERE id = ?",
    params: [1]
  }
});

3. execute

Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "execute",
  arguments: {
    sql: "INSERT INTO users (name, email) VALUES (?, ?)",
    params: ["John Doe", "[email protected]"]
  }
});

4. list_tables

List all tables in the connected database.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "list_tables",
  arguments: {}
});

5. describe_table

Get the structure of a specific table.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "describe_table",
  arguments: {
    table: "users"