handle_check_cluster_health

Assess the health of Redshift clusters by executing diagnostic SQL scripts. Choose 'basic' for operational status or 'full' for detailed table design checks. Returns results or errors in a structured dictionary for analysis.

Instructions

Performs a health assessment of the Redshift cluster.

Executes a series of diagnostic SQL scripts concurrently based on the
specified level ('basic' or 'full'). Aggregates raw results or errors
from each script into a dictionary.

Args:
    ctx: The MCP context object.
    level: Level of detail: 'basic' for operational status, 'full' for
           comprehensive table design/maintenance checks. Defaults to 'basic'.
    time_window_days: Lookback period in days for time-sensitive checks
                      (e.g., queue waits, commit waits). Defaults to 1.

Returns:
    A dictionary where keys are script names and values are either the raw
    list of dictionary results from the SQL query or an Exception object
    if that specific script failed.

Raises:
    DataApiError: If a critical error occurs during script execution that
                  prevents gathering results (e.g., config error). Individual
                  script errors are captured within the returned dictionary.

Input Schema

Name	Required	Description	Default
`level`	No		basic
`time_window_days`	No

Input Schema (JSON Schema)

{
  "properties": {
    "level": {
      "default": "basic",
      "title": "Level",
      "type": "string"
    },
    "time_window_days": {
      "default": 1,
      "title": "Time Window Days",
      "type": "integer"
    }
  },
  "title": "handle_check_cluster_healthArguments",
  "type": "object"
}

redshift-utils-mcp

handle_check_cluster_health

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from redshift-utils-mcp

Related Tools