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
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| level | No | basic | |
| time_window_days | No |