MCP Server for SQL Server using node-mssql
| Tool name | Description | Destructive? |
|---|---|---|
| get-tables | ✓ no | |
| get-table | ✓ no | |
| get-stored-procedures | ✓ no | |
| get-stored-procedure | ✓ no | |
| query | ✓ no |
| start-transaction | ✓ no | |
| commit-transaction | ✓ no | |
| rollback-transaction | ✓ no |
{
"mcpServers": {
"mcp-node-mssql": {
"command": "npx",
"args": [
"-y",
"mcp-node-mssql"
]
}
}
}