{"_rev":"4-5b83ecee678a569670aa2d00ac3a0e27","time":{"created":"2025-12-12T01:58:16.595Z","modified":"2025-12-12T01:58:17.099Z","1.0.0":"2025-12-12T01:50:15.363Z","1.0.1":"2025-12-12T01:58:16.832Z"},"_id":"@davis_zhang/mysql-mcp-server","name":"@davis_zhang/mysql-mcp-server","dist-tags":{"latest":"1.0.1"},"versions":{"1.0.1":{"name":"@davis_zhang/mysql-mcp-server","version":"1.0.1","description":"MySQL MCP Server for CMS","type":"module","main":"dist/index.js","bin":{"mysql-mcp":"dist/index.js"},"scripts":{"build":"tsc","dev":"tsc --watch","start":"node dist/index.js"},"keywords":["mcp","mysql","database"],"author":"","license":"MIT","dependencies":{"@modelcontextprotocol/sdk":"^1.0.0","mysql2":"^3.11.0"},"devDependencies":{"@types/node":"^20.0.0","typescript":"^5.3.0"},"_id":"@davis_zhang/mysql-mcp-server@1.0.1","types":"./dist/index.d.ts","_nodeVersion":"20.19.5","_npmVersion":"10.8.2","dist":{"integrity":"sha512-kmWQ7iUdyjOmp3iM5HqYCfV0tjzNT0L0Ybw/0iDt8v0CoDqWxT+cN+iUyNot5f3FiqncAKlFMDGkWuaIX9GPZQ==","shasum":"811a63413b4be8e6324a060f7e70e8c290fe2115","tarball":"https://registry.npmjs.org/@davis_zhang/mysql-mcp-server/-/mysql-mcp-server-1.0.1.tgz","fileCount":9,"unpackedSize":26229,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIFSXJgbZR9dVVlYoZtvsEe7lhc5MgcWf/gu7ilQpZpLHAiEAyDMJzCvnqJ26l4xgmZjyH9OMyU5EQSkv79EdT0dxklc="}]},"_npmUser":{"name":"davis_zhang","email":"657762708@qq.com"},"directories":{},"maintainers":[{"name":"davis_zhang","email":"657762708@qq.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mysql-mcp-server_1.0.1_1765504696677_0.00006426098429268556"},"_hasShrinkwrap":false}},"maintainers":[{"name":"davis_zhang","email":"657762708@qq.com"}],"description":"MySQL MCP Server for CMS","keywords":["mcp","mysql","database"],"license":"MIT","readme":"# MySQL MCP Server\n\n一个基于 Model Context Protocol (MCP) 的 MySQL 数据库服务器。\n\n## 功能\n\n- 执行 SQL 查询\n- 列出所有表\n- 查看表结构\n- 创建表\n- 插入数据\n- 更新数据\n- 删除数据\n\n## 安装\n\n```bash\nnpm install\n```\n\n## 配置\n\n复制 `.env.example` 到 `.env` 并配置数据库连接：\n\n```bash\ncp .env.example .env\n```\n\n编辑 `.env` 文件：\n\n```\nMYSQL_HOST=localhost\nMYSQL_PORT=3306\nMYSQL_USER=root\nMYSQL_PASSWORD=your_password\nMYSQL_DATABASE=your_database\n```\n\n## 构建\n\n```bash\nnpm run build\n```\n\n## 运行\n\n```bash\nnpm start\n```\n\n## 在 Claude Desktop 中使用\n\n在 Claude Desktop 配置文件中添加：\n\n**MacOS**: `~/Library/Application Support/Claude/claude_desktop_config.json`\n\n**Windows**: `%APPDATA%\\Claude\\claude_desktop_config.json`\n\n```json\n{\n  \"mcpServers\": {\n    \"mysql\": {\n      \"command\": \"node\",\n      \"args\": [\"/绝对路径/mysql-mcp-server/dist/index.js\"],\n      \"env\": {\n        \"MYSQL_HOST\": \"host\",\n        \"MYSQL_PORT\": \"xxx\",\n        \"MYSQL_USER\": \"xxx\",\n        \"MYSQL_PASSWORD\": \"your_password\",\n        \"MYSQL_DATABASE\": \"xxx\"\n      }\n    }\n  }\n}\n```\n\n## 可用工具\n\n- `query`: 执行 SQL 查询\n- `list_tables`: 列出所有表\n- `describe_table`: 查看表结构\n- `create_table`: 创建新表\n- `insert`: 插入数据\n- `update`: 更新数据\n- `delete`: 删除数据\n","readmeFilename":"README.md"}