# Amazon Redshift

Amazon Redshift — an MCP server for Redshift that discovers clusters and serverless workgroups, browses schemas and tables, and runs SQL. Read-only unless you opt out.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed, Gemini CLI · ★ 9939 repo stars
- Author: awslabs
- License: Apache-2.0 · policy=link-only · description only; the file stays with the author
- Source: https://github.com/awslabs/mcp/tree/HEAD/src/redshift-mcp-server
- Updated: 2026-10-23
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/mcp/amazon-redshift

## What it does

The server gives the agent tools for Redshift work: it finds provisioned clusters and serverless workgroups, walks databases, schemas, tables and columns, and runs SQL. Queries can go in parallel against the same database, and several calls can share one named transaction that you commit or roll back. A separate review checks a cluster or workgroup for health and configuration problems and returns a recommendation per finding.

Read-only is the default: one statement per call, writes rejected. `ACCESS_MODE=read-write` opens changes and deletes, and every statement that could alter something then waits for your approval. That prompt is the last point where you can stop it. An unsafe mode that skips the prompts stays off unless you turn it on.

Requirements: `uv`, Python 3.10 or newer, AWS credentials and a region. What actually guards the data is the database user's privileges, so create a dedicated user limited to the objects in play — an admin or superuser identity has no business behind a write-capable server. On a production cluster, confirm you have a snapshot you can restore first.

## Requirements
- Needs: Docker

## Install

### Claude Code (native platform)

**Install**
- The MCP registry has no launch command for it: see the repository README

## When to use it
- list every cluster and serverless workgroup in the account
- inspect schemas and columns before rewriting a query
- run an analytical query from the editor without opening the console
- group statements into a named transaction and roll it back
- audit a cluster for health and configuration issues

## Example prompts
- List the Redshift clusters and serverless workgroups I can reach, with their regions.
- Show the tables in the `analytics` schema and the columns of `orders`.
- Run a read-only query that totals revenue per day for last month.

## Similar
- [migrating-to-amazon-redshift](https://affpapa.org/en/nevibecode/skills/migrating-to-amazon-redshift.md) — skill · 4700 installs
- [redshift-guide](https://affpapa.org/en/nevibecode/skills/redshift-guide.md) — skill · 4000 installs
- [cortex-code](https://affpapa.org/en/nevibecode/skills/cortex-code.md) — skill · 1600 installs
- [snowflake-expert](https://affpapa.org/en/nevibecode/skills/snowflake-expert.md) — skill · 239 installs
- [fabric-dw](https://affpapa.org/en/nevibecode/mcp/fabric-dw.md) — MCP server · ★ 10 repo stars
- [sql-queries](https://affpapa.org/en/nevibecode/skills/sql-queries.md) — skill · 4700 installs

From the same set: [awslabs/mcp](https://affpapa.org/en/nevibecode/by/awslabs/mcp.md) — 36 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
