{"_id":"@dockeryu/mysql-mcp","_rev":"2-12a884fc68f489ed45ac5d1c72992381","name":"@dockeryu/mysql-mcp","dist-tags":{"latest":"1.0.1"},"versions":{"1.0.0":{"name":"@dockeryu/mysql-mcp","version":"1.0.0","keywords":["mcp","mysql","modelcontextprotocol"],"license":"MIT","_id":"@dockeryu/mysql-mcp@1.0.0","maintainers":[{"name":"dockeryu","email":"yuchong0111@gmail.com"}],"bin":{"mysql-mcp":"dist/index.js"},"dist":{"shasum":"9e5c1c8ed250904e1db22561bf065034d9db58e4","tarball":"https://registry.npmjs.org/@dockeryu/mysql-mcp/-/mysql-mcp-1.0.0.tgz","fileCount":4,"integrity":"sha512-XE8+WXTKdZtkvndzRPzOIOauogsah1OuMDjMHA49L0OC1FPplO8ozbIl8XT7GKeone3kcSranw2CYotIW0J0kg==","signatures":[{"sig":"MEYCIQCJbmpLf4HfRzw5yQgCKbER1jrrOmL2nZDpULiRwCvNSwIhAOND1H2dTachXhT1J49k/71wK3WC1kG4Et9uoGjdb/Lg","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":9963},"main":"dist/index.js","types":"./dist/index.d.ts","scripts":{"dev":"tsc --watch","build":"tsc","start":"node dist/index.js"},"_npmUser":{"name":"dockeryu","email":"yuchong0111@gmail.com"},"_npmVersion":"10.9.2","description":"MySQL MCP Server","directories":{},"_nodeVersion":"22.14.0","dependencies":{"zod":"^3.24.2","mysql2":"^3.14.0","@modelcontextprotocol/sdk":"^1.8.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.8.2","@types/node":"^22.13.14"},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp_1.0.0_1774416408664_0.7055287616628607","host":"s3://npm-registry-packages-npm-production"}},"1.0.1":{"name":"@dockeryu/mysql-mcp","version":"1.0.1","description":"MySQL MCP Server","main":"dist/index.js","bin":{"mysql-mcp":"dist/index.js"},"scripts":{"build":"tsc","start":"node dist/index.js","dev":"tsc --watch"},"keywords":["mcp","mysql","modelcontextprotocol"],"license":"MIT","publishConfig":{"access":"public"},"dependencies":{"@modelcontextprotocol/sdk":"^1.8.0","mysql2":"^3.14.0","zod":"^3.24.2"},"devDependencies":{"@types/node":"^22.13.14","typescript":"^5.8.2"},"_id":"@dockeryu/mysql-mcp@1.0.1","types":"./dist/index.d.ts","_nodeVersion":"22.14.0","_npmVersion":"10.9.2","dist":{"integrity":"sha512-BVLeUx8KPFsvYdPWkc/+GQL6YmZhLWs1ahtiyO/HE2h1RCy0j9XpHKaJxcNa0C7UJEAc2mcQ5RwiKHdpgMXhIQ==","shasum":"76e5cd3a60f843ad3300b92d6f1b86b5a1a186d6","tarball":"https://registry.npmjs.org/@dockeryu/mysql-mcp/-/mysql-mcp-1.0.1.tgz","fileCount":4,"unpackedSize":9701,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIBjTJ3p/loog1AhX4PMDkKxhdIvIr1OcJLXn0zM4YFVNAiEAi24LnWJza70F4Ym/e5mfH1yezMet1W5VEhyVwaNHWSw="}]},"_npmUser":{"name":"dockeryu","email":"yuchong0111@gmail.com"},"directories":{},"maintainers":[{"name":"dockeryu","email":"yuchong0111@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mysql-mcp_1.0.1_1774416779717_0.6239963755797455"},"_hasShrinkwrap":false}},"time":{"created":"2026-03-25T05:26:48.515Z","modified":"2026-03-25T05:33:00.000Z","1.0.0":"2026-03-25T05:26:48.812Z","1.0.1":"2026-03-25T05:32:59.885Z"},"license":"MIT","keywords":["mcp","mysql","modelcontextprotocol"],"description":"MySQL MCP Server","maintainers":[{"name":"dockeryu","email":"yuchong0111@gmail.com"}],"readme":"# @dockeryu/mysql-mcp\n\n基于 [Model Context Protocol](https://modelcontextprotocol.io) 的 MySQL 数据库服务，让 AI 助手可以直接操作 MySQL。\n\n## 安装与运行\n\n```bash\nnpx -y @dockeryu/mysql-mcp\n```\n\n## 配置\n\n通过环境变量配置数据库连接和操作权限。\n\n### 连接配置\n\n| 环境变量 | 默认值 | 说明 |\n|----------|--------|------|\n| `MYSQL_HOST` | `127.0.0.1` | 数据库地址 |\n| `MYSQL_PORT` | `3306` | 端口 |\n| `MYSQL_USER` | `root` | 用户名 |\n| `MYSQL_PASSWORD` | _(空)_ | 密码 |\n| `MYSQL_DATABASE` | _(无)_ | 默认数据库（可选）|\n\n### 操作权限\n\n危险操作默认禁止，需显式开启。\n\n| 环境变量 | 默认 | 说明 |\n|----------|------|------|\n| `MYSQL_ALLOW_INSERT` | `true` | 允许 INSERT |\n| `MYSQL_ALLOW_CREATE` | `true` | 允许 CREATE |\n| `MYSQL_ALLOW_UPDATE` | `false` | 允许 UPDATE |\n| `MYSQL_ALLOW_DELETE` | `false` | 允许 DELETE |\n| `MYSQL_ALLOW_DROP` | `false` | 允许 DROP |\n| `MYSQL_ALLOW_TRUNCATE` | `false` | 允许 TRUNCATE |\n\n## 在 Cursor / Claude Desktop 中使用\n\n编辑 MCP 配置文件（`mcp.json`）：\n\n```json\n{\n  \"mcpServers\": {\n    \"mysql\": {\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"@dockeryu/mysql-mcp\"],\n      \"env\": {\n        \"MYSQL_HOST\": \"127.0.0.1\",\n        \"MYSQL_PORT\": \"3306\",\n        \"MYSQL_USER\": \"root\",\n        \"MYSQL_PASSWORD\": \"your_password\",\n        \"MYSQL_DATABASE\": \"your_db\",\n        \"MYSQL_ALLOW_UPDATE\": \"true\",\n        \"MYSQL_ALLOW_DELETE\": \"true\"\n      }\n    }\n  }\n}\n```\n\n## 工具列表\n\n| 工具 | 说明 |\n|------|------|\n| `query` | 执行 SELECT 查询 |\n| `execute` | 执行写操作（受权限控制） |\n| `list_databases` | 列出所有数据库 |\n| `list_tables` | 列出指定库的所有表 |\n| `describe_table` | 查看表结构 |\n\n## 本地开发\n\n```bash\nnpm install\nnpm run build\nnpm start\n```\n\n\n## License\n\nMIT\n","readmeFilename":"README.md"}