redshift-utils-mcp

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.

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