End To End Text To SQL LLM App Along With Querying SQL Database Using Google Gemini Pro

github: github.com/kri...
In this video we will be developing an end to end LLm application using Google Gemini Pro where we will create Text To SQL LLM App and later retrieving query from sql database
-----------------------------------------------------------------------------------------------
Support me by joining membership so that I can upload these kind of videos
/ @krishnaik06
---------------------------------------------------------------------------------------------------------------------------
►Data Science Projects:
• Now you Can Crack Any ...
►Learn In One Tutorials
Statistics in 6 hours: • Complete Statistics Fo...
Machine Learning In 6 Hours: • Complete Machine Learn...
Deep Learning 5 hours : • Deep Learning Indepth ...
►Learn In a Week Playlist
Statistics: • Live Day 1- Introducti...
Machine Learning : • Announcing 7 Days Live...
Deep Learning: • 5 Days Live Deep Learn...
NLP : • Announcing NLP Live co...
---------------------------------------------------------------------------------------------------
My Recording Gear
Laptop: amzn.to/4886inY
Office Desk : amzn.to/48nAWcO
Camera: amzn.to/3vcEIHS
Writing Pad: amzn.to/3vcEIHS
Monitor: amzn.to/3vcEIHS
Audio Accessories: amzn.to/48nbgxD
Audio Mic: amzn.to/48nbgxD

[@krishnaik06]

Likes Target 1000 :)

[@raghavendranarayana1009]

Likes target only 1000 that’s too small value mainly for your valuable content your Videos should get minimum 5k in a day

[@yujibeballin4329]

Krish Bhai 729!

[@036saurabhlasonkar8]

Hello krish sir i have done all the code and execute that but the response is not working for me. I got correct Sql query but on streamlit it did not display anything can you help me

[@BTSDaily7]

Ho gaye bhaiya 👍👍👍

[@karthikmurumalla3936]

Hi Krish! Lately I've been watching your videos on GenAi and I'm so glad that someone is putting up content on actually using these openly available models for real world use cases! However I would like to see more and more videos on domain specific fine tuning! Ive practically seen domain specifically fine tuned models with around 200M, 300M parameters generating results far better than generic models like Gemini, GPT3.5 turbo etc which are huge! I'm looking forward to a full length video from you on actually fine tuning smaller LLMs like T5 (base/small openly available) for domain specific tasks like text2sql and benchmark those scores with the results produced in this video!! Lighter models and more accurate results are always exciting to watch!

[@BharatPatnawallah]

You are great Sir learning stats and Eda from you. Very smooth explanation. 🎉🎉

[@adikankwucharles9616]

Nice one, sir. I am from Nigeria and got convinced in one of your videos to join Pwskills FSDSP batch. Please, I am still waiting for you. I need you in this industry. Thanks for all you do

[@pdevender]

why dont you come to india

[@adikankwucharles9616]

@pdevender If I have an opportunity to work as a data analyst or a junior data scientist, I don't see anything that will deprive me of coming down to India.

[@shivamjha9254]

Thankyou sir🙏,from past 2 month I following your video.

[@dario_real]

I'm a programmer and I love using all kinds of tools, especially those related to artificial intelligence. If you have a project, we can work together to make it a reality

[@archowdhury007]

Wonderful video Krish. Beautifully explained. Keep posting.

[@datasciencegyan5145]

Krish mast banaya hai... I will try this in my ofc sample data

[@BrijeshPatel-cd4yd]

Have you tried.. is it working with organization Tables. ??

[@darshandaga7578]

can you please put up a video on fine tuning this with a specific context? lets say i want to delevop this for a cilent. How would we go about then?

[@myslates2854]

Interestingly all the data science students got better marks than Devops. Possibly a Krish-AI Bias :)

[@vamsitharunkumarsunku4583]

I have already mysql database with 20 schemas and each schema has multiple tables. In this case how to fine tune my mysql database with llm? Can you please explain. Thank you

[@Munnu-hs6rk]

One idea is to Give the customize data in form of a er diagram and relational structure schema in form of pdf or something and fine tune the model

[@TemporaryForstudy]

hey what did you do?

[@AayushSi7ha]

@Krish you are a legend.❤

[@alexramos587]

Thank you, Krish.

[@debbh274]

Crisp and to the point...❤

[@VictorAyalaSpooner]

Thank you Krish, this video was great! Now I have a question, I am an app developer and I use database services such as Firefox or Parse Sever, do you have any idea how to approach the same with those databases?

[@musicphimhan7530]

Thank you for your lecture.

[@miteshgarg9420]

Hi Krish, thanks for the amazing video. Can you please help to create a similar solution using open source llm models like codellama. How can we fine tune the open source llm model to work like text to sql solution

[@user-ds3qc8ge4k]

Hi Krish, thanks for the amazing video. Can you please help to create a similar solution using llama2 models . How can we fine tune the open source llm model to work like text to sql solution

