{"_id":"@mikechan2224/mysql-mcp-server","_rev":"5-157e8f95e0c94b2eff87c614152e8172","name":"@mikechan2224/mysql-mcp-server","dist-tags":{"latest":"1.0.4"},"versions":{"1.0.0":{"name":"@mikechan2224/mysql-mcp-server","version":"1.0.0","keywords":["mcp","mysql","modelcontextprotocol","server","database"],"author":{"name":"mikechan2224@gmail.com"},"license":"MIT","_id":"@mikechan2224/mysql-mcp-server@1.0.0","maintainers":[{"name":"mikechan2224","email":"mikechan2224@gmail.com"}],"homepage":"https://github.com/zhanghang2017/mcp-server/tree/main/mysql-mcp-server#readme","bugs":{"url":"https://github.com/zhanghang2017/mcp-server/issues"},"dist":{"shasum":"6c4a57a6f106b0466e64d8d68c4c6fec53d0bbc5","tarball":"https://registry.npmjs.org/@mikechan2224/mysql-mcp-server/-/mysql-mcp-server-1.0.0.tgz","fileCount":3,"integrity":"sha512-5znNWsEvPhWko4+oXu2H/+SX7fFjAKHWZj3b5GX8SLlLtokuN81n3m9Sipkzp8p8vuQ8u6xbCEdQyGTeuQBHxQ==","signatures":[{"sig":"MEYCIQDe3zX5R5zqZfXJhoXiOdXE9W9A0igO/zqYXuaMAe5q5gIhAMhmviHJMUInXcOhey+e5yFbiVKREl84hrWJuGmm5jwu","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":8106},"main":"dist/index.js","type":"module","exports":{".":"./dist/index.js"},"gitHead":"4551e6b568a04ac80c71fe7198ec7794f517d2fb","scripts":{"build":"tsc","start":"node dist/index.js","prepublishOnly":"npm run build"},"_npmUser":{"name":"mikechan2224","email":"mikechan2224@gmail.com"},"repository":{"url":"git+https://github.com/zhanghang2017/mcp-server.git","type":"git","directory":"mysql-mcp-server"},"_npmVersion":"10.9.2","description":"MCP server for MySQL.","directories":{},"_nodeVersion":"23.11.1","dependencies":{"zod":"^4.4.3","dotenv":"^17.4.2","mysql2":"^3.22.3","node-sql-parser":"^5.4.0","@modelcontextprotocol/sdk":"^1.29.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.1","typescript":"^6.0.3","@types/node":"^25.9.0"},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp-server_1.0.0_1779174700030_0.6962095601499088","host":"s3://npm-registry-packages-npm-production"}},"1.0.1":{"name":"@mikechan2224/mysql-mcp-server","version":"1.0.1","keywords":["mcp","mysql","modelcontextprotocol","server","database"],"author":{"name":"mikechan2224@gmail.com"},"license":"MIT","_id":"@mikechan2224/mysql-mcp-server@1.0.1","maintainers":[{"name":"mikechan2224","email":"mikechan2224@gmail.com"}],"homepage":"https://github.com/zhanghang2017/mcp-server/tree/main/mysql-mcp-server#readme","bugs":{"url":"https://github.com/zhanghang2017/mcp-server/issues"},"bin":{"mysql-mcp-server":"dist/index.js"},"dist":{"shasum":"8761fa1f339b9bf7ad3c67d9a4841839f1db306b","tarball":"https://registry.npmjs.org/@mikechan2224/mysql-mcp-server/-/mysql-mcp-server-1.0.1.tgz","fileCount":3,"integrity":"sha512-iAyKi51XlttEZl07bZ/4EMfAIWH6FrlU902AdbqWKw+BMhLrZnR8kEAYdZpzq5mv77tA14oeA8StDzbuy6ls6w==","signatures":[{"sig":"MEQCIF3qSxdANTdpt71HV7wW0+3AVMdD32qwk+A1/fVA5IuhAiAXe+otp3Q7tHiRv7psIMvJSOfw2VEwEaOAqDFOwuE21w==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":8211},"main":"dist/index.js","type":"module","exports":{".":"./dist/index.js"},"gitHead":"a5ac3f5165a2d6c06f29a5cb9ea9fa3bab08053b","scripts":{"build":"tsc","start":"node dist/index.js","prepublishOnly":"npm run build"},"_npmUser":{"name":"mikechan2224","email":"mikechan2224@gmail.com"},"repository":{"url":"git+https://github.com/zhanghang2017/mcp-server.git","type":"git","directory":"mysql-mcp-server"},"_npmVersion":"10.9.2","description":"MCP server for MySQL.","directories":{},"_nodeVersion":"23.11.1","dependencies":{"zod":"^4.4.3","dotenv":"^17.4.2","mysql2":"^3.22.3","node-sql-parser":"^5.4.0","@modelcontextprotocol/sdk":"^1.29.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.1","typescript":"^6.0.3","@types/node":"^25.9.0"},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp-server_1.0.1_1779178734113_0.24987065324889457","host":"s3://npm-registry-packages-npm-production"}},"1.0.2":{"name":"@mikechan2224/mysql-mcp-server","version":"1.0.2","keywords":["mcp","mysql","modelcontextprotocol","server","database"],"author":{"name":"mikechan2224@gmail.com"},"license":"MIT","_id":"@mikechan2224/mysql-mcp-server@1.0.2","maintainers":[{"name":"mikechan2224","email":"mikechan2224@gmail.com"}],"homepage":"https://github.com/zhanghang2017/mcp-server/tree/main/mysql-mcp-server#readme","bugs":{"url":"https://github.com/zhanghang2017/mcp-server/issues"},"bin":{"mysql-mcp-server":"dist/index.js"},"dist":{"shasum":"d049393eb6ad07b0415e90eb04db8013bc06793a","tarball":"https://registry.npmjs.org/@mikechan2224/mysql-mcp-server/-/mysql-mcp-server-1.0.2.tgz","fileCount":3,"integrity":"sha512-Bluut3y7u19jX/NCHAE0yUX0F/uVv6S5/+24G2YH1v4MhVHKs/yCfHSM/dMTzDeTpsiolWo7VjkY92BuLqxcBA==","signatures":[{"sig":"MEUCIQDzDRSHXKUPfmAQ6h0rps+2Csp4QSub2maj3uchEgomvwIgdHvbvX8bCvy6G3q3NUVGv6CdkI4CYP5rThP2aBcNMx4=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":8189},"main":"dist/index.js","type":"module","exports":{".":"./dist/index.js"},"gitHead":"a5ac3f5165a2d6c06f29a5cb9ea9fa3bab08053b","scripts":{"build":"tsc","start":"node dist/index.js","prepublishOnly":"npm run build"},"_npmUser":{"name":"mikechan2224","email":"mikechan2224@gmail.com"},"repository":{"url":"git+https://github.com/zhanghang2017/mcp-server.git","type":"git","directory":"mysql-mcp-server"},"_npmVersion":"10.9.2","description":"MCP server for MySQL.","directories":{},"_nodeVersion":"23.11.1","dependencies":{"zod":"^4.4.3","dotenv":"^17.4.2","mysql2":"^3.22.3","node-sql-parser":"^5.4.0","@modelcontextprotocol/sdk":"^1.29.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.1","typescript":"^6.0.3","@types/node":"^25.9.0"},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp-server_1.0.2_1779180502329_0.009223569511234597","host":"s3://npm-registry-packages-npm-production"}},"1.0.3":{"name":"@mikechan2224/mysql-mcp-server","version":"1.0.3","keywords":["mcp","mysql","modelcontextprotocol","server","database"],"author":{"name":"mikechan2224@gmail.com"},"license":"MIT","_id":"@mikechan2224/mysql-mcp-server@1.0.3","maintainers":[{"name":"mikechan2224","email":"mikechan2224@gmail.com"}],"homepage":"https://github.com/zhanghang2017/mcp-server/tree/main/mysql-mcp-server#readme","bugs":{"url":"https://github.com/zhanghang2017/mcp-server/issues"},"bin":{"mysql-mcp-server":"dist/index.js"},"dist":{"shasum":"1a93df1891e2213eaa1776de3a72bf012dfc852d","tarball":"https://registry.npmjs.org/@mikechan2224/mysql-mcp-server/-/mysql-mcp-server-1.0.3.tgz","fileCount":3,"integrity":"sha512-YQZDMJmlSaKE4o/lQOrc1A5OJoqDBmZKILRMYwel+HHLiiEt6OA3Y1OOZG6VMUhOkL3JZ8uW4osqWzjuUUdiIA==","signatures":[{"sig":"MEUCIFDU6t6NwM5/xZTnuI4S/zeQ9HKCwU0sWHEdhcppYHQUAiEA8jSwAqLUVwbBx77/ramhkkYVvghBoapD34hBfWIy63k=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":8189},"main":"dist/index.js","type":"module","exports":{".":"./dist/index.js"},"gitHead":"a5ac3f5165a2d6c06f29a5cb9ea9fa3bab08053b","scripts":{"build":"tsc","start":"node dist/index.js","prepublishOnly":"npm run build"},"_npmUser":{"name":"mikechan2224","email":"mikechan2224@gmail.com"},"repository":{"url":"git+https://github.com/zhanghang2017/mcp-server.git","type":"git","directory":"mysql-mcp-server"},"_npmVersion":"10.9.2","description":"MCP server for MySQL.","directories":{},"_nodeVersion":"23.11.1","dependencies":{"zod":"^4.4.3","dotenv":"^17.4.2","mysql2":"^3.22.3","node-sql-parser":"^5.4.0","@modelcontextprotocol/sdk":"^1.29.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.1","typescript":"^6.0.3","@types/node":"^25.9.0"},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp-server_1.0.3_1779180782936_0.20523451333041898","host":"s3://npm-registry-packages-npm-production"}},"1.0.4":{"name":"@mikechan2224/mysql-mcp-server","version":"1.0.4","description":"MCP server for MySQL.","type":"module","main":"dist/index.js","exports":{".":"./dist/index.js"},"scripts":{"build":"tsc","start":"node dist/index.js","postbuild":"node add-shebang.js","prepublishOnly":"npm run build"},"keywords":["mcp","mysql","modelcontextprotocol","server","database"],"bin":{"mysql-mcp-server":"dist/index.js"},"repository":{"type":"git","url":"git+https://github.com/zhanghang2017/mcp-server.git","directory":"mysql-mcp-server"},"bugs":{"url":"https://github.com/zhanghang2017/mcp-server/issues"},"homepage":"https://github.com/zhanghang2017/mcp-server/tree/main/mysql-mcp-server#readme","publishConfig":{"access":"public"},"author":{"name":"mikechan2224@gmail.com"},"license":"MIT","dependencies":{"@modelcontextprotocol/sdk":"^1.29.0","dotenv":"^17.4.2","mysql2":"^3.22.3","node-sql-parser":"^5.4.0","zod":"^4.4.3"},"devDependencies":{"@types/node":"^25.9.0","tsx":"^4.22.1","typescript":"^6.0.3"},"_id":"@mikechan2224/mysql-mcp-server@1.0.4","gitHead":"774ff74bc90185ea7fd0f751106f15c606146b6b","_nodeVersion":"23.11.1","_npmVersion":"10.9.2","dist":{"integrity":"sha512-nn7m1RLadsFLNud0G3YSDZKnKkH/HrJSXK9HxS2KTDl9If0zDVritxdjuYJBdH8xLWE6TP5C7lgZgMVASEs7ug==","shasum":"6076ba6ec36f14910c4d62f9fd6ef95d48445323","tarball":"https://registry.npmjs.org/@mikechan2224/mysql-mcp-server/-/mysql-mcp-server-1.0.4.tgz","fileCount":3,"unpackedSize":8550,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEQCIEFY0HYwK1HU0BcwR/8zCobCYfFJtUKbXIXGK5Y2z/igAiBMzhguLZw4566m0RDfjLHzP8iYwcaOTZ1jvwKw3z/S8w=="}]},"_npmUser":{"name":"mikechan2224","email":"mikechan2224@gmail.com"},"directories":{},"maintainers":[{"name":"mikechan2224","email":"mikechan2224@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mysql-mcp-server_1.0.4_1779197552421_0.12555990286861807"},"_hasShrinkwrap":false}},"time":{"created":"2026-05-19T07:11:39.915Z","modified":"2026-05-19T13:32:32.679Z","1.0.0":"2026-05-19T07:11:40.183Z","1.0.1":"2026-05-19T08:18:54.251Z","1.0.2":"2026-05-19T08:48:22.463Z","1.0.3":"2026-05-19T08:53:03.064Z","1.0.4":"2026-05-19T13:32:32.564Z"},"bugs":{"url":"https://github.com/zhanghang2017/mcp-server/issues"},"author":{"name":"mikechan2224@gmail.com"},"license":"MIT","homepage":"https://github.com/zhanghang2017/mcp-server/tree/main/mysql-mcp-server#readme","keywords":["mcp","mysql","modelcontextprotocol","server","database"],"repository":{"type":"git","url":"git+https://github.com/zhanghang2017/mcp-server.git","directory":"mysql-mcp-server"},"description":"MCP server for MySQL.","maintainers":[{"name":"mikechan2224","email":"mikechan2224@gmail.com"}],"readme":"# mysql-mcp-server\r\n\r\nMySQL MCP server.\r\n\r\n## Installation\r\n\r\n```bash\r\nnpm install @mikechan2224/mysql-mcp-server\r\n```\r\n\r\n## Usage\r\n\r\nRun with `npx` in your MCP client configuration:\r\n\r\n```json\r\n{\r\n  \"mcpServers\": {\r\n    \"mysql\": {\r\n      \"command\": \"npx\",\r\n      \"args\": [\"-y\", \"@mikechan2224/mysql-mcp-server\"],\r\n      \"env\": {\r\n        \"MYSQL_HOST\": \"localhost\",\r\n        \"MYSQL_PORT\": \"3306\",\r\n        \"MYSQL_USER\": \"root\",\r\n        \"MYSQL_PASSWORD\": \"\",\r\n        \"MYSQL_DATABASE\": \"your_db\",\r\n        \"MYSQL_ALLOW_WRITE_SQL\": \"false\",\r\n        \"MYSQL_SELECT_LIMIT\": \"100\"\r\n      }\r\n    }\r\n  }\r\n}\r\n```\r\n\r\n## Configuration\r\n\r\nEnvironment variables:\r\n\r\n- MYSQL_HOST\r\n- MYSQL_PORT\r\n- MYSQL_USER\r\n- MYSQL_PASSWORD\r\n- MYSQL_DATABASE\r\n- MYSQL_ALLOW_WRITE_SQL\r\n- MYSQL_SELECT_LIMIT\r\n\r\nNotes:\r\n\r\n- When using `npx`, you do not need to build locally.\r\n- For production, set `MYSQL_ALLOW_WRITE_SQL=\"true\"` only when write operations are required.\r\n\r\n## License\r\n\r\nMIT\r\n","readmeFilename":"README.md"}