{"_id":"@davewind/mysql-mcp-server","_rev":"2-02171c184afcbfaa9642ffe3f026f62d","name":"@davewind/mysql-mcp-server","dist-tags":{"latest":"0.2.0"},"versions":{"0.1.0":{"name":"@davewind/mysql-mcp-server","version":"0.1.0","keywords":["mcp","model-context-protocol","mysql","database","cursor","n8n"],"author":{"name":"dave-wind"},"license":"MIT","_id":"@davewind/mysql-mcp-server@0.1.0","maintainers":[{"name":"davejoins","email":"18119651372@163.com"}],"homepage":"https://github.com/dave-wind/mysql-mcp-server#readme","bugs":{"url":"https://github.com/dave-wind/mysql-mcp-server/issues"},"bin":{"mcp-mysql":"build/index.js"},"dist":{"shasum":"f9bbce4f7893331d903f8c12ef03a66b17ea660d","tarball":"https://registry.npmjs.org/@davewind/mysql-mcp-server/-/mysql-mcp-server-0.1.0.tgz","fileCount":4,"integrity":"sha512-w3N52RWDizpJWGih9+cYzXkKoFy0lPjvIligOOgJHcamLNz6szDRuNx49m+oD8Y5eZOYC/iEM8nNQPL8V0EPTw==","signatures":[{"sig":"MEUCIEC+TVGiy68Mvn0oBhjp8N730eb69k/XBePWNTgS8AlPAiEAodG+12qA1Hk6xrIYyCIVf/+HL+jd+bw4zqoZ+tkNtIM=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":12417},"type":"module","gitHead":"b06e76bfe360d52c83512d86a25f3d4809d72539","scripts":{"test":"node test-mcp.js","build":"tsc && node -e \"require('fs').chmodSync('build/index.js', '755')\"","watch":"tsc --watch","prepare":"npm run build","inspector":"npx @modelcontextprotocol/inspector@0.10.2 build/index.js mysql://user:password@localhost:port/database"},"_npmUser":{"name":"davejoins","email":"18119651372@163.com"},"repository":{"url":"git+https://github.com/dave-wind/mysql-mcp-server.git","type":"git"},"_npmVersion":"10.2.3","description":"A Model Context Protocol server for MySQL","directories":{},"_nodeVersion":"18.19.0","dependencies":{"mysql2":"^3.11.5","node-fetch":"^3.3.2","@modelcontextprotocol/sdk":"1.10.2"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.3.3","@types/node":"^20.11.24"},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp-server_0.1.0_1745719352393_0.726245883524375","host":"s3://npm-registry-packages-npm-production"}},"0.2.0":{"name":"@davewind/mysql-mcp-server","version":"0.2.0","description":"A Model Context Protocol server for MySQL","type":"module","bin":{"mcp-mysql":"build/index.js"},"scripts":{"build":"tsc && node -e \"require('fs').chmodSync('build/index.js', '755')\"","prepare":"npm run build","watch":"tsc --watch","inspector":"npx @modelcontextprotocol/inspector@0.10.2 build/index.js mysql://user:password@localhost:port/database","test":"node test-mcp.js"},"keywords":["mcp","model-context-protocol","mysql","database","cursor","n8n"],"author":{"name":"dave-wind"},"license":"MIT","dependencies":{"@modelcontextprotocol/sdk":"1.10.2","mysql2":"^3.11.5","node-fetch":"^3.3.2"},"devDependencies":{"@types/node":"^20.11.24","typescript":"^5.3.3"},"repository":{"type":"git","url":"git+https://github.com/dave-wind/mysql-mcp-server.git"},"publishConfig":{"access":"public"},"_id":"@davewind/mysql-mcp-server@0.2.0","gitHead":"b06e76bfe360d52c83512d86a25f3d4809d72539","bugs":{"url":"https://github.com/dave-wind/mysql-mcp-server/issues"},"homepage":"https://github.com/dave-wind/mysql-mcp-server#readme","_nodeVersion":"18.19.0","_npmVersion":"10.2.3","dist":{"integrity":"sha512-x77pk2X2flX6ZlfBjOEu+xV63WoDra+ouBKhYqpPkIATmUBIeF0cy0yxmLd7qymIRjj72d915A+psf8aql6bWA==","shasum":"94cb3ed4ed0d39dafbad874f97479bbd22a4c10a","tarball":"https://registry.npmjs.org/@davewind/mysql-mcp-server/-/mysql-mcp-server-0.2.0.tgz","fileCount":4,"unpackedSize":12414,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIFlWUpGrHFDyXUs/V/ME3h9AzibAWPx31+2Qjt+VekL5AiEAoGV8lRq/RoS0iv7TJL/cSNnMRYUuE8mmWscQRUeDaYI="}]},"_npmUser":{"name":"davejoins","email":"18119651372@163.com"},"directories":{},"maintainers":[{"name":"davejoins","email":"18119651372@163.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mysql-mcp-server_0.2.0_1745719525985_0.5805986723756784"},"_hasShrinkwrap":false}},"time":{"created":"2025-04-27T02:02:32.304Z","modified":"2025-04-27T02:05:26.368Z","0.1.0":"2025-04-27T02:02:32.556Z","0.2.0":"2025-04-27T02:05:26.175Z"},"bugs":{"url":"https://github.com/dave-wind/mysql-mcp-server/issues"},"author":{"name":"dave-wind"},"license":"MIT","homepage":"https://github.com/dave-wind/mysql-mcp-server#readme","keywords":["mcp","model-context-protocol","mysql","database","cursor","n8n"],"repository":{"type":"git","url":"git+https://github.com/dave-wind/mysql-mcp-server.git"},"description":"A Model Context Protocol server for MySQL","maintainers":[{"name":"davejoins","email":"18119651372@163.com"}],"readme":"# @davewind/mysql-mcp-server\n\n\nA Model Context Protocol server that provides read-only access to Mysql databases. This server enables LLMs to inspect database schemas and execute read-only queries.\n\n\n### Components\n\n### Tools\n\n- **query**\n  - Execute read-only SQL queries against the connected database\n  - Input: `sql` (string): The SQL query to execute\n  - All queries are executed within a READ ONLY transaction\n\n### Resources\n\nThe server provides schema information for each table in the database:\n\n- **Table Schemas** (`mysql://user:password@localhost:3306/mydb`)\n  - JSON schema information for each table\n  - Includes column names and data types\n  - Automatically discovered from database metadata\n\n\n### Install\n```bash\nnpm install @davewind/mysql-mcp-server -g\n```\n\n## Configuration\nMCP settings configuration file:\n\n> recommended use\n\n```json\n{\n  \"mcpServers\": {\n    \"mysql\": {\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"@davewind/mysql-mcp-server\", \"mysql://user:password@localhost:port/database\"],\n    }\n  }\n}\n```\n\n\n\n### Test\n>  Replace mysql://user:password@localhost:port/  and npm run inspector\n```js\n  \"scripts\": {\n    \"inspector\": \"npx @modelcontextprotocol/inspector@0.10.2 build/index.js mysql://user:password@localhost:port/\n  }\n```\n\n\n## License\n\nMIT\n","readmeFilename":"README.md"}