MCP-MySQL 服务器镜像

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] } });