Redshift

概要

The Redshift MCP Server is a TypeScript-based tool that empowers AI assistants and Large Language Models (LLMs) to securely interact with your Amazon Redshift data warehouse. It enables LLMs to perform schema introspection, execute read-only queries with automatic transaction safety, and understand your data structure. Designed for production, it supports dual transport modes (STDIO for IDEs and HTTP for web/cloud), offers robust Bearer authentication, optional PII redaction, and is cloud-native with Docker and Kubernetes readiness for scalable deployments.

主な機能

• Secure, read-only query execution with automatic transaction safety
• 1 GitHub stars
• Optional PII redaction for sensitive data during smart sampling
• Dual transport modes for IDE integration (STDIO) and web/cloud deployment (HTTP)
• Comprehensive schema introspection (tables, columns, relationships)
• Production-ready Bearer token authentication and cloud-native features for horizontal scaling

ユースケース

• Connecting AI platforms like Dust.tt to a Redshift data warehouse for intelligent data access.
• Deploying a scalable, secure Redshift data access layer for LLMs in cloud environments using Docker and Kubernetes.
• Empowering AI assistants in IDEs (Cursor, Windsurf, Claude Desktop) to understand and query Redshift data.