Copilot + SQL databases
Connect Microsoft 365 Copilot to your SQL database
Use the free BlazeSQL connector to let Copilot answer questions from SQL Server, PostgreSQL, MySQL, Snowflake, Databricks, BigQuery or Amazon Redshift. Choose your database below for the exact setup requirements.
- Free app on Microsoft Marketplace
- Live, read-only SQL
- No Copilot Studio build
Official destination: marketplace.microsoft.com
Choose your database
Copilot database setup guides
Each guide explains the connection details, permissions and network access commonly needed for that database.
The shared setup
How the Copilot SQL connector works
-
01
Open BlazeSQL on Microsoft Marketplace
Use the direct link on this page. It opens the BlazeSQL listing on the official marketplace.microsoft.com domain.
-
02
Add the free app
Select Get it now. If your organization asks for admin approval, send the listing to your Microsoft 365 admin and connect your database in BlazeSQL while you wait.
-
03
Sign in and connect your database
In Microsoft 365 Copilot, choose BlazeSQL, sign in and enter the approved database details. Then ask Copilot questions about your data.
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 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.
-
Microsoft’s built-in SQL connectors
They copy selected rows into Microsoft 365 search on a schedule, so Copilot can find individual records. They aren’t built to calculate totals or trends across whole tables.
Access and security
Keep database access under your control
The connector only runs read-only queries, and the database login you provide limits what it can reach. For production systems, use a dedicated login with access only to the data intended for analysis.
For the rest of your team
Use the same answers in Teams and on the web
Colleagues without a Copilot license can ask the same questions 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 database connector FAQ
Can Microsoft 365 Copilot connect to a SQL database?
Yes, with a connector. With the BlazeSQL app, Copilot looks up your tables, writes SQL and has BlazeSQL run it read-only on the databases listed on this page, then answers with the results.
Is the BlazeSQL connector for Copilot 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.
Which databases can I connect to Copilot?
The current guides cover Microsoft SQL Server and Azure SQL, PostgreSQL, MySQL, Snowflake, Databricks, Google BigQuery and Amazon Redshift.
Can Copilot change data in my database?
No. The connector only runs read-only queries. Statements that change data, such as UPDATE or DELETE, are blocked.
Ready to connect?
Connect your SQL database to Microsoft 365 Copilot
Continue to the official listing, add BlazeSQL and select your database.