Redshift

About

Redshift provides an open-source bridge between Amazon Redshift and modern AI assistants. It allows Large Language Models (LLMs) to securely query, explore, and optionally modify your Redshift data using the Model Context Protocol (MCP). This minimal, production-ready server, built with FastMCP, empowers AI agents to query databases, list schemas and tables, describe table structures, and perform data insertion/updates, all while enforcing strict access controls. It is ideal for data teams enabling AI-powered analytics and building secure, auditable AI workflows with production data, supporting automatic connection via environment variables and seamless integration with MCP clients like Claude Desktop and ChatGPT.

Key Features

• Compatible with Claude Desktop, ChatGPT, and any MCP client.
• 3 GitHub stars
• Production-ready, secure, robust, and easy to deploy.
• Enforces strict access modes: 'readonly', 'readwrite', and 'admin'.
• Exposes Redshift data as standardized tools for LLMs/AI via MCP.
• Supports auto-connection and configuration via environment variables or .env files.

Use Cases

• Building robust AI workflows and automations that interact with Redshift data.
• Empowering data teams with AI-powered analytics capabilities.
• Providing secure, auditable LLM access to production Redshift data.