Copilot Studio

Microsoft Copilot Studio connection to MySQL database

(1) Share

Report

Posted on by MK-10090737-0

I’ve been working on connecting Microsoft Copilot directly to my local MySQL database. Here’s what I’ve done so far:

Created a MySQL user with the necessary privileges to allow remote access.
Set up an on-premises data gateway to facilitate the connection between the MySQL database and Microsoft Power Automate.
Added the MySQL connector in Power Automate to enable communication between the database and Copilot Studio.

However, I’m encountering the following challenges:

At times, I encounter a connection error indicating that the MySQL connector is receiving an incorrect request.

The connector ‘MySQL’ returned an HTTP error with code 400. Error Code: ConnectorRequestFailure
No response from Copilot: In certain cases, the bot doesn't return any response after I attempt to interact with the database.
General message about database access: I also receive messages stating that Copilot doesn’t have direct access to databases and cannot execute queries or show real-time results.

After doing some additional research, I found that Microsoft Copilot Studio doesn't seem to support direct execution of MySQL queries on a local database.

Could you please provide some guidance on whether there's another approach or if I'm missing something in my setup?

I tried to connect MySQL database to Microsoft Copilot Studio. However, it seemed impossible to directly retrieve data from the database.

Categories:

General topics

All responses (3)

Answers (0)

Sort by

CU20120730-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

hello, may i know have you successfully connect MySQL database to Microsoft Copilot Studio to directly retrieve data from the database? if yes, how do you done it, can you share with me. Thx you.
Suggested answer

Artur Stepniak 1,539 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

why would you like to use MySQL database? Is it a must-have requirement? It would be easier for you to use a Dataverse table for that purpose.

In case of any other questions, let me know. If the answer helped you, mark it, so that others can benefit from it.

Best regards,

Artur Stepniak

Interested in GenAI? Visit my site!
Suggested answer

Vinoth Selvam 1,597 Super User 2025 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi MK-10090737-0,

The steps followed seems to fine.

Anyhow connecting MySQL database to Microsoft Copilot Studio directly is not possible at this point.

Does your approach provides output sometimes? If so we can check the Power automate flow logs.

Anyhow will wait for other experts to give a solution.

Thanks.
For Copilot studio technical blogs: Visit my Site