Bring Data Warehousing
to Windsurf
Create your Vinkius account to connect Amazon Redshift to Windsurf and start using all 7 AI tools in minutes. Fully managed, enterprise secure, and ready to use without writing a single line of code. No hosting, no server setup — just connect and start using.
GDPR Free for SubscribersCompatible with every major AI agent and IDE
Gemini
What is the Amazon Redshift MCP Server?
Connect your Amazon Redshift data warehouse securely to your AI agent utilizing the AWS Redshift Data API. This integration empowers your AI interface to natively run aggregations, explore massive schemas, and retrieve historical executing query logs asynchronously without requiring persistent DB connection pools, JDBC drivers, or complex networking configurations.
What you can do
- Execute Asynchronous SQL — Direct the AI to execute standard SQL commands (
execute_sql), including complex SELECT aggregations, table creation (DDL), or data mutation (DML). Since it uses the Data API, long-running queries will process in the background. - Poll & Retrieve Results — Ask the agent to proactively monitor the execution lifecycle (
statement_status) of dispatched query IDs and retrieve the dataset rows (get_results) securely into your terminal upon completion. - Schema & Table Discovery — Understand the database structure dynamically by generating lists of available schemas (
list_schemas) or looking up column metadata metrics for specific tables (describe_table). - Statement Histories — Perform audits assessing previously submitted query structures and track analytical workloads running on your configured cluster (
list_statements).
How it works
- Authorize the Amazon Redshift MCP plugin from your connected extension hub.
- Configure your serverless integration using standard AWS IAM principles. Supply an Access Key ID & Secret targeting your cluster, identifying the specific endpoint, Database Name, and DB User.
- Chat seamlessly with your AI to prompt queries like "Describe the metadata for the 'public.events' table" or "Execute a query counting all sales processed yesterday."
Who is this for?
- Data Analysts & Scientists — Execute ad-hoc exploratory aggregations through natural language prompts. Pull specific dataset metrics and schemas instantly into chat without switching to external SQL IDEs like DBeaver.
- Backend Developers — Test schema migrations intuitively. Troubleshoot data integrations and check table state integrity interactively from the code editor during development.
- Data Engineers — Audit Redshift cluster loads and verify execution lifecycles asynchronously for large reporting workloads directly connected to your conversational toolkit.
Built-in capabilities (7)
Retrieves column metadata for a table
This is an asynchronous operation that returns a statement ID. Executes a SQL statement using the Redshift Data API
Retrieves the results of a completed SQL statement
Lists all database schemas in Redshift
Lists recent SQL statements executed in the cluster
Lists all tables in a specific schema
Checks the execution status of a SQL statement
Why Windsurf?
Windsurf's Cascade agent chains multiple Amazon Redshift tool calls autonomously. query data, analyze results, and generate code in a single agentic session. Paste Vinkius Edge URL, reload, and all 7 tools are immediately available. Real-time tool feedback appears inline, so you see API responses directly in your editor.
- —
Windsurf's Cascade agent autonomously chains multiple tool calls in sequence, solving complex multi-step tasks without manual intervention
- —
Purpose-built for agentic workflows. Cascade understands context across your entire codebase and integrates MCP tools natively
- —
JSON-based configuration means zero code changes: paste a URL, reload, and all 7 tools are immediately available
- —
Real-time tool feedback is displayed inline, so you see API responses directly in your editor without switching contexts
Amazon Redshift in Windsurf
Why run Amazon Redshift with Vinkius?
The Amazon Redshift connection runs on our fully managed, secure cloud infrastructure. We handle the hosting, maintenance, and security so you don't have to deal with servers or code. All 7 tools are ready to work instantly without any complex setup.
You stay in complete control of your data. Your AI only accesses the information you approve, keeping your sensitive passwords and private details completely safe. Plus, with automatic optimizations, your AI works faster and more efficiently.
* Every connection is hosted and maintained by Vinkius. We handle the security, updates, and infrastructure so you don't have to write code or manage servers. See our infrastructure
Over 4,000 integrations ready for AI agents
Explore a vast library of pre-built integrations, optimized and ready to deploy.
Connect securely in under 30 seconds
Generate tokens to authenticate and link external services in a single step.
Complete visibility into every agent action
Audit live requests, latency, success rates, and active security compliance policies.
Optimize spending and track token ROI
Analyze real-time token consumption and cost metrics detailed by connection.
Explore our live AI Agents Analytics dashboard to see it all working
This dashboard is included when you connect Amazon Redshift using Vinkius. You will never be left in the dark about what your AI agents are doing with your tools.
Amazon Redshift and 4,000+ other AI tools. No hosting, no code, ready to use.
Professionals who connect Amazon Redshift to Windsurf through Vinkius don't need to write code, manage servers, or worry about security. Everything is pre-configured, secure, and runs automatically in the background.
Raw MCP | Vinkius | |
|---|---|---|
| Ready-to-use MCPs | Find and configure each manually | 4,000+ MCPs ready to use |
| Connection Setup | Manual coding & server setup | 1-click instant connection |
| Server Hosting | You host it yourself (needs 24/7 uptime) | 100% hosted & managed by Vinkius |
| Security & Privacy | Stored in plaintext config files | Bank-grade encrypted vault |
| Activity Visibility | Blind execution (no logs or tracking) | Live dashboard with real-time logs |
| Cost Control | Runaway AI token spend risk | Automatic budget limits |
| Revoking Access | Must delete files or code to stop | 1-click disconnect button |
How Vinkius secures
Amazon Redshift for Windsurf
Every request between Windsurf and Amazon Redshift is protected by our secure gateway. We automatically keep your sensitive data private, prevent unauthorized access, and let you disconnect instantly at any time.
Frequently asked questions
Are query results limited by size?
Yes. The underlying Redshift Data API imposes soft constraints; for enormous responses, you might receive a paginated NextToken. While this MCP server auto-handles some response collection, queries returning over a few megabytes of raw JSON should be pre-filtered using LIMIT or aggregated to avoid token constraints in the LLM.
Can I use standard IAM credentials or do I need specific AWS roles?
The integration accepts standard static IAM keys (AWS_ACCESS_KEY_ID & AWS_SECRET_ACCESS_KEY), provided they hold sufficient IAM inline or attached policies allowing use of redshift-data:* operations targeting your exact Cluster ARN.
Why does `execute_sql` only return a statement ID instead of the data?
Because the Amazon Redshift Data API is strictly asynchronous. Queries often take seconds to minutes. Returning the statement_id instantly allows the AI to continue parsing conversations or interacting with other systems without locking up, executing get_results at a later time when the query officially succeeds.
How does Windsurf discover MCP tools?
Windsurf reads the mcp_config.json file on startup and connects to each configured server via Streamable HTTP. Tools are listed in the MCP panel and available to Cascade automatically.
Can Cascade chain multiple MCP tool calls?
Yes. Cascade is an agentic system. it can plan and execute multi-step workflows, calling several tools in sequence to accomplish complex tasks without manual prompting between steps.
Does Windsurf support multiple MCP servers?
Yes. Add as many servers as needed in mcp_config.json. Each server's tools appear in the MCP panel and Cascade can use tools from different servers in a single flow.
Server not connecting
Check Settings → MCP for the server status. Try toggling it off and on.
Explore More MCP Servers
View all →
Crafter CMS
10 toolsManage headless content via Crafter CMS — execute GraphQL queries, write Git-based XML content, and publish to delivery engines directly from any AI agent.
Contentful
12 toolsEquip your AI agent to fetch, create, and manage digital content effortlessly using Contentful's headless architecture.
Wave Financial
10 toolsManage your accounting via Wave Financial — query businesses, invoices, customers, and transactions directly from any AI agent.
Hive (Project Management)
7 toolsManage projects via Hive — create actions, track initiatives, and organize workspaces.