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

I have the same question (0)

All responses (3)

Answers (0)

CU20120730-0 4 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Artur Stepniak 1,539 Super User 2025 Season 2 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

Vinoth Selvam 1,590 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No