handle_diagnose_query_performance

Analyzes Redshift query performance by fetching execution plan, metrics, and alerts, generating structured reports with identified issues and optimization recommendations.

Instructions

Analyzes a specific query's execution performance.

Fetches query text, execution plan, metrics, alerts, compilation info,
skew details, and optionally historical run data. Uses a formatting
utility to synthesize this into a structured report with potential issues
and recommendations.

Args:
    ctx: The MCP context object.
    query_id: The numeric ID of the Redshift query to analyze.
    compare_historical: Fetch performance data for previous runs of the
                       same query text. Defaults to True.

Returns:
    A dictionary conforming to DiagnoseQueryPerformanceResult structure:
    - On success: Contains detailed performance breakdown, issues, recommendations.
    - On query not found: Raises QueryNotFound exception.
    - On other errors: Raises DataApiError or similar for FastMCP to handle.

Raises:
    DataApiError: If a critical error occurs during script execution or parsing.
    QueryNotFound: If the specified query_id cannot be found in key tables.

Input Schema

Name	Required	Description	Default
`compare_historical`	No
`query_id`	Yes

Input Schema (JSON Schema)

{
  "properties": {
    "compare_historical": {
      "default": true,
      "title": "Compare Historical",
      "type": "boolean"
    },
    "query_id": {
      "title": "Query Id",
      "type": "integer"
    }
  },
  "required": [
    "query_id"
  ],
  "title": "handle_diagnose_query_performanceArguments",
  "type": "object"
}

redshift-utils-mcp

handle_diagnose_query_performance

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from redshift-utils-mcp

Related Tools