Amazon Redshift

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service in the cloud. Run complex analytical queries using SQL, analyze massive datasets with columnar storage, and integrate with business intelligence tools for data analytics and reporting at scale.

This Amazon Redshift MCP server is compatible with any MCP client including Claude Desktop, Cursor, and other Model Context Protocol implementations.

Developer Tools
FIELDS

Tools From This Provider (10)

Search

Search Redshift database using SQL queries or structured syntax. Returns ranked results with IDs and titles. Maximum 100 results per search.

Fetch

Universal fetch tool that retrieves any row, table schema, or metadata using smart ID routing.

Redshift List Tables

List Redshift tables with filtering and metadata options. Includes Redshift-specific information like distribution keys and sort keys.

Redshift List Rows

Browse rows from a Redshift table with filtering, column selection, sorting, and pagination.

Redshift Execute

Execute SQL statements on Redshift database. Supports all SQL operations including COPY and UNLOAD.

Redshift Inspect Schema

Inspect Redshift schema or table in detail. Get comprehensive information about tables, columns, distribution, and sort keys.

Redshift Get Ai Description

Get compact, token-efficient database schema description optimized for AI text-to-SQL. Returns tables with columns, types, and Redshift distribution info.

Redshift Get Table Design

Get Redshift-specific table design information including distribution key, sort keys, and column encoding. Essential for query optimization.

Redshift Analyze Distribution

Analyze data distribution across Redshift slices to identify skew. Shows how evenly data is distributed, which affects query performance.

Redshift Profile Column

Profile a column's data distribution: min, max, distinct count, null percentage, and most frequent values.

Provider Information

CategoryDeveloper Tools
Auth TypeFIELDS
AddedOctober 14, 2025
UpdatedFebruary 1, 2026
Used By Tools
10

Quick Links

Need Help?

Having trouble configuring Amazon Redshift? Check the available resources below.

Amazon Redshift MCP Server - MCP Bundles • MCP Providers