
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
相关推荐
I find academic articles and books for research and literature reviews.
Confidential guide on numerology and astrology, based of GG33 Public information
Advanced software engineer GPT that excels through nailing the basics.
Take an adjectivised noun, and create images making it progressively more adjective!
Embark on a thrilling diplomatic quest across a galaxy on the brink of war. Navigate complex politics and alien cultures to forge peace and avert catastrophe in this immersive interstellar adventure.
Découvrez la collection la plus complète et la plus à jour de serveurs MCP sur le marché. Ce référentiel sert de centre centralisé, offrant un vaste catalogue de serveurs MCP open-source et propriétaires, avec des fonctionnalités, des liens de documentation et des contributeurs.
Manipulation basée sur Micropython I2C de l'exposition GPIO de la série MCP, dérivée d'Adafruit_MCP230XX
L'application tout-en-un desktop et Docker AI avec chiffon intégré, agents AI, constructeur d'agent sans code, compatibilité MCP, etc.
Miroir dehttps: //github.com/bitrefill/bitrefill-mcp-server
Un puissant plugin Neovim pour gérer les serveurs MCP (Protocole de contexte modèle)
Reviews

user_iIgGKEl7
As a dedicated user of mysql_mcp_server, I must say it has remarkably streamlined my database management processes. The seamless integration and robust performance make it a standout tool for any developer. Kudos to shengshengshengbuxi for creating such an efficient and user-friendly application. Highly recommended for anyone working with MySQL!