Install sql-server-analyst-mcp 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": {
"coregentdevspace-sql-server-analyst-mcp": {
"command": "npx",
"args": [
"-y",
"sql-server-analyst-mcp@0.1.1"
],
"env": {
"MSSQL_SERVER": "",
"MSSQL_PORT": "",
"MSSQL_DATABASE": "",
"MSSQL_USER": "",
"MSSQL_PASSWORD": "YOUR_MSSQL_PASSWORD",
"MSSQL_ENCRYPT": "",
"MSSQL_TRUST_SERVER_CERT": "",
"ALLOWED_DATABASES": "",
"ALLOWED_SCHEMAS": "",
"MAX_ROWS": "",
"MAX_ROWS_LIMIT": "",
"QUERY_TIMEOUT_MS": "",
"LOG_LEVEL": ""
}
}
}
}