NL2SQL with LlamaIndex: Querying Databases Using Natural Language | Code

Discover LlamaIndex, a powerful toolkit that bridges the gap between LLMs and your external data. In this tutorial, we delve into the concept of Text-to-SQL and demonstrate how you can seamlessly query a database using just natural language. Tackling challenges like managing multiple tables and dynamically indexing table schemas for ChatGPT queries, we've got you covered!

📌 Refer to our earlier videos for a deeper understanding:

Don't forget to like, share, and subscribe for more insights into the world of Natural Language Processing with LLMs!

🚀 Top Rated Plus Data Science Freelancer with 8+ years of experience, specializing in NLP and Back-End Development. Founder of FutureSmart AI, helping clients build custom AI NLP applications using cutting-edge models and techniques. Former Lead Data Scientist at Oracle, primarily working on NLP and MLOps.

💡 As a Freelancer on Upwork, I have earned over $100K with a 100% Job Success rate, creating custom NLP solutions using GPT-3, ChatGPT, GPT-4, and Hugging Face Transformers. Expert in building applications involving semantic search, sentence transformers, vector databases, and more.

[FutureSmartAI]

Seems Llama Index latest vsersion giving error. Please try !pip install llama-index==0.8.39.post2

[aidev]

Thank you so much for keep sharing !!!You are truly a gem and In sha ALLAH you will have subscribers in Millions. I also recommend this to my friends.Thank you !!!

[ChangKaiHua]

Hi, thank you! do you know if it can work with not only the tables but also stored procedure?

[srijanshovit]

Hi Pradip
I would request you to make videos using open source models. Rest everything is 💯💯

[curiouspanda-lzbl]

Great content Pradip! Got to learn a lot. I was wondering if we can do the same using any open source model like llama2 or codellama instead of GPT. It would be great to know your views about it and maybe you can make some content related to it too

[AndersonMesquita]

Hello, excellent content! Do you have an example of NL2SQL with LlamaIndex, but using a local model, without OpenAI?

[RandomShart]

Is there a specific method to add context for the columns within the table, or is details of key columns just to be added to the string for the table context?

[jiaboli]

It seems there is langchain version compatibility issue. I got some error with the latest version of langchain. Which version of langchains are you guys using?

[miteshgarg]

Hi Pradip, Thank you so much for sharing an amazing tutorial. I was just wondering if we can also use an open source llm model like llama2 instead of OpenAI GPT and how does it impacts the results. If possible please share your views on the same

[vishalJoshii_]

Great content.Can you also share your views on how to achieve this on a production database.
I am using only Views table for my text to SQL bot. They are 450 tables in total.
Some of them have max 400 columns in them. How to tackle the token count limits in such situations?
Thanks.

[hotpot]

Can you use any other opensource model rather than using chatgpt

[hcozdcr]

hi Pradip thank you for such amazing content I want to use this concept in chat bot but what if we have user roles is their any way how restrict user and give access permission accordingly

[flutemelody]

can you pls tell which version of llam aindex you had used

[SriCaitanyaSiksamrtam]

Does OpenAI gets access to data stored in sqlDatabase or it is only used to convert NL to SQL and nothing else?
Is it secure if it exposes data to open ai?

[siddheshphapale]

will it generate graphs? eg. plot sales wise products?

[rushabhparikh]

sql_database.table_info(). This line is not working. It is giving the error AttributeError: 'SQLDatabase' object has no attribute 'table_info'. Please help to solve this error

[rekha]

how to persist the index which is created in this demo?

[rekha]

with azure gpt4 queryengine is failing