Use AI to chat with a relational SQL database with natural language!

Intro to Azure OpenAI

My other AI videos:

In this video we'll explore how to use the powerful OpenAI gpt-4 model to search your SQL Database using natural language. GPT-4 excels at understanding natural language, and can even understand database schemas and produces code and SQL queries of its own. We'll explore a working demo, the app architecture and the code necessary to get this working.

00:00 Intro
01:09 App demo
05:53 Architecture
07:12 Database setup
09:17 AI service setup
10:57 Explore the app code
20:13 Search service concepts

[Jake-tdnm]

AI has so much coverage, and 99% of it is either "here's a photorealistic image that has 13.5 fingers" or even worse the generic "You should be terrified because AI is coming!" both of which hold no value, provide no context, and don't show any use case that's valuable to 95% of individuals, and 100% of enterprise.

Conversely, this video shows an actual coherent use of AI that could blow up and be super valuable - actually improving the productivity of people using it. Bravo!

[ShaharNardiaAllOverTheNet]

thank you very much wolf🙏
exactly what I am coding right now for my customer

[sindhupillai]

Good starting point for the people who are exploring more with Gen AI. Thanks for sharing valuable real time use-case. I am in 'Subscribed'. Hurray! waiting for more such use cases.

[alexthecodewolf]

Due to the requests here I'm working on getting the source code available for this, it was tied to a project I couldn't release but am working that out.

[lshagh]

That was very useful and professional. Thank you indeed and thanks for sharing 👍

[Burak]

Hi thank you for sharing. Is there a way to get the sample code?

[GeorgeZoto]

Thank you for sharing another great tutorial :)

[TellaTrix]

Wowo ! No more developer required to binding data and complex query.

[applepeel]

Hey! Please share the source code!

This is honestly really cool

[alexclark]

Remember Microsoft English Query? Pepperidge Farm Remembers...

[rubberuk]

Excellent video! Have you got a link to source code? thank you.

[andrewherrick]

hi this is pretty cool. is your code available open source? i checked your GH but didn't see it. thanks!

[iamalmostanonymous]

Sqlite would be a simpler starting DB. No need for MS subscription.

[SocratesPonnusamy-piiu]

Hello Alex, This video was very helpful. I have a question. Do you have a video showing how we can do the same thing from a chatbot?

[Trymore-ri]

Good day bro .I need your help to setup my azure databse.I have been facing challenges for some time

[pvsherman]

Excellent video. But unfortunately I'm getting very inconsistent results. As soon as a little bit more complicated SQL needs to be produced - every run returns a different result. Subqueries, unions are too much for it. Or I'm doing something wrong.
Probably will have to create views so AI will be able to do simple selects.

[jigar]

Any suggestions as to how you can make this work with a microservices setup with individual domain databases?

[AbhinavKumar-txer]

Thanks for making this video. So what is the probability that it won't hallucinate . Well I am using similar kind of prompting approach when using llama model but curious to know about hallucination.

[sajjadmussani]

very informative. can you please share the code of your Razor app?

[sinamohammadpourinaeim]

Hi Code Wolf
Thanks for your useful video, Is there any offline AI Service to use the same thing in our local machine or our own sever?