Connect your data to Claude in 1 minute. No code needed Try it now

Connect Redshift to Copilot

Send Redshift table or view and custom SQL to Copilot on a schedule. Refresh as often as every 15 minutes.

capterra
star star star star star

4.9/5

Copilot

What changed in our Redshift data since last week?

Querying the Redshift data set in Coupler.io
Copilot queries your Redshift data through the Coupler.io MCP connector. Access is read-only.
Trusted by 200K+ users worldwide
Spotify
fifty-five
Al Jazeera
InPost
Visma
REHAU
Getir
Printify
Macromill
Stanford
Médecins Sans Frontières
Greenpeace
Save the Children
San Diego FC

How to connect Redshift and Copilot

4 steps. You can preview the Redshift data in Coupler.io before anything reaches Copilot.

Step 1 of 4

Connect Redshift

Add the Redshift account you want to export from.

Connect Redshift

Step 2 of 4

Choose what to export

Pick the Redshift data you want in Copilot.

SchemaNot setProvide the schema of the Redshift you want to use for export.
Table / ViewNot setSpecify which table or view you want to export.
SQL queryNot setEnter the SQL query used to select specific data from Redshift.

Step 3 of 4

Connect Copilot

In Copilot Studio, add a Model Context Protocol tool to your agent with the Coupler.io MCP server URL from the destination step. Each user signs in to Coupler.io once.

Data set to shareTable or viewThe data view the agent can read
Coupler.io MCP server URLhttps://mcp.coupler.io/mcpShown in the destination step, paste in Copilot Studio
AuthenticationOAuth 2.0OAuth 2.0 with Dynamic discovery, no client secret

Step 4 of 4

Set a schedule

Copilot sees the data as of the last run. Run it as often as every 15 minutes.

Get the most of Redshift to Copilot integration

Gather data icon

Gather data

Export data from numerous apps and sources into a single destination. Blend data from different apps to get a single source of truth.
Understand data icon

Understand data

Preview, transform, sort, and filter data for better clarity in just a few clicks in the Coupler.io interface. Take your data analytics to the next level.
Automate data icon

Automate data

Access data that is always up to date by enabling the automatic data refresh on a schedule as often as every 15 minutes and using triggered automation.
Act on data icon

Act on data

Visualize your data by quickly connecting to data visualization and BI tools. Build insightful dashboards in a breeze and make better decisions.
Redshift to Copilot questions

2 report types, including Table or view and Custom SQL.

Yes. SQL query lets you write a query instead of picking a ready-made report type.

No. The data stays in Coupler.io, and Copilot queries it read-only when you ask a question. It can't edit or delete Redshift rows.

Microsoft Copilot Studio. Add Coupler.io to your agent as an MCP tool, and the agent can query your Redshift data.

On a schedule you choose, from monthly down to every 15 minutes, depending on your Coupler.io plan.

Yes. Add more sources to the same data flow, for example Google Sheets or Airtable, and join or append them before the data reaches Copilot.

High five for scrolling till the very end!
See you in the app!