mcpField
M
MySQL MCP Server

MySQL MCP Server

Local
github.com/shengshengshengbuxiDatabases1Updated 47w ago
Repository

About MySQL MCP Server

MySQL MCP Server lets MCP clients run SQL against a configured MySQL database. It also provides a connection check and an SQL example prompt.

Key features

  1. 01Run SQL queries
  2. 02Check database connectivity
  3. 03Provide SQL example prompt

Use cases

  1. 01Run queries against a MySQL database
  2. 02Check whether the configured database is reachable

MCP support

It exposes SQL execution and connection-check tools, plus an SQL example prompt, to MCP clients.

#mysql#mcp#server

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

MySQL MCP Server

一个基于Model Context Protocol (MCP)的MySQL服务器，允许通过MCP协议执行SQL查询。

功能

  • 通过MCP协议执行SQL查询
  • 检查数据库连接状态
  • 内置SQL查询示例提示

安装

# 克隆仓库
git clone https://github.com/shengshengshengbuxi/mysql_mcp_server.git
cd mysql_mcp_server

# 安装依赖
npm install

# 编译TypeScript代码
npm run build

配置

服务器使用以下环境变量进行配置：

  • MYSQL_HOST: MySQL主机地址（默认: localhost）
  • MYSQL_PORT: MySQL端口（默认: 3306）
  • MYSQL_USER: MySQL用户名（默认: root）
  • MYSQL_PASSWORD: MySQL密码（默认: 空）
  • MYSQL_DATABASE: MySQL数据库名（默认: 空）

运行

# 设置MySQL连接参数
$env:MYSQL_HOST = "localhost"
$env:MYSQL_PORT = "3306"
$env:MYSQL_USER = "root"
$env:MYSQL_PASSWORD = "your_password"
$env:MYSQL_DATABASE = "your_database"

# 运行服务器
npm start

与Claude集成

要在Claude Desktop中使用此服务器，请编辑Claude Desktop配置文件：

Windows:

%USERPROFILE%\AppData\Roaming\Claude\claude_desktop_config.json

添加以下配置：

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": [
        "/path/to/mysql_mcp_server/dist/server.js",
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "your password",
        "MYSQL_DATABASE": "your database"
      }
    }
  }
}

工具

  • execute_sql: 执行SQL查询
  • check_connection: 检查数据库连接状态

提示

  • sql_example: 提供SQL查询示例

许可证

MIT

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.