How to Use the Amazon Redshift MCP in VS Code Copilot

Q: How do I configure the Amazon Redshift MCP for my team in VS Code Copilot?

Have a team lead create a .vscode/mcp.json file in the project's root directory. Add the Vinkius server URL there and commit the file to your repo. Everyone who pulls the project will have it configured.

Q: Can VS Code Copilot write a Python script that uses data from Amazon Redshift?

Yes. You can ask Copilot to query Redshift with executesql, get the results, and then write a complete Python script to process that data. It can build the entire file for you, right in the editor.

Give your entire engineering team shared access to Amazon Redshift right inside VS Code Copilot.

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 VS Code Copilot

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

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Team-Wide MCP Server Access

Configure this MCP Server in your project's `.vscode/mcp.json` file. Once you commit it, every developer on your team automatically gets the same Redshift tools in their VS Code Copilot chat. This ends the 'it works on my machine' problem for database access. Everyone from new hires to senior architects can query and explore Redshift using the exact same, centrally managed configuration.

Explore Schemas and Build Queries

Copilot can use `list_schemas` and `list_tables` to discover what's in your data warehouse. Ask it to 'find all tables with customer in the name,' and it will give you a list. From there, use `describe_table` to get the column details for a specific table. This lets your agent construct accurate SQL for `execute_sql` without you having to look up the schema manually.

Run & Manage Queries Asynchronously

The `execute_sql` tool runs queries against the Redshift Data API without blocking your editor. You get a statement ID back, so your workflow isn't stuck waiting for a long query to finish. Your agent can then use `statement_status` to poll for completion and `get_results` to fetch the data. It can also review past queries with `list_statements`, which is great for auditing or debugging as a team.

Setup guide

Set up Amazon Redshift MCP in VS Code Copilot

Prerequisites

VS Code 1.99 or later with GitHub Copilot extension
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Open the Command Palette (Cmd+Shift+P / Ctrl+Shift+P) and run "MCP: Add Server". Select HTTP (Streamable) as the server type. VS Code will create .vscode/mcp.json in your workspace.
2

Add the Amazon Redshift MCP

Paste the JSON snippet shown on the right into your .vscode/mcp.json. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Switch to Agent mode

Open Copilot Chat (Cmd+Shift+I / Ctrl+Shift+I) and switch to Agent mode using the dropdown. MCP tools are only available in Agent mode — they do not appear in Edit or Ask modes.
4

Verify the connection

In the Copilot Chat input, type # to list available tools. You should see the Amazon Redshift tools listed. Try asking: "List my recent Amazon Redshift transactions" and Copilot will invoke them automatically.

.vscode/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 VS Code Copilot

Have a team lead create a `.vscode/mcp.json` file in the project's root directory. Add the Vinkius server URL there and commit the file to your repo. Everyone who pulls the project will have it configured.

Yes. You can ask Copilot to query Redshift with `execute_sql`, get the results, and then write a complete Python script to process that data. It can build the entire file for you, right in the editor.

Yes, it's fully compatible. Your organization can manage access and ensure compliance while giving developers powerful tools in their editor. This MCP server works perfectly with your existing setup.

This isn't just a GUI for your database. It gives your AI agent the ability to programmatically access and reason about your data. Copilot uses the tools to answer complex questions or automate multi-step tasks involving your Redshift warehouse.

Nothing is stored. The MCP server processes SQL statements and result sets in-memory for each request. Vinkius uses ephemeral sandboxes, which means your data is not logged or saved anywhere.

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