{"_id":"@achmadya-dev/mcp-mssql-query","_rev":"6-9599b814daaa952ff35508b41e090de4","name":"@achmadya-dev/mcp-mssql-query","dist-tags":{"latest":"0.3.2"},"versions":{"0.2.0":{"name":"@achmadya-dev/mcp-mssql-query","version":"0.2.0","keywords":["mcp","model-context-protocol","mssql","sql-server","database","cursor"],"author":{"name":"achmadya"},"license":"MIT","_id":"@achmadya-dev/mcp-mssql-query@0.2.0","maintainers":[{"name":"madyardwn","email":"achmadya.dev@gmail.com"}],"homepage":"https://github.com/achmadya-dev/mcp-mssql-query#readme","bugs":{"url":"https://github.com/achmadya-dev/mcp-mssql-query/issues"},"bin":{"mcp-mssql-query":"dist/index.js"},"dist":{"shasum":"a1cb7e19cc318874aa475b333a44096dcf424568","tarball":"https://registry.npmjs.org/@achmadya-dev/mcp-mssql-query/-/mcp-mssql-query-0.2.0.tgz","fileCount":43,"integrity":"sha512-T5MfJsZr2S4+vYDMnmbVjVGmPZbggxuPs/9kHKbnl9jh0vCYN1UeeTOyEWeVIwcY6N/8HH+3LE7vpsVFN8Dozw==","signatures":[{"sig":"MEYCIQD3j+x8E13ieryvnfzk/bUY/Ku7XcmhKJ2OiBu8F4JOtAIhAJvKL7SntHsjwusQMHXzwFjVUaWQ/KZvj43Q+0qBwN1s","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":45215},"main":"dist/index.js","type":"module","_from":"file:achmadya-dev-mcp-mssql-query-0.2.0.tgz","types":"./dist/index.d.ts","engines":{"node":">=20"},"scripts":{"test":"node --experimental-vm-modules node_modules/jest/bin/jest.js","build":"tsc -p tsconfig.build.json","start":"node dist/index.js","changeset":"changeset","publish-packages":"pnpm run build && changeset publish","version-packages":"changeset version"},"_npmUser":{"name":"madyardwn","email":"achmadya.dev@gmail.com"},"_resolved":"/tmp/6da2b97dd4b859fba4a42dfdc006e444/achmadya-dev-mcp-mssql-query-0.2.0.tgz","_integrity":"sha512-T5MfJsZr2S4+vYDMnmbVjVGmPZbggxuPs/9kHKbnl9jh0vCYN1UeeTOyEWeVIwcY6N/8HH+3LE7vpsVFN8Dozw==","repository":{"url":"git+https://github.com/achmadya-dev/mcp-mssql-query.git","type":"git"},"_npmVersion":"11.13.0","description":"Model Context Protocol (MCP) server for Microsoft SQL Server to run SQL queries via stdio (read-only by default)","directories":{},"_nodeVersion":"24.16.0","dependencies":{"zod":"4.3.6","mssql":"12.5.4","@achmadya-dev/mcp-core":"^0.3.3"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"jest":"30.4.2","ts-jest":"29.4.11","typescript":"5.7.2","@types/jest":"30.0.0","@types/node":"22.10.0","@types/mssql":"12.3.0","@jest/globals":"30.4.1","@changesets/cli":"2.29.8"},"_npmOperationalInternal":{"tmp":"tmp/mcp-mssql-query_0.2.0_1781402499717_0.08832889068113814","host":"s3://npm-registry-packages-npm-production"}},"0.2.1":{"name":"@achmadya-dev/mcp-mssql-query","version":"0.2.1","keywords":["mcp","model-context-protocol","mssql","sql-server","database","cursor"],"author":{"name":"achmadya"},"license":"MIT","_id":"@achmadya-dev/mcp-mssql-query@0.2.1","maintainers":[{"name":"madyardwn","email":"achmadya.dev@gmail.com"}],"homepage":"https://github.com/achmadya-dev/mcp-mssql-query#readme","bugs":{"url":"https://github.com/achmadya-dev/mcp-mssql-query/issues"},"bin":{"mcp-mssql-query":"dist/index.js"},"dist":{"shasum":"64d3f19a1874c90b5bc4fe1ac41ad28a74a632e4","tarball":"https://registry.npmjs.org/@achmadya-dev/mcp-mssql-query/-/mcp-mssql-query-0.2.1.tgz","fileCount":43,"integrity":"sha512-zXbPCbpLpmaJB1P065XETKVqarq80ElrfGHk4V/szXgiEaoVYbOTGmOx2L/bYsX9r+hccNEEuY1D6B3FgXn0mw==","signatures":[{"sig":"MEYCIQDbjVhXIPo2rEU2na/OYQkWpp0U1paC5UYRZWq+X8KrUwIhAIYVpM8NCPkkZ6yXb4v7OR3d5p+aLCUGZPd247TtkfkR","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":45413},"main":"dist/index.js","type":"module","_from":"file:achmadya-dev-mcp-mssql-query-0.2.1.tgz","types":"./dist/index.d.ts","engines":{"node":">=20"},"scripts":{"test":"node --experimental-vm-modules node_modules/jest/bin/jest.js","build":"tsc -p tsconfig.build.json","start":"node dist/index.js","changeset":"changeset","publish-packages":"pnpm run build && changeset publish","version-packages":"changeset version"},"_npmUser":{"name":"madyardwn","email":"achmadya.dev@gmail.com"},"_resolved":"/tmp/c6c936debe420c93745d693f02c789fe/achmadya-dev-mcp-mssql-query-0.2.1.tgz","_integrity":"sha512-zXbPCbpLpmaJB1P065XETKVqarq80ElrfGHk4V/szXgiEaoVYbOTGmOx2L/bYsX9r+hccNEEuY1D6B3FgXn0mw==","repository":{"url":"git+https://github.com/achmadya-dev/mcp-mssql-query.git","type":"git"},"_npmVersion":"11.13.0","description":"Model Context Protocol (MCP) server for Microsoft SQL Server to run SQL queries via stdio (read-only by default)","directories":{},"_nodeVersion":"24.16.0","dependencies":{"zod":"4.3.6","mssql":"12.5.4","@achmadya-dev/mcp-core":"^0.5.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"jest":"30.4.2","husky":"9.1.7","ts-jest":"29.4.11","typescript":"5.7.2","@types/jest":"30.0.0","@types/node":"22.10.0","@types/mssql":"12.3.0","@jest/globals":"30.4.1","@changesets/cli":"2.29.8"},"_npmOperationalInternal":{"tmp":"tmp/mcp-mssql-query_0.2.1_1781916942805_0.520767449355175","host":"s3://npm-registry-packages-npm-production"}},"0.2.2":{"name":"@achmadya-dev/mcp-mssql-query","version":"0.2.2","keywords":["mcp","model-context-protocol","mssql","sql-server","database","cursor"],"author":{"name":"achmadya"},"license":"MIT","_id":"@achmadya-dev/mcp-mssql-query@0.2.2","maintainers":[{"name":"madyardwn","email":"achmadya.dev@gmail.com"}],"homepage":"https://github.com/achmadya-dev/mcp-mssql-query#readme","bugs":{"url":"https://github.com/achmadya-dev/mcp-mssql-query/issues"},"bin":{"mcp-mssql-query":"dist/index.js"},"dist":{"shasum":"15459edf28149cd22146c40adde74eacfafdda46","tarball":"https://registry.npmjs.org/@achmadya-dev/mcp-mssql-query/-/mcp-mssql-query-0.2.2.tgz","fileCount":43,"integrity":"sha512-OfWFjwUpkyXrIuOUaQgFiaP7kgbZnOz6DnWomq6kUKpnBEtsKA3mk7usvgEofb8Q16VKuZqUdSyUpziUR8gPFw==","signatures":[{"sig":"MEUCIQCL8POI7iDEHmCcvEAJEnF/nJpWiVbC/DprpWfrBF48WQIgFpcpONrppqh403XKSqbmmNYj5aa5lmxKZOidWEuqPT8=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":45413},"main":"dist/index.js","type":"module","_from":"file:achmadya-dev-mcp-mssql-query-0.2.2.tgz","types":"./dist/index.d.ts","engines":{"node":">=20"},"scripts":{"test":"node --experimental-vm-modules node_modules/jest/bin/jest.js","build":"tsc -p tsconfig.build.json","start":"node dist/index.js","changeset":"changeset","publish-packages":"pnpm run build && changeset publish","version-packages":"changeset version"},"_npmUser":{"name":"madyardwn","email":"achmadya.dev@gmail.com"},"_resolved":"/tmp/6880c8f80810c4b03bc3bf23cf8bc2fb/achmadya-dev-mcp-mssql-query-0.2.2.tgz","_integrity":"sha512-OfWFjwUpkyXrIuOUaQgFiaP7kgbZnOz6DnWomq6kUKpnBEtsKA3mk7usvgEofb8Q16VKuZqUdSyUpziUR8gPFw==","repository":{"url":"git+https://github.com/achmadya-dev/mcp-mssql-query.git","type":"git"},"_npmVersion":"11.13.0","description":"Model Context Protocol (MCP) server for Microsoft SQL Server to run SQL queries via stdio (read-only by default)","directories":{},"_nodeVersion":"24.16.0","dependencies":{"zod":"4.3.6","mssql":"12.5.4","@achmadya-dev/mcp-core":"^0.6.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"jest":"30.4.2","husky":"9.1.7","ts-jest":"29.4.11","typescript":"5.7.2","@types/jest":"30.0.0","@types/node":"22.10.0","@types/mssql":"12.3.0","@jest/globals":"30.4.1","@changesets/cli":"2.29.8"},"_npmOperationalInternal":{"tmp":"tmp/mcp-mssql-query_0.2.2_1782005504621_0.7339076717848148","host":"s3://npm-registry-packages-npm-production"}},"0.3.0":{"name":"@achmadya-dev/mcp-mssql-query","version":"0.3.0","keywords":["mcp","model-context-protocol","mssql","sql-server","database","cursor"],"author":{"name":"achmadya"},"license":"MIT","_id":"@achmadya-dev/mcp-mssql-query@0.3.0","maintainers":[{"name":"madyardwn","email":"achmadya.dev@gmail.com"}],"homepage":"https://github.com/achmadya-dev/mcp-mssql-query#readme","bugs":{"url":"https://github.com/achmadya-dev/mcp-mssql-query/issues"},"bin":{"mcp-mssql-query":"dist/index.js"},"dist":{"shasum":"79f08df8a80b49d60d255d1d45e5ebaa2e91c70b","tarball":"https://registry.npmjs.org/@achmadya-dev/mcp-mssql-query/-/mcp-mssql-query-0.3.0.tgz","fileCount":43,"integrity":"sha512-+UdwnJ//Ziy93BPuIwRqk+PyDXZIKlkIp6zZCfy2Hq0smUkK6CosWfWehsBnNSQsS5q/wkwUPQNWJey3N+AnmQ==","signatures":[{"sig":"MEUCIQDrye/zKEExUoKkrdZ0uE10Yd8SAXgIPA92T0EuXvvMRAIgRuJw3WvCF+sA6aBoHStP2wxYaoF6thsdxJ0eu+BPydc=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":46588},"main":"dist/index.js","type":"module","_from":"file:achmadya-dev-mcp-mssql-query-0.3.0.tgz","types":"./dist/index.d.ts","engines":{"node":">=20"},"scripts":{"test":"node --experimental-vm-modules node_modules/jest/bin/jest.js","build":"tsc -p tsconfig.build.json","start":"node dist/index.js","changeset":"changeset","publish-packages":"pnpm run build && changeset publish","version-packages":"changeset version"},"_npmUser":{"name":"madyardwn","email":"achmadya.dev@gmail.com"},"_resolved":"/tmp/0a75b6c1c1f3cff7374f2ed33b3466f2/achmadya-dev-mcp-mssql-query-0.3.0.tgz","_integrity":"sha512-+UdwnJ//Ziy93BPuIwRqk+PyDXZIKlkIp6zZCfy2Hq0smUkK6CosWfWehsBnNSQsS5q/wkwUPQNWJey3N+AnmQ==","repository":{"url":"git+https://github.com/achmadya-dev/mcp-mssql-query.git","type":"git"},"_npmVersion":"11.13.0","description":"Model Context Protocol (MCP) server for Microsoft SQL Server to run SQL queries via stdio (read-only by default)","directories":{},"_nodeVersion":"24.16.0","dependencies":{"zod":"4.3.6","mssql":"12.5.4","@achmadya-dev/mcp-core":"^0.7.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"jest":"30.4.2","husky":"9.1.7","ts-jest":"29.4.11","typescript":"5.7.2","@types/jest":"30.0.0","@types/node":"22.10.0","@types/mssql":"12.3.0","@jest/globals":"30.4.1","@changesets/cli":"2.29.8"},"_npmOperationalInternal":{"tmp":"tmp/mcp-mssql-query_0.3.0_1782006372951_0.4340665790082485","host":"s3://npm-registry-packages-npm-production"}},"0.3.1":{"name":"@achmadya-dev/mcp-mssql-query","version":"0.3.1","keywords":["mcp","model-context-protocol","mssql","sql-server","database","cursor"],"author":{"name":"achmadya"},"license":"MIT","_id":"@achmadya-dev/mcp-mssql-query@0.3.1","maintainers":[{"name":"madyardwn","email":"achmadya.dev@gmail.com"}],"homepage":"https://github.com/achmadya-dev/mcp-mssql-query#readme","bugs":{"url":"https://github.com/achmadya-dev/mcp-mssql-query/issues"},"bin":{"mcp-mssql-query":"dist/index.js"},"dist":{"shasum":"9eae319a359af6f41c958f2d44f15099f15b2ae3","tarball":"https://registry.npmjs.org/@achmadya-dev/mcp-mssql-query/-/mcp-mssql-query-0.3.1.tgz","fileCount":47,"integrity":"sha512-uoYSI8UBVclToONNfckkbersZJIpB+kbqbUhUYaKa+9w4CLhoaQhOR8XE+MmiyGWVoQCipRkEHtDJtUv43KUIA==","signatures":[{"sig":"MEUCIDsLSXobioEO5Trj0O5HRLbHfcIj9ubaM00BYKXkkKiSAiEAjjY3PHcXeDXEqY1an6EGYSNrZc1zQ3/BcNjYnNBVe8M=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":51503},"main":"dist/index.js","type":"module","_from":"file:achmadya-dev-mcp-mssql-query-0.3.1.tgz","types":"./dist/index.d.ts","engines":{"node":">=20"},"scripts":{"test":"node --experimental-vm-modules node_modules/jest/bin/jest.js","build":"tsc -p tsconfig.build.json","start":"node dist/index.js","changeset":"changeset","publish-packages":"pnpm run build && changeset publish","version-packages":"changeset version"},"_npmUser":{"name":"madyardwn","email":"achmadya.dev@gmail.com"},"_resolved":"/tmp/741cb2210d0d7de4d0225e33571beede/achmadya-dev-mcp-mssql-query-0.3.1.tgz","_integrity":"sha512-uoYSI8UBVclToONNfckkbersZJIpB+kbqbUhUYaKa+9w4CLhoaQhOR8XE+MmiyGWVoQCipRkEHtDJtUv43KUIA==","repository":{"url":"git+https://github.com/achmadya-dev/mcp-mssql-query.git","type":"git"},"_npmVersion":"11.13.0","description":"Model Context Protocol (MCP) server for Microsoft SQL Server to run SQL queries via stdio (read-only by default)","directories":{},"_nodeVersion":"24.16.0","dependencies":{"zod":"4.3.6","mssql":"12.5.4","@achmadya-dev/mcp-core":"^0.7.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"jest":"30.4.2","husky":"9.1.7","ts-jest":"29.4.11","typescript":"5.7.2","@types/jest":"30.0.0","@types/node":"22.10.0","@types/mssql":"12.3.0","@jest/globals":"30.4.1","@changesets/cli":"2.29.8"},"_npmOperationalInternal":{"tmp":"tmp/mcp-mssql-query_0.3.1_1782007758267_0.732569262096356","host":"s3://npm-registry-packages-npm-production"}},"0.3.2":{"name":"@achmadya-dev/mcp-mssql-query","version":"0.3.2","description":"Model Context Protocol (MCP) server for Microsoft SQL Server to run SQL queries via stdio (read-only by default)","type":"module","author":{"name":"achmadya"},"license":"MIT","repository":{"type":"git","url":"git+https://github.com/achmadya-dev/mcp-mssql-query.git"},"keywords":["mcp","model-context-protocol","mssql","sql-server","database","cursor"],"main":"dist/index.js","bin":{"mcp-mssql-query":"dist/index.js"},"publishConfig":{"access":"public"},"engines":{"node":">=20"},"dependencies":{"@achmadya-dev/mcp-core":"^0.8.0","mssql":"12.5.4","zod":"4.3.6"},"devDependencies":{"@changesets/cli":"2.29.8","@jest/globals":"30.4.1","@types/jest":"30.0.0","@types/mssql":"12.3.0","@types/node":"22.10.0","husky":"9.1.7","jest":"30.4.2","ts-jest":"29.4.11","typescript":"5.7.2"},"scripts":{"build":"tsc -p tsconfig.build.json","test":"node --experimental-vm-modules node_modules/jest/bin/jest.js","start":"node dist/index.js","changeset":"changeset","version-packages":"changeset version","publish-packages":"pnpm run build && changeset publish"},"types":"./dist/index.d.ts","_id":"@achmadya-dev/mcp-mssql-query@0.3.2","bugs":{"url":"https://github.com/achmadya-dev/mcp-mssql-query/issues"},"homepage":"https://github.com/achmadya-dev/mcp-mssql-query#readme","_integrity":"sha512-gqCRjeSIrkzEvXuHEeW0I/qmoNtsMxDwt2MUS/3qmS5KFX7+1sa4mNIFR+xjD2FN4moayr+4s15uyVBbVr4ddQ==","_resolved":"/tmp/c397ff61de172000a2e186b445032f26/achmadya-dev-mcp-mssql-query-0.3.2.tgz","_from":"file:achmadya-dev-mcp-mssql-query-0.3.2.tgz","_nodeVersion":"24.16.0","_npmVersion":"11.13.0","dist":{"integrity":"sha512-gqCRjeSIrkzEvXuHEeW0I/qmoNtsMxDwt2MUS/3qmS5KFX7+1sa4mNIFR+xjD2FN4moayr+4s15uyVBbVr4ddQ==","shasum":"98a0250fb35bce604970de6d5e71141fb8fc0801","tarball":"https://registry.npmjs.org/@achmadya-dev/mcp-mssql-query/-/mcp-mssql-query-0.3.2.tgz","fileCount":47,"unpackedSize":51503,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIQCBQsOtLRw4xH9RtugUCUn314f/0NdheQquV406mGEaEwIgSw2jfQYzlLhBAbfe2rvPIKF6i2nbT7jVdeWmGSKPO0o="}]},"_npmUser":{"name":"madyardwn","email":"achmadya.dev@gmail.com"},"directories":{},"maintainers":[{"name":"madyardwn","email":"achmadya.dev@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mcp-mssql-query_0.3.2_1782027893323_0.49696809001536435"},"_hasShrinkwrap":false}},"time":{"created":"2026-06-14T02:01:39.552Z","modified":"2026-06-21T07:44:53.586Z","0.2.0":"2026-06-14T02:01:39.864Z","0.2.1":"2026-06-20T00:55:42.947Z","0.2.2":"2026-06-21T01:31:44.765Z","0.3.0":"2026-06-21T01:46:13.113Z","0.3.1":"2026-06-21T02:09:18.429Z","0.3.2":"2026-06-21T07:44:53.469Z"},"bugs":{"url":"https://github.com/achmadya-dev/mcp-mssql-query/issues"},"author":{"name":"achmadya"},"license":"MIT","homepage":"https://github.com/achmadya-dev/mcp-mssql-query#readme","keywords":["mcp","model-context-protocol","mssql","sql-server","database","cursor"],"repository":{"type":"git","url":"git+https://github.com/achmadya-dev/mcp-mssql-query.git"},"description":"Model Context Protocol (MCP) server for Microsoft SQL Server to run SQL queries via stdio (read-only by default)","maintainers":[{"name":"madyardwn","email":"achmadya.dev@gmail.com"}],"readme":"# @achmadya-dev/mcp-mssql-query\n\nMCP server for Microsoft SQL Server. Runs a single T-SQL statement per tool call over **stdio**. **Read-only by default** — writes and DDL require explicit env flags.\n\n## Requirements\n\n- Node.js **≥ 20**\n- A reachable SQL Server instance\n\n## Install from npm\n\n```json\n{\n  \"mcpServers\": {\n    \"mssql\": {\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"@achmadya-dev/mcp-mssql-query\"],\n      \"env\": {\n        \"MSSQL_HOST\": \"localhost\",\n        \"MSSQL_PORT\": \"1433\",\n        \"MSSQL_USER\": \"sa\",\n        \"MSSQL_PASSWORD\": \"your_password\",\n        \"MSSQL_DATABASE\": \"your_database\",\n        \"MSSQL_TRUST_SERVER_CERTIFICATE\": \"true\"\n      }\n    }\n  }\n}\n```\n\nOr use `envFile` instead of inline `env`.\n\n## Develop from source\n\n```bash\ngit clone https://github.com/achmadya-dev/mcp-mssql-query.git\ncd mcp-mssql-query\npnpm install\npnpm run build\npnpm test\n```\n\nOpen the repo root in Cursor. You need a reachable SQL Server instance — set connection env in `.cursor/mcp.json` or via `envFile`:\n\n```json\n{\n  \"mcpServers\": {\n    \"mssql\": {\n      \"command\": \"node\",\n      \"args\": [\"${workspaceFolder}/dist/index.js\"],\n      \"env\": {\n        \"MSSQL_HOST\": \"localhost\",\n        \"MSSQL_PORT\": \"1433\",\n        \"MSSQL_USER\": \"sa\",\n        \"MSSQL_PASSWORD\": \"your_password\",\n        \"MSSQL_DATABASE\": \"your_database\",\n        \"MSSQL_TRUST_SERVER_CERTIFICATE\": \"true\"\n      }\n    }\n  }\n}\n```\n\n## Environment variables\n\n### Connection\n\n| Variable                         | Default      | Description                          |\n| -------------------------------- | ------------ | ------------------------------------ |\n| `MSSQL_HOST`                     | `localhost`  | SQL Server host                      |\n| `MSSQL_PORT`                     | `1433`       | Port                                 |\n| `MSSQL_USER`                     | _(empty)_    | Username                             |\n| `MSSQL_PASSWORD`                 | _(empty)_    | Password                             |\n| `MSSQL_DATABASE`                 | _(optional)_ | Database name                        |\n| `MSSQL_INSTANCE_NAME`            | _(optional)_ | Instance name (e.g. `SQLEXPRESS`)    |\n| `MSSQL_ENCRYPT`                  | `true`       | Encrypt connection                   |\n| `MSSQL_TRUST_SERVER_CERTIFICATE` | `true`       | Trust server certificate (local dev) |\n| `MSSQL_CONNECTION_TIMEOUT_MS`    | `15000`      | Connection timeout (ms)              |\n| `MSSQL_REQUEST_TIMEOUT_MS`       | `15000`      | Request timeout (ms)                 |\n| `MSSQL_MAX_ROWS`                 | `500`        | Max rows for row-returning queries   |\n\n### Write access\n\n| Variable                 | Allows   |\n| ------------------------ | -------- |\n| `ALLOW_INSERT_OPERATION` | `INSERT` |\n| `ALLOW_UPDATE_OPERATION` | `UPDATE` |\n| `ALLOW_DELETE_OPERATION` | `DELETE` |\n| `ALLOW_DDL_OPERATION`    | DDL      |\n\nEnabled values: `true`, `1`, `yes`, `on`.\n\n## Tools\n\n| Tool           | Statements                  | Env flag                 |\n| -------------- | --------------------------- | ------------------------ |\n| `mssql_select` | `SELECT`, `VALUES`, `PRINT` | always on                |\n| `mssql_insert` | `INSERT`                    | `ALLOW_INSERT_OPERATION` |\n| `mssql_update` | `UPDATE`                    | `ALLOW_UPDATE_OPERATION` |\n| `mssql_delete` | `DELETE`                    | `ALLOW_DELETE_OPERATION` |\n| `mssql_ddl`    | DDL                         | `ALLOW_DDL_OPERATION`    |\n\nEach tool accepts one `sql` string.\n\n## Behavior and security\n\n- One T-SQL statement per request.\n- Results are JSON text; row-returning queries include truncation metadata.\n- Non-row commands return `kind: \"execute\"` with `affectedRows`.\n\n## Package scripts\n\n```bash\npnpm run build\npnpm test\npnpm start\n```\n","readmeFilename":"README.md"}