Bring Data Warehousing
to VS Code Copilot
Create your Vinkius account to connect Amazon Redshift to VS Code Copilot 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 VS Code Copilot?
GitHub Copilot Agent mode brings Amazon Redshift data directly into your VS Code workflow. With a project-scoped config, the entire team shares access to 7 tools. Copilot queries live data, generates typed code, and writes tests from actual API responses, all without leaving the editor.
- —
VS Code is used by over 70% of developers. adding MCP tools to Copilot means your team can leverage external data without leaving their primary editor
- —
Project-scoped MCP configs (
.vscode/mcp.json) let you commit server configurations to your repository, ensuring the entire team shares the same tool access - —
Copilot's Agent mode integrates MCP tools seamlessly with file editing, terminal commands, and workspace search in a single agentic loop
- —
GitHub's enterprise compliance and audit features extend to MCP tool usage, providing visibility into how AI interacts with external services
Amazon Redshift in VS Code Copilot
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 VS Code Copilot 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 VS Code Copilot
Every request between VS Code Copilot 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.
Which VS Code version supports MCP?
MCP support requires VS Code 1.99 or later with the GitHub Copilot extension. Ensure both are updated to the latest version. Older versions of Copilot may not expose the Agent mode toggle.
How do I switch to Agent mode?
Open the Copilot Chat panel and look for two mode options: "Ask" and "Agent". Click "Agent" to enable autonomous tool calling. In Ask mode, Copilot provides conversational answers but cannot invoke MCP tools.
Can I restrict which MCP tools Copilot can access?
Yes. VS Code shows a tool consent dialog before any MCP tool is invoked for the first time. You can also configure tool access policies at the organization level through GitHub Copilot settings.
Does MCP work in VS Code Remote or Codespaces?
Yes. MCP servers configured via .vscode/mcp.json work in Remote SSH, WSL, and GitHub Codespaces environments. The MCP connection is established from the remote host, so ensure the server URL is accessible from that environment.
MCP tools not available
Ensure you are in Agent mode in Copilot Chat. MCP tools only appear in Agent mode.
Explore More MCP Servers
View all →
Kustomer
10 toolsManage customer service — list conversations, audit customers, and search timelines.
Mabl (AI-Powered Test Automation)
10 toolsManage E2E testing via Mabl — trigger test plans, monitor execution results, and perform AI-driven failure analysis.
GivingFuel
10 toolsRetrieve donation orders, track registrants, and oversee fundraising pages via AI agents with GivingFuel.
PubNub (Real-time Messaging)
31 toolsEnable real-time messaging, presence tracking, and message history for your AI agent using PubNub's global data stream network.