{"_id":"@ainetwork/mssql-mcp-server","_rev":"7-6916886c1f4e4feb2ddacf52cbca4ffb","name":"@ainetwork/mssql-mcp-server","dist-tags":{"latest":"0.6.7"},"versions":{"0.6.1":{"name":"@ainetwork/mssql-mcp-server","version":"0.6.1","keywords":["mcp","sql-server","mssql","database","ai","claude","windsurf","model-context-protocol"],"author":{"name":"Connor England","email":"connor.r.england@gmail.com"},"license":"MIT","_id":"@ainetwork/mssql-mcp-server@0.6.1","maintainers":[{"name":"dev_ainetwork","email":"dev@ainetwork.ai"}],"homepage":"https://github.com/ainetwork-ai/mssql-mcp-server","bugs":{"url":"https://github.com/ainetwork-ai/mssql-mcp-server/issues"},"bin":{"mssql-mcp-server":"dist/index.js"},"dist":{"shasum":"13ecf9b2a626b2fd098f8508330b23e33dbaf9cb","tarball":"https://registry.npmjs.org/@ainetwork/mssql-mcp-server/-/mssql-mcp-server-0.6.1.tgz","fileCount":6,"integrity":"sha512-hONy8mTMLy/anVVDTiWeENo5ZOrDqf3xyvxzO3dsO7DxslePARw4vQozgBd638uD7J1AkAulZ8cMp1m/vYw2eg==","signatures":[{"sig":"MEQCIHRqMHH0YD++U3r07LQkUIjpMadeizxItVNHPcRdErX3AiAq7T3BAkqGz6T9ELd+i2XeS0c3EPD1p6IqtH0yRL44aw==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":5219},"main":"dist/index.js","type":"module","types":"./dist/index.d.ts","gitHead":"bac0a473d0377fc7783edee96224657dcf299509","scripts":{"build":"tsc && shx chmod +x dist/*.js","start":"node dist/index.js","watch":"tsc --watch","prepare":"npm run build"},"_npmUser":{"name":"dev_ainetwork","email":"dev@ainetwork.ai"},"repository":{"url":"git+https://github.com/ainetwork-ai/mssql-mcp-server.git","type":"git"},"_npmVersion":"11.12.1","description":"Model Context Protocol (MCP) server for Microsoft SQL Server - enterprise-ready schema discovery, profiling, and safe data operations","directories":{},"_nodeVersion":"25.9.0","dependencies":{"@ainetwork/mssql-mcp-core":"^0.6.1"},"_hasShrinkwrap":false,"devDependencies":{"shx":"^0.3.4","typescript":"^5.4.5","@types/node":"^20.14.2","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_0.6.1_1785207647072_0.814915388424043","host":"s3://npm-registry-packages-npm-production"}},"0.6.2":{"name":"@ainetwork/mssql-mcp-server","version":"0.6.2","keywords":["mcp","sql-server","mssql","database","ai","claude","windsurf","model-context-protocol"],"author":{"name":"Connor England","email":"connor.r.england@gmail.com"},"license":"MIT","_id":"@ainetwork/mssql-mcp-server@0.6.2","maintainers":[{"name":"dev_ainetwork","email":"dev@ainetwork.ai"}],"homepage":"https://github.com/ainetwork-ai/mssql-mcp-server","bugs":{"url":"https://github.com/ainetwork-ai/mssql-mcp-server/issues"},"bin":{"mssql-mcp-server":"dist/index.js"},"dist":{"shasum":"2c6a824b6de6a077548ccf9b0ec58cb661f6b236","tarball":"https://registry.npmjs.org/@ainetwork/mssql-mcp-server/-/mssql-mcp-server-0.6.2.tgz","fileCount":6,"integrity":"sha512-yQE3FWsjdFJlY/A7PXQFFlYfDIVwxQzL42FKqERj+K1uauZXsXZQfkpk32E1GHXjbC5V7D47K/Vi6iio0ukBrg==","signatures":[{"sig":"MEUCIQDmpqk+UQ+dpJryWIJA6XC1/YdGvK/o1/9CNYCKx8SU8wIgPyX5vu2vSGWWKM40JBzIKB0B77Nt768GGE3k6B0YtN4=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":5219},"main":"dist/index.js","type":"module","types":"./dist/index.d.ts","gitHead":"8ea95fd87f48e710e82a9481fd8121438310b9dd","scripts":{"build":"tsc && shx chmod +x dist/*.js","start":"node dist/index.js","watch":"tsc --watch","prepare":"npm run build"},"_npmUser":{"name":"dev_ainetwork","email":"dev@ainetwork.ai"},"repository":{"url":"git+https://github.com/ainetwork-ai/mssql-mcp-server.git","type":"git"},"_npmVersion":"11.12.1","description":"Model Context Protocol (MCP) server for Microsoft SQL Server - enterprise-ready schema discovery, profiling, and safe data operations","directories":{},"_nodeVersion":"25.9.0","dependencies":{"@ainetwork/mssql-mcp-core":"^0.6.2"},"_hasShrinkwrap":false,"devDependencies":{"shx":"^0.3.4","typescript":"^5.4.5","@types/node":"^20.14.2","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_0.6.2_1785212062244_0.3684730456677614","host":"s3://npm-registry-packages-npm-production"}},"0.6.3":{"name":"@ainetwork/mssql-mcp-server","version":"0.6.3","keywords":["mcp","sql-server","mssql","database","ai","claude","windsurf","model-context-protocol"],"author":{"name":"Connor England","email":"connor.r.england@gmail.com"},"license":"MIT","_id":"@ainetwork/mssql-mcp-server@0.6.3","maintainers":[{"name":"dev_ainetwork","email":"dev@ainetwork.ai"}],"homepage":"https://github.com/ainetwork-ai/mssql-mcp-server","bugs":{"url":"https://github.com/ainetwork-ai/mssql-mcp-server/issues"},"bin":{"mssql-mcp-server":"dist/index.js"},"dist":{"shasum":"d415df3110b4e5f5dc11018e620d44e0f16a0329","tarball":"https://registry.npmjs.org/@ainetwork/mssql-mcp-server/-/mssql-mcp-server-0.6.3.tgz","fileCount":6,"integrity":"sha512-ypcrFAjeQXqP6EGHK63mr+wcQPKc09refZX/+FCAWED6reL1ceC8t2QfykSztzW50Kt4ifvsJsKRy2lmKWcS3A==","signatures":[{"sig":"MEYCIQDLxUNu/+DAeuhOu1T88B5COs8Jn1UuKNG7HG85Ke4umQIhANW5OkIThYARUp5VjTzj9Y7zBzO/HsfiFcwpIx26zf3f","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":5219},"main":"dist/index.js","type":"module","types":"./dist/index.d.ts","gitHead":"e672a062d0e2766c9c394dd2f0a575e9feb6bbc5","scripts":{"build":"tsc && shx chmod +x dist/*.js","start":"node dist/index.js","watch":"tsc --watch","prepare":"npm run build"},"_npmUser":{"name":"dev_ainetwork","email":"dev@ainetwork.ai"},"repository":{"url":"git+https://github.com/ainetwork-ai/mssql-mcp-server.git","type":"git"},"_npmVersion":"11.12.1","description":"Model Context Protocol (MCP) server for Microsoft SQL Server - enterprise-ready schema discovery, profiling, and safe data operations","directories":{},"_nodeVersion":"25.9.0","dependencies":{"@ainetwork/mssql-mcp-core":"^0.6.3"},"_hasShrinkwrap":false,"devDependencies":{"shx":"^0.3.4","typescript":"^5.4.5","@types/node":"^20.14.2","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_0.6.3_1785213536965_0.41084739016244876","host":"s3://npm-registry-packages-npm-production"}},"0.6.4":{"name":"@ainetwork/mssql-mcp-server","version":"0.6.4","keywords":["mcp","sql-server","mssql","database","ai","claude","windsurf","model-context-protocol"],"author":{"name":"Connor England","email":"connor.r.england@gmail.com"},"license":"MIT","_id":"@ainetwork/mssql-mcp-server@0.6.4","maintainers":[{"name":"dev_ainetwork","email":"dev@ainetwork.ai"}],"homepage":"https://github.com/ainetwork-ai/mssql-mcp-server","bugs":{"url":"https://github.com/ainetwork-ai/mssql-mcp-server/issues"},"bin":{"mssql-mcp-server":"dist/index.js"},"dist":{"shasum":"b0bd88320d1b7a4054221589c086851e260c7a31","tarball":"https://registry.npmjs.org/@ainetwork/mssql-mcp-server/-/mssql-mcp-server-0.6.4.tgz","fileCount":6,"integrity":"sha512-PkHTpLBpG19ffL2EbNrTAtvbj+fXi7brb8aA/62nCdYdi6eh1btqERedW5WWrdama2e6k4gHPEgaaKGnMsv+Ww==","signatures":[{"sig":"MEQCIDGGVr+v0rFyxZexpGjiBYN0zQbxGJymBkHyfu1Gy+nMAiAwsObA1x6PlLZ/FU+AEcZnHDl2lUt5KR8YJl4TsOBX7Q==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":5219},"main":"dist/index.js","type":"module","types":"./dist/index.d.ts","gitHead":"5556b0da6324567d0198177c560dabf97229f952","scripts":{"build":"tsc && shx chmod +x dist/*.js","start":"node dist/index.js","watch":"tsc --watch","prepare":"npm run build"},"_npmUser":{"name":"dev_ainetwork","email":"dev@ainetwork.ai"},"repository":{"url":"git+https://github.com/ainetwork-ai/mssql-mcp-server.git","type":"git"},"_npmVersion":"11.12.1","description":"Model Context Protocol (MCP) server for Microsoft SQL Server - enterprise-ready schema discovery, profiling, and safe data operations","directories":{},"_nodeVersion":"25.9.0","dependencies":{"@ainetwork/mssql-mcp-core":"^0.6.4"},"_hasShrinkwrap":false,"devDependencies":{"shx":"^0.3.4","typescript":"^5.4.5","@types/node":"^20.14.2","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_0.6.4_1785214528381_0.25890083366051986","host":"s3://npm-registry-packages-npm-production"}},"0.6.5":{"name":"@ainetwork/mssql-mcp-server","version":"0.6.5","keywords":["mcp","sql-server","mssql","database","ai","claude","windsurf","model-context-protocol"],"author":{"name":"Connor England","email":"connor.r.england@gmail.com"},"license":"MIT","_id":"@ainetwork/mssql-mcp-server@0.6.5","maintainers":[{"name":"dev_ainetwork","email":"dev@ainetwork.ai"}],"homepage":"https://github.com/ainetwork-ai/mssql-mcp-server","bugs":{"url":"https://github.com/ainetwork-ai/mssql-mcp-server/issues"},"bin":{"mssql-mcp-server":"dist/index.js"},"dist":{"shasum":"dac3c05cdc34c4023c0fad88bfc1e81ed993c059","tarball":"https://registry.npmjs.org/@ainetwork/mssql-mcp-server/-/mssql-mcp-server-0.6.5.tgz","fileCount":6,"integrity":"sha512-TSfBW5zoFcekSR8fSMioR7/pPEXPUwsmV9SbGu2nYl7D17aFROcGGusAMipaTt1LbTCheXjUWoUCBmRnAKmCyw==","signatures":[{"sig":"MEQCID7rYTwDPI7sTiqrRIy7Qt8NRYLGHaMTC7gFgJPDH7ePAiAn6afA/A5L+WuF4TuWSpGqtj7hD6Cy8CtXE4wYhwhJzg==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":5219},"main":"dist/index.js","type":"module","types":"./dist/index.d.ts","gitHead":"0dad96b0cc592f7b5ca0ba9d3d2ad808c27b2516","scripts":{"build":"tsc && shx chmod +x dist/*.js","start":"node dist/index.js","watch":"tsc --watch","prepare":"npm run build"},"_npmUser":{"name":"dev_ainetwork","email":"dev@ainetwork.ai"},"repository":{"url":"git+https://github.com/ainetwork-ai/mssql-mcp-server.git","type":"git"},"_npmVersion":"11.12.1","description":"Model Context Protocol (MCP) server for Microsoft SQL Server - enterprise-ready schema discovery, profiling, and safe data operations","directories":{},"_nodeVersion":"25.9.0","dependencies":{"@ainetwork/mssql-mcp-core":"^0.6.5"},"_hasShrinkwrap":false,"devDependencies":{"shx":"^0.3.4","typescript":"^5.4.5","@types/node":"^20.14.2","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_0.6.5_1785217445253_0.4878306335624478","host":"s3://npm-registry-packages-npm-production"}},"0.6.6":{"name":"@ainetwork/mssql-mcp-server","version":"0.6.6","keywords":["mcp","sql-server","mssql","database","ai","claude","windsurf","model-context-protocol"],"author":{"name":"Connor England","email":"connor.r.england@gmail.com"},"license":"MIT","_id":"@ainetwork/mssql-mcp-server@0.6.6","maintainers":[{"name":"dev_ainetwork","email":"dev@ainetwork.ai"}],"homepage":"https://github.com/ainetwork-ai/mssql-mcp-server","bugs":{"url":"https://github.com/ainetwork-ai/mssql-mcp-server/issues"},"bin":{"mssql-mcp-server":"dist/index.js"},"dist":{"shasum":"0c3a5742a0d11781152fddf4f387ebe26386bee0","tarball":"https://registry.npmjs.org/@ainetwork/mssql-mcp-server/-/mssql-mcp-server-0.6.6.tgz","fileCount":6,"integrity":"sha512-WyO5W8xqr12g3VJn7LUQqHe8wZfSfaAswU5bjFg/P1tCbmLB8nQ56oF9kcrqw6gOVptD8v2XwE3hrcSHhoGj6g==","signatures":[{"sig":"MEUCIFt7BQzDpW6Azdk2/A01/QOYFT3PyLGu4+2IG/+YJUExAiEA5ImFEmgmZr3v66zLBjDPf3zh31Y3Ua73PXZ++re9cv4=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":5341},"main":"dist/index.js","type":"module","types":"./dist/index.d.ts","gitHead":"9af5c4dbd9d7bf58bd1955f698a83bdaddd93185","scripts":{"build":"tsc && shx chmod +x dist/*.js","start":"node dist/index.js","watch":"tsc --watch","prepare":"npm run build","pack:offline":"npm run build && tar -czf ../../mssql-mcp-server-${npm_package_version}-offline.tar.gz -C .. node"},"_npmUser":{"name":"dev_ainetwork","email":"dev@ainetwork.ai"},"repository":{"url":"git+https://github.com/ainetwork-ai/mssql-mcp-server.git","type":"git"},"_npmVersion":"11.12.1","description":"Model Context Protocol (MCP) server for Microsoft SQL Server - enterprise-ready schema discovery, profiling, and safe data operations","directories":{},"_nodeVersion":"25.9.0","dependencies":{"@ainetwork/mssql-mcp-core":"^0.6.6"},"_hasShrinkwrap":false,"devDependencies":{"shx":"^0.3.4","typescript":"^5.4.5","@types/node":"^20.14.2","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_0.6.6_1786098299272_0.8403775919938186","host":"s3://npm-registry-packages-npm-production"}},"0.6.7":{"name":"@ainetwork/mssql-mcp-server","version":"0.6.7","description":"Model Context Protocol (MCP) server for Microsoft SQL Server - enterprise-ready schema discovery, profiling, and safe data operations","keywords":["mcp","sql-server","mssql","database","ai","claude","windsurf","model-context-protocol"],"author":{"name":"Connor England","email":"connor.r.england@gmail.com"},"license":"MIT","repository":{"type":"git","url":"git+https://github.com/ainetwork-ai/mssql-mcp-server.git"},"homepage":"https://github.com/ainetwork-ai/mssql-mcp-server","bugs":{"url":"https://github.com/ainetwork-ai/mssql-mcp-server/issues"},"main":"dist/index.js","bin":{"mssql-mcp-server":"dist/index.js"},"scripts":{"build":"tsc && shx chmod +x dist/*.js","prepare":"npm run build","watch":"tsc --watch","start":"node dist/index.js","pack:offline":"npm run build && tar -czf ../../mssql-mcp-server-${npm_package_version}-offline.tar.gz -C .. node"},"devDependencies":{"@types/mssql":"^9.1.7","@types/node":"^20.14.2","shx":"^0.3.4","typescript":"^5.4.5"},"dependencies":{"@ainetwork/mssql-mcp-core":"^0.6.7"},"type":"module","gitHead":"3899470d1621de534d8e4142948bae8e0dcac44d","types":"./dist/index.d.ts","_id":"@ainetwork/mssql-mcp-server@0.6.7","_nodeVersion":"25.9.0","_npmVersion":"11.12.1","dist":{"integrity":"sha512-cFecsQKLEeAMJwAyShq2pWCYRFeLRJpxcyzv3uG41/ap4DIb591HTqW8Q2A6FFB1fF8uRjEA9Z+uBY6lfylocA==","shasum":"fab93f6a97b4797f8e5c95ae6f2ccd4708d9fa87","tarball":"https://registry.npmjs.org/@ainetwork/mssql-mcp-server/-/mssql-mcp-server-0.6.7.tgz","fileCount":6,"unpackedSize":5341,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIAdKBAvwaTeT6ioTjVvH55a0iooRMQ23EZ91UeE24FkYAiEAgP6kpgaM32VDS3fTNPIzaLpoTjvsAS3evHHU2vpECYE="}]},"_npmUser":{"name":"dev_ainetwork","email":"dev@ainetwork.ai"},"directories":{},"maintainers":[{"name":"dev_ainetwork","email":"dev@ainetwork.ai"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mssql-mcp-server_0.6.7_1786337877017_0.7428108499430133"},"_hasShrinkwrap":false}},"time":{"created":"2026-07-28T03:00:46.973Z","modified":"2026-08-10T04:57:57.340Z","0.6.1":"2026-07-28T03:00:47.210Z","0.6.2":"2026-07-28T04:14:22.460Z","0.6.3":"2026-07-28T04:38:57.124Z","0.6.4":"2026-07-28T04:55:28.538Z","0.6.5":"2026-07-28T05:44:05.398Z","0.6.6":"2026-08-07T10:24:59.424Z","0.6.7":"2026-08-10T04:57:57.161Z"},"bugs":{"url":"https://github.com/ainetwork-ai/mssql-mcp-server/issues"},"author":{"name":"Connor England","email":"connor.r.england@gmail.com"},"license":"MIT","homepage":"https://github.com/ainetwork-ai/mssql-mcp-server","keywords":["mcp","sql-server","mssql","database","ai","claude","windsurf","model-context-protocol"],"repository":{"type":"git","url":"git+https://github.com/ainetwork-ai/mssql-mcp-server.git"},"description":"Model Context Protocol (MCP) server for Microsoft SQL Server - enterprise-ready schema discovery, profiling, and safe data operations","maintainers":[{"name":"dev_ainetwork","email":"dev@ainetwork.ai"}],"readme":"# MSSQL MCP Server\r\n\r\n[![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://opensource.org/licenses/MIT)\r\n\r\n**Enterprise-grade Model Context Protocol server for Microsoft SQL Server.**\r\n\r\nProduction-ready MCP server with 20 tools for schema discovery, data operations, profiling, and administration. Full governance controls for enterprise environments.\r\n\r\n## Package Tiers\r\n\r\n| Package | Tools | Use Case |\r\n|---------|-------|----------|\r\n| [@connorbritain/mssql-mcp-reader](https://www.npmjs.com/package/@connorbritain/mssql-mcp-reader) | 14 read-only | Analysts, auditors |\r\n| [@connorbritain/mssql-mcp-writer](https://www.npmjs.com/package/@connorbritain/mssql-mcp-writer) | 17 (reader + data ops) | Data engineers |\r\n| **@connorbritain/mssql-mcp-server** (this) | 20 (all tools) | DBAs, full admin |\r\n\r\n## Tools\r\n\r\n| Category | Tools |\r\n|----------|-------|\r\n| **Discovery** | `search_schema`, `describe_table`, `list_table`, `list_databases`, `list_environments` |\r\n| **Profiling** | `profile_table`, `inspect_relationships`, `inspect_dependencies`, `explain_query` |\r\n| **Data** | `read_data`, `insert_data`, `update_data`, `delete_data` |\r\n| **DDL** | `create_table`, `create_index`, `drop_table` |\r\n| **Scripts** | `list_scripts`, `run_script` |\r\n| **Operations** | `test_connection`, `validate_environment_config` |\r\n\r\n**[Config Builder](https://connorbritain.github.io/mssql-mcp-config-builder/)** — Visual wizard to generate your `mcp_config.json` and `environments.json` files.\r\n\r\n## Install\r\n\r\n```bash\r\nnpm install -g @connorbritain/mssql-mcp-server@latest\r\n```\r\n\r\n## MCP Client Config\r\n\r\n```json\r\n{\r\n  \"mcpServers\": {\r\n    \"mssql\": {\r\n      \"command\": \"npx\",\r\n      \"args\": [\"@connorbritain/mssql-mcp-server@latest\"],\r\n      \"env\": {\r\n        \"SERVER_NAME\": \"127.0.0.1\",\r\n        \"DATABASE_NAME\": \"mydb\",\r\n        \"SQL_AUTH_MODE\": \"sql\",\r\n        \"SQL_USERNAME\": \"sa\",\r\n        \"SQL_PASSWORD\": \"YourPassword123\"\r\n      }\r\n    }\r\n  }\r\n}\r\n```\r\n\r\n## Configuration\r\n\r\n| Variable | Required | Notes |\r\n|----------|----------|-------|\r\n| `SERVER_NAME` | Yes | SQL Server hostname/IP |\r\n| `DATABASE_NAME` | Yes | Target database |\r\n| `SQL_AUTH_MODE` | | `sql`, `windows`, or `aad` (default: `aad`) |\r\n| `SQL_USERNAME` / `SQL_PASSWORD` | | Required for `sql`/`windows` modes |\r\n| `READONLY` | | `true` disables write tools |\r\n| `ENVIRONMENTS_CONFIG_PATH` | | Multi-environment JSON config |\r\n| `SCRIPTS_PATH` | | Named SQL scripts directory |\r\n\r\n## Features\r\n\r\n- **Multi-environment support** - Named environments with per-environment policies\r\n- **Governance controls** - `allowedTools`, `deniedTools`, `allowedSchemas`, `deniedSchemas`\r\n- **Audit logging** - JSON Lines with session IDs and auto-redaction\r\n- **Secret management** - `${secret:NAME}` placeholders\r\n- **Safe mutations** - Preview/confirm for UPDATE and DELETE\r\n\r\n## Documentation\r\n\r\n**Full docs:** [github.com/ConnorBritain/mssql-mcp-server](https://github.com/ConnorBritain/mssql-mcp-server#readme)\r\n","readmeFilename":"README.md"}