How to Use the Amazon Redshift MCP in Claude Code

Q: How do I add the Amazon Redshift MCP Server to Claude Code?

Run the CLI command claude mcp add --transport http redshift -- . Make sure you put all flags before the server name. The configuration saves automatically to your /.claude.json file.

Connect Claude Code to Amazon Redshift and automate warehouse maintenance, schema validations, and query audits right from your terminal.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Amazon Redshift MCP to Claude Code

Create your Vinkius account to connect Amazon Redshift to Claude Code and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Amazon Redshift with Claude Code

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Headless Amazon Redshift MCP Server

Terminal-based workflows demand tools that operate without graphical interfaces. This server lets your CLI agent interact with petabytes of data directly from an SSH session or inside a GitHub Action. You can script a nightly cron job that tells the agent to run `list_schemas` and `list_tables`. If it detects an unexpected structural change, it immediately alerts your DevOps team via standard output.

Asynchronous CI/CD Pipeline Integration

Running heavy data transformations during a build process often causes timeouts. We built this MCP integration around the serverless AWS Data API to keep your pipelines moving. The agent triggers a massive materialization job using `execute_sql` and captures the statement ID. It then polls `statement_status` in a headless loop, only calling `get_results` when the payload is ready for the next deployment stage.

Automated Cluster Auditing

Keeping track of who ran what on your production cluster requires digging through massive audit logs. Now your terminal agent handles the forensic work automatically. By calling `list_statements`, the agent pulls a fresh batch of recent queries. It parses the execution history for expensive table scans, formats a markdown report, and pipes the output directly to your local filesystem.

Setup guide

Set up Amazon Redshift MCP in Claude Code

Prerequisites

Claude Code CLI installed (npm install -g @anthropic-ai/claude-code)
Active Vinkius subscription with a valid endpoint token

1

Run the add command

Open your terminal and run the command shown on the right. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com. Use --scope user to make it available across all projects.
2

Verify the connection

Start a Claude Code session and type /mcp to list connected servers. You should see amazon-redshift-mcp with a green status indicator.
3

Start using tools

Ask Claude Code something like "Check my latest Amazon Redshift transactions." It will automatically discover and invoke the available Amazon Redshift tools.

Terminal

claude mcp add --transport http amazon-redshift-mcp https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp

Get your connection token →

Prerequisites

Claude Code CLI installed
Active Vinkius subscription with a valid endpoint token

1

Open the config file

Create or edit .mcp.json in your project root for project-level scope, or ~/.claude.json for user-level scope.
2

Add the Amazon Redshift MCP

Paste the JSON snippet shown on the right into the mcpServers object. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Restart Claude Code

Start a new Claude Code session. Type /mcp to confirm the server is connected. The tools will be automatically available in your conversation.

.mcp.json

{
  "mcpServers": {
    "amazon-redshift-mcp": {
      "type": "url",
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Amazon Redshift. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Amazon Redshift now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Amazon Redshift MCP in Claude Code

Run the CLI command `claude mcp add --transport http redshift -- `. Make sure you put all flags before the server name. The configuration saves automatically to your ~/.claude.json file.

Yes. You can write a shell script that prompts the agent to map your database. It uses the describe table tool to verify column types before approving a CI/CD deployment.

The integration handles this perfectly. It fires asynchronous queries and monitors the execution status, meaning your terminal won't freeze while waiting for a massive aggregation to finish.

You can connect using stdio, http, or sse transports. Vinkius provides the endpoint URL, and you just pass the appropriate transport flag during the initial setup command.

Your raw telemetry data and proprietary queries process through a strict zero-trust V8 Isolate. The sandbox is completely ephemeral, so no sensitive database records leak into your build server logs.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript