{"_id":"@edsamo/mysql-mcp-server","_rev":"3-782a4c6ee6f4752557fd46f5c1928c3f","name":"@edsamo/mysql-mcp-server","dist-tags":{"latest":"1.0.3"},"versions":{"1.0.1":{"name":"@edsamo/mysql-mcp-server","version":"1.0.1","keywords":["mysql","mcp","model-context-protocol","mariadb","database","vscode","ai","claude","continue","sql","typescript","local-development"],"author":{"name":"Edmilson Motta","email":"edd.contato@gmail.com"},"license":"MIT","_id":"@edsamo/mysql-mcp-server@1.0.1","maintainers":[{"name":"edsamo","email":"edd.contato@gmail.com"}],"homepage":"https://github.com/EdDevFront/mysql-mcp-server.git","bugs":{"url":"https://github.com/EdDevFront/mysql-mcp-server/issues"},"bin":{"mcp-server-mysql":"dist/index.js"},"dist":{"shasum":"79c7623274a387d2a0ee59e8b865e8b904285f4b","tarball":"https://registry.npmjs.org/@edsamo/mysql-mcp-server/-/mysql-mcp-server-1.0.1.tgz","fileCount":7,"integrity":"sha512-CtWlu2F7C4P8Rb6H2cznwPKHaGiiuV+VSVMnNVgQRFMV+7wqIYbgPDruHCyjXJVfdNOs9JlpqQeXwSs3ca0TNA==","signatures":[{"sig":"MEQCIEj+mGwwKSbfx2jA2s60s5Dtx9cF0z6ZpawKi/JPSKY3AiAmfkuNgvmHvlHwjZiI5rZUIU9/PobpOYKJnOBepDhjVQ==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":15763},"main":"dist/index.js","type":"module","types":"./dist/index.d.ts","gitHead":"0ddf24e105976c97d419b79450011e1a2270390e","scripts":{"dev":"tsc --watch","pack":"npm run build && npm pack","test":"echo \"Tests coming soon\" && exit 0","build":"tsc","start":"node dist/index.js","prepublishOnly":"npm run build"},"_npmUser":{"name":"edsamo","email":"edd.contato@gmail.com"},"repository":{"url":"git+https://github.com/EdDevFront/mysql-mcp-server.git","type":"git"},"_npmVersion":"10.9.2","description":"MySQL Model Context Protocol Server for VS Code AI extensions with any MySQL server","directories":{},"_nodeVersion":"22.16.0","dependencies":{"dotenv":"^16.4.5","mysql2":"^3.11.0","@modelcontextprotocol/sdk":"^0.5.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.5.0","@types/node":"^22.0.0"},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp-server_1.0.1_1755728637301_0.4672437002645262","host":"s3://npm-registry-packages-npm-production"}},"1.0.2":{"name":"@edsamo/mysql-mcp-server","version":"1.0.2","keywords":["mysql","mcp","model-context-protocol","mariadb","database","vscode","ai","claude","continue","sql","typescript","local-development"],"author":{"name":"Edmilson Motta","email":"edd.contato@gmail.com"},"license":"MIT","_id":"@edsamo/mysql-mcp-server@1.0.2","maintainers":[{"name":"edsamo","email":"edd.contato@gmail.com"}],"homepage":"https://github.com/EdDevFront/mysql-mcp-server.git","bugs":{"url":"https://github.com/EdDevFront/mysql-mcp-server/issues"},"bin":{"mcp-server-mysql":"dist/index.js"},"dist":{"shasum":"5bdb1a22d5bdb081357905def85e6237dbb8b718","tarball":"https://registry.npmjs.org/@edsamo/mysql-mcp-server/-/mysql-mcp-server-1.0.2.tgz","fileCount":7,"integrity":"sha512-muGc/aqHCJnRJPF+W5PpqgtTCbqKQLfVr6p1LUfGyqkVAjfupb44bziWNuqiZdysUyqoG9MoaUUmKjlI27cUrA==","signatures":[{"sig":"MEYCIQCsRQaYsZv7KeULuIV1Dfk40y9/QcX1AWV5RPfdoAr72gIhALzkK2PHllEpyGvs9MtihnQbVM1gvw9QNB2rdLtFt9Qj","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":16901},"main":"dist/index.js","type":"module","types":"./dist/index.d.ts","gitHead":"59f0e9dbb581a4a774d44620d20f7ec25784d88c","scripts":{"dev":"tsc --watch","pack":"npm run build && npm pack","test":"echo \"Tests coming soon\" && exit 0","build":"tsc","start":"node dist/index.js","prepublishOnly":"npm run build"},"_npmUser":{"name":"edsamo","email":"edd.contato@gmail.com"},"repository":{"url":"git+https://github.com/EdDevFront/mysql-mcp-server.git","type":"git"},"_npmVersion":"10.9.2","description":"MySQL Model Context Protocol Server for VS Code AI extensions with any MySQL server","directories":{},"_nodeVersion":"22.16.0","dependencies":{"dotenv":"^16.4.5","mysql2":"^3.11.0","@modelcontextprotocol/sdk":"^0.5.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.5.0","@types/node":"^22.0.0"},"_npmOperationalInternal":{"tmp":"tmp/mysql-mcp-server_1.0.2_1755729096058_0.6955859898783658","host":"s3://npm-registry-packages-npm-production"}},"1.0.3":{"name":"@edsamo/mysql-mcp-server","version":"1.0.3","description":"MySQL Model Context Protocol Server for VS Code AI extensions with any MySQL server","main":"dist/index.js","bin":{"mcp-server-mysql":"dist/index.js"},"type":"module","scripts":{"build":"tsc","dev":"tsc --watch","start":"node dist/index.js","pack":"npm run build && npm pack","prepublishOnly":"npm run build","test":"echo \"Tests coming soon\" && exit 0"},"keywords":["mysql","mcp","model-context-protocol","mariadb","database","vscode","ai","claude","continue","sql","typescript","local-development"],"author":{"name":"Edmilson Motta","email":"edd.contato@gmail.com"},"license":"MIT","repository":{"type":"git","url":"git+https://github.com/EdDevFront/mysql-mcp-server.git"},"bugs":{"url":"https://github.com/EdDevFront/mysql-mcp-server/issues"},"homepage":"https://github.com/EdDevFront/mysql-mcp-server.git","publishConfig":{"access":"public"},"dependencies":{"@modelcontextprotocol/sdk":"^0.5.0","mysql2":"^3.11.0","dotenv":"^16.4.5"},"devDependencies":{"@types/node":"^22.0.0","typescript":"^5.5.0"},"_id":"@edsamo/mysql-mcp-server@1.0.3","gitHead":"a26e1878030d55882ff16f168cb28cc7f7d3fc63","types":"./dist/index.d.ts","_nodeVersion":"22.16.0","_npmVersion":"10.9.2","dist":{"integrity":"sha512-teKBkcXSTnjwJ6WL9IWdC00sttrLcRVRsAtu/QQPvwN/0kXXta/xkMumJi2e/PIcYBVuwW+avIWqX1GcjHCRcg==","shasum":"403be3938ef960cddbbd551ec625c5f79ae577cb","tarball":"https://registry.npmjs.org/@edsamo/mysql-mcp-server/-/mysql-mcp-server-1.0.3.tgz","fileCount":7,"unpackedSize":16897,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIQCBGk6GHXsQ9EnmOw1wmQCXfKXNloaaQ3rDq9dF5Utt6wIgU6PLk0GpQ62c9IPoRYIXuaGE5qIBQIKMiKR7SY6lwR4="}]},"_npmUser":{"name":"edsamo","email":"edd.contato@gmail.com"},"directories":{},"maintainers":[{"name":"edsamo","email":"edd.contato@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mysql-mcp-server_1.0.3_1755729876988_0.5592997012793124"},"_hasShrinkwrap":false}},"time":{"created":"2025-08-20T22:23:57.242Z","modified":"2025-08-20T22:44:37.389Z","1.0.1":"2025-08-20T22:23:57.479Z","1.0.2":"2025-08-20T22:31:36.280Z","1.0.3":"2025-08-20T22:44:37.196Z"},"bugs":{"url":"https://github.com/EdDevFront/mysql-mcp-server/issues"},"author":{"name":"Edmilson Motta","email":"edd.contato@gmail.com"},"license":"MIT","homepage":"https://github.com/EdDevFront/mysql-mcp-server.git","keywords":["mysql","mcp","model-context-protocol","mariadb","database","vscode","ai","claude","continue","sql","typescript","local-development"],"repository":{"type":"git","url":"git+https://github.com/EdDevFront/mysql-mcp-server.git"},"description":"MySQL Model Context Protocol Server for VS Code AI extensions with any MySQL server","maintainers":[{"name":"edsamo","email":"edd.contato@gmail.com"}],"readme":"# MySQL MCP Server\r\n\r\nA Model Context Protocol (MCP) server that provides MySQL/MariaDB access to AI extensions in Visual Studio Code.\r\n\r\nThis project works with any MySQL/MariaDB installation — local, remote, containerized, or cloud-hosted.\r\n\r\n## Installation\r\n\r\nInstall the published scoped package globally:\r\n\r\n```bash\r\nnpm install -g @edsamo/mysql-mcp-server\r\n```\r\n\r\nOr install it locally in a project:\r\n\r\n```bash\r\nnpm install @edsamo/mysql-mcp-server\r\n```\r\n\r\nAfter installing globally, the command available is `mcp-server-mysql`.\r\n\r\n## Configuration\r\n\r\nYou can configure the server either per-project or globally in VS Code. The server reads configuration from environment variables; the examples below show how to provide them via the MCP server configuration.\r\n\r\n### Option 1 — `.vscode/mcp.json` (per-project, recommended)\r\n\r\nCreate `.vscode/mcp.json` in your project:\r\n\r\n```json\r\n{\r\n  \"servers\": {\r\n    \"mysql\": {\r\n      \"command\": \"mcp-server-mysql\",\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_database\"\r\n      }\r\n    }\r\n  }\r\n}\r\n```\r\n\r\n### Option 2 — VS Code `settings.json` (global)\r\n\r\nAdd the server configuration to your global VS Code settings (`settings.json`):\r\n\r\n```json\r\n{\r\n  \"mcp.servers\": {\r\n    \"mysql\": {\r\n      \"command\": \"mcp-server-mysql\",\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_database\"\r\n      }\r\n    }\r\n  }\r\n}\r\n```\r\n\r\nTo open `settings.json` in VS Code: press `Ctrl+Shift+P` → \"Preferences: Open Settings (JSON)\".\r\n\r\n## Common environment examples\r\n\r\n- Local (XAMPP/WAMP):\r\n\r\n```json\r\n{\r\n  \"MYSQL_HOST\": \"localhost\",\r\n  \"MYSQL_PORT\": \"3306\",\r\n  \"MYSQL_USER\": \"root\",\r\n  \"MYSQL_PASSWORD\": \"\",\r\n  \"MYSQL_DATABASE\": \"app_db\"\r\n}\r\n```\r\n\r\n- Docker (custom port):\r\n\r\n```json\r\n{\r\n  \"MYSQL_HOST\": \"localhost\",\r\n  \"MYSQL_PORT\": \"3307\",\r\n  \"MYSQL_USER\": \"mysql_user\",\r\n  \"MYSQL_PASSWORD\": \"mysql_pass\",\r\n  \"MYSQL_DATABASE\": \"app_db\"\r\n}\r\n```\r\n\r\n- Remote (VPS / public IP):\r\n\r\n```json\r\n{\r\n  \"MYSQL_HOST\": \"203.0.113.10\",\r\n  \"MYSQL_PORT\": \"3306\",\r\n  \"MYSQL_USER\": \"remote_user\",\r\n  \"MYSQL_PASSWORD\": \"secure\",\r\n  \"MYSQL_DATABASE\": \"prod_db\"\r\n}\r\n```\r\n\r\n## Features\r\n\r\n- Execute SQL queries (`mysql_query`)\r\n- List database tables (`mysql_list_tables`)\r\n- Describe table schema (`mysql_describe_table`)\r\n- Support for remote connections and SSH tunnels\r\n\r\n## License\r\n\r\nMIT\r\n","readmeFilename":"README.md"}