Redshift MCP Server

Example Use Cases

• 1

  Secure, read-only access to Amazon Redshift data warehouses.

• 2

  Introspect database schemas and execute safe SQL queries.

• 3

  Integration with IDEs, web apps, or cloud-native environments like Kubernetes.

Description

This TypeScript-based MCP server enables large language models to introspect schemas, execute safe read-only queries, and understand the structure of Amazon Redshift data warehouses. It supports multiple transport modes including STDIO for IDEs and HTTP for web/cloud deployments, with production-ready features like bearer token authentication, stateless mode for horizontal scaling, and optional PII redaction. The server facilitates integration with tools like Dust.tt and Kubernetes, making it easy to deploy and secure AI access to internal Redshift data.