redshift-utils-mcp
If you are the rightful owner of redshift-utils-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
Redshift Utils MCP Server is a Model Context Protocol server designed to integrate LLM capabilities with Amazon Redshift databases.
This project implements a Model Context Protocol (MCP) server designed specifically to interact with Amazon Redshift databases. It bridges the gap between Large Language Models (LLMs) or AI assistants (like those in Claude, Cursor, or custom applications) and your Redshift data warehouse, enabling secure, standardized data access and interaction. This allows users to query data, understand database structure, and perform monitoring/diagnostic operations using natural language or AI-driven prompts. This server is for developers, data analysts, or teams looking to integrate LLM capabilities directly with their Amazon Redshift data environment in a structured and secure manner.
Features
- Secure Redshift Connection: Connects to your Amazon Redshift cluster using the AWS Redshift Data API via Boto3, leveraging AWS Secrets Manager for credentials managed securely via environment variables.
- Schema Discovery: Exposes MCP resources for listing schemas and tables within a specified schema.
- Metadata & Statistics: Provides a tool to gather detailed table metadata, statistics, and maintenance status.
- Read-Only Query Execution: Offers a secure MCP tool to execute arbitrary SELECT queries against the Redshift database.
- Query Performance Analysis: Includes a tool to retrieve and analyze the execution plan, metrics, and historical data for a specific query ID.
Tools
handle_check_cluster_health
Performs a health assessment of the Redshift cluster using a set of diagnostic SQL scripts.
handle_diagnose_locks
Identifies active lock contention and blocking sessions in the cluster.
handle_diagnose_query_performance
Analyzes a specific query's execution performance, including plan, metrics, and historical data.
handle_execute_ad_hoc_query
Executes an arbitrary SQL query provided by the user via Redshift Data API.
handle_get_table_definition
Retrieves the DDL statement for a specific table.
