Model Context Protocol (MCP) server for Amazon Redshift. This MCP server provides tools to discover, explore, and query Amazon Redshift clusters and serverless workgroups. It enables AI assistants to interact with Redshift resources safely and efficiently through a comprehensive set of discovery and query execution tools.
This server provides the following tools for AI assistants:
Discovers all available Amazon Redshift clusters and serverless workgroups.
Lists all databases in a specified Redshift cluster.
Lists all schemas in a specified database.
Lists all tables in a specified schema.
Lists all columns in a specified table.
Automatically discover both provisioned Redshift clusters and serverless workgroups
Browse databases, schemas, tables, and columns
Execute SQL queries in a READ ONLY mode (a safe READ WRITE support is planned to be implemnted in the future versions)
`SELECT` permissions on tables/views you want to query
`USAGE` permissions on schemas you want to explore
Connection permissions to databases you want to access
Executes a SQL query against a Redshift cluster with safety protections.