Skip to main content
MCP server CX Codex

Amazon Redshift — Claude Code MCP server: what it does, how to install

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.

Apache-2.0 ★ 9,939 updated 2026-10-23

Open on GitHub

What Amazon Redshift 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.

What it helps with

  • 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 for the agent

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

How to install Amazon Redshift

Install

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

Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more

Questions about Amazon Redshift

How do I install the Amazon Redshift MCP server in Claude Code?

Add an entry to your MCP client config: command set to uvx, args set to awslabs.redshift-mcp-server@latest, and AWS_PROFILE plus AWS_DEFAULT_REGION under env. Install uv and Python 3.10 or newer first, then restart the client.

What does the Amazon Redshift MCP server do?

It discovers provisioned clusters and serverless workgroups, browses databases, schemas, tables and columns, executes SQL, and reviews a cluster for health and configuration issues.

Can the server change or delete data in Redshift?

Only when ACCESS_MODE=read-write is set. In that mode each statement that could alter something asks for approval, and without a transaction there is no undo. The database user's privileges remain the real safeguard, so skip admin accounts.

Similar MCP servers

All MCP servers for Cloud: AWS, Azure, GCP →

From the same set36

The whole set →
dsql dsql is a Claude Code skill that redirects Aurora DSQL questions to the current skill. It activates for work on schemas, migrations, queries, authentication, and performance. CX Codex +1 548installs Amazon ElastiCache/MemoryDB for Valkey Amazon ElastiCache/MemoryDB for Valkey is an MCP server for Claude Code with 12 Valkey tools for search indices, JSON paths and tiered command execution. CX Codex +1 ★ 9,939repo stars Amazon Timestream for InfluxDB Handles Amazon Timestream for InfluxDB clusters and instances, letting your assistant query time-series data and inspect AWS resources. CX Codex +1 ★ 9,939repo stars AWS S3 Tables The AWS S3 Tables MCP server lets AI agents work with S3 Tables, run read-only SQL, inspect metadata, and turn CSV files in S3 into tables. CX Codex +1 ★ 9,939repo stars AWS Labs Nova Canvas AWS Labs Nova Canvas generates AI images with Amazon Nova Canvas directly in your coding assistant via the Model Context Protocol. CX Codex +1 ★ 9,939repo stars Amazon ElastiCache for Memcached The Amazon ElastiCache for Memcached MCP server lets an AI agent work with Memcached through standard cache operations. Use it for inspection, debugging, or controlled data access. CX Codex +1 ★ 9,939repo stars AWS IAM Lets your agent create and edit AWS IAM users, roles, groups and policies, with a simulator to test permissions before anything changes. CX Codex +1 ★ 9,939repo stars Amazon ElastiCache Manages Amazon ElastiCache resources via AWS control plane APIs directly from your assistant. It handles serverless caches, replication groups, and CloudWatch metrics. CX Codex +1 ★ 9,939repo stars

Project sponsors

Companies that keep this analytics open