{"_id":"@affanshahid/sql-mcp-server","_rev":"4-4cc8bcbbac153ea9632b306b687bfca9","name":"@affanshahid/sql-mcp-server","dist-tags":{"latest":"0.1.3"},"versions":{"0.1.0":{"name":"@affanshahid/sql-mcp-server","version":"0.1.0","_id":"@affanshahid/sql-mcp-server@0.1.0","maintainers":[{"name":"affanshahid","email":"affan.shahid.94@gmail.com"}],"homepage":"https://github.com/affanshahid/sql-mcp-server#readme","bugs":{"url":"https://github.com/affanshahid/sql-mcp-server/issues"},"bin":{"sql-mcp-server":"run-sql-mcp-server.js"},"dist":{"shasum":"301480ffcdb0292d656668137367c6128ccb9b3d","tarball":"https://registry.npmjs.org/@affanshahid/sql-mcp-server/-/sql-mcp-server-0.1.0.tgz","fileCount":10,"integrity":"sha512-HMTNXeLz94DLrrd3jGdzdpaBYrnI5P+vQ1fLU7GpmjV92xe/tIUraa3G/0o/o4ArJ+KYHcpn57ZQk8XUmYC6DA==","signatures":[{"sig":"MEYCIQDpupg38NJ3n9l3HdEtPNrbHdvkNnwCqKTLX24Zeo2gsAIhALGA9cGXHqoeDRpBfITSJBKeFW+fu9vFNPM07DxuK4DF","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":21466},"_from":"file:sql-mcp-server-npm-package.tar.gz","volta":{"npm":"9.5.0","node":"18.14.1"},"engines":{"npm":">=6","node":">=14.14"},"scripts":{"fmt":"prettier --write **/*.js","fmt:check":"prettier --check **/*.js","postinstall":"node ./install.js"},"_npmUser":{"name":"affanshahid","email":"affan.shahid.94@gmail.com"},"_resolved":"/Users/affan/Development/sql-mcp-server/sql-mcp-server-npm-package.tar.gz","_integrity":"sha512-HMTNXeLz94DLrrd3jGdzdpaBYrnI5P+vQ1fLU7GpmjV92xe/tIUraa3G/0o/o4ArJ+KYHcpn57ZQk8XUmYC6DA==","repository":{"url":"git+https://github.com/affanshahid/sql-mcp-server.git","type":"git"},"_npmVersion":"10.9.4","description":"An MCP server for connecting to and running queries on SQL databases. Supports built-in SSH tunneling","directories":{},"_nodeVersion":"22.22.0","dependencies":{"detect-libc":"^2.1.2"},"glibcMinimum":{"major":2,"series":35},"_hasShrinkwrap":true,"devDependencies":{"prettier":"^3.8.3"},"preferUnplugged":true,"supportedPlatforms":{"x86_64-apple-darwin":{"bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz","artifactName":"sql-mcp-server-x86_64-apple-darwin.tar.xz"},"aarch64-apple-darwin":{"bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz","artifactName":"sql-mcp-server-aarch64-apple-darwin.tar.xz"},"x86_64-pc-windows-gnu":{"bins":{"sql-mcp-server":"sql-mcp-server.exe"},"zipExt":".zip","artifactName":"sql-mcp-server-x86_64-pc-windows-msvc.zip"},"x86_64-pc-windows-msvc":{"bins":{"sql-mcp-server":"sql-mcp-server.exe"},"zipExt":".zip","artifactName":"sql-mcp-server-x86_64-pc-windows-msvc.zip"},"aarch64-pc-windows-msvc":{"bins":{"sql-mcp-server":"sql-mcp-server.exe"},"zipExt":".zip","artifactName":"sql-mcp-server-x86_64-pc-windows-msvc.zip"},"x86_64-unknown-linux-gnu":{"bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz","artifactName":"sql-mcp-server-x86_64-unknown-linux-gnu.tar.xz"},"aarch64-unknown-linux-gnu":{"bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz","artifactName":"sql-mcp-server-aarch64-unknown-linux-gnu.tar.xz"}},"artifactDownloadUrls":["https://github.com/affanshahid/sql-mcp-server/releases/download/v0.1.0"],"_npmOperationalInternal":{"tmp":"tmp/sql-mcp-server_0.1.0_1781366425956_0.48197601051440686","host":"s3://npm-registry-packages-npm-production"}},"0.1.1":{"name":"@affanshahid/sql-mcp-server","version":"0.1.1","_id":"@affanshahid/sql-mcp-server@0.1.1","maintainers":[{"name":"affanshahid","email":"affan.shahid.94@gmail.com"}],"homepage":"https://github.com/affanshahid/sql-mcp-server#readme","bugs":{"url":"https://github.com/affanshahid/sql-mcp-server/issues"},"bin":{"sql-mcp-server":"run-sql-mcp-server.js"},"dist":{"shasum":"6631c747665d611eebfb64d3507ae3b2462bb188","tarball":"https://registry.npmjs.org/@affanshahid/sql-mcp-server/-/sql-mcp-server-0.1.1.tgz","fileCount":10,"integrity":"sha512-b33ev4cWog7v+Uw+MF//txSix9W69QJ+ZFHeir6GQ08DyipNyN4/ZLCyMEKGgs6iHPv41GPyson02gUHAR42wA==","signatures":[{"sig":"MEUCIAsJ2wnNVlqONDI5Yul7ARqJNNm8iXKQpk2Km24LY3CCAiEAyegaz/T4fxr2+oMIDrS2Dm6/Y1Apfdfj2/YfCPnodPQ=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":21726},"_from":"file:npm/sql-mcp-server-npm-package.tar.gz","volta":{"npm":"9.5.0","node":"18.14.1"},"engines":{"npm":">=6","node":">=14.14"},"scripts":{"fmt":"prettier --write **/*.js","fmt:check":"prettier --check **/*.js","postinstall":"node ./install.js"},"_npmUser":{"name":"affanshahid","email":"affan.shahid.94@gmail.com"},"_resolved":"/home/runner/work/sql-mcp-server/sql-mcp-server/npm/sql-mcp-server-npm-package.tar.gz","_integrity":"sha512-b33ev4cWog7v+Uw+MF//txSix9W69QJ+ZFHeir6GQ08DyipNyN4/ZLCyMEKGgs6iHPv41GPyson02gUHAR42wA==","repository":{"url":"git+https://github.com/affanshahid/sql-mcp-server.git","type":"git"},"_npmVersion":"10.8.2","description":"An MCP server for connecting to and running queries on SQL databases. Supports built-in SSH tunneling","directories":{},"_nodeVersion":"20.20.2","dependencies":{"detect-libc":"^2.1.2"},"glibcMinimum":{"major":2,"series":35},"_hasShrinkwrap":true,"devDependencies":{"prettier":"^3.8.3"},"preferUnplugged":true,"supportedPlatforms":{"x86_64-apple-darwin":{"bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz","artifactName":"sql-mcp-server-x86_64-apple-darwin.tar.xz"},"aarch64-apple-darwin":{"bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz","artifactName":"sql-mcp-server-aarch64-apple-darwin.tar.xz"},"x86_64-pc-windows-gnu":{"bins":{"sql-mcp-server":"sql-mcp-server.exe"},"zipExt":".zip","artifactName":"sql-mcp-server-x86_64-pc-windows-msvc.zip"},"x86_64-pc-windows-msvc":{"bins":{"sql-mcp-server":"sql-mcp-server.exe"},"zipExt":".zip","artifactName":"sql-mcp-server-x86_64-pc-windows-msvc.zip"},"aarch64-pc-windows-msvc":{"bins":{"sql-mcp-server":"sql-mcp-server.exe"},"zipExt":".zip","artifactName":"sql-mcp-server-x86_64-pc-windows-msvc.zip"},"x86_64-unknown-linux-gnu":{"bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz","artifactName":"sql-mcp-server-x86_64-unknown-linux-gnu.tar.xz"},"aarch64-unknown-linux-gnu":{"bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz","artifactName":"sql-mcp-server-aarch64-unknown-linux-gnu.tar.xz"}},"artifactDownloadUrls":["https://github.com/affanshahid/sql-mcp-server/releases/download/v0.1.1"],"_npmOperationalInternal":{"tmp":"tmp/sql-mcp-server_0.1.1_1781367458741_0.30721353754657477","host":"s3://npm-registry-packages-npm-production"}},"0.1.2":{"name":"@affanshahid/sql-mcp-server","version":"0.1.2","keywords":["mariadb","mcp","mysql","postgres","proxy","server","sql","sqlite","ssh","tunneling"],"_id":"@affanshahid/sql-mcp-server@0.1.2","maintainers":[{"name":"affanshahid","email":"affan.shahid.94@gmail.com"}],"homepage":"https://github.com/affanshahid/sql-mcp-server#readme","bugs":{"url":"https://github.com/affanshahid/sql-mcp-server/issues"},"bin":{"sql-mcp-server":"run-sql-mcp-server.js"},"dist":{"shasum":"c63fc2de0b089709a3494ce82dcbdd6aa29ceab5","tarball":"https://registry.npmjs.org/@affanshahid/sql-mcp-server/-/sql-mcp-server-0.1.2.tgz","fileCount":10,"integrity":"sha512-H8vFAb3eMqbMLtcKWKMiFL+eWIqfdXiyxkVBmIpxhS7twAcPOEaAz2un5lXeqWg+/30cQFWJHnyFcIyDLEC4/g==","signatures":[{"sig":"MEQCIBoWC22/VZhArI22DUKR5CCuqIZbT4CM0bCmDGDlyLtdAiA0jOCKakSKWdvsCObCe9sDo14xTQdSJS4wipOA9D7fLA==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":21905},"_from":"file:npm/sql-mcp-server-npm-package.tar.gz","volta":{"npm":"9.5.0","node":"18.14.1"},"engines":{"npm":">=6","node":">=14.14"},"scripts":{"fmt":"prettier --write **/*.js","fmt:check":"prettier --check **/*.js","postinstall":"node ./install.js"},"_npmUser":{"name":"affanshahid","email":"affan.shahid.94@gmail.com"},"_resolved":"/home/runner/work/sql-mcp-server/sql-mcp-server/npm/sql-mcp-server-npm-package.tar.gz","_integrity":"sha512-H8vFAb3eMqbMLtcKWKMiFL+eWIqfdXiyxkVBmIpxhS7twAcPOEaAz2un5lXeqWg+/30cQFWJHnyFcIyDLEC4/g==","repository":{"url":"git+https://github.com/affanshahid/sql-mcp-server.git","type":"git"},"_npmVersion":"10.8.2","description":"An MCP server for connecting to and running queries on SQL databases. Supports built-in SSH tunneling","directories":{},"_nodeVersion":"20.20.2","dependencies":{"detect-libc":"^2.1.2"},"glibcMinimum":{"major":2,"series":35},"_hasShrinkwrap":true,"devDependencies":{"prettier":"^3.8.3"},"preferUnplugged":true,"supportedPlatforms":{"x86_64-apple-darwin":{"bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz","artifactName":"sql-mcp-server-x86_64-apple-darwin.tar.xz"},"aarch64-apple-darwin":{"bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz","artifactName":"sql-mcp-server-aarch64-apple-darwin.tar.xz"},"x86_64-pc-windows-gnu":{"bins":{"sql-mcp-server":"sql-mcp-server.exe"},"zipExt":".zip","artifactName":"sql-mcp-server-x86_64-pc-windows-msvc.zip"},"x86_64-pc-windows-msvc":{"bins":{"sql-mcp-server":"sql-mcp-server.exe"},"zipExt":".zip","artifactName":"sql-mcp-server-x86_64-pc-windows-msvc.zip"},"aarch64-pc-windows-msvc":{"bins":{"sql-mcp-server":"sql-mcp-server.exe"},"zipExt":".zip","artifactName":"sql-mcp-server-x86_64-pc-windows-msvc.zip"},"x86_64-unknown-linux-gnu":{"bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz","artifactName":"sql-mcp-server-x86_64-unknown-linux-gnu.tar.xz"},"aarch64-unknown-linux-gnu":{"bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz","artifactName":"sql-mcp-server-aarch64-unknown-linux-gnu.tar.xz"}},"artifactDownloadUrls":["https://github.com/affanshahid/sql-mcp-server/releases/download/v0.1.2"],"_npmOperationalInternal":{"tmp":"tmp/sql-mcp-server_0.1.2_1782339421619_0.8224171656019743","host":"s3://npm-registry-packages-npm-production"}},"0.1.3":{"artifactDownloadUrls":["https://github.com/affanshahid/sql-mcp-server/releases/download/v0.1.3"],"bin":{"sql-mcp-server":"run-sql-mcp-server.js"},"dependencies":{"detect-libc":"^2.1.2"},"description":"An MCP server for connecting to and running queries on SQL databases. Supports built-in SSH tunneling","devDependencies":{"prettier":"^3.8.3"},"engines":{"node":">=14.14","npm":">=6"},"glibcMinimum":{"major":2,"series":35},"homepage":"https://github.com/affanshahid/sql-mcp-server#readme","keywords":["mcp","mysql","postgres","ssh","tunneling"],"name":"@affanshahid/sql-mcp-server","preferUnplugged":true,"repository":{"type":"git","url":"git+https://github.com/affanshahid/sql-mcp-server.git"},"scripts":{"fmt":"prettier --write **/*.js","fmt:check":"prettier --check **/*.js","postinstall":"node ./install.js"},"supportedPlatforms":{"aarch64-apple-darwin":{"artifactName":"sql-mcp-server-aarch64-apple-darwin.tar.xz","bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz"},"aarch64-pc-windows-msvc":{"artifactName":"sql-mcp-server-x86_64-pc-windows-msvc.zip","bins":{"sql-mcp-server":"sql-mcp-server.exe"},"zipExt":".zip"},"aarch64-unknown-linux-gnu":{"artifactName":"sql-mcp-server-aarch64-unknown-linux-gnu.tar.xz","bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz"},"x86_64-apple-darwin":{"artifactName":"sql-mcp-server-x86_64-apple-darwin.tar.xz","bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz"},"x86_64-pc-windows-gnu":{"artifactName":"sql-mcp-server-x86_64-pc-windows-msvc.zip","bins":{"sql-mcp-server":"sql-mcp-server.exe"},"zipExt":".zip"},"x86_64-pc-windows-msvc":{"artifactName":"sql-mcp-server-x86_64-pc-windows-msvc.zip","bins":{"sql-mcp-server":"sql-mcp-server.exe"},"zipExt":".zip"},"x86_64-unknown-linux-gnu":{"artifactName":"sql-mcp-server-x86_64-unknown-linux-gnu.tar.xz","bins":{"sql-mcp-server":"sql-mcp-server"},"zipExt":".tar.xz"}},"version":"0.1.3","volta":{"node":"18.14.1","npm":"9.5.0"},"_id":"@affanshahid/sql-mcp-server@0.1.3","bugs":{"url":"https://github.com/affanshahid/sql-mcp-server/issues"},"_integrity":"sha512-ZK8nQ3/vF8uN8+07GgYSzN1PfIej0Bq2qTNG+0y1pIKrVysLvnUEDvqejd+gUnZ0xZrCWE/8ATPYa7eLdmBy8w==","_resolved":"/home/runner/work/sql-mcp-server/sql-mcp-server/npm/sql-mcp-server-npm-package.tar.gz","_from":"file:npm/sql-mcp-server-npm-package.tar.gz","_nodeVersion":"20.20.2","_npmVersion":"10.8.2","dist":{"integrity":"sha512-ZK8nQ3/vF8uN8+07GgYSzN1PfIej0Bq2qTNG+0y1pIKrVysLvnUEDvqejd+gUnZ0xZrCWE/8ATPYa7eLdmBy8w==","shasum":"1b7a5683f8a51de19b0ac330797f2efd34d1e55c","tarball":"https://registry.npmjs.org/@affanshahid/sql-mcp-server/-/sql-mcp-server-0.1.3.tgz","fileCount":10,"unpackedSize":21838,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIQC1kzuT6MGBeZY1lxHVjoOAKuSGKlXpdXeNLl1L8TQq8gIgYXKvhTq1jTdeRv9YIwFULuA5gsrms1Qwf078Be4FOZQ="}]},"_npmUser":{"name":"affanshahid","email":"affan.shahid.94@gmail.com"},"directories":{},"maintainers":[{"name":"affanshahid","email":"affan.shahid.94@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/sql-mcp-server_0.1.3_1783287892009_0.732302796749283"},"_hasShrinkwrap":true}},"time":{"created":"2026-06-13T16:00:25.841Z","modified":"2026-07-05T21:44:52.284Z","0.1.0":"2026-06-13T16:00:26.112Z","0.1.1":"2026-06-13T16:17:38.872Z","0.1.2":"2026-06-24T22:17:01.773Z","0.1.3":"2026-07-05T21:44:52.154Z"},"bugs":{"url":"https://github.com/affanshahid/sql-mcp-server/issues"},"homepage":"https://github.com/affanshahid/sql-mcp-server#readme","keywords":["mcp","mysql","postgres","ssh","tunneling"],"repository":{"type":"git","url":"git+https://github.com/affanshahid/sql-mcp-server.git"},"description":"An MCP server for connecting to and running queries on SQL databases. Supports built-in SSH tunneling","maintainers":[{"name":"affanshahid","email":"affan.shahid.94@gmail.com"}],"readme":"# SQL MCP Server\n\nAn MCP server for connecting to and running queries on SQL databases. **Supports built-in SSH tunneling.**\n\nSupported databases: MySQL, MariaDB, PostgreSQL, SQLite.\n\n## Install\n\n**Run Directly**\n\n```sh\nnpx -y @affanshahid/sql-mcp-server\n```\n\n**npm**\n\n```sh\nnpm install -g @affanshahid/sql-mcp-server\n```\n\n**Shell (macOS / Linux)**\n\n```sh\ncurl --proto '=https' --tlsv1.2 -LsSf https://github.com/affanshahid/sql-mcp-server/releases/latest/download/sql-mcp-server-installer.sh | sh\n```\n\n**PowerShell (Windows)**\n\n```sh\npowershell -ExecutionPolicy Bypass -c \"irm https://github.com/affanshahid/sql-mcp-server/releases/latest/download/sql-mcp-server-installer.ps1 | iex\"\n```\n\n**Build From Source**\n\n```sh\ncargo install sql-mcp-server --locked\n```\n\n## Usage\n\n```json\n{\n  \"mcpServers\": {\n    \"sql\": {\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"@affanshahid/sql-mcp-server\"],\n      \"env\": {\n        \"DATABASE_URL\": \"postgres://user:pass@host:5432/dbname\"\n      }\n    }\n  }\n}\n```\n\n## SSH tunneling\n\nTo reach a database that isn't directly accessible, supply SSH options and the server will open a local forward and connect through it:\n\n```json\n{\n  \"mcpServers\": {\n    \"sql\": {\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"@affanshahid/sql-mcp-server\"],\n      \"env\": {\n        \"DATABASE_URL\": \"postgres://user:pass@db.internal:5432/dbname\",\n        \"SSH_HOST\": \"bastion.example.com\",\n        \"SSH_USERNAME\": \"deploy\",\n        \"SSH_PRIVATE_KEY\": \"/home/you/.ssh/id_ed25519\"\n      }\n    }\n  }\n}\n```\n\nAuthentication also accepts a password (`SSH_PASSWORD`) instead.\n\n## Permissions\n\nBy default only `SELECT` is allowed. Use `DATABASE_OPERATIONS` to permit more:\n\n```json\n{\n  \"mcpServers\": {\n    \"sql\": {\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"@affanshahid/sql-mcp-server\"],\n      \"env\": {\n        \"DATABASE_URL\": \"postgres://user:pass@host:5432/dbname\",\n        \"DATABASE_OPERATIONS\": \"select,insert,update\"\n      }\n    }\n  }\n}\n```\n\nPossible values: `select`, `insert`, `update`, `delete`, `ddl`.\n\nAdditional guards (off by default):\n\n- `DENY_LIMITLESS_SELECT` — reject `SELECT` without `LIMIT`.\n- `DENY_BOUNDLESS_UPDATE` — reject `UPDATE` without `WHERE`.\n- `DENY_BOUNDLESS_DELETE` — reject `DELETE` without `WHERE`.\n\n## Configuration reference\n\nEvery option can be set as either a CLI flag or an environment variable.\n\n| Flag                      | Env                     | Default  |\n| ------------------------- | ----------------------- | -------- |\n| `-d`, `--database-url`    | `DATABASE_URL`          | —        |\n| `-o`, `--operations`      | `DATABASE_OPERATIONS`   | `select` |\n| `--deny-limitless-select` | `DENY_LIMITLESS_SELECT` | `false`  |\n| `--deny-boundless-update` | `DENY_BOUNDLESS_UPDATE` | `false`  |\n| `--deny-boundless-delete` | `DENY_BOUNDLESS_DELETE` | `false`  |\n| `-H`, `--host`            | `SSH_HOST`              | —        |\n| `-P`, `--port`            | `SSH_PORT`              | `22`     |\n| `-u`, `--username`        | `SSH_USERNAME`          | —        |\n| `-p`, `--password`        | `SSH_PASSWORD`          | —        |\n| `-i`, `--private-key`     | `SSH_PRIVATE_KEY`       | —        |\n","readmeFilename":"README.md"}