Chat With SQL Database In Natural Language Using Azure OpenAI

Are you ready to revolutionize your database interactions? In this video, I'll show you how can you ask questions to your SQL database in a plain English using Azure OpenAI's gpt-35-turbo-instruct.
👉 Subscribe now and hit the notification bell to stay updated on our latest tech tutorials! Let’s chat with data like never before! 🗣️💡
* REFERRAL LINK ************
🤩 Creating websites simpler than Wix and Wordpress: www.strikingly...
* REFERRAL LINK ************
................ LINKS ................
Medium: / shweta-lodha
Blog: shwetalodha.in
You can support me here: www.buymeacoff...
.............................................
###### AI PLAYLISTS ########
⭐Azure OpenAI
• Azure OpenAI
⭐OpenAI
• OpenAI
⭐Azure Prompt Flow
• Azure ML Prompt Flow
⭐ChatGPT
• ChatGPT
⭐AI In General
• AI In General
⭐Azure AI & Machine Learning
• Azure Machine Learning...
###### MORE PLAYLISTS ######
⭐Python for beginners
⭐Python Pandas
⭐Python tips and tricks
⭐Jupyter tips & tricks
⭐Microsoft Azure
⭐Visual Studio Code a.k.a. VS Code
#openai #chatbot #chatgpt #trending

[@seadude]

Your content is excellent, thank you! Since LangChain is not often allowed in enterprise environments, it would be wonderful to see some vanilla Python examples.

[@shweta-lodha]

Great suggestion! Will try to do one.

[@sankalpmore9606]

Can you show this using promptflow portal😊

[@shweta-lodha]

Will do it sometime

[@amithpatel]

I have a question. What service you need to register with Langchain? How does Langchain and Azure OpenAI integrate in this example? Is it possible to share the config file, removing the Keys and Endpoints from your file..

[@shweta-lodha]

As you can see, we are getting SQL chaining and db object creation part from langchain and LLM creds from AzureOpenAI, that’s how it is integrated. Config file contains text in the form of key-value pair. For example, api_key=“val”.

[@surekhap8140]

How to configure Azure SQL in environment variables??

[@rahulsharma15]

Thank you for this video.
I am having a use case where I want to connect more than 100 tables of single azure sql database. Can you please guide me how can I achieve this ?

[@shweta-lodha]

Thanks for watching. I haven’t tried it with these many tables, perhaps it may not work. I am publishing another video in a day or 2, which handles more complex scenarios using agents. There you can provide all the required info in the prompt about tables/schema/column-description, etc. Stay tuned!