Microsoft 365 Copilot Microsoft 365 Copilot database guide

Copilot + Redshift

Connect Microsoft 365 Copilot to Amazon Redshift

Use the BlazeSQL app to let Microsoft 365 Copilot answer questions about data in an Amazon Redshift cluster or serverless workgroup. The database user and network path you set up limit what it can reach.

  • Free app on Microsoft Marketplace
  • Live, read-only SQL
  • No Copilot Studio build
Get the free Copilot connector

Official destination: marketplace.microsoft.com

Illustration of a BlazeSQL answer in Microsoft 365 Copilot. Copilot asks BlazeSQL for your tables, writes the SQL, and BlazeSQL runs it read-only on Redshift.

Three steps

Connect Copilot to Redshift

  1. 01

    Open BlazeSQL on Microsoft Marketplace

    The button above takes you straight to the BlazeSQL listing on marketplace.microsoft.com, so you don’t need to search for it.

  2. 02

    Add the app for your account

    Select Get it now and add BlazeSQL. If your organization asks for admin approval, send the listing to your Microsoft 365 admin and connect Redshift in BlazeSQL while you wait.

  3. 03

    Sign in and connect Redshift

    In Microsoft 365 Copilot, choose BlazeSQL and sign in. Then select Redshift, enter the approved connection details and pick the data Copilot can use.

Before you start

What you need for Redshift

  • A Microsoft 365 Copilot license
  • Redshift cluster or serverless endpoint
  • Database name and port (commonly 5439)
  • A database username and supported authentication method
  • VPC, security group and network access required by the endpoint

Optional but recommended

Create a read-only Redshift login for Copilot

BlazeSQL already blocks queries that change data. A login that can only read adds a second safeguard. Replace the example names and password with your own.

Once connected

Questions you can ask Copilot about Redshift data

Which accounts drove the change in monthly recurring revenue?

Show fulfilment delays by warehouse and carrier.

Identify unusually expensive queries from the last seven days.

Other ways to connect

How BlazeSQL compares with other Copilot options

  • BlazeSQL app

    Add it from Microsoft Marketplace and ask questions straight away. Each question runs a new read-only query on live Redshift data, so Copilot can answer with totals, trends and comparisons.

  • A custom agent in Copilot Studio

    You can build your own database agent, but someone has to set up the connection, design the agent and maintain it.

For the rest of your team

Use the same answers in Teams and on the web

Colleagues without a Copilot license can ask questions about Redshift in Microsoft Teams or the BlazeSQL web app. Business definitions you teach BlazeSQL once, like how you count active customers, apply everywhere.

Common questions

Copilot and Redshift FAQ

Can Copilot connect to Redshift?

Yes. Copilot can query Amazon Redshift through the BlazeSQL connector using the cluster or serverless endpoint, database credentials and a network route that can reach it.

Is the Copilot database connector free?

The BlazeSQL app is free to add from Microsoft Marketplace. Using it inside Copilot requires a Microsoft 365 Copilot license from Microsoft, and BlazeSQL itself may have plan limits for heavier use.

Do I need a Microsoft 365 admin?

Not always. If your organization restricts which apps people can add, a Microsoft 365 admin needs to approve BlazeSQL first. You can use BlazeSQL directly while you wait.

Can Copilot change data in Redshift?

No. The connector only runs read-only queries. Statements that change data, such as UPDATE or DELETE, are blocked.

Ready to connect?

Connect Redshift to Microsoft 365 Copilot

Continue to the official listing, add BlazeSQL and connect your database.

Go to Marketplace