{"_id":"@liangshanli/mcp-server-mysql","_rev":"14-faf74f6f9c488268b1649cd54e22e3e8","name":"@liangshanli/mcp-server-mysql","dist-tags":{"latest":"3.2.0"},"versions":{"1.0.0":{"name":"@liangshanli/mcp-server-mysql","version":"1.0.0","keywords":["mcp","mysql","server","ddl","database"],"author":{"name":"liliangshan"},"license":"MIT","_id":"@liangshanli/mcp-server-mysql@1.0.0","maintainers":[{"name":"liangshanli1983","email":"kefu@03s.cn"}],"homepage":"https://github.com/liliangshan/mcp-server-mysql#readme","bugs":{"url":"https://github.com/liliangshan/mcp-server-mysql/issues"},"bin":{"mcp-server-mysql":"bin/cli.js"},"dist":{"shasum":"789b0894e67cac50f655e4e04c1adec1ea7e5bb9","tarball":"https://registry.npmjs.org/@liangshanli/mcp-server-mysql/-/mcp-server-mysql-1.0.0.tgz","fileCount":8,"integrity":"sha512-/rViljxyvdmHYxTw8nosB0LZvooI4tjqHbhksLMPOJRbQAapUG9k/OJ74k2b/9AIsm7XdndZOr2z2udrouAJug==","signatures":[{"sig":"MEUCIHF62hFDiMlnWLNERYVi8VrZmwk4AUA/jX6AqsNjQ3n9AiEApAh+Uq5VAdhDSaNhV2pNdLG1jsH86KQwudNmrfhawFY=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":39106},"main":"src/server-final.js","scripts":{"dev":"node --inspect src/server-final.js","test":"node test-simple.js","start":"node src/server-final.js","daemon":"node start-server.js","start-managed":"node start-server.js"},"_npmUser":{"name":"liangshanli1983","email":"kefu@03s.cn"},"deprecated":"This version is deprecated. Please use version 1.0.6 or later for the latest features and improvements.","repository":{"url":"git+https://github.com/liliangshan/mcp-server-mysql.git","type":"git"},"_npmVersion":"11.4.0","description":"MCP MySQL server with DDL support, permission control and operation logs","directories":{},"_nodeVersion":"22.12.0","dependencies":{"mysql2":"^3.9.7"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^20.0.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-server-mysql_1.0.0_1753716134953_0.9958735420932356","host":"s3://npm-registry-packages-npm-production"}},"1.0.1":{"name":"@liangshanli/mcp-server-mysql","version":"1.0.1","keywords":["mcp","mysql","server","ddl","database"],"author":{"name":"liliangshan"},"license":"MIT","_id":"@liangshanli/mcp-server-mysql@1.0.1","maintainers":[{"name":"liangshanli1983","email":"kefu@03s.cn"}],"homepage":"https://github.com/liliangshan/mcp-server-mysql#readme","bugs":{"url":"https://github.com/liliangshan/mcp-server-mysql/issues"},"bin":{"mcp-server-mysql":"bin/cli.js"},"dist":{"shasum":"8a1fc04e9c6c283c95c7f053c9e379573e205437","tarball":"https://registry.npmjs.org/@liangshanli/mcp-server-mysql/-/mcp-server-mysql-1.0.1.tgz","fileCount":8,"integrity":"sha512-EsuCT8tzqQfEP1dyWeKchoGFWuqJvUajZ2PTBRCJsfnKR3pQn+65qh4Ph7eGHenE2BvFFk7TPoCe+IIArZT8ZQ==","signatures":[{"sig":"MEQCIHmgoccniydcJtXVp6gtxpnSGddycSkFo891luTqK9FdAiAtePe03WvqMSyn1XC0yIb4qF21AdyePZ2907T+u3e36w==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":39106},"main":"src/server-final.js","scripts":{"dev":"node --inspect src/server-final.js","test":"node test-simple.js","start":"node src/server-final.js","daemon":"node start-server.js","start-managed":"node start-server.js"},"_npmUser":{"name":"liangshanli1983","email":"kefu@03s.cn"},"deprecated":"This version is deprecated. Please use version 1.0.6 or later for the latest features and improvements.","repository":{"url":"git+https://github.com/liliangshan/mcp-server-mysql.git","type":"git"},"_npmVersion":"11.4.0","description":"MCP MySQL server with DDL support, permission control and operation logs","directories":{},"_nodeVersion":"22.12.0","dependencies":{"mysql2":"^3.9.7"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^20.0.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-server-mysql_1.0.1_1753716192779_0.25657248081117046","host":"s3://npm-registry-packages-npm-production"}},"1.0.3":{"name":"@liangshanli/mcp-server-mysql","version":"1.0.3","keywords":["mcp","mysql","server","ddl","database"],"author":{"name":"liliangshan"},"license":"MIT","_id":"@liangshanli/mcp-server-mysql@1.0.3","maintainers":[{"name":"liangshanli1983","email":"kefu@03s.cn"}],"homepage":"https://github.com/liliangshan/mcp-server-mysql#readme","bugs":{"url":"https://github.com/liliangshan/mcp-server-mysql/issues"},"bin":{"mcp-server-mysql":"bin/cli.js"},"dist":{"shasum":"be559bcda7ec2387c9dcb1602c7f7c32d0a812bf","tarball":"https://registry.npmjs.org/@liangshanli/mcp-server-mysql/-/mcp-server-mysql-1.0.3.tgz","fileCount":8,"integrity":"sha512-aUNTFy4eD/gz2TVQwwVMb89ltaa+ZWzuSOfr8QrJQ29ggC8nkz4Gs5Jc6sN6ZaSOs2twsrwZs4LS0fvQsUQdnw==","signatures":[{"sig":"MEYCIQC6J9vxV9FGx7rCI/3bWaYuJSwaT0mbL6tTHLDANrcrqwIhANoLXTyZ76Xeay2BB/SsqRGU0L/nq3H6Mlp6enxWmlLz","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":41232},"main":"src/server-final.js","scripts":{"dev":"node --inspect src/server-final.js","test":"node test-simple.js","start":"node src/server-final.js","daemon":"node start-server.js","start-managed":"node start-server.js"},"_npmUser":{"name":"liangshanli1983","email":"kefu@03s.cn"},"deprecated":"This version is deprecated. Please use version 1.0.6 or later for the latest features and improvements.","repository":{"url":"git+https://github.com/liliangshan/mcp-server-mysql.git","type":"git"},"_npmVersion":"11.4.0","description":"MCP MySQL server with DDL support, permission control and operation logs","directories":{},"_nodeVersion":"22.12.0","dependencies":{"mysql2":"^3.9.7"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^20.0.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-server-mysql_1.0.3_1753716684946_0.8968349068027304","host":"s3://npm-registry-packages-npm-production"}},"1.0.5":{"name":"@liangshanli/mcp-server-mysql","version":"1.0.5","keywords":["mcp","mysql","server","ddl","database"],"author":{"name":"liliangshan"},"license":"MIT","_id":"@liangshanli/mcp-server-mysql@1.0.5","maintainers":[{"name":"liangshanli1983","email":"kefu@03s.cn"}],"homepage":"https://github.com/liliangshan/mcp-server-mysql#readme","bugs":{"url":"https://github.com/liliangshan/mcp-server-mysql/issues"},"bin":{"mcp-server-mysql":"bin/cli.js"},"dist":{"shasum":"53a6fe68060e07204c97366b4570619bacba7308","tarball":"https://registry.npmjs.org/@liangshanli/mcp-server-mysql/-/mcp-server-mysql-1.0.5.tgz","fileCount":9,"integrity":"sha512-MNMf5AmDrMGsbPJzVZulJExmafMAFteZsMyPZ62FWjK7h76IHfoaYYGihCndOLPCcHnXBXatc1NiVy6SlejlVA==","signatures":[{"sig":"MEUCIQD4OrP8J9eSkgsPmBUIPkfMmMd/2q9wiJn5LKs5VfqScQIgZaZPNYuw+rgvC/CbdkbJmHFziqfXIPBA2H86/7dUzLU=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":46550},"main":"src/server-final.js","scripts":{"dev":"node --inspect src/server-final.js","test":"node test-simple.js","start":"node src/server-final.js","daemon":"node start-server.js","start-managed":"node start-server.js"},"_npmUser":{"name":"liangshanli1983","email":"kefu@03s.cn"},"deprecated":"This version is deprecated. Please use version 1.0.6 or later for the latest features and improvements.","repository":{"url":"git+https://github.com/liliangshan/mcp-server-mysql.git","type":"git"},"_npmVersion":"11.4.0","description":"MCP MySQL server with DDL support, permission control and operation logs","directories":{},"_nodeVersion":"22.12.0","dependencies":{"mysql2":"^3.9.7"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^20.0.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-server-mysql_1.0.5_1753717125945_0.18643784991168344","host":"s3://npm-registry-packages-npm-production"}},"1.0.6":{"name":"@liangshanli/mcp-server-mysql","version":"1.0.6","keywords":["mcp","mysql","server","ddl","database"],"author":{"name":"liliangshan"},"license":"MIT","_id":"@liangshanli/mcp-server-mysql@1.0.6","maintainers":[{"name":"liangshanli1983","email":"kefu@03s.cn"}],"homepage":"https://github.com/liliangshan/mcp-server-mysql#readme","bugs":{"url":"https://github.com/liliangshan/mcp-server-mysql/issues"},"bin":{"mcp-server-mysql":"bin/cli.js"},"dist":{"shasum":"b0eaf52bcb3d0d5ba53337f690b47ac6a727defd","tarball":"https://registry.npmjs.org/@liangshanli/mcp-server-mysql/-/mcp-server-mysql-1.0.6.tgz","fileCount":8,"integrity":"sha512-t/L+FsVQOhKrW0RPEoQjRNljpNB7pWlnTVMp86LP3RhWoIB/B0/Dt20cPfQUNhttzQ22IdH2tC55j38+XPQEOQ==","signatures":[{"sig":"MEQCIEk1uih2QQSB/QPAv2vZ16DviL6TnI2SpEC4SFet/jILAiBXpCZgBhwO9onVN5QDao5ybOveP8mPqGTSidv7svj+Xg==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":51931},"main":"src/server-final.js","scripts":{"dev":"node --inspect src/server-final.js","test":"node test-simple.js","start":"node src/server-final.js","daemon":"node start-server.js","start-managed":"node start-server.js"},"_npmUser":{"name":"liangshanli1983","email":"kefu@03s.cn"},"repository":{"url":"git+https://github.com/liliangshan/mcp-server-mysql.git","type":"git"},"_npmVersion":"11.4.0","description":"MCP MySQL server with DDL support, permission control and operation logs","directories":{},"_nodeVersion":"22.12.0","dependencies":{"mysql2":"^3.9.7"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^20.0.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-server-mysql_1.0.6_1753717459272_0.33049532936689796","host":"s3://npm-registry-packages-npm-production"}},"1.0.7":{"name":"@liangshanli/mcp-server-mysql","version":"1.0.7","keywords":["mcp","mysql","server","ddl","database"],"author":{"name":"liliangshan"},"license":"MIT","_id":"@liangshanli/mcp-server-mysql@1.0.7","maintainers":[{"name":"liangshanli1983","email":"kefu@03s.cn"}],"homepage":"https://github.com/liliangshan/mcp-server-mysql#readme","bugs":{"url":"https://github.com/liliangshan/mcp-server-mysql/issues"},"bin":{"mcp-server-mysql":"bin/cli.js"},"dist":{"shasum":"cd84110365e5e01c3e63060c6fc96489b2974534","tarball":"https://registry.npmjs.org/@liangshanli/mcp-server-mysql/-/mcp-server-mysql-1.0.7.tgz","fileCount":8,"integrity":"sha512-EL8lWFhpzDyml17xE8fBO0DRWdVYIwplBvG1z4F7wUChUfap0tIx2je4HkEyUGj7XOC5kSMbKnuVzwidkCR9Yw==","signatures":[{"sig":"MEUCIFBt1Pcw/bZaKoenUB0yExuYQ4CUnB+lZP9MjtxV89AXAiEAplLbO68qGz+ys/BXhWyJC/f9Osh5AFJKgxrYgsK7BfE=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":52896},"main":"src/server-final.js","scripts":{"dev":"node --inspect src/server-final.js","test":"node test-simple.js","start":"node src/server-final.js","daemon":"node start-server.js","start-managed":"node start-server.js"},"_npmUser":{"name":"liangshanli1983","email":"kefu@03s.cn"},"repository":{"url":"git+https://github.com/liliangshan/mcp-server-mysql.git","type":"git"},"_npmVersion":"11.4.0","description":"MCP MySQL server with DDL support, permission control and operation logs","directories":{},"_nodeVersion":"22.12.0","dependencies":{"mysql2":"^3.9.7"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^20.0.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-server-mysql_1.0.7_1753719010787_0.25402153242368053","host":"s3://npm-registry-packages-npm-production"}},"1.0.8":{"name":"@liangshanli/mcp-server-mysql","version":"1.0.8","keywords":["mcp","mysql","server","ddl","database"],"author":{"name":"liliangshan"},"license":"MIT","_id":"@liangshanli/mcp-server-mysql@1.0.8","maintainers":[{"name":"liangshanli1983","email":"kefu@03s.cn"}],"homepage":"https://github.com/liliangshan/mcp-server-mysql#readme","bugs":{"url":"https://github.com/liliangshan/mcp-server-mysql/issues"},"bin":{"mcp-server-mysql":"bin/cli.js"},"dist":{"shasum":"3b887760ddc3aea0af4a1d5c1c168a804e160188","tarball":"https://registry.npmjs.org/@liangshanli/mcp-server-mysql/-/mcp-server-mysql-1.0.8.tgz","fileCount":8,"integrity":"sha512-o97vexDOO+Ae5i4NVB++hja+PmkhtY7Rty+HRwsIxsnKHuxth5PExBHxk6ejQHa7dhE8eYKVyGdEWTvmJ2I1Gg==","signatures":[{"sig":"MEQCIBrTFpX/KqjRNIqpnG+l7YckirUd2TvZGQC/2Z+Hrs0CAiB04CRXeB5CjcQIdEzIvV+vrRUgZJN8sIScsGDLwaLapQ==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":53252},"main":"src/server-final.js","scripts":{"dev":"node --inspect src/server-final.js","test":"node test-simple.js","start":"node src/server-final.js","daemon":"node start-server.js","start-managed":"node start-server.js"},"_npmUser":{"name":"liangshanli1983","email":"kefu@03s.cn"},"repository":{"url":"git+https://github.com/liliangshan/mcp-server-mysql.git","type":"git"},"_npmVersion":"11.4.0","description":"MCP MySQL server with DDL support, permission control and operation logs","directories":{},"_nodeVersion":"22.12.0","dependencies":{"mysql2":"^3.9.7"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^20.0.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-server-mysql_1.0.8_1753719400845_0.9600066222458947","host":"s3://npm-registry-packages-npm-production"}},"2.0.0":{"name":"@liangshanli/mcp-server-mysql","version":"2.0.0","keywords":["mcp","mysql","server","ddl","database"],"author":{"name":"liliangshan"},"license":"MIT","_id":"@liangshanli/mcp-server-mysql@2.0.0","maintainers":[{"name":"liangshanli1983","email":"kefu@03s.cn"}],"homepage":"https://github.com/liliangshan/mcp-server-mysql#readme","bugs":{"url":"https://github.com/liliangshan/mcp-server-mysql/issues"},"bin":{"mcp-server-mysql":"bin/cli.js"},"dist":{"shasum":"e376a4c1c40f6e61b5b04e8030281326a695fc12","tarball":"https://registry.npmjs.org/@liangshanli/mcp-server-mysql/-/mcp-server-mysql-2.0.0.tgz","fileCount":6,"integrity":"sha512-vJlyAWFKg52LcEiTFTF+IDNTtnbvX9YQ6pdtNYpv+34K8g3t5kI0/nUHAuMJB/jKdTBcsCNmN6uEYQOWPbRhSQ==","signatures":[{"sig":"MEQCICDf9imvheIiNp+JJ0E6jbpxj+lSAHq4BpATSBfAm29oAiAA2IeFlxRpUkUSoIGNUdQtmpooJEq2w54tkSc5f28Qbg==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":49033},"main":"bin/cli.js","scripts":{"dev":"node --inspect bin/cli.js","test":"node test-simple.js","start":"node bin/cli.js","daemon":"node start-server.js","server":"node src/server-final.js","start-managed":"node start-server.js"},"_npmUser":{"name":"liangshanli1983","email":"kefu@03s.cn"},"repository":{"url":"git+https://github.com/liliangshan/mcp-server-mysql.git","type":"git"},"_npmVersion":"11.4.0","description":"MCP MySQL server with DDL support, permission control and operation logs","directories":{},"_nodeVersion":"22.12.0","dependencies":{"mysql2":"^3.9.7"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^20.0.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-server-mysql_2.0.0_1753733834335_0.9761813986208736","host":"s3://npm-registry-packages-npm-production"}},"2.0.1":{"name":"@liangshanli/mcp-server-mysql","version":"2.0.1","keywords":["mcp","mysql","server","ddl","database"],"author":{"name":"liliangshan"},"license":"MIT","_id":"@liangshanli/mcp-server-mysql@2.0.1","maintainers":[{"name":"liangshanli1983","email":"kefu@03s.cn"}],"homepage":"https://github.com/liliangshan/mcp-server-mysql#readme","bugs":{"url":"https://github.com/liliangshan/mcp-server-mysql/issues"},"bin":{"mcp-server-mysql":"bin/cli.js"},"dist":{"shasum":"2ba79e53f3c888f1c592af94eb9490f1a3b12f53","tarball":"https://registry.npmjs.org/@liangshanli/mcp-server-mysql/-/mcp-server-mysql-2.0.1.tgz","fileCount":6,"integrity":"sha512-v3JGJdswkS9l1BlSB5WdPyPrQUtnxvKFa0Er3edyfISyvXnqsuBZ9Cba04HmEnsqExde7PS4TdWA6fnqBjBSdw==","signatures":[{"sig":"MEUCIQDHaYbnenVGyS6J8lICyPi/0tohlQ38qRcvWSVRXe/DhwIgfKn1F6C6xdidKV/P1HUcnwg2nhgJ1Qxx0lCwN+Yx+4I=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":59026},"main":"bin/cli.js","gitHead":"e57c07240152817d711b97d4bb7e6b7e20db6e89","scripts":{"dev":"node --inspect bin/cli.js","test":"node test-simple.js","start":"node bin/cli.js","daemon":"node start-server.js","server":"node src/server-final.js","start-managed":"node start-server.js"},"_npmUser":{"name":"liangshanli1983","email":"kefu@03s.cn"},"repository":{"url":"git+https://github.com/liliangshan/mcp-server-mysql.git","type":"git"},"_npmVersion":"11.4.0","description":"MCP MySQL server with DDL support, permission control and operation logs","directories":{},"_nodeVersion":"22.12.0","dependencies":{"mysql2":"^3.9.7"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^20.0.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-server-mysql_2.0.1_1757344757196_0.9115186299220055","host":"s3://npm-registry-packages-npm-production"}},"3.0.0":{"name":"@liangshanli/mcp-server-mysql","version":"3.0.0","keywords":["mcp","mysql","server","ddl","database"],"author":{"name":"liliangshan"},"license":"MIT","_id":"@liangshanli/mcp-server-mysql@3.0.0","maintainers":[{"name":"liangshanli1983","email":"kefu@03s.cn"}],"homepage":"https://github.com/liliangshan/mcp-server-mysql#readme","bugs":{"url":"https://github.com/liliangshan/mcp-server-mysql/issues"},"bin":{"mcp-server-mysql":"bin/cli.js"},"dist":{"shasum":"9978f7208956ebcae1ebbb6f4eb0aaf0c42d7d13","tarball":"https://registry.npmjs.org/@liangshanli/mcp-server-mysql/-/mcp-server-mysql-3.0.0.tgz","fileCount":6,"integrity":"sha512-UkAf9s/p4JD1zlp8y1TkKRgIEKEHJ/laoDmBZGvWUoCrfZmC8iQQiRYo9tAjUgoMyJsEtS8+368OZdKsz9IEow==","signatures":[{"sig":"MEYCIQCRF5LzNd3WpQy4gPaY1bgw/rhrWCRYSSN8raIpIeAnyAIhAP/bAZ7UIKfxFemTGSS7PFY80XfWpvKemZM8Z8MBfzp8","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":71362},"main":"bin/cli.js","gitHead":"9e762bd4979ef38eef9aa471c5da367ef8f7ae3c","scripts":{"dev":"node --inspect bin/cli.js","test":"node test-simple.js","start":"node bin/cli.js","daemon":"node start-server.js","server":"node src/server-final.js","start-managed":"node start-server.js"},"_npmUser":{"name":"liangshanli1983","email":"kefu@03s.cn"},"repository":{"url":"git+https://github.com/liliangshan/mcp-server-mysql.git","type":"git"},"_npmVersion":"11.5.2","description":"MCP MySQL server with DDL support, permission control and operation logs","directories":{},"_nodeVersion":"22.17.0","dependencies":{"mysql2":"^3.9.7"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^20.0.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-server-mysql_3.0.0_1763015311172_0.6205749767105635","host":"s3://npm-registry-packages-npm-production"}},"3.1.0":{"name":"@liangshanli/mcp-server-mysql","version":"3.1.0","keywords":["mcp","mysql","server","ddl","database"],"author":{"name":"liliangshan"},"license":"MIT","_id":"@liangshanli/mcp-server-mysql@3.1.0","maintainers":[{"name":"liangshanli1983","email":"kefu@03s.cn"}],"homepage":"https://github.com/liliangshan/mcp-server-mysql#readme","bugs":{"url":"https://github.com/liliangshan/mcp-server-mysql/issues"},"bin":{"mcp-server-mysql":"bin/cli.js"},"dist":{"shasum":"58f425bbbb71d889cd6abb9facee8ffcebf6cfdc","tarball":"https://registry.npmjs.org/@liangshanli/mcp-server-mysql/-/mcp-server-mysql-3.1.0.tgz","fileCount":7,"integrity":"sha512-r9nBT+t8Yz/yKxkCQhtge/UmjRZMwo7cAdw5TFAHFwYnmdnStUFtPh2M4ThShggJ9t7ZTNl8miNRuyZi7J0pog==","signatures":[{"sig":"MEUCIQCxDUmjLxO0YdVaMgjVkxWyd4JuePxIF0p6nON3Qubp6wIgHVWgKgpqogq46z3Z9jz1QVPgHxJCda5f+tEmVQiR/gw=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":93338},"main":"bin/cli.js","gitHead":"85d57fe4d83b5ed329890a6b2654733a18a34946","scripts":{"dev":"node --inspect bin/cli.js","test":"node test-simple.js","start":"node bin/cli.js","daemon":"node start-server.js","server":"node src/server-final.js","start-managed":"node start-server.js"},"_npmUser":{"name":"liangshanli1983","email":"kefu@03s.cn"},"repository":{"url":"git+https://github.com/liliangshan/mcp-server-mysql.git","type":"git"},"_npmVersion":"11.11.0","description":"MCP MySQL server with DDL support, permission control and operation logs","directories":{},"_nodeVersion":"25.8.1","dependencies":{"mysql2":"^3.9.7"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^20.0.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-server-mysql_3.1.0_1776964389064_0.6761489286751676","host":"s3://npm-registry-packages-npm-production"}},"3.2.0":{"_id":"@liangshanli/mcp-server-mysql@3.2.0","bin":{"mcp-server-mysql":"bin/cli.js"},"bugs":{"url":"https://github.com/liliangshan/mcp-server-mysql/issues"},"dist":{"shasum":"e5d0112f9acea8876dd8a1e40abfc0a3776d51d7","tarball":"https://registry.npmjs.org/@liangshanli/mcp-server-mysql/-/mcp-server-mysql-3.2.0.tgz","fileCount":13,"integrity":"sha512-CeWnm6jKpCr3qDBPsF9v5mwkKLZBjI8ui9ksmI1VhhoSLAsdrJtxkjsBFSb9bLdMPOX5f055C0aqYTWPPXq2ZA==","signatures":[{"sig":"MEUCIH1ZxxfU9pBOCPjvBXpjoYkxa8lzlFYb2l+Gi9O88MOtAiEAmgstMJ5J4DRgIo2++m8XsSgObYNR44imIKlB4uwCNdU=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"},{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIEpmInSaDDxkyuMalnG5lJEkPoLAVWZeAEW41bAOIBGZAiEAzKGPeY8EN0VKqeCW59kW8iR5VW+6vBkvKdRwCKFdiqc="}],"unpackedSize":134149},"main":"bin/cli.js","name":"@liangshanli/mcp-server-mysql","_from":"file:/var/folders/5h/n250lhy50pv0vfzgjl71hsjr0000gn/T/mcp-npm-publish-ix1w0o09/liangshanli-mcp-server-mysql-3.2.0.tgz","author":{"name":"liliangshan"},"license":"MIT","scripts":{"dev":"node --inspect bin/cli.js","test":"node --test test/*.test.js","start":"node bin/cli.js","daemon":"node start-server.js","server":"node src/server-final.js","start-managed":"node start-server.js"},"version":"3.2.0","_npmUser":{"name":"liangshanli1983","email":"kefu@03s.cn"},"homepage":"https://github.com/liliangshan/mcp-server-mysql#readme","keywords":["mcp","mysql","server","ddl","database"],"_resolved":"/var/folders/5h/n250lhy50pv0vfzgjl71hsjr0000gn/T/mcp-npm-publish-ix1w0o09/liangshanli-mcp-server-mysql-3.2.0.tgz","_integrity":"sha512-CeWnm6jKpCr3qDBPsF9v5mwkKLZBjI8ui9ksmI1VhhoSLAsdrJtxkjsBFSb9bLdMPOX5f055C0aqYTWPPXq2ZA==","repository":{"url":"git+https://github.com/liliangshan/mcp-server-mysql.git","type":"git"},"_npmVersion":"11.11.0","description":"MCP MySQL server with DDL support, permission control and operation logs","directories":{},"maintainers":[{"name":"liangshanli1983","email":"kefu@03s.cn"}],"_nodeVersion":"25.8.1","dependencies":{"mysql2":"^3.9.7"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^20.0.0"},"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mcp-server-mysql_3.2.0_1791719373230_0.9962672173584965"}}},"time":{"created":"2025-07-28T15:22:14.820Z","modified":"2026-10-11T11:49:33.489Z","1.0.0":"2025-07-28T15:22:15.205Z","1.0.1":"2025-07-28T15:23:13.035Z","1.0.3":"2025-07-28T15:31:25.182Z","1.0.5":"2025-07-28T15:38:46.149Z","1.0.6":"2025-07-28T15:44:19.434Z","1.0.7":"2025-07-28T16:10:11.026Z","1.0.8":"2025-07-28T16:16:41.040Z","2.0.0":"2025-07-28T20:17:14.508Z","2.0.1":"2025-09-08T15:19:17.404Z","3.0.0":"2025-11-13T06:28:31.377Z","3.1.0":"2026-04-23T17:13:09.197Z","3.2.0":"2026-10-11T11:49:33.313Z"},"bugs":{"url":"https://github.com/liliangshan/mcp-server-mysql/issues"},"author":{"name":"liliangshan"},"license":"MIT","homepage":"https://github.com/liliangshan/mcp-server-mysql#readme","keywords":["mcp","mysql","server","ddl","database"],"repository":{"url":"git+https://github.com/liliangshan/mcp-server-mysql.git","type":"git"},"description":"MCP MySQL server with DDL support, permission control and operation logs","maintainers":[{"name":"liangshanli1983","email":"kefu@03s.cn"}],"readme":"# MCP MySQL 服务器\n\n一个支持DDL操作、权限控制和操作日志的MCP MySQL服务器。\n\n## 版本历史\n\n### v3.2.0 (最新版本)\n- ✅ **只读保护加固**：检查完整 SQL，并使用只读事务阻止 SELECT 间接写入及危险语法。\n- ✅ **可选 TLS**：`MYSQL_SSL=true` 启用证书和主机名校验，不再强制已有非 TLS 连接开启加密。\n- ✅ **连接配置修复**：用有效的 `connectTimeout` 替换不支持的超时选项，初始化与重建连接池共享配置。\n- ✅ **回归测试**：新增 SQL 权限、连接生命周期、TLS 配置及版本一致性测试。\n\n### v3.1.1\n- ✅ **Claude 技能支持**：新增 `SKILL.md`，用于 Claude 集成。\n\n### v3.1.0\n- ✅ **BIGINT 精度支持**：新增 `supportBigNumbers` 和 `bigNumberStrings` 选项，防止大整数（如 `order_id`、`user_id` > 2^53 - 1）精度丢失。大数值将以字符串形式返回，确保完整精度。\n\n### v3.0.0\n- ✅ **只读模式**：新增 `READONLY` 环境变量 - 启用后只允许执行 SELECT 和 SHOW 命令（最高优先级检查）\n- ✅ **工具前缀支持**：新增 `TOOL_PREFIX` 环境变量，用于工具名称隔离和配置分离\n- ✅ **项目品牌**：新增 `PROJECT_NAME` 环境变量，用于自定义工具描述\n- ✅ **增强权限检查**：改进了 `check_permissions` 工具，包含详细消息和只读模式警告\n- ✅ **默认日志路径**：将默认日志目录从 `./logs` 改为 `./.setting`（如果设置了前缀则为 `./.setting.<TOOL_PREFIX>`）\n- ✅ **多实例支持**：完整支持运行多个 MySQL 服务器实例，配置相互隔离\n- ✅ **改进 CLI**：更新 CLI 以支持所有新环境变量和日志路径配置\n\n### v2.0.1\n- ✅ **DDL SQL 日志记录**：新增专门的 DDL SQL 操作日志记录到 `ddl.sql` 文件\n- ✅ **仅记录成功操作**：只有成功的 DDL 操作才会记录到 SQL 文件中\n- ✅ **时间戳条目**：每个 DDL 操作都包含精确的时间戳注释\n- ✅ **自动格式化**：SQL 语句自动格式化并添加分号结尾\n- ✅ **新工具**：新增 `get_ddl_sql_logs` 工具用于查询 DDL 操作历史\n- ✅ **增强日志**：改进日志配置，支持独立的 DDL 日志文件\n\n### v2.0.0\n- ✅ 初始版本，支持 DDL 操作\n- ✅ 权限控制系统\n- ✅ 操作日志记录\n- ✅ 连接池管理\n\n## 功能特性\n\n- ✅ 支持SQL查询执行（DDL和DML）\n- ✅ 数据库信息获取\n- ✅ 操作日志记录\n- ✅ 连接池管理\n- ✅ 自动重连机制\n- ✅ 健康检查\n- ✅ 错误处理和恢复\n\n## 安装\n\n### 全局安装（推荐）\n```bash\nnpm install -g @liangshanli/mcp-server-mysql\n```\n\n### 本地安装\n```bash\nnpm install @liangshanli/mcp-server-mysql\n```\n\n### 从源码安装\n```bash\ngit clone https://github.com/liliangshan/mcp-server-mysql.git\ncd mcp-server-mysql\nnpm install\n```\n\n## 配置\n\n设置环境变量：\n\n```bash\nexport MYSQL_HOST=localhost\nexport MYSQL_PORT=3306\nexport MYSQL_USER=root\nexport MYSQL_PASSWORD=your_password\nexport MYSQL_DATABASE=your_database\nexport MYSQL_SSL=false\nexport READONLY=false\nexport ALLOW_DDL=true\nexport ALLOW_DROP=false\nexport ALLOW_DELETE=false\n\n# 可选：工具前缀，用于配置隔离\nexport TOOL_PREFIX=\"projA\"\n\n# 可选：项目品牌名称\nexport PROJECT_NAME=\"MyProject\"\n```\n\n### SSL/TLS 连接\n\n仅当 `MYSQL_SSL=true` 时启用 TLS。未设置或设置为 `false` 时保持非 TLS 连接。初始化和重建连接池使用相同配置；开启 TLS 后，握手或证书验证失败不会自动降级为明文连接。\n\nTLS 会校验证书信任链及服务器主机名。`MYSQL_HOST` 请使用与证书匹配的数据库域名。私有 CA 或自签名 CA 场景，可在 MCP 进程环境中设置 `NODE_EXTRA_CA_CERTS=/absolute/path/to/ca.pem`，必须在 **Node.js 启动前**设置，并重启服务。CLI 和托管启动均会继承这些环境变量。不要通过关闭证书校验来绕过信任错误。\n\n## 使用方法\n\n### 1. 全局安装后直接运行\n```bash\nmcp-server-mysql\n```\n\n### 2. 使用 npx 运行（推荐）\n```bash\nnpx @liangshanli/mcp-server-mysql\n```\n\n### 3. 直接启动（源码安装）\n```bash\nnpm start\n```\n\n### 4. 托管启动（推荐用于生产环境）\n```bash\nnpm run start-managed\n```\n\n托管启动提供以下功能：\n- 自动重启（最多10次）\n- 错误恢复\n- 进程管理\n- 日志记录\n\n### 5. 开发模式\n```bash\nnpm run dev\n```\n\n## 编辑器集成\n\n### Cursor 编辑器配置\n\n1. 在项目根目录创建 `.cursor/mcp.json` 文件：\n\n```json\n{\n  \"mcpServers\": {\n    \"mysql\": {\n      \"command\": \"npx\",\n      \"args\": [\"@liangshanli/mcp-server-mysql\"],\n      \"env\": {\n        \"MYSQL_HOST\": \"your_host\",\n        \"MYSQL_PORT\": \"3306\",\n        \"MYSQL_USER\": \"your_user\",\n        \"MYSQL_PASSWORD\": \"your_password\",\n        \"MYSQL_DATABASE\": \"your_database\",\n        \"MYSQL_SSL\": \"false\",\n        \"READONLY\": \"false\",\n        \"ALLOW_DDL\": \"false\",\n        \"ALLOW_DROP\": \"false\",\n        \"ALLOW_DELETE\": \"false\",\n        \"TOOL_PREFIX\": \"projA\",\n        \"PROJECT_NAME\": \"MyProject\"\n      }\n    }\n  }\n}\n```\n\n### VS Code 配置\n\n1. 安装 VS Code 的 MCP 扩展\n2. 创建 `.vscode/settings.json` 文件：\n\n```json\n{\n  \"mcp.servers\": {\n    \"mysql\": {\n      \"command\": \"npx\",\n      \"args\": [\"@liangshanli/mcp-server-mysql\"],\n      \"env\": {\n        \"MYSQL_HOST\": \"your_host\",\n        \"MYSQL_PORT\": \"3306\",\n        \"MYSQL_USER\": \"your_user\",\n        \"MYSQL_PASSWORD\": \"your_password\",\n        \"MYSQL_DATABASE\": \"your_database\",\n        \"MYSQL_SSL\": \"false\",\n        \"READONLY\": \"false\",\n        \"ALLOW_DDL\": \"false\",\n        \"ALLOW_DROP\": \"false\",\n        \"ALLOW_DELETE\": \"false\",\n        \"TOOL_PREFIX\": \"projA\",\n        \"PROJECT_NAME\": \"MyProject\"\n      }\n    }\n  }\n}\n```\n\n### 多 MySQL 服务器实例支持\n\n您可以配置多个 MySQL 服务器实例，使用不同的 `TOOL_PREFIX` 和 `PROJECT_NAME` 来隔离工具和配置。这在需要同时连接到多个数据库时非常有用。\n\n**示例：Cursor 编辑器配置**\n\n创建 `.cursor/mcp.json` 文件：\n\n```json\n{\n  \"mcpServers\": {\n    \"local-mysql\": {\n      \"disabled\": false,\n      \"timeout\": 60,\n      \"command\": \"npx\",\n      \"args\": [\"@liangshanli/mcp-server-mysql\"],\n      \"env\": {\n        \"MYSQL_HOST\": \"localhost\",\n        \"MYSQL_PORT\": \"3306\",\n        \"MYSQL_USER\": \"your_user\",\n        \"MYSQL_PASSWORD\": \"your_password\",\n        \"MYSQL_DATABASE\": \"your_database\",\n        \"MYSQL_SSL\": \"false\",\n        \"ALLOW_DDL\": \"true\",\n        \"ALLOW_DROP\": \"true\",\n        \"ALLOW_DELETE\": \"false\",\n        \"TOOL_PREFIX\": \"local\",\n        \"PROJECT_NAME\": \"local-mysql\"\n      }\n    },\n    \"online-mysql\": {\n      \"disabled\": false,\n      \"timeout\": 60,\n      \"command\": \"npx\",\n      \"args\": [\"@liangshanli/mcp-server-mysql\"],\n      \"env\": {\n        \"MYSQL_HOST\": \"your_remote_host\",\n        \"MYSQL_PORT\": \"3306\",\n        \"MYSQL_USER\": \"your_user\",\n        \"MYSQL_PASSWORD\": \"your_password\",\n        \"MYSQL_DATABASE\": \"your_database\",\n        \"MYSQL_SSL\": \"true\",\n        \"READONLY\": \"true\",\n        \"ALLOW_DDL\": \"false\",\n        \"ALLOW_DROP\": \"false\",\n        \"ALLOW_DELETE\": \"false\",\n        \"TOOL_PREFIX\": \"online\",\n        \"PROJECT_NAME\": \"online-mysql\"\n      }\n    }\n  }\n}\n```\n\n**多实例的优势：**\n\n- **工具隔离**：每个实例都有自己独立的工具名称（例如：`local_sql_query`、`online_sql_query`）\n- **配置隔离**：日志和 DDL 文件存储在独立的目录中（例如：`./.setting.local/`、`./.setting.online/`）\n- **不同权限**：为每个实例配置不同的权限级别（例如：生产环境只读，开发环境完全访问）\n- **项目品牌**：每个实例可以有自己的项目名称，便于识别\n\n**注意**：使用多个实例时，工具名称会带有 `TOOL_PREFIX` 前缀。例如：\n- `local_sql_query` - 查询本地数据库\n- `online_sql_query` - 查询在线数据库（只读）\n\n### 作为MCP服务器\n\n服务器启动后，通过stdin/stdout与MCP客户端通信：\n\n```json\n{\"jsonrpc\": \"2.0\", \"id\": 1, \"method\": \"initialize\", \"params\": {\"protocolVersion\": \"2025-06-18\"}}\n```\n\n### 可用工具\n\n1. **sql_query**: 执行SQL查询\n   ```json\n   {\n     \"jsonrpc\": \"2.0\",\n     \"id\": 2,\n     \"method\": \"tools/call\",\n     \"params\": {\n       \"name\": \"sql_query\",\n       \"arguments\": {\n         \"sql\": \"SELECT * FROM users LIMIT 10\"\n       }\n     }\n   }\n   ```\n\n2. **get_database_info**: 获取数据库信息\n   ```json\n   {\n     \"jsonrpc\": \"2.0\",\n     \"id\": 3,\n     \"method\": \"tools/call\",\n     \"params\": {\n       \"name\": \"get_database_info\",\n       \"arguments\": {}\n     }\n   }\n   ```\n\n3. **get_operation_logs**: 获取操作日志\n   ```json\n   {\n     \"jsonrpc\": \"2.0\",\n     \"id\": 4,\n     \"method\": \"tools/call\",\n     \"params\": {\n       \"name\": \"get_operation_logs\",\n       \"arguments\": {\n         \"limit\": 50,\n         \"offset\": 0\n       }\n     }\n   }\n   ```\n\n4. **get_ddl_sql_logs**: 获取 DDL SQL 操作日志 (v2.0.1+)\n   ```json\n   {\n     \"jsonrpc\": \"2.0\",\n     \"id\": 5,\n     \"method\": \"tools/call\",\n     \"params\": {\n       \"name\": \"get_ddl_sql_logs\",\n       \"arguments\": {\n         \"limit\": 50,\n         \"offset\": 0\n       }\n     }\n   }\n   ```\n\n5. **check_permissions**: 检查数据库权限\n   ```json\n   {\n     \"jsonrpc\": \"2.0\",\n     \"id\": 6,\n     \"method\": \"tools/call\",\n     \"params\": {\n       \"name\": \"check_permissions\",\n       \"arguments\": {}\n     }\n   }\n   ```\n\n## 只读模式的安全边界\n\n`READONLY=true` 优先于所有 `ALLOW_*` 配置。只读请求只接受单条 `SELECT` 或 `SHOW`，并在同一连接的 `START TRANSACTION READ ONLY` 事务中执行；成功或失败后都会回滚。事务开启失败时不会执行用户 SQL，回滚失败的连接会被销毁而不是放回连接池。\n\n- 全部模式显式禁用多语句，并在连接数据库前检查完整 SQL。允许末尾的一个分号，字符串和普通注释中的分号不会被当作语句分隔符。\n- 拒绝 MySQL `/*! ... */` 和 MariaDB `/*M! ... */` 可执行注释；普通注释不影响语句类型判断，因此不能再通过前置注释绕过 DDL、DROP、DELETE 检查。\n- 只读模式拒绝 `SELECT ... INTO OUTFILE/DUMPFILE`、`INTO @变量`、`:=` 赋值、`FOR UPDATE/SHARE`、`LOCK IN SHARE MODE` 和获取/释放命名锁的函数。\n- 不同 `sql_mode` 对引号和反斜杠的解释不同；不能在所有支持的解释下安全校验的 SQL 会被保守拒绝。只读模式仍不接受 `WITH`、`EXPLAIN`、`CALL` 等其他起始命令。\n- 单语句校验采用保守策略，不接受含内部分号的存储过程/函数定义等复合脚本；需要执行此类脚本时，请使用独立的受控迁移工具。\n\n**应用层检查不能替代数据库权限。** 只读事务用于进一步阻止 SELECT 调用存储函数时修改普通表，但不是任意 UDF、外部副作用或临时表操作的完整沙箱。生产环境应使用专用的最小权限账号，只授予需要的查询和元数据读取权限，不授予写入、DDL、`FILE`、不必要的 `EXECUTE` 等权限，不要使用 `root` 作为只读账号。\n\n修改后需重启实际使用的 MCP 服务。运行 `npx @liangshanli/mcp-server-mysql` 不会自动使用本地源码修改，需指向本地 `bin/cli.js` 或安装包含修复的版本。\n\n## 连接池特性\n\n- **自动创建**: 在`notifications/initialized`时自动创建连接池\n- **健康检查**: 每5分钟检查连接池状态\n- **自动重连**: 连接池失效时自动重新创建\n- **连接复用**: 使用连接池提高性能\n- **优雅关闭**: 服务器关闭时正确释放连接\n\n## 日志\n\n### 常规日志\n日志文件位置：`./.setting/mcp-mysql.log` (如果设置了TOOL_PREFIX则为 `./.setting.<TOOL_PREFIX>/mcp-mysql.log`)\n\n记录内容：\n- 所有请求和响应\n- SQL操作记录\n- 错误信息\n- 连接池状态变化\n\n### DDL SQL 日志 (v2.0.1+)\nDDL 日志文件位置：`./.setting/ddl.sql` (如果设置了TOOL_PREFIX则为 `./.setting.<TOOL_PREFIX>/ddl.sql`)\n\n功能特性：\n- **仅记录成功操作**：只有成功的 DDL 操作才会被记录\n- **时间戳条目**：每个操作都包含精确的时间戳注释\n- **自动格式化**：SQL 语句自动格式化并添加分号结尾\n- **可执行格式**：可以直接执行来重建数据库结构\n\nDDL 日志格式示例：\n```sql\n# 2024-01-15 14:23:45\nCREATE TABLE users (id INT PRIMARY KEY, name VARCHAR(100));\n# 2024-01-15 14:24:12\nALTER TABLE users ADD COLUMN email VARCHAR(255);\n# 2024-01-15 14:25:33\nCREATE INDEX idx_email ON users(email);\n```\n\n#### DDL 日志记录优势\n\n**🔄 数据库同步**\n- **生产环境同步**：轻松将开发环境的数据库结构变更同步到生产环境\n- **多环境部署**：在测试、预发布、生产等多个环境中应用相同的 DDL 变更\n- **回滚支持**：维护完整的结构变更历史，便于快速回滚操作\n\n**📋 开发工作流**\n- **结构版本控制**：通过时间戳记录跟踪数据库演进历史\n- **团队协作**：通过可执行的 SQL 文件与团队成员分享数据库结构变更\n- **代码审查**：将数据库变更与应用程序代码变更一起进行审查\n\n**🛡️ 运营卓越**\n- **审计跟踪**：维护所有数据库结构修改的全面审计日志\n- **合规性**：满足数据库变更跟踪的监管要求\n- **灾难恢复**：在数据丢失情况下快速从 DDL 日志重建数据库结构\n\n**⚡ 性能与可靠性**\n- **清洁执行**：只记录成功操作，确保脚本执行的可靠性\n- **错误预防**：排除失败操作，防止脚本执行错误\n- **自动格式化**：一致的 SQL 格式化减少手动错误并提高可读性\n\n## 错误处理\n\n- 单个请求错误不会影响整个服务器\n- 连接池错误会自动恢复\n- 进程异常会自动重启（托管模式）\n\n## 环境变量\n\n| 变量名 | 默认值 | 说明 |\n|--------|--------|------|\n| MYSQL_HOST | localhost | MySQL主机地址 |\n| MYSQL_PORT | 3306 | MySQL端口 |\n| MYSQL_USER | root | MySQL用户名 |\n| MYSQL_PASSWORD | | MySQL密码 |\n| MYSQL_DATABASE | | 数据库名 |\n| MYSQL_SSL | false | 仅设置为'true'时启用 TLS，并校验证书和主机名；初始化与重建连接池均使用此设置 |\n| NODE_EXTRA_CA_CERTS | | 可选，私有或自签名 CA 的 PEM 文件绝对路径；Node.js 在进程启动时读取 |\n| READONLY | false | 如果设置为'true'，只允许执行SELECT和SHOW命令。此检查具有最高优先级，会覆盖所有其他权限设置 |\n| ALLOW_DDL | false | 是否允许DDL操作（CREATE、ALTER、TRUNCATE、RENAME、COMMENT）。设置为'true'启用 |\n| ALLOW_DROP | false | 是否允许DROP操作。设置为'true'启用 |\n| ALLOW_DELETE | false | 是否允许DELETE操作。设置为'true'启用 |\n| TOOL_PREFIX | | 可选工具前缀，用于工具名称和配置隔离。示例：`export TOOL_PREFIX=\"projA\"` |\n| PROJECT_NAME | | 可选项目品牌名称，用于工具描述 |\n| MCP_LOG_DIR | ./.setting (如果设置了TOOL_PREFIX则为 ./.setting.<TOOL_PREFIX>) | 日志目录 |\n| MCP_LOG_FILE | mcp-mysql.log | 日志文件名 |\n| MCP_DDL_LOG_FILE | ddl.sql | DDL SQL 日志文件名 (v2.0.1+) |\n\n## 开发\n\n### 项目结构\n```\nmcpmysql/\n├── src/\n│   └── server-final.js    # 主服务器文件\n├── start-server.js        # 托管启动脚本\n├── package.json\n└── README.md\n```\n\n### 测试\n```bash\nnpm test\n```\n\n## 快速开始\n\n### 1. 安装包\n```bash\nnpm install -g @liangshanli/mcp-server-mysql\n```\n\n### 2. 配置环境变量\n```bash\nexport MYSQL_HOST=localhost\nexport MYSQL_PORT=3306\nexport MYSQL_USER=root\nexport MYSQL_PASSWORD=your_password\nexport MYSQL_DATABASE=your_database\nexport MYSQL_SSL=false\nexport READONLY=false\nexport ALLOW_DDL=false\nexport ALLOW_DROP=false\nexport ALLOW_DELETE=false\n\n**权限控制示例：**\n```bash\n# 只读模式：只允许SELECT和SHOW命令（最高优先级）\nexport READONLY=true\n\n# 默认：禁用所有破坏性操作（安全模式）\nexport READONLY=false\nexport ALLOW_DDL=false\nexport ALLOW_DROP=false\nexport ALLOW_DELETE=false\n\n# 允许DDL但禁用DROP和DELETE\nexport READONLY=false\nexport ALLOW_DDL=true\nexport ALLOW_DROP=false\nexport ALLOW_DELETE=false\n\n# 允许所有操作但禁用DELETE\nexport READONLY=false\nexport ALLOW_DDL=true\nexport ALLOW_DROP=true\nexport ALLOW_DELETE=false\n\n# 启用所有操作（谨慎使用）\nexport READONLY=false\nexport ALLOW_DDL=true\nexport ALLOW_DROP=true\nexport ALLOW_DELETE=true\n```\n\n### 3. 运行服务器\n```bash\nmcp-server-mysql\n```\n\n## 许可证\n\nMIT ","readmeFilename":"README.zh-CN.md"}