MCP-MySQL 服务器镜像
一个为 AI 模型提供 MySQL 数据库操作的标准化接口的服务器。
快速入门
安装
通过 Smithery 自动安装: npx -y @smithery/cli install @f4ww4z/mcp-mysql-server --client claude 手动安装: npx @f4ww4z/mcp-mysql-server
配置
在 MCP 设置文件中设置以下环境变量: { "mcpServers": { "mysql": { "command": "npx", "args": ["-y", "@f4ww4z/mcp-mysql-server"], "env": { "MYSQL_HOST": "your_host", "MYSQL_USER": "your_user", "MYSQL_PASSWORD": "your_password", "MYSQL_DATABASE": "your_database" } } } }
使用工具
连接数据库: use_mcp_tool({ server_name: "mysql", tool_name: "connect_db", arguments: { host: "localhost", user: "your_user", password: "your_password", database: "your_database" } }); 执行查询: use_mcp_tool({ server_name: "mysql", tool_name: "query", arguments: { sql: "SELECT * FROM users WHERE id = ?", params: [1] } });