{"_id":"@davidfei/mysql-mcp","_rev":"13-e5a2394cc9ab69ed8a0bfbd5b81fa9b3","name":"@davidfei/mysql-mcp","dist-tags":{"latest":"1.3.7"},"versions":{"1.0.0":{"name":"@davidfei/mysql-mcp","version":"1.0.0","keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","_id":"@davidfei/mysql-mcp@1.0.0","maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"homepage":"https://gitlab.com/davidfei1971/mysql-mcp","bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"bin":{"mysql-mcp":"mysql-mcp-server.py"},"mcp":{"env":{"MYSQL_HOST":"localhost","MYSQL_PORT":"3306","MYSQL_USER":"root","MYSQL_DATABASE":"","MYSQL_PASSWORD":"","MYSQL_ROOT_PASSWORD":""},"args":[],"type":"stdio","command":"mysql-mcp"},"dist":{"shasum":"92811050534b14e319762686b65712c2974911da","tarball":"https://registry.npmjs.org/@davidfei/mysql-mcp/-/mysql-mcp-1.0.0.tgz","fileCount":5,"integrity":"sha512-9Pn2+O/n53p5Qpr8f0sX+QfpT/nl+PvYSNFhKDUsnOALsFH7t+/qUlBjGnyWNpBrCTl/7QXzvvPtT21akqXT2w==","signatures":[{"sig":"MEUCIQC+ipiTcWoodS25g1lLRHxKy6m2fde+F634hfGyo1AFhAIgOwJiQmJGpHmPJ2Kd/B5+9vfNF227KwBdtu/e683HoIA=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":29093},"main":"mysql-mcp-server.py","engines":{"node":">=14.0.0"},"gitHead":"8a3f7d19f1978f7c83760d73cb8210853e44d02a","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"davidfei","email":"dvdfei@yahoo.ca"},"repository":{"url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","directories":{},"_nodeVersion":"20.19.5","dependencies":{},"_hasShrinkwrap":false,"peerDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp_1.0.0_1760982220506_0.822106067844808","host":"s3://npm-registry-packages-npm-production"}},"1.1.0":{"name":"@davidfei/mysql-mcp","version":"1.1.0","keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","_id":"@davidfei/mysql-mcp@1.1.0","maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"homepage":"https://gitlab.com/davidfei1971/mysql-mcp","bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"bin":{"mysql-mcp":"mysql-mcp-server.py"},"mcp":{"env":{"MYSQL_HOST":"localhost","MYSQL_PORT":"3306","MYSQL_USER":"root","MYSQL_DATABASE":"","MYSQL_PASSWORD":"","MYSQL_ROOT_PASSWORD":""},"args":[],"type":"stdio","command":"mysql-mcp"},"dist":{"shasum":"69418bac9d08bc650194aae2d164b5765f090043","tarball":"https://registry.npmjs.org/@davidfei/mysql-mcp/-/mysql-mcp-1.1.0.tgz","fileCount":5,"integrity":"sha512-JT/vo8mUZwY/YVAEyvdekrP4ZNK8qBOJgiF20JOCNGrQoZT3GaZYCSUacfPR/kjeiizI1034gvkfrsMBf/j07Q==","signatures":[{"sig":"MEUCIAqn2r19Fv90Ql7kl+KNNKtN2P9pN8Gq7JkSxTJc2qozAiEAmrMKxoJWBy2DeFIzd22tz9SIOvL5wJPUQS8oL5nujAY=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":32178},"main":"mysql-mcp-server.py","engines":{"node":">=14.0.0"},"gitHead":"0efcdbdf5c87dc68eaa4ab1f1ec1a8819dc55033","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"davidfei","email":"dvdfei@yahoo.ca"},"repository":{"url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","directories":{},"_nodeVersion":"20.19.5","dependencies":{},"_hasShrinkwrap":false,"peerDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp_1.1.0_1760984586742_0.8699207294354254","host":"s3://npm-registry-packages-npm-production"}},"1.1.1":{"name":"@davidfei/mysql-mcp","version":"1.1.1","keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","_id":"@davidfei/mysql-mcp@1.1.1","maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"homepage":"https://gitlab.com/davidfei1971/mysql-mcp","bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"bin":{"mysql-mcp":"mysql-mcp-server.py"},"mcp":{"env":{"MYSQL_HOST":"localhost","MYSQL_PORT":"3306","MYSQL_USER":"root","MYSQL_DATABASE":"","MYSQL_PASSWORD":"","MYSQL_ROOT_PASSWORD":""},"args":[],"type":"stdio","command":"mysql-mcp"},"dist":{"shasum":"8c0372524e8acc820b4d00909add1bbf09ec663f","tarball":"https://registry.npmjs.org/@davidfei/mysql-mcp/-/mysql-mcp-1.1.1.tgz","fileCount":5,"integrity":"sha512-r7Xfw1lTv0lTt2QKQxicWHxzNqB1Nv2Wmi/g2PF04vLhvaNljthk2fc2U45HdLSvQBEoX0Qznv7uSWob7+M/Ew==","signatures":[{"sig":"MEMCHzRl5Z3LIegzXdwwXY3iLdWz8+ydq2+7HIEwuFNOgekCIANfFtFdy+Nt61uUtdi4dlfoKB6j4AtQXy/lXIXQkd2z","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":32178},"main":"mysql-mcp-server.py","engines":{"node":">=14.0.0"},"gitHead":"427266bf3040cd4ca75a68fd50d5de3f7c0113f5","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"davidfei","email":"dvdfei@yahoo.ca"},"repository":{"url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","directories":{},"_nodeVersion":"20.19.5","dependencies":{},"_hasShrinkwrap":false,"peerDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp_1.1.1_1760984826057_0.8461678609725027","host":"s3://npm-registry-packages-npm-production"}},"1.2.0":{"name":"@davidfei/mysql-mcp","version":"1.2.0","keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","_id":"@davidfei/mysql-mcp@1.2.0","maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"homepage":"https://gitlab.com/davidfei1971/mysql-mcp","bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"bin":{"mysql-mcp":"mysql-mcp-server.py"},"mcp":{"env":{"MYSQL_HOST":"localhost","MYSQL_PORT":"3306","MYSQL_USER":"root","MYSQL_DATABASE":"","MYSQL_PASSWORD":"","MYSQL_ROOT_PASSWORD":""},"args":[],"type":"stdio","command":"mysql-mcp"},"dist":{"shasum":"292d1956fcd283fd61a6f2b95a94552604323b0c","tarball":"https://registry.npmjs.org/@davidfei/mysql-mcp/-/mysql-mcp-1.2.0.tgz","fileCount":5,"integrity":"sha512-5/qN3Pa+jyEyyoQt2ZXqxFWy7QaKtYtOa3mZV/lRQPjhkkCw5K3JLM+TvExntutaTEfTbMv2DQy6WVFvx6kGTA==","signatures":[{"sig":"MEQCIFmjQMamdwaVgwjNs5ugZxSxJJKBjNY08mxFSw9yTTvtAiA+jVHPtO2uDEqlL4+rSlmer6yqP9Sjc/uTkFmEpVTVcA==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":32795},"main":"mysql-mcp-server.py","engines":{"node":">=14.0.0"},"gitHead":"da2c508aad5269bfac47792517f06f9f10767f60","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"davidfei","email":"dvdfei@yahoo.ca"},"repository":{"url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","directories":{},"_nodeVersion":"20.19.5","dependencies":{},"_hasShrinkwrap":false,"peerDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp_1.2.0_1760990599624_0.6014320479525033","host":"s3://npm-registry-packages-npm-production"}},"1.2.1":{"name":"@davidfei/mysql-mcp","version":"1.2.1","keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","_id":"@davidfei/mysql-mcp@1.2.1","maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"homepage":"https://gitlab.com/davidfei1971/mysql-mcp","bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"bin":{"mysql-mcp":"mysql-mcp-server.py"},"mcp":{"env":{"MYSQL_HOST":"localhost","MYSQL_PORT":"3306","MYSQL_USER":"root","MYSQL_DATABASE":"","MYSQL_PASSWORD":"","MYSQL_ROOT_PASSWORD":""},"args":[],"type":"stdio","command":"mysql-mcp"},"dist":{"shasum":"5b3e1fed77cec565298bd1d1c0ba1f44be701c13","tarball":"https://registry.npmjs.org/@davidfei/mysql-mcp/-/mysql-mcp-1.2.1.tgz","fileCount":5,"integrity":"sha512-FwKaPWvTUZqs7UlfZ5M4wvOdMwHhLLXHb9tCIg7nbfRJVAe68vFhDwnOAvrobB/6ioVJ2Tg1VIns/9HcaOBIrQ==","signatures":[{"sig":"MEQCIBuVhyXuoYsM662uWb1eIPHOpeRR/WSBinJAEQPjiHXSAiA+clXOSpQb+i67KbpFwwQU2uk3t3n3DL1Pz2IICLR3+g==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":32786},"main":"mysql-mcp-server.py","engines":{"node":">=14.0.0"},"gitHead":"a0af01d0f9e80ce226ab1c8ba40f68232cd98662","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"davidfei","email":"dvdfei@yahoo.ca"},"repository":{"url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","directories":{},"_nodeVersion":"20.19.5","dependencies":{},"_hasShrinkwrap":false,"peerDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp_1.2.1_1760990952918_0.7792440642989273","host":"s3://npm-registry-packages-npm-production"}},"1.3.0":{"name":"@davidfei/mysql-mcp","version":"1.3.0","keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","_id":"@davidfei/mysql-mcp@1.3.0","maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"homepage":"https://gitlab.com/davidfei1971/mysql-mcp","bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"bin":{"mysql-mcp":"mysql-mcp-server.py"},"mcp":{"env":{"MYSQL_HOST":"localhost","MYSQL_PORT":"3306","MYSQL_USER":"root","MYSQL_DATABASE":"","MYSQL_PASSWORD":"","MYSQL_ROOT_PASSWORD":""},"args":[],"type":"stdio","command":"mysql-mcp"},"dist":{"shasum":"fde22c60938cc16ad684fe1bad44ce7e24491ef5","tarball":"https://registry.npmjs.org/@davidfei/mysql-mcp/-/mysql-mcp-1.3.0.tgz","fileCount":5,"integrity":"sha512-M+fnJn7wgN9sIkZovVLJmFD3znRKrOGLatjXvI0cJiG/GrqsbWSVwuLk1jiEDX1AOmig9PY4TtzTxHsXko2pdw==","signatures":[{"sig":"MEYCIQC43e2li8un2FlXauUSXz6NpIBxdX11NkcJ47sDRQSmXgIhAIaBaZIF8N+e72IWsbc5nYiByzFf0EZleD+e3BDJTnlx","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":36449},"main":"mysql-mcp-server.py","engines":{"node":">=14.0.0"},"gitHead":"c0bc684ffee24d5e1fb223d004787247121ce602","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"davidfei","email":"dvdfei@yahoo.ca"},"repository":{"url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","directories":{},"_nodeVersion":"20.19.5","dependencies":{},"_hasShrinkwrap":false,"peerDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp_1.3.0_1761001942573_0.40959907469106294","host":"s3://npm-registry-packages-npm-production"}},"1.3.1":{"name":"@davidfei/mysql-mcp","version":"1.3.1","keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","_id":"@davidfei/mysql-mcp@1.3.1","maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"homepage":"https://gitlab.com/davidfei1971/mysql-mcp","bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"bin":{"mysql-mcp":"mysql-mcp-server.py"},"mcp":{"env":{"MYSQL_HOST":"localhost","MYSQL_PORT":"3306","MYSQL_USER":"root","MYSQL_DATABASE":"","MYSQL_PASSWORD":"","MYSQL_ROOT_PASSWORD":""},"args":[],"type":"stdio","command":"mysql-mcp"},"dist":{"shasum":"f107592f045d5581a10ba678ca901f26aa7f66df","tarball":"https://registry.npmjs.org/@davidfei/mysql-mcp/-/mysql-mcp-1.3.1.tgz","fileCount":5,"integrity":"sha512-j/7/UnBIT45Q0PK8p1isdwB6ZiKrC/E64y8B/QYYTtaXQINZaNSUzhkA6s4ZKOdWwzrseOhinmAanTSZ91i4vw==","signatures":[{"sig":"MEUCIQCqVV1BqX0dl2EU6s1ZxyuZka3GLkcQf/HdKs1LgWEc5wIgUt2Ge/Uhbe+075MrU7kyus9YzqbIkrtBH6FD5is6M+s=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":36483},"main":"mysql-mcp-server.py","engines":{"node":">=14.0.0"},"gitHead":"0bcbe770de64f9149e31e285d290ef521ac24eea","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"davidfei","email":"dvdfei@yahoo.ca"},"repository":{"url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","directories":{},"_nodeVersion":"20.19.5","dependencies":{},"_hasShrinkwrap":false,"peerDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp_1.3.1_1761002122196_0.5287009148530435","host":"s3://npm-registry-packages-npm-production"}},"1.3.2":{"name":"@davidfei/mysql-mcp","version":"1.3.2","keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","_id":"@davidfei/mysql-mcp@1.3.2","maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"homepage":"https://gitlab.com/davidfei1971/mysql-mcp","bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"bin":{"mysql-mcp":"mysql-mcp-server.py"},"mcp":{"env":{"MYSQL_HOST":"localhost","MYSQL_PORT":"3306","MYSQL_USER":"root","MYSQL_DATABASE":"","MYSQL_PASSWORD":"","MYSQL_ROOT_PASSWORD":""},"args":[],"type":"stdio","command":"mysql-mcp"},"dist":{"shasum":"77e26603b83b59665bf208c13f57521d91a55e86","tarball":"https://registry.npmjs.org/@davidfei/mysql-mcp/-/mysql-mcp-1.3.2.tgz","fileCount":5,"integrity":"sha512-hqQZ3r2gFuTbUdTKFWWd0cfH8BSRIQvoAJBFotTUMorJmHCPFo2BUXD2WLh/Zksy4Qa6SBeVF/PWYCzP7TUB+w==","signatures":[{"sig":"MEUCIGvAFEr67ytz9qVvMv71DbKRbU6gBKAXiLsDyWhXlk5iAiEAli2XDEe3jmNIrP838ciqbiJHDUB0tcPIDBiiL4RXD0w=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":36525},"main":"mysql-mcp-server.py","engines":{"node":">=14.0.0"},"gitHead":"4bf62b552a939ef383f866f1bc89f8032f2234b8","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"davidfei","email":"dvdfei@yahoo.ca"},"repository":{"url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","directories":{},"_nodeVersion":"20.19.5","dependencies":{},"_hasShrinkwrap":false,"peerDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp_1.3.2_1761002301773_0.6066501095915944","host":"s3://npm-registry-packages-npm-production"}},"1.3.3":{"name":"@davidfei/mysql-mcp","version":"1.3.3","keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","_id":"@davidfei/mysql-mcp@1.3.3","maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"homepage":"https://gitlab.com/davidfei1971/mysql-mcp","bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"bin":{"mysql-mcp":"mysql-mcp-server.py"},"mcp":{"env":{"MYSQL_HOST":"localhost","MYSQL_PORT":"3306","MYSQL_USER":"root","MYSQL_DATABASE":"","MYSQL_PASSWORD":"","MYSQL_ROOT_PASSWORD":""},"args":[],"type":"stdio","command":"mysql-mcp"},"dist":{"shasum":"f703b969403f82015fa285f07fea0bc14e7c2c84","tarball":"https://registry.npmjs.org/@davidfei/mysql-mcp/-/mysql-mcp-1.3.3.tgz","fileCount":5,"integrity":"sha512-Hx4NsgZUabFIvvH/poLTuVT8syvAp+LfeWo7X2At/rIjJ7gW3/C4KiazUuT1F+SN4ryb9771ogviJ54UcNpvqw==","signatures":[{"sig":"MEUCIQCMornnFfnBUj6Ct9YwOj50J5W3/CL3KGk0qXH5qGC1zQIgDcvw54fl4dOpIqeJZUVEZ3qOxjhcBY1xokBW2a0uU0U=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":36833},"main":"mysql-mcp-server.py","engines":{"node":">=14.0.0"},"gitHead":"2cd83c31d7ae928dd8e43ce5dbef9165ab449597","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"davidfei","email":"dvdfei@yahoo.ca"},"repository":{"url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","directories":{},"_nodeVersion":"20.19.5","dependencies":{},"_hasShrinkwrap":false,"peerDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp_1.3.3_1761011100276_0.8180521482962089","host":"s3://npm-registry-packages-npm-production"}},"1.3.4":{"name":"@davidfei/mysql-mcp","version":"1.3.4","keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","_id":"@davidfei/mysql-mcp@1.3.4","maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"homepage":"https://gitlab.com/davidfei1971/mysql-mcp","bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"bin":{"mysql-mcp":"mysql-mcp-server.py"},"mcp":{"env":{"MYSQL_HOST":"localhost","MYSQL_PORT":"3306","MYSQL_USER":"root","MYSQL_DATABASE":"","MYSQL_PASSWORD":"","MYSQL_ROOT_PASSWORD":""},"args":[],"type":"stdio","command":"mysql-mcp"},"dist":{"shasum":"670e7df1ff6afa82c67bf77806e6b47c194f1f1e","tarball":"https://registry.npmjs.org/@davidfei/mysql-mcp/-/mysql-mcp-1.3.4.tgz","fileCount":5,"integrity":"sha512-DRHHDkChqKZqYAoaB7QkXkPg/kxcs80hi4NiPnPP2TEyWi4HgR/PTS2h9jCbCH8rq2izOXfs1aAioC7rNdya1A==","signatures":[{"sig":"MEQCIF8SS7u5gu1/q7gPUsRptjsgJvgmKPSSOITGQET/6P15AiBlUuUHvjT+c/IfhyYguuke8YsQ6AgXGvn/ncPldfEdfA==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":37468},"main":"mysql-mcp-server.py","engines":{"node":">=14.0.0"},"gitHead":"5e4a17ab33e136b387d1156b56b57ff535d4f044","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"davidfei","email":"dvdfei@yahoo.ca"},"repository":{"url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","directories":{},"_nodeVersion":"20.19.5","dependencies":{},"_hasShrinkwrap":false,"peerDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp_1.3.4_1761012537044_0.9416864776986611","host":"s3://npm-registry-packages-npm-production"}},"1.3.5":{"name":"@davidfei/mysql-mcp","version":"1.3.5","keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","_id":"@davidfei/mysql-mcp@1.3.5","maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"homepage":"https://gitlab.com/davidfei1971/mysql-mcp","bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"bin":{"mysql-mcp":"mysql-mcp-server.py"},"mcp":{"env":{"MYSQL_HOST":"localhost","MYSQL_PORT":"3306","MYSQL_USER":"root","MYSQL_DATABASE":"","MYSQL_PASSWORD":"","MYSQL_ROOT_PASSWORD":""},"args":[],"type":"stdio","command":"mysql-mcp"},"dist":{"shasum":"8c84b5da47f5e638061c7ece7df67cdc78b4c0b7","tarball":"https://registry.npmjs.org/@davidfei/mysql-mcp/-/mysql-mcp-1.3.5.tgz","fileCount":5,"integrity":"sha512-LA6iHqjPgxk5PLGpF/TypNEmE38YH1qJo+0L6NNr55ud0egxWpOrcWVaR9Y3wV5uZ7uUVddJpWs0hOQjpuW8vg==","signatures":[{"sig":"MEUCIDruDdBzGiN3g8zvD+5fO429Z/zSFfxnCV714P3UDlGDAiEAu2pi2Vfto3P/DxoEjBcwXAtbdhA7XcW2NeAwkzrQ25A=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":39713},"main":"mysql-mcp-server.py","engines":{"node":">=14.0.0"},"gitHead":"7433feeb831840ca48da191a5a7e22d5827fab73","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"davidfei","email":"dvdfei@yahoo.ca"},"repository":{"url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","directories":{},"_nodeVersion":"20.19.5","dependencies":{},"_hasShrinkwrap":false,"peerDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp_1.3.5_1761068227498_0.10124244387424697","host":"s3://npm-registry-packages-npm-production"}},"1.3.6":{"name":"@davidfei/mysql-mcp","version":"1.3.6","keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","_id":"@davidfei/mysql-mcp@1.3.6","maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"homepage":"https://gitlab.com/davidfei1971/mysql-mcp","bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"bin":{"mysql-mcp":"mysql-mcp-server.py"},"mcp":{"env":{"MYSQL_HOST":"localhost","MYSQL_PORT":"3306","MYSQL_USER":"root","MYSQL_DATABASE":"","MYSQL_PASSWORD":"","MYSQL_ROOT_PASSWORD":""},"args":[],"type":"stdio","command":"mysql-mcp"},"dist":{"shasum":"5fd7f165f5657d64c20be6ec77a9d72de4ef4257","tarball":"https://registry.npmjs.org/@davidfei/mysql-mcp/-/mysql-mcp-1.3.6.tgz","fileCount":5,"integrity":"sha512-CrB9Dnwe31zDA1FESaHBgBZL1iCQY8TGl5foPtu0hYJfyeT3iJj80sM4twMH7ZpJhXdkHpOrwJyn7KWe9LXhGw==","signatures":[{"sig":"MEUCIQCiKfXfYSXebfy34seJ7oAxCTLPgX85xwdcAiOmo3P5sQIgak55qZN7LPBt2YaoUcVfyIoZNIDOORc2qpvfa/WaP04=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":39654},"main":"mysql-mcp-server.py","engines":{"node":">=14.0.0"},"gitHead":"36c043aff398165cdbf48c37b20274e4fc0adfe8","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"davidfei","email":"dvdfei@yahoo.ca"},"repository":{"url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","directories":{},"_nodeVersion":"20.19.5","dependencies":{},"_hasShrinkwrap":false,"peerDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp_1.3.6_1761437836089_0.6393900694336663","host":"s3://npm-registry-packages-npm-production"}},"1.3.7":{"name":"@davidfei/mysql-mcp","version":"1.3.7","description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","main":"mysql-mcp-server.py","bin":{"mysql-mcp":"mysql-mcp-server.py"},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","repository":{"type":"git","url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git"},"homepage":"https://gitlab.com/davidfei1971/mysql-mcp","bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"engines":{"node":">=14.0.0"},"dependencies":{},"peerDependencies":{},"mcp":{"type":"stdio","command":"mysql-mcp","args":[],"env":{"MYSQL_HOST":"localhost","MYSQL_PORT":"3306","MYSQL_USER":"root","MYSQL_PASSWORD":"","MYSQL_ROOT_PASSWORD":"","MYSQL_DATABASE":""}},"_id":"@davidfei/mysql-mcp@1.3.7","gitHead":"cf1eff8902ec337eec6b6a47972655d36bab367e","_nodeVersion":"20.19.5","_npmVersion":"10.8.2","dist":{"integrity":"sha512-9B/XIHhEWBMbHUbfaMd010KId/ZL5CvMBo/z4wqV/UdESlnLcoVqXhaL/SmjF6wfFK1GQtfN6wa+TuqOoOM5/g==","shasum":"3e9b3ef68b68bef64575e164535d4bd80ee3481a","tarball":"https://registry.npmjs.org/@davidfei/mysql-mcp/-/mysql-mcp-1.3.7.tgz","fileCount":5,"unpackedSize":36589,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEYCIQCEOzpRU5niTGS7LcrUSDGn4swBTx01r0+vhW5cMBEM7AIhAIeN7A2H2cWuHAFzE4HApqaKoQMFSrKG9dwgeIShUKY6"}]},"_npmUser":{"name":"davidfei","email":"dvdfei@yahoo.ca"},"directories":{},"maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mysql-mcp_1.3.7_1761439338091_0.051791992032839795"},"_hasShrinkwrap":false}},"time":{"created":"2025-10-20T17:43:40.417Z","modified":"2025-10-26T00:42:18.497Z","1.0.0":"2025-10-20T17:43:40.718Z","1.1.0":"2025-10-20T18:23:06.919Z","1.1.1":"2025-10-20T18:27:06.254Z","1.2.0":"2025-10-20T20:03:19.813Z","1.2.1":"2025-10-20T20:09:13.113Z","1.3.0":"2025-10-20T23:12:22.764Z","1.3.1":"2025-10-20T23:15:22.380Z","1.3.2":"2025-10-20T23:18:21.948Z","1.3.3":"2025-10-21T01:45:00.452Z","1.3.4":"2025-10-21T02:08:57.226Z","1.3.5":"2025-10-21T17:37:07.701Z","1.3.6":"2025-10-26T00:17:16.353Z","1.3.7":"2025-10-26T00:42:18.286Z"},"bugs":{"url":"https://gitlab.com/davidfei1971/mysql-mcp/-/issues"},"author":{"name":"david fei","email":"davidfei1971@gmail.com"},"license":"MIT","homepage":"https://gitlab.com/davidfei1971/mysql-mcp","keywords":["mcp","model-context-protocol","mysql","database","sql","ai","claude","anthropic"],"repository":{"type":"git","url":"git+https://gitlab.com/davidfei1971/mysql-mcp.git"},"description":"Model Context Protocol (MCP) server for MySQL database operations with secure credential handling","maintainers":[{"name":"davidfei","email":"dvdfei@yahoo.ca"}],"readme":"# MySQL MCP Server\n\nA Model Context Protocol (MCP) server that enables Claude Code to interact with MySQL databases securely. This server provides tools for database management, querying, and data manipulation while keeping your credentials secure.\n\n## Features\n\n- 🔒 Secure credential handling - passwords never exposed to the LLM\n- 🗄️ Database management (create, drop, list databases)\n- 📊 Table operations (list, describe tables)\n- 🔍 Execute SELECT queries with formatted results\n- ✏️ Execute INSERT, UPDATE, DELETE operations\n- 🌐 Support for remote MySQL servers\n- ℹ️ Server information and connection testing\n\n## Installation\n\n### Prerequisites\n\n- Python 3.7 or higher\n- MySQL server (local or remote)\n- `mysql-connector-python` package (install via `sudo apt-get install python3-mysql.connector`)\n\n### Install via AI Coding Assistant CLI\n\n**Important**: Before using this MCP server, ensure Python dependencies are installed.\n\n#### Installing Python Dependencies\n\n**Option 1: System Package Manager (Recommended)**\n\n```bash\nsudo apt-get install python3-mysql.connector\n```\n\n**Option 2: Using Virtual Environment**\n\nIf you prefer using a virtual environment or encounter issues with system packages:\n\n```bash\n# Create and activate virtual environment\npython3 -m venv ~/mysql-mcp-venv\nsource ~/mysql-mcp-venv/bin/activate  # On macOS/Linux\n# Or on Windows: ~/mysql-mcp-venv\\Scripts\\activate\n\n# Install dependencies\npip install mysql-connector-python\ndeactivate\n```\n\nThen install the MCP server using the virtual environment Python (see configuration examples below).\n\n#### Claude Code\n\n```bash\nclaude mcp add --scope user mysql-mcp npx @davidfei/mysql-mcp\n```\n\nYou'll be prompted to enter your MySQL connection details during setup.\n\nAlternatively, you can provide the configuration directly:\n\n```bash\nclaude mcp add --scope user mysql-mcp --env MYSQL_HOST=localhost --env MYSQL_PORT=3306 --env MYSQL_USER=myuser --env MYSQL_PASSWORD=user-password --env MYSQL_ROOT_PASSWORD=root-password --env MYSQL_DATABASE=mydb -- npx @davidfei/mysql-mcp\n```\n\n#### Codex\n\n**Note:** This MCP server requires Codex version 0.40.0 (not the latest version).\n\n```bash\ncodex mcp add mysql-mcp --env MYSQL_HOST=localhost --env MYSQL_PORT=3306 --env MYSQL_USER=myuser --env MYSQL_PASSWORD=user-password --env MYSQL_ROOT_PASSWORD=root-password --env MYSQL_DATABASE=mydb -- npx @davidfei/mysql-mcp\n```\n\n#### Gemini CLI\n\n```bash\ngemini mcp add mysql-mcp npx @davidfei/mysql-mcp -t stdio -s user -e MYSQL_HOST=localhost -e MYSQL_PORT=3306 -e MYSQL_USER=myuser -e MYSQL_PASSWORD=user-password -e MYSQL_ROOT_PASSWORD=root-password -e MYSQL_DATABASE=mydb\n```\n\nThis MCP server works with any MCP-compatible client.\n\n**Important**: Before configuring any MCP client, ensure Python dependencies are installed.\n\n#### Installing Python Dependencies\n\n```bash\n# Option 1: System package manager (recommended)\nsudo apt-get install python3-mysql.connector\n\n# Option 2: Virtual environment (if needed)\npython3 -m venv ~/mysql-mcp-venv\nsource ~/mysql-mcp-venv/bin/activate\npip install mysql-connector-python\ndeactivate\n```\n\nWhen using a virtual environment, update the `command` in your MCP configuration to use the venv Python path (e.g., `/home/user/mysql-mcp-venv/bin/python` instead of `python3`).\n\nHere are configuration examples for popular clients:\n\n\n\n**Note**: Replace the environment variable values with your actual MySQL connection details. For better security, consider using environment variables instead of hardcoding credentials.\n\n### Manual Installation\n\n1. Clone or download this repository\n\n2. Install the Python dependencies:\n\n```bash\n# Option 1: System package manager (recommended)\nsudo apt-get install python3-mysql.connector\n\n# Option 2: Virtual environment\ncd mysql-mcp\npython3 -m venv venv\nsource venv/bin/activate\npip install mysql-connector-python\ndeactivate\n```\n\n3. Make the server executable:\n\n```bash\nchmod +x mysql-mcp-server.py\n```\n\n4. Configure your MySQL connection via environment variables (see Configuration section)\n\n5. If using virtual environment, use `venv/bin/python` as the command in your MCP configuration\n\n## Configuration\n\nThe server uses environment variables for MySQL connection configuration:\n\n- `MYSQL_HOST` - MySQL server hostname (default: `localhost`)\n- `MYSQL_PORT` - MySQL server port (default: `3306`)\n- `MYSQL_USER` - MySQL username for normal operations (default: `root`)\n- `MYSQL_PASSWORD` - Password for the normal MySQL user\n- `MYSQL_ROOT_PASSWORD` - MySQL root password (used for administrative operations like creating/dropping databases)\n- `MYSQL_DATABASE` - Default database(s) to use (optional). Can be a single database name or a comma-separated list (e.g., `mydb` or `db1,db2,db3`). When multiple databases are specified, the first one is used as the default.\n- `MYSQL_SSL` - Enable SSL/TLS for MySQL connection (optional). Set to `true`, `1`, `yes`, or `enabled` to enable SSL. Defaults to disabled for compatibility. Use this when connecting to MySQL servers that require SSL connections.\n\nThe server automatically uses root credentials for administrative operations (create/drop database) and normal user credentials for regular operations (queries, updates). If the normal user lacks permissions for a query or update operation, the server will automatically retry with root credentials.\n\n## Available Tools\n\nOnce installed, Claude Code will have access to these MySQL tools:\n\n### 1. `test_connection`\n\nTest the MySQL connection and get server information.\n\n**Example:** \"Test the MySQL connection\"\n\n### 2. `get_server_info`\n\nGet MySQL server information including version, host, port, and current user.\n\n**Example:** \"Show me the MySQL server information\"\n\n### 3. `list_databases`\n\nList all databases on the MySQL server.\n\n**Example:** \"List all databases\"\n\n### 4. `create_database`\n\nCreate a new database.\n\n**Parameters:**\n- `database_name` (required): Name of the database to create\n\n**Example:** \"Create a database called 'myapp'\"\n\n### 5. `drop_database`\n\nDrop (delete) a database.\n\n**Parameters:**\n- `database_name` (required): Name of the database to drop\n\n**Example:** \"Drop the database 'old_data'\"\n\n**Warning:** This operation is irreversible!\n\n### 6. `list_tables`\n\nList all tables in a database.\n\n**Parameters:**\n- `database_name` (optional): Name of the database (uses MYSQL_DATABASE env var if not specified)\n\n**Example:** \"List all tables in the 'myapp' database\"\n\n### 7. `describe_table`\n\nDescribe the structure of a table (columns, types, keys, etc.).\n\n**Parameters:**\n- `table_name` (required): Name of the table to describe\n- `database_name` (optional): Name of the database (uses MYSQL_DATABASE env var if not specified)\n\n**Example:** \"Describe the 'users' table\"\n\n### 8. `execute_query`\n\nExecute a SELECT query and return results.\n\n**Parameters:**\n- `query` (required): The SELECT query to execute\n- `database_name` (optional): Name of the database (uses MYSQL_DATABASE env var if not specified)\n\n**Examples:**\n- \"Select all users from the users table\"\n- \"Query the products table for items with price > 100\"\n\n**Note:** Only SELECT queries are allowed. Use `execute_update` for other operations.\n\n### 9. `execute_update`\n\nExecute an INSERT, UPDATE, DELETE, or other non-SELECT query.\n\n**Parameters:**\n- `query` (required): The query to execute\n- `database_name` (optional): Name of the database (uses MYSQL_DATABASE env var if not specified)\n\n**Examples:**\n- \"Insert a new user into the users table\"\n- \"Update the price of product with id 5\"\n- \"Delete all orders older than 2020\"\n- \"Create a new table called 'logs'\"\n\n**Note:** Returns the number of affected rows.\n\n## Common Use Cases\n\n### Database Exploration\n\n```\nYou: \"List all databases and show me the tables in the 'myapp' database\"\nClaude: [Uses list_databases, then list_tables with database_name='myapp']\n\nYou: \"Describe the structure of the 'users' table\"\nClaude: [Uses describe_table with table_name='users']\n```\n\n### Data Querying\n\n```\nYou: \"Show me all users registered in the last 30 days\"\nClaude: [Uses execute_query with appropriate SELECT statement]\n\nYou: \"Find all products with low stock (less than 10 items)\"\nClaude: [Uses execute_query to find products where quantity < 10]\n```\n\n### Data Manipulation\n\n```\nYou: \"Add a new user with email 'john@example.com'\"\nClaude: [Uses execute_update with INSERT statement]\n\nYou: \"Update the status of order #12345 to 'shipped'\"\nClaude: [Uses execute_update with UPDATE statement]\n```\n\n### Database Management\n\n```\nYou: \"Create a new database for my project called 'analytics'\"\nClaude: [Uses create_database with database_name='analytics']\n\nYou: \"Create a users table with id, name, email, and created_at columns\"\nClaude: [Uses execute_update with CREATE TABLE statement]\n```\n\n## Security\n\nThis tool handles database credentials securely:\n\n- 🔒 **Password Protection**: MySQL passwords are never exposed to the LLM or logged\n- 🛡️ **Environment Variables**: Credentials stored in environment variables, not in code\n- 🔍 **Query Separation**: SELECT and modification queries are separated for safety\n- ⚠️ **SQL Injection**: Always review queries before execution\n\n**Important**: Always review what queries Claude suggests before allowing execution.\n\n## Connecting to Remote MySQL Servers\n\nThis MCP server supports connecting to remote MySQL servers. Simply configure the environment variables with your remote server details:\n\n```bash\nexport MYSQL_HOST=mysql.example.com\nexport MYSQL_PORT=3306\nexport MYSQL_USER=myuser\nexport MYSQL_PASSWORD=user-password\nexport MYSQL_ROOT_PASSWORD=root-password\nexport MYSQL_DATABASE=mydb\nexport MYSQL_SSL=true  # Enable if your server requires SSL\n```\n\nMake sure your MySQL server allows remote connections and your firewall rules permit access.\n\n## Troubleshooting\n\n### Connection Issues\n\n**\"Failed to connect to MySQL\"**: Verify your connection details (host, port, username, password) are correct.\n\n**\"Access denied for user\"**: Check that your MySQL user has the necessary privileges.\n\n**\"Can't connect to MySQL server\"**: Ensure MySQL server is running and accessible from your machine.\n\n### Permission Issues\n\nIf you get permission errors, ensure your MySQL user has appropriate privileges:\n\n```sql\nGRANT ALL PRIVILEGES ON *.* TO 'your_user'@'%' WITH GRANT OPTION;\nFLUSH PRIVILEGES;\n```\n\n### Python Dependencies\n\nIf you get import errors:\n\n```bash\n# Option 1: System package manager (recommended)\nsudo apt-get install python3-mysql.connector\n\n# Option 2: Use virtual environment\npython3 -m venv ~/mysql-mcp-venv\nsource ~/mysql-mcp-venv/bin/activate\npip install mysql-connector-python\ndeactivate\n\n# Then update your MCP config to use ~/mysql-mcp-venv/bin/python\n```\n\n## Limitations\n\n- **SQL Injection**: While basic safety checks are in place, always review queries\n- **Large Result Sets**: Very large query results may be truncated\n- **Transaction Support**: Currently no explicit transaction management\n- **Stored Procedures**: Limited support for stored procedures and functions\n\n## Development\n\n### Project Structure\n\n```\nmysql-mcp/\n├── mysql-mcp-server.py   # Main MCP server implementation\n├── package.json          # NPM package configuration\n├── requirements.txt      # Python dependencies\n└── README.md            # This file\n```\n\n### Testing Locally\n\n1. Set up environment variables:\n\n```bash\nexport MYSQL_HOST=localhost\nexport MYSQL_PORT=3306\nexport MYSQL_USER=myuser\nexport MYSQL_PASSWORD=user-password\nexport MYSQL_ROOT_PASSWORD=root-password\n```\n\n2. Run the server:\n\n```bash\npython3 mysql-mcp-server.py\n```\n\n3. Test with MCP protocol messages via stdin\n\n## License\n\nMIT\n\n## Support\n\nReport issues at: [GitLab Issues](https://gitlab.com/davidfei1971/mysql-mcp/-/issues)\n\n## Author\n\nDavid Fei <davidfei1971@gmail.com>\n\n## Disclaimer\n\nThis tool provides direct access to MySQL databases. Always review queries before execution and ensure you have proper backups. The authors are not responsible for any data loss or damage caused by misuse of this tool.\n","readmeFilename":"README.md"}