Install Microsoft SQL Server for Claude Desktop
Claude Desktop reads mcpServers from claude_desktop_config.json. Restart the app after saving.
- Open ~/Library/Application Support/Claude/claude_desktop_config.json on macOS, %APPDATA%\Claude\claude_desktop_config.json on Windows, or ~/.config/Claude/claude_desktop_config.json on Linux.
- Paste the JSON config below.
- Replace placeholder secrets, then restart the client if it does not reload on its own.
~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"alyiox-alyio-mcpmssql": {
"command": "dnx",
"args": [
"Alyio.McpMssql"
],
"env": {
"MCPMSSQL_CONNECTION_STRING": "YOUR_MCPMSSQL_CONNECTION_STRING",
"MCPMSSQL_DESCRIPTION": "",
"MCPMSSQL_QUERY_MAX_ROWS": "",
"MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS": "",
"MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS": "",
"MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS": "",
"MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS": "",
"MCPMSSQL_ALLOW_WRITE": "",
"MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS": "",
"DOTNET_ENVIRONMENT": ""
}
}
}
}