Which integrations are available for this server?

Provides tools for executing SQL queries, checking database connection status, and accessing SQL query examples to interact with MySQL databases.

How do I use MySQL MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@MySQL MCP Server show me the first 5 rows from the customers table" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

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" } } } }