Use Amazon Redshift with your AI.
Connect your account once and let the AI you already use work with it, without building another integration. Equip your AI to directly query, analyze, and manage your petabyte-scale data warehouse via the serverless AWS Redshift Data API.
Developed, maintained, and hosted by Vinkius.
MCP VERIFIED · PRODUCTION READY · VINKIUS GUARANTEED
Waiting for input…
Works with modern AI clients that support MCP, including ChatGPT, Claude, Cursor, and more.
Complete set · 7 capabilities
The complete Amazon Redshift capability set.
These are the exact actions your AI can choose when you ask it to work with Amazon Redshift.
01-04
4 capabilities in this set.
Part of 7 available through Amazon Redshift.
- 01
Describe table
Retrieves column metadata for a table
- 02
Execute SQL
This is an asynchronous operation that returns a statement ID. Executes a SQL statement using the Redshift Data API
- 03
List statements
Lists recent SQL statements executed in the cluster
- 04
Get results
Retrieves the results of a completed SQL statement
05-07
3 capabilities in this set.
Part of 7 available through Amazon Redshift.
- 05
List tables
Lists all tables in a specific schema
- 06
Statement status
Checks the execution status of a SQL statement
- 07
List schemas
Lists all database schemas in Redshift
Observed, not estimated
843ms average. Fast in production.
Amazon Redshift is checked daily against the live service.
- Fastest day
- 699ms
- Slowest day
- 1058ms
- 14-day trend
- Improving-27%
Connect your client
One URL. Every client.
Activate the Connector, copy your link, and paste it into the client you already use. 7 capabilities arrive ready to run.
Preview access · not provider authentication
The vk_preview_* token belongs to Vinkius preview infrastructure. It lets Claude discover and display the capabilities of Amazon Redshift, so you can see the experience inside your AI.
It does not authenticate your account with Amazon Redshift. Actions requiring credentials or live account data may not run until you activate the Connector and authorize the service.
Amazon Redshift Connector
You're all set. Choose your MCP client and follow the setup instructions.
https://edge.vinkius.com/vk_preview_QDzQjDxNMJC2VmZh3q1JKRAmKezB8DhMd2clGxBp/mcpClaude Desktop
Follow the steps below to connect in seconds.
- 1In Claude Desktop, open Settings → Connectors.
- 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
- 3Click Add and start a new chat — Amazon Redshift capabilities are ready to use.
{
"mcpServers": {
"amazon-redshift-mcp": {
"url": "https://edge.vinkius.com/vk_preview_QDzQjDxNMJC2VmZh3q1JKRAmKezB8DhMd2clGxBp/mcp"
}
}
}
Claude
ChatGPT
Cursor
VS Code
Windsurf
Claude Code
JetBrains
Cline
Step-by-step instructions for each client are in the guide. How to connect
FAQ
Questions Amazon Redshift owners ask.
- 01
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.
- 02
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.
- 03
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.
Explore
More in Industry Titans
Snowflake AI Connector
Execute SQL queries, manage databases, and analyze data on Snowflake with AI agents.
ViewSnowflake AI Connector
Execute SQL queries, manage databases, and analyze data on Snowflake with AI agents.
ViewStarRocks AI Connector
High-performance analytical database — manage clusters, tables, and query data via AI.
ViewClickHouse (Vector Search) AI Connector
Manage vector embeddings and SQL via ClickHouse — list databases, execute SQL, and perform high-speed vector s
View
Suggestions
Apache Superset AI Connector
Connect your AI to Apache Superset. Explore BI dashboards, extract chart data, and run live SQL Lab analytics
ViewSingleStore AI Connector
Equip your AI agent to natively interact with your SingleStore database. Execute raw SQL queries, perform sema
ViewNinox AI Connector
Build custom business databases and apps with a visual platform that replaces spreadsheets with structured, re
ViewCData Connect Cloud AI Connector
Universal Data Gateway mapping explicitly proxy structures parsing SQL schemas dynamically connecting APIs nat
View
