Redshift Utils MCP Server

stdio

Perform database actions on Amazon Redshift via its Data API.

Install

uvx (no

handle_inspect_table Gather detailed table metadata, statistics (like size, row counts, skew, stats staleness), and maintenance status.
handle_execute_ad_hoc_query Execute arbitrary SELECT queries against the Redshift database for data retrieval.
handle_diagnose_query_performance Retrieve and analyze the execution plan, metrics, and historical data for a specific query ID.
handle_check_cluster_health Perform a basic or full health assessment of the cluster using various diagnostic queries.
handle_diagnose_locks Identify and report on current lock contention and blocking sessions.
handle_monitor_workload Analyze cluster workload patterns over a time window, covering WLM, top queries, and resource usage.
handle_get_table_definition Retrieve the SHOW TABLE output (DDL) for a specified table.

★ 6 GitHub stars