{"_id":"@bluspace/mssql-mcp-server","_rev":"14-6c56da76a8f3d540c1c1444eae9142d9","name":"@bluspace/mssql-mcp-server","dist-tags":{"latest":"1.2.0"},"versions":{"1.0.0":{"name":"@bluspace/mssql-mcp-server","version":"1.0.0","_id":"@bluspace/mssql-mcp-server@1.0.0","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"bin":{"mssql-mcp-server":"build/index.js"},"dist":{"shasum":"96a2ec29bc1f377ecf2cb60bf294bc00e9992cad","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.0.0.tgz","fileCount":6,"integrity":"sha512-ttlaukIfGaKC44QVws0LOxOIIVVGe4gVKaAWNY+Z/NPJU9UoYE0cOft47k+DN+ue4Eih4iQGzvEKKPk2yd/D6Q==","signatures":[{"sig":"MEUCIAky/jlZXIZtYMQ6NoTVwIkqItQX+s0IjF3u4++AHOY4AiEAmY7OIP2yI2VV+GzQe/0FEzYhgiVsUUcHrsF6tz4AyU8=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":15373},"type":"module","scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","start":"node ./build/index.js","prepare":"npm run build"},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"_npmVersion":"10.9.2","description":"A Node.js-based command-line tool that acts as a Model Context Protocol (MCP) server for Microsoft SQL Server databases. This tool allows AI agents and other MCP-compatible clients to interact with SQL Server databases by inspecting schemas and performing","directories":{},"_nodeVersion":"22.14.0","dependencies":{"zod":"^3.24.4","mssql":"^10.0.1","commander":"^10.0.0","@modelcontextprotocol/sdk":"^1.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.0.0","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_1.0.0_1748527091173_0.4627839457538614","host":"s3://npm-registry-packages-npm-production"}},"1.0.1":{"name":"@bluspace/mssql-mcp-server","version":"1.0.1","_id":"@bluspace/mssql-mcp-server@1.0.1","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"bin":{"mssql-mcp-server":"build/index.js"},"dist":{"shasum":"61e02322165fe615dd8f658da147b23c48fa81c0","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.0.1.tgz","fileCount":6,"integrity":"sha512-Zgan2M+ax7w1NfOYNoNOSU0gTtAztYcihj72RBn4s/wXzwxPV6LDFr0JrfH09iQmoWbFoj9CMmDjbhloR0AwoA==","signatures":[{"sig":"MEYCIQDfVrqEX+KADXqlQXs4PuXXq9IuODp0Rlmw+EKawFH3uQIhAJRf+6yur0nQSDQ40+o9AYiNlO1n1qr+cmEsGNfxp71r","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":15490},"type":"module","scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","start":"node ./build/index.js","prepare":"npm run build"},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"_npmVersion":"10.9.2","description":"A Node.js-based command-line tool that acts as a Model Context Protocol (MCP) server for Microsoft SQL Server databases. This tool allows AI agents and other MCP-compatible clients to interact with SQL Server databases by inspecting schemas and performing","directories":{},"_nodeVersion":"22.14.0","dependencies":{"zod":"^3.24.4","mssql":"^10.0.4","commander":"^10.0.0","@modelcontextprotocol/sdk":"^1.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.0.0","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_1.0.1_1748530004885_0.46436495557524426","host":"s3://npm-registry-packages-npm-production"}},"1.0.2":{"name":"@bluspace/mssql-mcp-server","version":"1.0.2","_id":"@bluspace/mssql-mcp-server@1.0.2","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"bin":{"mssql-mcp-server":"build/index.js"},"dist":{"shasum":"1dee65ade7dd64dd5419de1a82cb3440c6fe4722","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.0.2.tgz","fileCount":6,"integrity":"sha512-8LpdnZBAFMmM3lQU3DbEvHQkiW4bgn3r5jxbT2f97EVe8c6agmbzntNCiUNtf5SRIapGGfoN70TQfgM3IZ4rKQ==","signatures":[{"sig":"MEUCIQCTew962GUDVGtS3yjRt4hDfBSjkb77RmEabT/ZdMj+gAIgT3dz1l/nJGAO2ltta+aIH8IgB/q6sTqJS95j8BQJQrY=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":15991},"type":"module","scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","start":"node ./build/index.js","prepare":"npm run build"},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"_npmVersion":"10.9.2","description":"A Node.js-based command-line tool that acts as a Model Context Protocol (MCP) server for Microsoft SQL Server databases. This tool allows AI agents and other MCP-compatible clients to interact with SQL Server databases by inspecting schemas and performing","directories":{},"_nodeVersion":"22.14.0","dependencies":{"zod":"^3.24.4","mssql":"^10.0.4","commander":"^10.0.0","@modelcontextprotocol/sdk":"^1.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.0.0","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_1.0.2_1748530411457_0.8819481080381326","host":"s3://npm-registry-packages-npm-production"}},"1.0.3":{"name":"@bluspace/mssql-mcp-server","version":"1.0.3","_id":"@bluspace/mssql-mcp-server@1.0.3","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"bin":{"mssql-mcp-server":"build/index.js"},"dist":{"shasum":"dc135e1ad01f1f315ffa84b9267bc9020543c874","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.0.3.tgz","fileCount":6,"integrity":"sha512-o2a3vbO8WWOlxzAIG0oRjgiTsgJbAPbsqbnrs7qldh3r14NJAAn/lQJOep5LrPN3RHG9bOsjxqq1Kon24eT2Jw==","signatures":[{"sig":"MEYCIQCzRRsYI58mDU3ruWi9s4rtuqdqSr26i2dUouIRrYKz+AIhANAm7kd0738Fpl1kJNEFQ8CDaULHxqvgJ/UZ25mXmBtl","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":16115},"type":"module","scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","start":"node ./build/index.js","prepare":"npm run build"},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"_npmVersion":"10.9.2","description":"A Node.js-based command-line tool that acts as a Model Context Protocol (MCP) server for Microsoft SQL Server databases. This tool allows AI agents and other MCP-compatible clients to interact with SQL Server databases by inspecting schemas and performing","directories":{},"_nodeVersion":"22.14.0","dependencies":{"zod":"^3.24.4","mssql":"^10.0.4","commander":"^10.0.0","@modelcontextprotocol/sdk":"^1.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.0.0","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_1.0.3_1748530721184_0.13483136498820358","host":"s3://npm-registry-packages-npm-production"}},"1.0.4":{"name":"@bluspace/mssql-mcp-server","version":"1.0.4","_id":"@bluspace/mssql-mcp-server@1.0.4","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"bin":{"mssql-mcp-server":"build/index.js"},"dist":{"shasum":"5ced8bcfc85804a23fd8a25bd90064a09116c2dd","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.0.4.tgz","fileCount":6,"integrity":"sha512-e2empIBruj2+LXAo2jOVuymqgGXBwZ/i8v1TI8UUa3mbDbOQ20is/bg6i2vIe6mm4GaBlQSXHIb2NBPPhZxTew==","signatures":[{"sig":"MEYCIQC1cIQV5O9GTe25gzULDxlLx+N6OyOb8JZXmDada8djEAIhAP5rpWWWkFTY9Ogij927aiExlMdegVWG1+D8zLfYYbK6","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":18008},"type":"module","gitHead":"5d40203bd2df5ebe4a8772a4f862d60736ae11d9","scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","start":"node ./build/index.js","prepare":"npm run build"},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"_npmVersion":"10.9.2","description":"A Node.js-based command-line tool that acts as a Model Context Protocol (MCP) server for Microsoft SQL Server databases. This tool allows AI agents and other MCP-compatible clients to interact with SQL Server databases by inspecting schemas and performing","directories":{},"_nodeVersion":"22.14.0","dependencies":{"zod":"^3.24.4","mssql":"^10.0.4","commander":"^10.0.0","@modelcontextprotocol/sdk":"^1.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.0.0","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_1.0.4_1748605746346_0.07837603545428196","host":"s3://npm-registry-packages-npm-production"}},"1.0.5":{"name":"@bluspace/mssql-mcp-server","version":"1.0.5","_id":"@bluspace/mssql-mcp-server@1.0.5","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"bin":{"mssql-mcp-server":"build/index.js"},"dist":{"shasum":"828a4a69024d8ea55730629e24bfa29d5028e030","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.0.5.tgz","fileCount":6,"integrity":"sha512-N3S8g0WQ2shfcILqiQcsWH5JMHuE85R3HTYOF2CGi9OdBd55gmBxG6PzJJ8PP/AGAmjSqAmniZ2fAMvOgMNllA==","signatures":[{"sig":"MEYCIQCT4PpOTxKBrwoHXWwBO7rnIVoeQNOLhMYzUZmbpUW00gIhAIdvqiiUBmGda0PQR6VDsdsOEcGWzeqtfkE+GphSxnzK","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":16125},"type":"module","gitHead":"6755e7e6ff4db3330d06d3d804a8826179cc56e2","scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","start":"node ./build/index.js","prepare":"npm run build"},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"_npmVersion":"11.4.1","description":"A Node.js-based command-line tool that acts as a Model Context Protocol (MCP) server for Microsoft SQL Server databases. This tool allows AI agents and other MCP-compatible clients to interact with SQL Server databases by inspecting schemas and performing","directories":{},"_nodeVersion":"22.16.0","dependencies":{"zod":"^3.24.4","mssql":"^10.0.4","commander":"^10.0.0","@modelcontextprotocol/sdk":"^1.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.0.0","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_1.0.5_1748866062027_0.6372317095937703","host":"s3://npm-registry-packages-npm-production"}},"1.0.6":{"name":"@bluspace/mssql-mcp-server","version":"1.0.6","_id":"@bluspace/mssql-mcp-server@1.0.6","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"bin":{"mssql-mcp-server":"build/index.js"},"dist":{"shasum":"fc1ae0f9dd082acd7321763e84d1c5d946dbfe13","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.0.6.tgz","fileCount":6,"integrity":"sha512-CEAMif/gCeMVkUyPZIw5fe+leXwp8Zu5TYhDw8VQZOJM8dj9pyO8ezKGOTCnkJPik3qxKddjh6LgpdGMhFYORQ==","signatures":[{"sig":"MEUCIEs6HFkIGm+CQPx+sSr2QOSmacw02YXyiIfNlUKd7Q7JAiEAkDF2ABFfAbpzoAYmYv60yJ0v24gciVc2CINSXIEqT9I=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":16050},"type":"module","gitHead":"5bd25d6e8108117d807b26e675a56cef8abcde88","scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","start":"node ./build/index.js","prepare":"npm run build"},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"_npmVersion":"11.4.1","description":"A Node.js-based command-line tool that acts as a Model Context Protocol (MCP) server for Microsoft SQL Server databases. This tool allows AI agents and other MCP-compatible clients to interact with SQL Server databases by inspecting schemas and performing","directories":{},"_nodeVersion":"22.16.0","dependencies":{"zod":"^3.24.4","mssql":"^10.0.4","commander":"^10.0.0","@modelcontextprotocol/sdk":"^1.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.0.0","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_1.0.6_1748872612980_0.4382755339712434","host":"s3://npm-registry-packages-npm-production"}},"1.0.7":{"name":"@bluspace/mssql-mcp-server","version":"1.0.7","_id":"@bluspace/mssql-mcp-server@1.0.7","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"bin":{"mssql-mcp-server":"build/index.js"},"dist":{"shasum":"99cfe6c9af40f39f4994d39dcb73b4e505d8691d","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.0.7.tgz","fileCount":6,"integrity":"sha512-Ijhc8ET74u/Nes3Fghy71L9j9r+ZAAh4iPc1TtttZ1hugxDbF4qz1gXccAeaoc8XLs1gp4S0BS6qnJwIDz9ocA==","signatures":[{"sig":"MEYCIQDrmhKIBeAYM2PqDNIXSN6gAHzNBOFCi0KtVJZDxOUJJAIhAKXYSiG5GmlLv7UNpl9ZltfcrzG9xycUHqkkfL0hmWzC","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":16040},"type":"module","gitHead":"a0b6e303de289aafff8f44262e163828d7aa4d8c","scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","start":"node ./build/index.js","prepare":"npm run build"},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"_npmVersion":"11.4.1","description":"A Node.js-based command-line tool that acts as a Model Context Protocol (MCP) server for Microsoft SQL Server databases. This tool allows AI agents and other MCP-compatible clients to interact with SQL Server databases by inspecting schemas and performing","directories":{},"_nodeVersion":"22.16.0","dependencies":{"zod":"^3.24.4","mssql":"^10.0.4","commander":"^10.0.0","@modelcontextprotocol/sdk":"^1.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.0.0","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_1.0.7_1748879061988_0.026004094491650864","host":"s3://npm-registry-packages-npm-production"}},"1.0.8":{"name":"@bluspace/mssql-mcp-server","version":"1.0.8","_id":"@bluspace/mssql-mcp-server@1.0.8","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"bin":{"mssql-mcp-server":"build/index.js"},"dist":{"shasum":"5aff01c9c03f34a258b2ef47d9153821e903e13d","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.0.8.tgz","fileCount":6,"integrity":"sha512-JKTFRVqgdjMlmFgmxUXb1nCjFmOgKIBP9ipspvsVLZ0dHwUjOrss4hN4eB/2Q95p5K2A8IcW3BmBJGMdwD8qLA==","signatures":[{"sig":"MEYCIQCVsAw1cVdQw3vD0sKnDSHdD/rVLjiusULoGm3xtCLXJgIhAOhysHsvJZVoyURZHrll5VFtHlF28dA/fkl2ThmsRNAM","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":16041},"type":"module","gitHead":"6bc9776693270a0a5ad5945a19ce479de28ae33b","scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","start":"node ./build/index.js","prepare":"npm run build"},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"_npmVersion":"11.4.1","description":"A Node.js-based command-line tool that acts as a Model Context Protocol (MCP) server for Microsoft SQL Server databases. This tool allows AI agents and other MCP-compatible clients to interact with SQL Server databases by inspecting schemas and performing","directories":{},"_nodeVersion":"22.16.0","dependencies":{"zod":"^3.24.4","mssql":"^10.0.4","commander":"^10.0.0","@modelcontextprotocol/sdk":"^1.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.0.0","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_1.0.8_1748880262870_0.6607265436007042","host":"s3://npm-registry-packages-npm-production"}},"1.0.9":{"name":"@bluspace/mssql-mcp-server","version":"1.0.9","_id":"@bluspace/mssql-mcp-server@1.0.9","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"bin":{"mssql-mcp-server":"build/index.js"},"dist":{"shasum":"55a5623ed4648520298641645ff27e22725175b6","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.0.9.tgz","fileCount":6,"integrity":"sha512-8oneyoy249OGf0ZB6fbVbJvULjvIVls8PTaX3tYfE39Ujdd0aUvbsig1NEbKcn1evgNZ8mj5TK+W/9q/flGxJw==","signatures":[{"sig":"MEYCIQCA97qQZpuI8Ota9M3m8fuWBZ2FBHPzJw2Yr6Q2dBlG2QIhAJDyElMaar9io/b/bfCP2JTDigfx1t6NsR4+CODTUKPT","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":16041},"type":"module","gitHead":"6bc9776693270a0a5ad5945a19ce479de28ae33b","scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","start":"node ./build/index.js","prepare":"npm run build"},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"_npmVersion":"11.4.1","description":"A Node.js-based command-line tool that acts as a Model Context Protocol (MCP) server for Microsoft SQL Server databases. This tool allows AI agents and other MCP-compatible clients to interact with SQL Server databases by inspecting schemas and performing","directories":{},"_nodeVersion":"22.16.0","dependencies":{"zod":"^3.24.4","mssql":"^10.0.4","commander":"^10.0.0","@modelcontextprotocol/sdk":"^1.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.0.0","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_1.0.9_1748944893137_0.7443111704976899","host":"s3://npm-registry-packages-npm-production"}},"1.0.10":{"name":"@bluspace/mssql-mcp-server","version":"1.0.10","_id":"@bluspace/mssql-mcp-server@1.0.10","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"bin":{"mssql-mcp-server":"build/index.js"},"dist":{"shasum":"21172f86f6ebb9f3ddab29eaf0b47d3fe8c159d8","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.0.10.tgz","fileCount":6,"integrity":"sha512-005kA7RN8+6uujMitJSbVpOq5w53V/Y2jGbB2QeziIQyTKieq0XLVREzmsIZyEzFAlgWeJE//bjut4fERbXa5Q==","signatures":[{"sig":"MEUCIE/DT9FIsmwPRP+gQRZvaoDCG4/53Cqe1k0rIrMG4zbaAiEAobcWcoJnptqyfSJpNhwX7Qzy2Mkeqzwbi0teOYDk3gs=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":17032},"type":"module","gitHead":"6bc9776693270a0a5ad5945a19ce479de28ae33b","scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","start":"node ./build/index.js","prepare":"npm run build"},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"_npmVersion":"11.4.1","description":"A Node.js-based command-line tool that acts as a Model Context Protocol (MCP) server for Microsoft SQL Server databases. This tool allows AI agents and other MCP-compatible clients to interact with SQL Server databases by inspecting schemas and performing","directories":{},"_nodeVersion":"22.16.0","dependencies":{"zod":"^3.24.4","mssql":"^10.0.4","commander":"^10.0.0","@modelcontextprotocol/sdk":"^1.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.0.0","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_1.0.10_1748950793377_0.2717814501055207","host":"s3://npm-registry-packages-npm-production"}},"1.1.0":{"name":"@bluspace/mssql-mcp-server","version":"1.1.0","keywords":["mcp","model-context-protocol","sql-server","mssql","database","ai","claude","anthropic"],"author":{"name":"Bluspace"},"license":"MIT","_id":"@bluspace/mssql-mcp-server@1.1.0","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"homepage":"https://github.com/bluspace/mssql-mcp-server#readme","bugs":{"url":"https://github.com/bluspace/mssql-mcp-server/issues"},"bin":{"mssql-mcp-server":"build/index.js"},"dist":{"shasum":"d5afe1492862d5655178d637b3cd2ecce0f591e5","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.1.0.tgz","fileCount":11,"integrity":"sha512-Ti+CEan3ebdfszXVGKwI3nNx2w+XMc3vl/rgG7F+j5M8pKtHRHt4gr96DMD5QQkk9ADOcQzBa5QtInnN1i6nHg==","signatures":[{"sig":"MEUCIB/ax/yTwFGxtp4TCuXSbNZt/TVbHG7eQnH11nMHCvdhAiEAtevRu62CSvstziW1Ae1W4rW3pVn7YP6pM/fnMxotDgo=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":89496},"type":"module","engines":{"node":">=16.0.0"},"gitHead":"191caf12d59a59582376ac984926b1b74e07d063","scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","start":"node ./build/index.js","prepare":"npm run build"},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"repository":{"url":"git+https://github.com/bluspace/mssql-mcp-server.git","type":"git"},"_npmVersion":"11.4.1","description":"Microsoft SQL Server MCP (Model Context Protocol) Server - AI-powered database interaction tool","directories":{},"_nodeVersion":"22.16.0","dependencies":{"zod":"^3.24.4","mssql":"^10.0.4","commander":"^10.0.0","@modelcontextprotocol/sdk":"^1.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.0.0","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_1.1.0_1749051896154_0.47782608762127077","host":"s3://npm-registry-packages-npm-production"}},"1.1.1":{"name":"@bluspace/mssql-mcp-server","version":"1.1.1","keywords":["mcp","model-context-protocol","sql-server","mssql","database","ai","claude","anthropic"],"author":{"name":"Bluspace"},"license":"MIT","_id":"@bluspace/mssql-mcp-server@1.1.1","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"homepage":"https://github.com/bluspace/mssql-mcp-server#readme","bugs":{"url":"https://github.com/bluspace/mssql-mcp-server/issues"},"bin":{"mssql-mcp-server":"build/index.js"},"dist":{"shasum":"a3b4b714dd510f148cd386e89e2a714c81b998e0","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.1.1.tgz","fileCount":11,"integrity":"sha512-9HSP++2lQGTYeCgWZwa962S71hw3ZUYSetZPFzALgTIHLnVywU6fd83uVaL1ICMXY5VOHnbCZYlg98qRhlpEuA==","signatures":[{"sig":"MEUCIQDhPnX91Z7aZzOh+EmTAcvykcGZ7vlObpdva2xXU8zFeQIgerxE0lftv/TEhjUhi2KJMxX2NCoKYVY8Hq2uT6CHMmo=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":97420},"type":"module","engines":{"node":">=16.0.0"},"gitHead":"191caf12d59a59582376ac984926b1b74e07d063","scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","start":"node ./build/index.js","prepare":"npm run build"},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"repository":{"url":"git+https://github.com/bluspace/mssql-mcp-server.git","type":"git"},"_npmVersion":"11.4.1","description":"Microsoft SQL Server MCP (Model Context Protocol) Server - AI-powered database interaction tool","directories":{},"_nodeVersion":"22.16.0","dependencies":{"zod":"^3.24.4","mssql":"^10.0.4","commander":"^10.0.0","@modelcontextprotocol/sdk":"^1.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.0.0","@types/mssql":"^9.1.7"},"_npmOperationalInternal":{"tmp":"tmp/mssql-mcp-server_1.1.1_1749052819333_0.42200938516000597","host":"s3://npm-registry-packages-npm-production"}},"1.2.0":{"name":"@bluspace/mssql-mcp-server","version":"1.2.0","description":"Microsoft SQL Server MCP (Model Context Protocol) Server - AI-powered database interaction tool","keywords":["mcp","model-context-protocol","sql-server","mssql","database","ai","claude","anthropic"],"author":{"name":"Bluspace"},"license":"MIT","repository":{"type":"git","url":"git+https://github.com/bluspace/mssql-mcp-server.git"},"bugs":{"url":"https://github.com/bluspace/mssql-mcp-server/issues"},"homepage":"https://github.com/bluspace/mssql-mcp-server#readme","type":"module","bin":{"mssql-mcp-server":"build/index.js"},"scripts":{"build":"tsc && (node -e \"try { require('fs').chmodSync('./build/index.js', '755') } catch(e) { console.error(e) }\")","prepare":"npm run build","start":"node ./build/index.js"},"engines":{"node":">=16.0.0"},"dependencies":{"@modelcontextprotocol/sdk":"^1.4.0","commander":"^10.0.0","mssql":"^10.0.4","zod":"^3.24.4"},"devDependencies":{"@types/mssql":"^9.1.7","@types/node":"^20.0.0","typescript":"^5.0.0"},"_id":"@bluspace/mssql-mcp-server@1.2.0","gitHead":"a38715714302a64365b3c1dff01e70c239e9caa6","_nodeVersion":"22.16.0","_npmVersion":"11.4.1","dist":{"integrity":"sha512-D5afdzzZ3lgPuks5z7S9lZbGhd97LPsEWZ4mwe+pPYM7NBiezsqzcWBdsU6VJsX8XBltmVr9PxEDoJEZOC34jg==","shasum":"e87371c8087e1c95010a219755c3a9a8b52b6e51","tarball":"https://registry.npmjs.org/@bluspace/mssql-mcp-server/-/mssql-mcp-server-1.2.0.tgz","fileCount":12,"unpackedSize":135754,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIQDOy56rd+b/aamdm/5w6qppEA85ag9wEzVTjYYVaXjgpQIgU0XawIUT7/AN+Cw0hRg6xvq8E1ozVAtbAJHaOkSqopk="}]},"_npmUser":{"name":"bluspace","email":"lee@iceblue.co.uk"},"directories":{},"maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mssql-mcp-server_1.2.0_1750066368946_0.4509708992552137"},"_hasShrinkwrap":false}},"time":{"created":"2025-05-29T13:58:11.032Z","modified":"2025-06-16T09:32:49.319Z","1.0.0":"2025-05-29T13:58:11.358Z","1.0.1":"2025-05-29T14:46:45.074Z","1.0.2":"2025-05-29T14:53:31.631Z","1.0.3":"2025-05-29T14:58:41.385Z","1.0.4":"2025-05-30T11:49:06.503Z","1.0.5":"2025-06-02T12:07:42.195Z","1.0.6":"2025-06-02T13:56:53.135Z","1.0.7":"2025-06-02T15:44:22.191Z","1.0.8":"2025-06-02T16:04:23.054Z","1.0.9":"2025-06-03T10:01:33.316Z","1.0.10":"2025-06-03T11:39:53.554Z","1.1.0":"2025-06-04T15:44:56.319Z","1.1.1":"2025-06-04T16:00:19.511Z","1.2.0":"2025-06-16T09:32:49.133Z"},"bugs":{"url":"https://github.com/bluspace/mssql-mcp-server/issues"},"author":{"name":"Bluspace"},"license":"MIT","homepage":"https://github.com/bluspace/mssql-mcp-server#readme","keywords":["mcp","model-context-protocol","sql-server","mssql","database","ai","claude","anthropic"],"repository":{"type":"git","url":"git+https://github.com/bluspace/mssql-mcp-server.git"},"description":"Microsoft SQL Server MCP (Model Context Protocol) Server - AI-powered database interaction tool","maintainers":[{"name":"bluspace","email":"lee@iceblue.co.uk"}],"readme":"# Microsoft SQL Server MCP Server\n\nA comprehensive Node.js-based Model Context Protocol (MCP) server for Microsoft SQL Server databases. This tool enables AI agents and MCP-compatible clients to interact with SQL Server databases through a rich set of tools for schema exploration, data manipulation, and advanced database operations.\n\n## Features\n\n### 🔍 Schema Exploration\n- **Comprehensive Discovery**: List schemas, tables, views, functions, stored procedures, triggers, indexes, and constraints\n- **Detailed Metadata**: Get row counts, column information, relationships, and more\n- **Pattern Matching**: Filter database objects using SQL wildcards\n\n### 📊 Data Operations  \n- **CRUD Operations**: Create, read, update, and delete rows with full transaction support\n- **Query Builder**: Build complex SQL queries programmatically without writing raw SQL\n- **Bulk Operations**: Efficient bulk insert, update, delete, and upsert operations\n- **Transaction Management**: Execute multiple operations atomically with isolation level control\n\n### 🚀 Advanced Features\n- **Stored Procedures**: Execute procedures with input/output parameters\n- **Performance**: Connection pooling and optimized batch operations\n- **Security**: Permission-based access control and parameterized queries to prevent SQL injection\n- **Easy Deployment**: Simple npm/npx installation\n\n## Installation\n\nYou can run this tool directly via `npx`:\n\n```bash\nnpx -y @bluspace/mssql-mcp-server \\\n  --user dbuser --password secret \\\n  --server localhost --port 1433 --database mydb \\\n  --permissions all\n```\n\n## Usage\n\nThe CLI accepts the following parameters:\n\n- `--user <string>` (required): Database user\n- `--password <string>` (required): Database password\n- `--server <string>` (required): SQL Server hostname or IP address\n- `--port <number>` (optional, default: \"1433\"): Database port\n- `--database <string>` (required): Database name\n- `--permissions <read|write|all>` (optional, default: \"all\"): Allowed operations\n\n## Available Tools\n\n### Schema Exploration Tools (available with `read` permissions)\n\n- `listSchemas`: List all schema names in the database\n- `readSchema`: Get detailed table and column information for schemas\n- `listTables`: List all tables with metadata (row counts, column counts)\n- `listViews`: List all views in the database\n- `listFunctions`: List user-defined functions (scalar and table-valued)\n- `listStoredProcedures`: List stored procedures with filtering options\n- `listIndexes`: Get detailed index information for a table\n- `listConstraints`: List constraints (PK, FK, CHECK, UNIQUE, DEFAULT)\n- `listTriggers`: List triggers with timing and event information\n- `getTableSchema`: Get complete table structure with all column details, keys, and metadata\n\n### Query Tools (available with `read` permissions)\n\n- `queryBuilder`: Build and execute complex SQL queries programmatically\n- `executeStoredProcedure`: Execute stored procedures with parameters\n- `getStoredProcedureInfo`: Get detailed information about a stored procedure\n\n### Data Manipulation Tools (available with `write` or `all` permissions)\n\n- `createRow`: Insert a new row into a table\n- `readRows`: Read rows with filtering (supports up to 100 rows by default)\n- `updateRow`: Update existing rows by primary key\n- `deleteRow`: Delete rows by primary key\n\n### Bulk Operations (available with `write` or `all` permissions)\n\n- `bulkInsert`: Efficiently insert multiple rows with batching\n- `bulkUpdate`: Update multiple rows in batches\n- `bulkDelete`: Delete multiple rows in batches\n- `bulkUpsert`: Insert or update using SQL Server MERGE\n\n### Transaction Tools (available with `write` or `all` permissions)\n\n- `executeTransaction`: Execute multiple operations in a single transaction\n- `beginTransaction`: Start a long-running transaction\n- `commitTransaction`: Commit an active transaction\n- `rollbackTransaction`: Rollback an active transaction\n\n### DDL (Data Definition Language) Tools (available with `write` or `all` permissions)\n\n- `createTable`: Create new tables with columns, constraints, and indexes\n- `alterTable`: Modify table structure (add/drop columns, constraints)\n- `dropTable`: Drop tables with optional IF EXISTS clause\n- `createIndex`: Create indexes with various options (unique, clustered, filtered, included columns)\n- `dropIndex`: Drop indexes from tables\n- `executeQuery`: Execute custom SQL queries with parameterized inputs (supports DDL, DML, and other operations)\n- `executeSqlBatch`: Execute multiple SQL statements in sequence with automatic transaction support\n\n## Examples\n\n### Query Builder\n```javascript\n// Complex query with joins and aggregations\nawait mcp.call(\"queryBuilder\", {\n  select: [\"c.CustomerName\", \"COUNT(o.OrderID) as OrderCount\", \"SUM(o.Total) as TotalSpent\"],\n  from: { table: \"Customers\", alias: \"c\" },\n  joins: [{\n    type: \"LEFT\",\n    table: \"Orders o\",\n    on: \"c.CustomerID = o.CustomerID\"\n  }],\n  where: [\n    { column: \"o.OrderDate\", operator: \">=\", value: \"2024-01-01\" },\n    { column: \"c.Country\", operator: \"IN\", values: [\"USA\", \"Canada\"] }\n  ],\n  groupBy: [\"c.CustomerID\", \"c.CustomerName\"],\n  having: \"COUNT(o.OrderID) > 5\",\n  orderBy: [{ column: \"TotalSpent\", direction: \"DESC\" }],\n  limit: 10\n});\n```\n\n### Bulk Operations\n```javascript\n// Bulk insert with validation\nawait mcp.call(\"bulkInsert\", {\n  table: \"Products\",\n  rows: productData, // Array of product objects\n  batchSize: 1000,\n  validateSchema: true\n});\n```\n\n### Schema Exploration\n```javascript\n// Discover foreign key relationships\nawait mcp.call(\"listConstraints\", {\n  table: \"Orders\",\n  type: \"FOREIGN KEY\"\n});\n\n// Find all tables with 'Customer' in the name\nawait mcp.call(\"listTables\", {\n  pattern: \"%Customer%\"\n});\n```\n\n### DDL Operations\n```javascript\n// Create a new table with various column types and constraints\nawait mcp.call(\"createTable\", {\n  table: \"Products\",\n  columns: [\n    {\n      name: \"ProductID\",\n      type: \"int\",\n      nullable: false,\n      identity: { seed: 1, increment: 1 },\n      primaryKey: true\n    },\n    {\n      name: \"ProductName\",\n      type: \"nvarchar(100)\",\n      nullable: false\n    },\n    {\n      name: \"Price\",\n      type: \"decimal(10,2)\",\n      nullable: false,\n      check: \"Price > 0\"\n    },\n    {\n      name: \"CategoryID\",\n      type: \"int\",\n      nullable: true,\n      references: {\n        table: \"Categories\",\n        column: \"CategoryID\",\n        onDelete: \"SET NULL\"\n      }\n    },\n    {\n      name: \"CreatedDate\",\n      type: \"datetime2\",\n      nullable: false,\n      default: \"GETDATE()\"\n    }\n  ],\n  constraints: {\n    uniqueKeys: [{\n      columns: [\"ProductName\"]\n    }],\n    checks: [{\n      expression: \"LEN(ProductName) > 0\",\n      name: \"CHK_ProductName_NotEmpty\"\n    }]\n  }\n});\n\n// Create an index with included columns\nawait mcp.call(\"createIndex\", {\n  indexName: \"IX_Products_CategoryPrice\",\n  table: \"Products\",\n  columns: [\n    { name: \"CategoryID\", direction: \"ASC\" },\n    { name: \"Price\", direction: \"DESC\" }\n  ],\n  include: [\"ProductName\"],\n  where: \"Price > 10\"\n});\n\n// Execute custom DDL using executeQuery\nawait mcp.call(\"executeQuery\", {\n  query: \"CREATE VIEW vw_ExpensiveProducts AS SELECT * FROM Products WHERE Price > 100\"\n});\n```\n\n### SQL Batch Execution\n```javascript\n// Execute multiple statements in a transaction (default behavior)\nawait mcp.call(\"executeSqlBatch\", {\n  statements: [\n    \"DELETE FROM OrderItems WHERE OrderID = 123\",\n    \"DELETE FROM Orders WHERE OrderID = 123\"\n  ]\n});\n\n// Execute with parameterized queries\nawait mcp.call(\"executeSqlBatch\", {\n  statements: [\n    {\n      sql: \"INSERT INTO Categories (Name) VALUES (@name)\",\n      parameters: { name: \"Electronics\" }\n    },\n    {\n      sql: \"INSERT INTO Products (Name, CategoryID, Price) VALUES (@name, @catId, @price)\",\n      parameters: { name: \"Laptop\", catId: 1, price: 999.99 }\n    }\n  ]\n});\n\n// Execute without transaction for independent operations\nawait mcp.call(\"executeSqlBatch\", {\n  statements: [\n    \"UPDATE Statistics SET LastUpdated = GETDATE()\",\n    \"EXEC sp_UpdateCache\",\n    \"DELETE FROM TempData WHERE CreatedDate < DATEADD(day, -7, GETDATE())\"\n  ],\n  useTransaction: false,\n  stopOnError: false  // Continue even if one statement fails\n});\n\n// Complex migration with DDL and DML\nawait mcp.call(\"executeSqlBatch\", {\n  statements: [\n    \"ALTER TABLE Users ADD Email nvarchar(255)\",\n    \"UPDATE Users SET Email = Username + '@example.com' WHERE Email IS NULL\",\n    \"ALTER TABLE Users ALTER COLUMN Email nvarchar(255) NOT NULL\",\n    \"CREATE UNIQUE INDEX IX_Users_Email ON Users(Email)\"\n  ],\n  isolationLevel: \"SERIALIZABLE\"  // Use highest isolation for schema changes\n});\n```\n\n## Development\n\n1. Clone the repository\n2. Install dependencies: `npm install`\n3. Build the project: `npm run build`\n4. Run the CLI: `npm start -- [options]`\n\n## Version History\n\n### 1.2.0\n- Added comprehensive DDL (Data Definition Language) tools:\n  - `createTable`: Create tables with full constraint and column options\n  - `alterTable`: Modify table structure (add/drop columns, constraints)\n  - `dropTable`: Drop tables with IF EXISTS support\n  - `createIndex`: Create indexes with advanced options (filtered, included columns)\n  - `dropIndex`: Drop indexes safely\n  - `executeQuery`: Execute custom SQL queries with parameterized inputs\n  - `executeSqlBatch`: Execute multiple SQL statements with automatic transaction support\n- Fixed queryBuilder limitation - DDL operations now supported via dedicated tools\n- Fixed transaction tool complexity - new executeSqlBatch provides simple multi-statement execution\n\n### 1.1.1\n- Added `getTableSchema` tool for comprehensive table structure information\n- Shows column details, data types, nullability, defaults, identity columns, computed columns\n- Includes primary keys, foreign keys, and table metadata (size, row count)\n\n### 1.1.0\n- Added comprehensive schema exploration tools (tables, views, functions, indexes, constraints, triggers)\n- Implemented Phase 1 developer features:\n  - Query Builder for complex SQL queries\n  - Stored Procedure support with input/output parameters\n  - Transaction Management with isolation levels\n  - Bulk Operations (insert, update, delete, upsert)\n- Enhanced default behaviors (dbo schema, increased row limits)\n- Improved error handling and logging\n\n### 1.0.10\n- Initial release with basic CRUD operations and schema inspection\n\n## License\n\nMIT\n","readmeFilename":"README.md"}