Use AI to chat with a relational SQL database with natural language!
HTML-код
- Опубликовано: 13 май 2024
- Demo app: github.com/alex-wolf-ps/chat-...
Intro to Azure OpenAI
• Learn Azure OpenAI - G...
My other AI videos:
Use AI to chat with a NoSQL database: • Use AI to chat with a ...
Learn to code a simple AI powered app: • Learn Azure OpenAI - B...
Learn to use AI to chat with your document data: • Learn Azure OpenAI - C...
Learn Azure OpenAI fundamentals: • Learn Azure OpenAI - G...
Learn how to authenticate to Azure OpenAI the RIGHT way: • Authenticate to Azure ...
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 - Наука
The demo app is now available here: github.com/alex-wolf-ps/chat-sql-data-demo Sorry for the delays!
That was very useful and professional. Thank you indeed and thanks for sharing 👍
Thanks I appreciate it!
Hi thank you for sharing. Is there a way to get the sample code?
thank you very much wolf🙏
exactly what I am coding right now for my customer
Thank you so much, generous!
Your a helpful cheerful youtuber :D
Excellent video! Have you got a link to source code? thank you.
Thanks
Thanks so much for your support! It means a lot.
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!
Thanks, I try to showcase real world demos instead of just flashy but useless concepts
Hey! Please share the source code!
This is honestly really cool
hi this is pretty cool. is your code available open source? i checked your GH but didn't see it. thanks!
very good, thank you 🐺
Glad you enjoyed it
BTW ; 11:00 warning , ur openaikey is exposed ;) @@alexthecodewolf
Hi, do you have a public demo?
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.
Thanks, did you get chance to get repo?
Thank you Alex, looking forward to learn how to do it
@@mukshobhit It's available now, thanks.
It's available now, thanks.
@@alexthecodewolf Thank you Alex, grateful for making it available
very informative. can you please share the code of your Razor app?
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?
Hey, thanks for watching. There are definitely local AI models, but I haven't worked with them enough to recommend any sort of solution for this. Would probably be a good topic to research for another video :)
Wowo ! No more developer required to binding data and complex query.
Yeah one of my favorite things about this is it can help devs as much as analysts because it can write your sql queries for you....to some extent :)
Hello, Could you please let me know where can I get the source code for it?
Hi, could be possible to have database definition in azure storage file so that way we aboid large prompt, or is there any other solution.
Hey, good question, this is something I'm also looking into myself - how to only have to send the schema once and be able to update and maintain that schema in an active context. So far I haven't found a solution I'm happy with yet but I'll respond here again if I do. The models are getting better at deconstructing large inputs all the time, but I understand from a cost perspective its not desirable.
@@alexthecodewolf I tried using the assistant for that - sent him all the scheme in JSON files but it sucks 😔
Hi @alexthecodewolf ! Thanks for the video. I have two questions: Is there a way to use OpenAI with and SQL database, without using the Azure OpenAI Service? It is currently only for people and companies who have requested special access. So Im wondering if there is a workout where I can use the OpenAI's API directly towards my own Azure SQL Database, and not have to rely on the OpenAI service on Azure?
Number 2: Do you have the source code anywhere?
Hope you will reply ASAP as im currently working on a project that has come to a halt.. Thank you very much! :D
Hey, thanks for watching. You should be able to use the regular OpenAI service (non Azure) with this exact same approach, there might just be some slight differences in the code and authentication. I'm not sure how pricing differs between them.
Currently this code is part of a separate project I'm working on that I adjusted for this demo, so at this point I can't distribute the source code to for a few reasons, sorry!
@@alexthecodewolf any idea what the code for that approach would Look like? Spent all day today, but to no avail.. also, thanks for the response!!
Can we use GPT-35-Turbo instead of GPT 4?
You can certainly try using GPT-35-turbo, but GPT-4 included major improvements to understanding and responding with structural content. However it'd be interesting to see how well 35-turbo does in comparison, I didn't actually try that myself.
Hello sir can you please source code for education purposes? Its working universe database?
What happens if someone says “delete all the data” ?
That's a really valid concern, you'd want to make sure the app is running as a user that only has read permissions.
Code Wolf, can you please share your source code?
GIT REPO IF YOU DONT MIND PLEASE