Redshift MCP Server

Redshift MCP Server is a TypeScript-based Model Context Protocol (MCP) server that allows secure, read-only access for AI assistants and LLMs to Amazon Redshift data warehouses. It enables schema introspection, intelligent query execution, column search, smart sampling—including optional PII redaction—and supports both STDIO (for IDE/local/dev) and HTTP (for cloud/web) transport modes. The server is ideal for data, AI, and developer teams who want to safely integrate AI-powered assistants with their Redshift data for exploration, analysis, and automation, while enforcing production-grade authentication, stateless cloud deployments, and robust security features.