Developer Tools

Amazon Redshift MCP Server

Connect your account, then chat with AI to run tools.

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.

10 tools
Agent guide included
Start Chatting

Opens MCPBundles Studio with this server selected. After sign-in, chat and run tools from the same thread.

Browse all tools

AI Skill
SKILL.md

Domain knowledge for Amazon Redshift — workflow patterns, data models, and gotchas for your AI agent.

Amazon Redshift

Redshift uses PostgreSQL-compatible SQL. Data is organized in Schemas and Tables. Columnar storage optimizes analytical queries.

Data Model

  • Schemas — logical namespaces (e.g., public); contain tables.
  • Tables — identified by schema.table; have columns, distribution style, sort keys.
  • Rows — table data; accessed via SQL or row-level fetch.
  • Distribution — how data is spread across nodes (KEY, EVEN, ALL).
  • Column profiles — statistics and value distributions per column.

Gotchas

  • schema.table format: Always use fully qualified names (e.g., public.users) when referencing tables.
  • SSL required: Redshift connections require SSL; use require or verify-full.
  • Query timeout: Long-running queries may time out; consider LIMIT or more selective filters.

Tools in this Server (10)

Fetch

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

Redshift Analyze Distribution

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

Redshift Execute

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

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 i...

Redshift Get Table Design

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

Redshift Inspect Schema

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

Redshift List Rows

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

Redshift List Tables

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

Redshift Profile Column

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

Search

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

Frequently Asked Questions

What is the Amazon Redshift MCP server?

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. It provides 10 tools that AI agents can use through the Model Context Protocol (MCP).

How do I connect Amazon Redshift to my AI agent?

Add the MCPBundles server URL to your MCP client configuration (Claude Desktop, Cursor, VS Code, etc.). The URL format is: https://mcp.mcpbundles.com/bundle/redshift. Authentication is handled automatically.

How many tools does Amazon Redshift provide?

Amazon Redshift provides 10 tools that can be called by AI agents, along with a SKILL.md that gives your AI agent domain knowledge about when and how to use them.

What authentication does Amazon Redshift require?

Amazon Redshift uses API Key. Amazon Redshift requires credentials. Connect via MCPBundles and authentication is handled automatically.

Setup Instructions

Connect Amazon Redshift to any MCP client in minutes

https://mcp.mcpbundles.com/bundle/redshift

What is MCP?

Model Context Protocol lets AI tools call external capabilities securely through a single URL. This bundle groups tools behind an MCP endpoint that many clients can use.

Use this bundle in 3 steps

  1. Copy the MCP URL above
  2. Open your AI tool and add a new MCP/connector
  3. Paste the URL and follow any auth prompts

Claude Desktop Users

Skip the manual setup! Use the .mcpb file format for one-click installation. Check the Claude Desktop tab for setup instructions.

Pick your tool tab for exact steps

Select ChatGPT, Cursor, Claude Code, or another tab for copy-paste config.

Ready to use Amazon Redshift?

Sign in to connect your credentials and start running tools from the chat.

Amazon Redshift MCP Server & Skill — 10 Tools