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"
}