Redshift MCP Server

Example Use Cases

• 1

  Discover and list tables, views, and materialized views across multiple Redshift schemas to determine available data sources.

• 2

  Detailed column and schema metadata for multiple tables in a single request to build context-aware queries or data mappings.

• 3

  Run safe, read-only SQL queries against Redshift and stream results via stdio or SSE transport for downstream processing.

Description

This repository implements a Model Context Protocol (MCP) server for Amazon Redshift, providing tools to list tables, views, and materialized views across multiple schemas, retrieve detailed schema information for multiple tables at once, and execute read-only SQL queries. It supports both stdio and Server-Sent Events (SSE) transports and is implemented in a type-safe TypeScript codebase. The server runs read-only transactions for safety and is intended to be used by agents and AI models that need structured access to Redshift metadata and query results.