How to Use the Amazon Redshift MCP in Claude

Q: Can I run a complex join on Amazon Redshift with Claude Desktop?

Yes. Write any SQL statement and pass it to the executesql tool. Your agent sends it to Redshift and fetches the results for you when it's done.

Q: How does Claude Desktop handle long-running Amazon Redshift queries?

It runs them in the background. executesql returns a statement ID immediately, so your chat isn't blocked. You can check the status later with statementstatus and get the data with getresults.

Query your Amazon Redshift warehouse right from the Claude Desktop app. No more context switching.

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 Desktop

Create your Vinkius account to connect Amazon Redshift to Claude Desktop 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 Desktop

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Run and Check SQL Queries

The `execute_sql` tool lets you kick off long-running queries against your Redshift cluster. It doesn't block your chat; you get a statement ID back right away so you can keep working. You can then ask your agent to use `statement_status` to see if your query is finished, running, or if it failed. Once it's done, `get_results` pulls the data directly into your Claude chat. This is perfect for quick analysis without ever leaving the conversation.

Explore Your Data Warehouse

`list_schemas` and `list_tables` give your agent a map of your entire Redshift environment. Just ask Claude to find all tables related to user activity, and it will use these tools to give you an answer. Once you have a table name, tell the agent to use `describe_table` to get the column names and data types. This means you can build a correct query on the first try, because your agent knows the schema before you even start.

Your Redshift MCP Server Toolkit

This MCP Server connects your agent to the AWS Redshift Data API. You're not just running SELECT statements. You can run any SQL, including DDL and DML, to manage the warehouse itself. Your agent can also use `list_statements` to review recent query history. This helps you track what's been run, audit activity, or debug issues directly from your chat prompt.

Setup guide

Set up Amazon Redshift MCP in Claude Web or Desktop

1

Open Claude Settings

Go to claude.ai, click your profile icon, then navigate to Customize → Connectors.
2

Add Custom Connector

Click the "+" button and select Add custom connector. Paste your Vinkius endpoint URL: https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com. For OAuth-protected servers, expand Advanced settings to add credentials.
3

Start a conversation

Open a new chat. The Amazon Redshift MCP tools are available immediately — no restart needed.

Endpoint URL

https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp

No configuration file needed — paste the URL directly in the Claude web interface.

Available on Free (1 connector), Pro, Max, Team, and Enterprise plans.

Prerequisites

Claude Desktop installed (macOS or Windows)
Active Vinkius subscription with a valid endpoint token

1

Open Claude Desktop Settings

Click the menu icon at the top-left corner, go to Settings → Developer → Edit Config. This opens claude_desktop_config.json in your default text editor.
2

Paste the Amazon Redshift MCP configuration

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

Restart Claude Desktop

Close and reopen the application. Claude needs a full restart to load new MCPs — refreshing a conversation is not enough.
4

Verify the connection

Open a new conversation. Click the 🔌 icon at the bottom of the message input. You should see tools listed under amazon-redshift-mcp.

json

{
  "mcpServers": {
    "amazon-redshift-mcp": {
      "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 Desktop

For the app, use the one-click install from the Extensions menu. If you're using claude.ai in the browser, just paste the Vinkius MCP server URL into the Custom Connectors section in your settings.

Yes. Write any SQL statement and pass it to the `execute_sql` tool. Your agent sends it to Redshift and fetches the results for you when it's done.

It runs them in the background. `execute_sql` returns a statement ID immediately, so your chat isn't blocked. You can check the status later with `statement_status` and get the data with `get_results`.

It's all about context. Your agent can reason about the data it gets back from Redshift. It uses that data to answer follow-up questions or even write code for you. It's a conversation, not just a query-result loop.

Yes, your data is safe. The server only interacts with Redshift's Data API. It processes query statement text and result sets inside Vinkius's ephemeral, zero-trust environment and does not store them.

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