Connecting GPT4 with SQL data

Question

Connecting GPT4 with SQL data

Innoimagine 0

Hello!

I want to create a model using OpenAI that can take queries from a user in plain english language and retrieve the data from an SQL database and answer it in plain language. Is there a way to achieve this? The model should be able to create SQL queries from the text, fire them and return the result back to the user. We are okay if we need to convert the database data into json or txt files. But the data is huge (millions of lines).

AshokPeddakotla-MSFT 35,971 Reputation points Moderator

2023-12-18T13:51:39.4166667+00:00

Innoimagine We received your feedback that the answer provided on the thread was not helpful.

Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback.

I have provided an answer with blogpost which has clear steps for the scenario you are looking for.

I also see that you have deleted few comments.

It is unclear in the blog if the Azure AI is used for converting speech to text or convert text to sql. Could you please clarify that?

To answer your query, yes, in the Python code class named STTPlugin that provides a function for converting speech to text using the Azure Cognitive Services Speech SDK. Please check Creating the Plugins section for more details.

Speech To Text: Speech to text overview - Speech service - Azure Cognitive Services | Microsoft Learn

If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!
AshokPeddakotla-MSFT 35,971 Reputation points Moderator

2023-12-20T02:10:46.03+00:00

Innoimagine Just checking if we are still connected on this discussion? Please let us know if you need further help.
AshokPeddakotla-MSFT 35,971 Reputation points Moderator

2023-12-28T09:22:39.4633333+00:00

Innoimagine Did you get a chance to see my response?

It is unclear in the blog if the Azure AI is used for converting speech to text or convert text to sql. Could you please clarify that?

To answer your query, yes, in the Python code class named STTPlugin that provides a function for converting speech to text using the Azure Cognitive Services Speech SDK. Please check Creating the Plugins section for more details.

Speech To Text: Speech to text overview - Speech service - Azure Cognitive Services | Microsoft Learn

If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!

1 answer

Your answer

AshokPeddakotla-MSFT 35,971 Reputation points Moderator

2023-12-18T13:51:39.4166667+00:00

Innoimagine We received your feedback that the answer provided on the thread was not helpful.

Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback.

I have provided an answer with blogpost which has clear steps for the scenario you are looking for.

I also see that you have deleted few comments.

It is unclear in the blog if the Azure AI is used for converting speech to text or convert text to sql. Could you please clarify that?

To answer your query, yes, in the Python code class named STTPlugin that provides a function for converting speech to text using the Azure Cognitive Services Speech SDK. Please check Creating the Plugins section for more details.

Speech To Text: Speech to text overview - Speech service - Azure Cognitive Services | Microsoft Learn

If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!
AshokPeddakotla-MSFT 35,971 Reputation points Moderator

2023-12-20T02:10:46.03+00:00

Innoimagine Just checking if we are still connected on this discussion? Please let us know if you need further help.
AshokPeddakotla-MSFT 35,971 Reputation points Moderator

2023-12-28T09:22:39.4633333+00:00

Innoimagine Did you get a chance to see my response?

It is unclear in the blog if the Azure AI is used for converting speech to text or convert text to sql. Could you please clarify that?

To answer your query, yes, in the Python code class named STTPlugin that provides a function for converting speech to text using the Azure Cognitive Services Speech SDK. Please check Creating the Plugins section for more details.

Speech To Text: Speech to text overview - Speech service - Azure Cognitive Services | Microsoft Learn

If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!

Answer 1

Innoimagine Greetings & Welcome to Microsoft Q&A forum!

I want to create a model using OpenAI that can take queries from a user in plain english language and retrieve the data from an SQL database and answer it in plain language. Is there a way to achieve this?

Did you check this Revolutionizing SQL Queries with Azure Open AI and Semantic Kernel already?

User's image

This architecture diagram shows how a user can interact with a SQL server using natural language and receive the output as speech. It uses Azure Speech Services and an NLP system to convert the user’s speech into an SQL query and then fetches data from the SQL server based on that query. Finally, the result is converted back into speech using Azure Text to Speech Service and played back to the user

The blog post provides a step-by-step guide on how to create a semantic search model using Azure OpenAI and integrate it with your SQL database. It also includes sample code and screenshots to help you get started.

I would recommend reading through the blog post and following the instructions to create your own semantic search model.

Do let me know if that helps or have any further queries.

If the response helped, please do click Accept Answer and Yes for was this answer helpful.

Doing so would help other community members with similar issue identify the solution. I highly appreciate your contribution to the community.

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Share via

Connecting GPT4 with SQL data

1 answer

Your answer