End To End Text To SQL LLM App Along With Querying SQL Database Using Google Gemini Pro
ฝัง
- เผยแพร่เมื่อ 12 ม.ค. 2024
- github: github.com/krishnaik06/Google...
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
![[Watch Party] APL 2024 ใครชนะเข้ารอบ Hydra 🆚 Flash Wolves Talon 🆚 GGLive](http://i.ytimg.com/vi/BvuSgyLy4hA/mqdefault.jpg)
Likes Target 1000 :)
Likes target only 1000 that’s too small value mainly for your valuable content your Videos should get minimum 5k in a day
Krish Bhai 729!
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
Ho gaye bhaiya 👍👍👍
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!
You are great Sir learning stats and Eda from you. Very smooth explanation. 🎉🎉
Thankyou sir🙏,from past 2 month I following your video.
Wonderful video Krish. Beautifully explained. Keep posting.
Krish mast banaya hai... I will try this in my ofc sample data
Thank you, Krish.
Just wow 🌟
You are wonderful sir
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
why dont you come to india
@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.
Ultimate...thanks krish
@Krish you are a legend.❤
Crisp and to the point...❤
Great😊
This video is really helpful for me ,sir I have one doubt can we use ready made data
Best video.
Excellent video!
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
Thank you for your lecture.
great,,,
Made my life simple
Krishna, great content! Can we use this for generating pictorial output representation.
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?
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?
Wow..
Krish the king bhai
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?
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 ????
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
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
Sir could you post a video on your time management.
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
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
Interestingly all the data science students got better marks than Devops. Possibly a Krish-AI Bias :)
What is the best way to have an offline LLM interacting with sqlite db?
Hi krish Sir , i wanted to show the Query on the front end so basically Search(Question) -> Sql Query should be the answer
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
would be nice to see this working with llama and not gemini only. Please show us how to use llama
Thank you , was very informative . How should I go about implementing if the data model is complex with 10 tables and has star schema ?
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..
@@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.
Have you found a way? Multiple agent?
Sir NLP with deep learning one shot please
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.
all newly fresh videos on ML and DL are getting uplaoded. Check the below playlist
th-cam.com/video/ip4WxEZwEPc/w-d-xo.html
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.
Is there a way to use Data Dictionary to train LLM model to generate SQL queries later on?
Second ❤
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.
Nice idea bro...😊
I have a doubt. Will this send my Database contents/schema along with API request to LLMs for queries I ask ?
First❤
Can you please train more data to the SQL server
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 ?
I had made one using Hugging face .
could you please share your hugging face space link
could you please share that link
I tried it with one database table with timeseries data in postgresql, It is giving entire records no matter what question I ask?
Did you resolved it
Should I make predictions about the future based on the data in my table?
How can we get only query out of this chain ?
Is it possible to retrieve table name from where ever it in any schema with respect to column name
Sir new video to store data into vector database free tier….
Hello Krish, how do I fix a 'DefaultCredentialsError'? I can't seem to get the app answering questions despite inputing my Api key. Thanks
Hi, do you have videos for chatbot? thanks
How can we scale it for real world data with 100s of tables/columns? Any refernces?
even i had the same query ? can we have multiple tables ? as in this video he has used a single table
try rag
sir my API Key is not generating
Would it be possible to have it sql to txt instead ?
Can I have a llm for Tex to BDD test cases for java applications
plz make video on how to deploy it
Can it also run on any warehouse SAP BW, Synapse etc
Like number 674
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
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
@@raghavendranarayana1009 which domain have you chosen for your career
@@raghavendranarayana1009 right now are you in ML domain. How did learn this things. Did interviewer concerned about your background
@@pdevender interviewer asked on why did you transit from marketing domain to Data science domain
@@raghavendranarayana1009 ok what was your answer then ?
Can this connect to Oracle Database?
im interested in this too.
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
Did you complete this project?
in out put i am getting paranthesis and single quotes so how to remove it
@krishnaik can we use my SQL instead of SQL lite ?
Yes you can
Can you pls make video like same for NoSQL db by using Mongo
Sir when enter Streamlit run app.py mine display comes empty. Why? I am very confuse.
Hello sir please tell me? Why this happens
Google AI Studio not available here in canada
Any other way out ??
@@anirudhgrack7560leave canada
Do I have to change thw peopt language? I mean, may I wrote it in Portuguese, for example?
Sir it depends, I think Gemini can understand Portuguese... So u can write in Portuguese
can you amke a video how to use that in angular?
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
Did you resolved this one buddy?
@@programmerpro-hs8ro join all the prompts in single string using " ".join
pass a string in the method instead of list like "model.generate_content(prompt[0] + question)" this will resolve the above error
how we can use Gemini in EU? Anyone got the Idea?
Anyone did this one?
whatsApp bot with gemini pro is this possible ............?
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
If I want to read and ask questions from multiple csv files at a time, then how can I implement?