Redshift

About

Redshift provides a plug-and-play Model Context Protocol (MCP) server designed to securely and safely bridge Amazon Redshift databases with modern AI assistants like Claude and ChatGPT. It acts as an open-source intermediary, enabling LLMs to query, explore, and optionally modify Redshift data through standardized tools. Built on the FastMCP framework, it offers a production-ready solution for data teams to integrate AI-powered analytics, automate workflows, and provide auditable LLM access to critical production data without needing code changes.

Key Features

• Compatible with Claude Desktop, ChatGPT, and any MCP client.
• Exposes Redshift as standardized tools for LLMs/AI via MCP Standard.
• Supports auto-connection with environment variables or .env files for seamless setup.
• Enforces strict access modes (readonly, readwrite, admin) for data safety.
• 0 GitHub stars
• Production-ready, secure, and robust server for Redshift data access.

Use Cases

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