handle_monitor_workload

Analyze Amazon Redshift cluster workload patterns by executing SQL scripts to gather data on resource usage, WLM performance, and query efficiency. Customize time windows and top queries for detailed insights.

Instructions

Analyzes cluster workload patterns over a specified time window.

Executes various SQL scripts concurrently to gather data on resource usage,
WLM performance, top queries, queuing, COPY performance, and disk-based
queries. Returns a dictionary containing the raw results (or Exceptions)
keyed by the script name.

Args:
    ctx: The MCP context object.
    time_window_days: Lookback period in days for the workload analysis.
                      Defaults to 2.
    top_n_queries: Number of top queries (by total execution time) to
                   consider for the 'top_queries.sql' script. Defaults to 10.

Returns:
    A dictionary where keys are script names (e.g., 'workload/top_queries.sql')
    and values are either a list of result rows (as dictionaries) or the
    Exception object if that script failed.

Raises:
    DataApiError: If a critical error occurs during configuration loading.
                  (Note: Individual script errors are returned in the result dict).

Input Schema

Name	Required	Description	Default
`time_window_days`	No
`top_n_queries`	No

Input Schema (JSON Schema)

{
  "properties": {
    "time_window_days": {
      "default": 2,
      "title": "Time Window Days",
      "type": "integer"
    },
    "top_n_queries": {
      "default": 10,
      "title": "Top N Queries",
      "type": "integer"
    }
  },
  "title": "handle_monitor_workloadArguments",
  "type": "object"
}

redshift-utils-mcp

handle_monitor_workload

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from redshift-utils-mcp

Related Tools