handle_diagnose_locks

Analyzes and resolves lock contention in Redshift clusters by identifying active locks, filtering by process ID, table name, or wait time, and providing detailed reports for troubleshooting.

Instructions

Identifies active lock contention in the cluster.

Fetches all current lock information and then filters it based on the
optional target PID, target table name, and minimum wait time.
Formats the results into a list of contention details and a summary.

Args:
    ctx: The MCP context object.
    target_pid: Optional: Filter results to show locks held by or waited
                for by this specific process ID (PID).
    target_table_name: Optional: Filter results for locks specifically on
                       this table name (schema qualification recommended
                       if ambiguous).
    min_wait_seconds: Minimum seconds a lock must be in a waiting state
                      to be included. Defaults to 5.

Returns:
    A list of dictionaries, where each dictionary represents a row
    from the lock contention query result.

Raises:
    DataApiError: If fetching the initial lock information fails.

Input Schema

Name	Required	Description	Default
`min_wait_seconds`	No
`target_pid`	No
`target_table_name`	No

Input Schema (JSON Schema)

{
  "properties": {
    "min_wait_seconds": {
      "default": 5,
      "title": "Min Wait Seconds",
      "type": "integer"
    },
    "target_pid": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Target Pid"
    },
    "target_table_name": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Target Table Name"
    }
  },
  "title": "handle_diagnose_locksArguments",
  "type": "object"
}

redshift-utils-mcp

handle_diagnose_locks

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from redshift-utils-mcp

Related Tools