How to Use the Amazon Redshift MCP in Windsurf

Give Windsurf direct access to your petabyte-scale data warehouse to autonomously query, analyze, and build features from your database.

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 Windsurf

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

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Windsurf MCP Server for Data Warehousing

Cascade takes a single prompt and builds complete data pipelines. When you ask it to analyze user retention, the agent runs `list_schemas` to find the right environment, then calls `list_tables` to locate the activity logs. You sit back while it maps out the schema using `describe_table`. Instead of stopping to ask for column names, Cascade builds the complex join, triggers `execute_sql`, and pulls the final output through `get_results` right into your editor.

Asynchronous Query Execution

Redshift queries take time, especially over petabytes of telemetry. This MCP integration uses the serverless AWS Data API to fire off heavy operations without locking up your IDE workspace. Cascade issues an `execute_sql` command and immediately gets a statement ID back. It then loops `statement_status` in the background, letting you continue writing Python code until the dataset is ready for extraction.

Autonomous Debugging and Troubleshooting

Broken SQL statements usually mean digging through AWS CloudWatch logs. Now your agent handles the forensic work directly inside the IDE. If a migration script fails, Cascade fires `list_statements` to grab the recent cluster history. It identifies the exact syntax error, rewrites the query, and re-runs the job without you ever opening the AWS console.

Setup guide

Set up Amazon Redshift MCP in Windsurf

Prerequisites

Windsurf IDE installed (macOS, Windows, or Linux)
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Click the Cascade assistant icon in the sidebar, then click the hammer icon (🔨) at the top of the panel. Select "Configure" to open ~/.codeium/windsurf/mcp_config.json.
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

Refresh MCPs

Go back to the hammer icon (🔨) in Cascade and click "Refresh". Windsurf will detect the new server. No full restart is needed — the connection is hot-reloaded.
4

Verify in Cascade

Start a new Cascade conversation and ask something like "Show my Amazon Redshift payment history." If connected, Cascade will call the Amazon Redshift tools directly. You will see a green dot next to the server name in the MCP panel.

mcp_config.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 Windsurf

Open Settings, navigate to Cascade, and find the MCP Servers UI. You can either use the built-in marketplace for a quick install or manually add the server details into your ~/.codeium/windsurf/mcp_config.json file. Hit refresh in the panel to connect.

Yes. The server uses asynchronous execution via the AWS Data API. Cascade triggers the query, checks progress with the statement status tool, and grabs the output when finished.

Cascade dynamically reads your database structure. It calls the list tables and describe table tools before writing any SQL, so your code always matches the live warehouse schema.

No. Vinkius manages the authentication through an isolated V8 sandbox. You only provide a single endpoint token to connect your IDE to the managed server.

Your petabyte-scale warehouse data and SQL query logs remain strictly protected. The isolated environment destroys itself after the session ends, leaving no persistent storage of your proprietary database records.

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