redshift-utils-mcp
The Redshift Utils MCP Server provides a secure interface for developers and data analysts to connect AI-driven models with Amazon Redshift databases. It facilitates seamless natural language interactions with Redshift, enhancing data querying and analysis capabilities using Large Language Models.
Overview
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 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 (via Data API) using AWS Secrets Manager.
- Schema Discovery: Exposes MCP resources for listing schemas and tables.
- Metadata & Statistics: Provides detailed table metadata and statistics.
- Read-Only Query Execution: Allows secure SELECT queries based on LLM requests.
- Query Performance Analysis and Table Inspection.
- Cluster Health Check and Lock Diagnosis.
- Workload Monitoring and DDL Retrieval.
- Input Sanitization and Standardized MCP Interface.