Redshift

This MCP server provides AI assistants with secure Amazon Redshift database access through a FastMCP-based implementation built by Anshul Patre using Python with configurable security modes (readonly, readwrite, admin) that enforce SQL operation restrictions based on environment variables. The implementation features automatic connection management using environment variables or manual credentials, comprehensive database operations including schema/table discovery and query execution, and built-in SQL command filtering that prevents dangerous operations in restricted modes. Built with support for both Amazon's official redshift-connector and PostgreSQL-compatible drivers, automatic reconnection capabilities, and structured JSON responses for all operations, it serves data analysts needing conversational database querying, developers requiring AI-assisted data exploration, and teams wanting secure programmatic access to Redshift warehouses with granular permission controls and connection state management.