Copilot + SQL Server
Connect Microsoft 365 Copilot to SQL Server & Azure SQL
Use the BlazeSQL app to ask Microsoft 365 Copilot questions about data in SQL Server or Azure SQL Database. Copilot gets answers from live data without anyone exporting tables to Excel first.
- Free app on Microsoft Marketplace
- Live, read-only SQL
- No Copilot Studio build
Official destination: marketplace.microsoft.com
Three steps
Connect Copilot to SQL Server
-
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.
-
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 SQL Server in BlazeSQL while you wait.
-
03
Sign in and connect SQL Server
In Microsoft 365 Copilot, choose BlazeSQL and sign in. Then select SQL Server, enter the approved connection details and pick the data Copilot can use.
Before you start
What you need for SQL Server
- A Microsoft 365 Copilot license
- SQL Server hostname or network address
- Database name and port (commonly 1433)
- A database username and password or supported authentication method
- Network access to the server and your required encryption settings
Optional but recommended
Create a read-only SQL Server 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.
-- Run in the master database
CREATE LOGIN blazesql_reader WITH PASSWORD = 'replace-with-a-strong-password';
-- Run in the database Copilot should read
CREATE USER blazesql_reader FOR LOGIN blazesql_reader;
ALTER ROLE db_datareader ADD MEMBER blazesql_reader;
db_datareader can read every table in the database. To limit access, grant SELECT on specific schemas or tables instead.
Once connected
Questions you can ask Copilot about SQL Server data
Which customers generated the most revenue this quarter?
Why did order volume fall compared with last month?
Show the slowest-running reporting queries and the tables they use.
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 SQL Server 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 Server connector
It copies selected rows into Microsoft 365 search on a schedule, so Copilot can find individual records. It isn’t built to calculate totals or trends across whole tables.
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 SQL Server 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 SQL Server FAQ
Can Copilot connect to SQL Server?
Yes. Copilot can query Microsoft SQL Server and Azure SQL Database through the BlazeSQL connector when the server is reachable and the login can read the data you want to use.
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 SQL Server?
No. The connector only runs read-only queries. Statements that change data, such as UPDATE or DELETE, are blocked.
Ready to connect?
Connect SQL Server to Microsoft 365 Copilot
Continue to the official listing, add BlazeSQL and connect your database.