{"slug":"vinodismyname/redshift-utils-mcp","name":"Redshift Utils MCP Server","description":"Perform database actions on Amazon Redshift via its Data API.","category":"database","tags":[],"official":false,"stars":6,"transport":"stdio","install":[{"cmd":"uvx (no","imports":[]}],"tools":[{"name":"handle_inspect_table","description":"Gather detailed table metadata, statistics (like size, row counts, skew, stats staleness), and maintenance status."},{"name":"handle_execute_ad_hoc_query","description":"Execute arbitrary SELECT queries against the Redshift database for data retrieval."},{"name":"handle_diagnose_query_performance","description":"Retrieve and analyze the execution plan, metrics, and historical data for a specific query ID."},{"name":"handle_check_cluster_health","description":"Perform a basic or full health assessment of the cluster using various diagnostic queries."},{"name":"handle_diagnose_locks","description":"Identify and report on current lock contention and blocking sessions."},{"name":"handle_monitor_workload","description":"Analyze cluster workload patterns over a time window, covering WLM, top queries, and resource usage."},{"name":"handle_get_table_definition","description":"Retrieve the SHOW TABLE output (DDL) for a specified table."}],"env_vars":["REDSHIFT_CLUSTER_ID"],"auth_type":"none","github":"https://github.com/vinodismyname/redshift-utils-mcp","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Mon May 25"}