HotStack

← Back to browse

sql-server-analyst-mcp

Indexed by io.github.coregentdevspace
View source ↗

About

Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.

Use this server

Add it to your MCP client. The catalogue lists this config verbatim from its source — it does not run, download, or vouch for the server. Review the command before you run it.

Transportstdio (runs a local command)
Env varsMSSQL_SERVER MSSQL_PORT MSSQL_DATABASE MSSQL_USER MSSQL_PASSWORD MSSQL_ENCRYPT MSSQL_TRUST_SERVER_CERT ALLOWED_DATABASES ALLOWED_SCHEMAS MAX_ROWS MAX_ROWS_LIMIT QUERY_TIMEOUT_MS LOG_LEVEL
Claude Code 
claude mcp add --env MSSQL_SERVER= --env MSSQL_PORT= --env MSSQL_DATABASE= --env MSSQL_USER= --env MSSQL_PASSWORD= --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= sql-server-analyst-mcp -- npx sql-server-analyst-mcp
Cursor

Add to Cursor

If the button doesn't open Cursor, use the JSON below — Cursor accepts the same mcpServers config.

VS Code 
code --add-mcp '{"name":"sql-server-analyst-mcp","command":"npx","args":["sql-server-analyst-mcp"],"env":{"MSSQL_SERVER":"","MSSQL_PORT":"","MSSQL_DATABASE":"","MSSQL_USER":"","MSSQL_PASSWORD":"","MSSQL_ENCRYPT":"","MSSQL_TRUST_SERVER_CERT":"","ALLOWED_DATABASES":"","ALLOWED_SCHEMAS":"","MAX_ROWS":"","MAX_ROWS_LIMIT":"","QUERY_TIMEOUT_MS":"","LOG_LEVEL":""}}'
JSON 
{
  "mcpServers": {
    "sql-server-analyst-mcp": {
      "command": "npx",
      "args": [
        "sql-server-analyst-mcp"
      ],
      "env": {
        "MSSQL_SERVER": "",
        "MSSQL_PORT": "",
        "MSSQL_DATABASE": "",
        "MSSQL_USER": "",
        "MSSQL_PASSWORD": "",
        "MSSQL_ENCRYPT": "",
        "MSSQL_TRUST_SERVER_CERT": "",
        "ALLOWED_DATABASES": "",
        "ALLOWED_SCHEMAS": "",
        "MAX_ROWS": "",
        "MAX_ROWS_LIMIT": "",
        "QUERY_TIMEOUT_MS": "",
        "LOG_LEVEL": ""
      }
    }
  }
}

Environment variables are listed by name only — fill in your own values. Entries never carry secrets.