[@Iqbalshah-fd8yk]

You are wonderful sir

[@yuvrajdawande6382]

Just wow 🌟

[@karthikbalasubramanya]

Ultimate...thanks krish

[@shashankpandey1966]

I had made one using Hugging face .

[@pdevender]

could you please share your hugging face space link

[@bihanbanerjee3541]

could you please share that link

[@haku660]

Hi krish Sir , i wanted to show the Query on the front end so basically Search(Question) -> Sql Query should be the answer

[@somethingnew7979]

This video is really helpful for me ,sir I have one doubt can we use ready made data

[@wassimdiai6]

thank you for the useful informations you provide in all of your videos, i have a question regarding this video , can we add a performance metric to make sur the query is correct

[@allaboutworld5177]

Sir is there anything like we can upload pdf then the text in pdf should translate in another lang and the translated text should replace the text in pdf with same format of pdf and generate translated pdf if possible then sir please let me know.

[@meghanaarvapally5484]

Nice idea bro...😊

[@user-po5rg8zu6e]

Made my life simple

[@rvraghvender]

I think the information posted in the "JOIN" button is quite old. Please re-explain what are the benefits we get in different subscription option.

[@krishnaik06]

all newly fresh videos on ML and DL are getting uplaoded. Check the below playlist kzbin.info/www/bejne/n6GXiKt7j9x4hsU

[@Shivang0369]

Great Video Dear Krish Naik Sir :") Can I use this approach for larger projects ??? Like i have HRMS project which has so many tables and data , can you please answer to my question wether this approach is suitable or I have to use different approach ????

[@divyanshdhadwal9530]

Sir how can we add another table in db and join them and on the basis of that joined table how will our model respond. Like in the given table there are name, class, subject and marks. In second table there is name and their roll number. So how can we join these two tables and make our model train over it please help

[@selub1058]

In the same way. It doesn't matter how many tables you have in the database. Just adjust the prompt a little.

[@wheresthecode]

would be nice to see this working with llama and not gemini only. Please show us how to use llama

[@satbhattacharya6481]

Excellent video!

[@guyknowsanime]

sir ap aik application bna de jesse apne q/a based bnai thi streamlit or gemini api key k sath. vhi cheez fastapi k through bnani ha

[@gerokatseros]

actually last query was wrong, it would return all marks less except from largest. The question was to find student with second mark.

[@srikrishna6595]

Can you please train more data to the SQL server

[@mohamedelzonkoli6680]

What is the best way to have an offline LLM interacting with sqlite db?

[@Ai-ni3gs]

Sir new video to store data into vector database free tier….

[@datascientist_]

Best video.

[@lenkamndev9988]

Sir could you post a video on your time management.

[@MuhammedSavadkv]

Great😊

[@Abhishek_Aman06]

How can we get only query out of this chain ?

[@palashjain4203]

Krishna, great content! Can we use this for generating pictorial output representation.

[@Debanjali-uk7wf]

sir my API Key is not generating

[@shivanisharma9554]

I tried it with one database table with timeseries data in postgresql, It is giving entire records no matter what question I ask?

[@programmerpro-hs8ro]

Did you resolved it

[@08inside]

How can we scale it for real world data with 100s of tables/columns? Any refernces?

[@simply54]

even i had the same query ? can we have multiple tables ? as in this video he has used a single table

[@sahilsaini4574]

try rag

[@brightlyricsmusic]

Could not create `Blob`, expected `Blob`, `dict` or an `Image` type(`PIL.Image.Image` or `IPython.display.Image`). Got a: Value: ['You are an expert in converting English questions to SQL query!The SQL database has the name STUDENTS and has the following columns NAME, CLASS, SECTION and MARKS For example, Example 1 How many entries of records are present?, the SQL command will be something like this SELECT COUNT(*) FROM STUDENTS; Example 2 - Tell me all the students studying in Data Science class?,the SQL command will be something like this SELECT * FROM STUDENTS where CLASS="data science"; also the sql code should not have \'\'\' or any quotes symbol in beginning or end and sql word in the output. '] getting this error someone help

[@programmerpro-hs8ro]

Did you resolved this one buddy?

[@brightlyricsmusic]

@@programmerpro-hs8ro join all the prompts in single string using " ".join

[@alaparthinagabhaskar2318]

pass a string in the method instead of list like "model.generate_content(prompt[0] + question)" this will resolve the above error

[@KumR]

Can this connect to Oracle Database?

[@KokkeOP]

im interested in this too.

[@abhijitpatra1387]

in out put i am getting paranthesis and single quotes so how to remove it

[@krishnaprasadsheshadri6206]

damn this is crazy, what a great video. How would one go about scaling this application for a larger dataset and maybe for different kinds of data like geospatial etc?

[@n.aniruddhan4464]

Sir NLP with deep learning one shot please

[@DineshkumarRamasamy]

