Redshift

Provides secure Amazon Redshift database access with configurable permission modes (readonly, readwrite, admin) that enforce SQL operation restrictions, featuring automatic connection management, schema discovery, query execution, and built-in command filtering to prevent dangerous operations.

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.