MCP Servers / database / Redshift Utils MCP Server

Redshift Utils MCP Server

stdionone★ 6database

Perform database actions on Amazon Redshift via its Data API.

Install

How to run this server

[ { "cmd": "uvx (no", "imports": [] } ]

server path: redshift-utils-mcp-server

Tools

What this server exposes

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.

Configuration

Environment & auth

authnone

envREDSHIFT_CLUSTER_ID

Resources