Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.
npx -y sql-server-analyst-mcp{
"MSSQL_SERVER": "YOUR_VALUE_HERE",
"MSSQL_PORT": "YOUR_VALUE_HERE",
"MSSQL_DATABASE": "YOUR_VALUE_HERE",
"MSSQL_USER": "YOUR_VALUE_HERE",
"MSSQL_PASSWORD": "YOUR_SECRET_VALUE",
"MSSQL_ENCRYPT": "YOUR_VALUE_HERE",
"MSSQL_TRUST_SERVER_CERT": "YOUR_VALUE_HERE",
"ALLOWED_DATABASES": "YOUR_VALUE_HERE",
"ALLOWED_SCHEMAS": "YOUR_VALUE_HERE",
"MAX_ROWS": "YOUR_VALUE_HERE",
"MAX_ROWS_LIMIT": "YOUR_VALUE_HERE",
"QUERY_TIMEOUT_MS": "YOUR_VALUE_HERE",
"LOG_LEVEL": "YOUR_VALUE_HERE"
}Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.
{
"mcpServers": {
"io-github-coregentdevspace-sql-server-analyst-mcp": {
"command": "npx",
"args": [
"-y",
"sql-server-analyst-mcp"
],
"env": {
"MSSQL_SERVER": "YOUR_VALUE_HERE",
"MSSQL_PORT": "YOUR_VALUE_HERE",
"MSSQL_DATABASE": "YOUR_VALUE_HERE",
"MSSQL_USER": "YOUR_VALUE_HERE",
"MSSQL_PASSWORD": "YOUR_SECRET_VALUE",
"MSSQL_ENCRYPT": "YOUR_VALUE_HERE",
"MSSQL_TRUST_SERVER_CERT": "YOUR_VALUE_HERE",
"ALLOWED_DATABASES": "YOUR_VALUE_HERE",
"ALLOWED_SCHEMAS": "YOUR_VALUE_HERE",
"MAX_ROWS": "YOUR_VALUE_HERE",
"MAX_ROWS_LIMIT": "YOUR_VALUE_HERE",
"QUERY_TIMEOUT_MS": "YOUR_VALUE_HERE",
"LOG_LEVEL": "YOUR_VALUE_HERE"
}
}
}
}~/Library/Application Support/Claude/claude_desktop_config.json%APPDATA%\Claude\claude_desktop_config.jsonNo remote HTTP endpoint is advertised. Use the package or stdio setup shown in Install.
sql-server-analyst-mcp is an MCP server for Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.. It supports STDIO transport.
Use the generated config in Install. This server runs with npx -y sql-server-analyst-mcp; add any required environment variables before starting your client.
Choose the Claude Desktop tab in Install and copy the config for npx -y sql-server-analyst-mcp. Add required environment variables before starting Claude Desktop.
Choose the Claude Code tab in Install and copy the config for npx -y sql-server-analyst-mcp. Add required environment variables before starting Claude Code.
Choose the Codex tab in Install and copy the config for npx -y sql-server-analyst-mcp. Add required environment variables before starting Codex.
Choose the Cursor or VS Code tab in Install and copy the config for npx -y sql-server-analyst-mcp. Add required environment variables before starting Cursor or VS Code.
sql-server-analyst-mcp uses STDIO transport. Use the package or command config in Install.
sql-server-analyst-mcp inventory is listed when the MCP endpoint exposes tools, resources, or prompts. Some servers require auth first.
sql-server-analyst-mcp is marked with Auth required by registry metadata auth. You may need provider login, an API key, a bearer token, or a session header.
| Package | Registry | Version | Inputs |
|---|---|---|---|
sql-server-analyst-mcpstdio | npm | 0.1.1 | Env: MSSQL_SERVER required Env: MSSQL_PORT Env: MSSQL_DATABASE Env: MSSQL_USER required Env: MSSQL_PASSWORD required secret Env: MSSQL_ENCRYPT Env: MSSQL_TRUST_SERVER_CERT Env: ALLOWED_DATABASES Env: ALLOWED_SCHEMAS Env: MAX_ROWS Env: MAX_ROWS_LIMIT Env: QUERY_TIMEOUT_MS Env: LOG_LEVEL |