Redshift

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse

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

Developer Tools

API KEY

Official Website

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.

Related Bundles (1)

Redshift Tools

10 tools

Primary

Developer Tools

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse

Provider Information

Verification

Unverified

CategoryDeveloper Tools

Auth TypeAPI KEY

AddedOctober 14, 2025

UpdatedOctober 19, 2025

Approval

Required

Used By Tools

Quick Links

Official Website

Need Help?

Having trouble configuring Redshift? Check the available resources below.

Browse Other Providers