SQL Server Analyst MCP Server

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

claude mcp add sql-server-analyst-mcp -- npx -y sql-server-analyst-mcp

{
  "mcpServers": {
    "sql-server-analyst-mcp": {
      "args": [
        "-y",
        "sql-server-analyst-mcp"
      ],
      "command": "npx"
    }
  }
}

[mcp_servers.sql-server-analyst-mcp]
command = "npx"
args = ["-y", "sql-server-analyst-mcp"]

{
  "mcpServers": {
    "sql-server-analyst-mcp": {
      "args": [
        "-y",
        "sql-server-analyst-mcp"
      ],
      "command": "npx"
    }
  }
}

{
  "mcpServers": {
    "sql-server-analyst-mcp": {
      "args": [
        "-y",
        "sql-server-analyst-mcp"
      ],
      "command": "npx"
    }
  }
}

This one needs environment variables set before it will start: MSSQL_SERVER (SQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL).), MSSQL_PORT (TCP port (default 1433; set 0 for named instance with dynamic port).), MSSQL_DATABASE (Default database to connect to. Most tools also accept an override argument.), MSSQL_USER (SQL authentication login name.), MSSQL_PASSWORD (SQL authentication password. Quote values containing '#' in .env files.), MSSQL_ENCRYPT (Encrypt the connection (true|false). Required true for Azure SQL.), MSSQL_TRUST_SERVER_CERT (Trust self-signed certificates (true|false). Use true only for local dev.), ALLOWED_DATABASES (Comma-separated allowlist of databases the server may access. Empty = unrestricted.), ALLOWED_SCHEMAS (Comma-separated allowlist of schemas for schema tools. Empty = unrestricted.), MAX_ROWS (Default row limit per safe query (default 100).), MAX_ROWS_LIMIT (Hard cap on query rows (default 1000).), QUERY_TIMEOUT_MS (Query execution timeout in milliseconds (default 30000).), LOG_LEVEL (error | warn | info | debug (default info).). The author declared them in the registry entry; get the values from the project itself.