Have tested with one table and it works all good. But struggling with multiple tables Can you provide a sample with multiple table in one database ?

[@Imvishnuch]

Hi krish, we have this already but the query is taking 1 - 2 mins, i am an AI product manager, can you share techniques to reduce that time to 5-10 seconds ?

[@swatikeshari858]

If I want to read and ask questions from multiple csv files at a time, then how can I implement?

[@anirudhgrack7560]

Google AI Studio not available here in canada

[@anirudhgrack7560]

Any other way out ??

[@swatik2509]

​@@anirudhgrack7560leave canada

[@bellosaburoladipupo7430]

Hello Krish, how do I fix a 'DefaultCredentialsError'? I can't seem to get the app answering questions despite inputing my Api key. Thanks

[@_csds_PranjalSharma]

plz make video on how to deploy it

[@DataPulse]

Krish the king bhai

[@arinspace6588]

Hey Krish, amazing work. I have been trying to run this on an AWS Linux instance and it throws me (argument of type 'Part' is not iterable) error. It works fine on Windows local PC. Can you help me fix this issue please.

[@arielgamao5480]

Hi, do you have videos for chatbot? thanks

[@imranurrehman264]

great,,,

[@satyajamalla1429]

Can I have a llm for Tex to BDD test cases for java applications

[@1984tushu]

Can it also run on any warehouse SAP BW, Synapse etc

[@chihebnouri5541]

can you amke a video how to use that in angular?

[@datasciencegyan5145]

Is it possible to retrieve table name from where ever it in any schema with respect to column name

[@abdulrahmanalrabah8324]

Would it be possible to have it sql to txt instead ?

[@JayantKumar-lq9lg]

Can you pls make video like same for NoSQL db by using Mongo

[@dulshansamarakoon5068]

Wow..

[@user-xj6bx1hn5s]

Thank you , was very informative . How should I go about implementing if the data model is complex with 10 tables and has star schema ?

[@mithunshet5922]

This is not reliable.. llm should be used to correct the SQL code if at all an error exists.. But this questionnaire is unreliable for complex data models..

[@KokkeOP]

@@mithunshet5922 Honestly, what he should do is simply try his .db and see if it retrieve the right results with his queries. its not hard as long as the code is ran from his on-prem/local environment, the results should output a plausible answer. The hardest part should be to update the Prompt to the right kind of questions the model is going to be enquiry.

[@protimaranipaul7107]

Have you found a way? Multiple agent?

[@tharunps8048]

I have a doubt. Will this send my Database contents/schema along with API request to LLMs for queries I ask ?

[@luckytalkz9442]

Sir when enter Streamlit run app.py mine display comes empty. Why? I am very confuse.

[@luckytalkz9442]

Hello sir please tell me? Why this happens

[@BharatPatnawallah]

Krish Sir I am from sales background but wanted to switch started learning but not sure how to proceed and land a job in the end. Please make a session for which we can increase our chance to get interview calls. Is there any mock preparation or Hr connect available in ineuron

[@raghavendranarayana1009]

I am also from Marketing background I moved to Data science in 2022 if you understand the basics and statistics ML,DL,CV and NLP is nothing

[@BharatPatnawallah]

@@raghavendranarayana1009 which domain have you chosen for your career

[@pdevender]

@@raghavendranarayana1009 right now are you in ML domain. How did learn this things. Did interviewer concerned about your background

[@raghavendranarayana1009]

@@pdevender interviewer asked on why did you transit from marketing domain to Data science domain

[@pdevender]

@@raghavendranarayana1009 ok what was your answer then ?

[@yvens_data]

Hi krish , I tried to push it to github and deploy the app on streamlit community, the data base stopp working, how can i fix that

[@programmerpro-hs8ro]

Did you complete this project?

[@jawadasif8130]

how we can use Gemini in EU? Anyone got the Idea?

[@qzwwzt]

Do I have to change thw peopt language? I mean, may I wrote it in Portuguese, for example?

[@TheIITianExplorer]

Sir it depends, I think Gemini can understand Portuguese... So u can write in Portuguese

[@shashankpandey1966]

First❤

[@bangarrajumuppidu8354]

Second ❤

[@programmerpro-hs8ro]

Anyone did this one?

[@rishichowdhury4296]

@krishnaik can we use my SQL instead of SQL lite ?

[@krishnaik06]

Yes you can

[@RobbieMraz]

Hi do you know, if Let's say we connect Azure OpenAI to a SQL DB (Oracle) and want to retrieve data using AI Azure Platform, will SQL DB have an impact performance if so do you know how much can be impacted? Let say that we use SqL dB with many integrations

[@rohithak9419]

Like number 674

[@nileshbhujbal7489]

I will tell your AI bot to delete all data from xyz table...👿

[@MUsmandev]

whatsApp bot with gemini pro is this possible ............?

[@abhishekfnu7455]

Is there a way to use Data Dictionary to train LLM model to generate SQL queries later on?