Natural Language to SQL | LangChain, SQL Database & OpenAI LLMs

Make natural language queries to a SQL Database using LangChain & LLM's. In this video, you will discover how you can harness the power of LangChain, SQL Agent, and OpenAI LLMs to query a SQL Database using natural language. This step-by-step tutorial will guide you through setting up a powerful, intuitive, and user-friendly SQ querying system.

*I use affiliate links on the products that I recommend. These give me a small portion of the sales price at no cost to you. I appreciate the proceeds and they help me to improve my channel!

Equipments I use for recording the videos:

If you do have any questions with what we covered in this video then feel free to ask in the comment section below & I'll do my best to answer those.

If you enjoy these tutorials & would like to support them then the easiest way is to simply like the video & give it a thumbs up & also it's a huge help to share these videos with anyone who you think would find them useful.

Please consider clicking the SUBSCRIBE button to be notified for future videos & thank you all for watching.

You can find me on:

#langchain #sql #openai

[KumR]

Can we create complex sql from multiple tables ?? or only supports simple select * from??

[namanjain]

Have been making something similar by using other Ai orchestrator tools (semantic kernel)
I have made my own personal function to do but in that, I am not able to deal with multi tables.
just want to know how well it does with multi-table databases where 10-20+ tables are involved

[SMCGPRA]

It is mostly achievable using open ai keys but can we use open-source LLM models

[nishantkumar-lwce]

Can we generate the visualizations as well with this one?

[ShubhankarSharma]

Will this work for multiple databases containing multiple tables?

[shivarajgudaganatti]

how can we extract the SQL generated by the agent as output ?

[kumaradabala]

Is there any other open source llm to do this instead of OpenAI?

[kirthans]

How to print the intermediate results of SQL query in the output ?

[capeandcode]

How can I get only the generated SQL query and not the natural response for the results?

[ritishajaiswal]

Will this work for Vertica database? If not, please suggest how can I translate plain English to vertical executable query. I have hundreds of table so I cannot provide the scheme in the prompt. The schema can be provided as RAG or something. Please provide your suggestion how can I implement this. thanks!

[akshpreetsingh]

Is it possible to use chat history in this ? SQLDatabase_chain
if not , is there a work around ?

[lxybsip]

how can we convert the results into a table or a dataframe?

[rohitpandey]

Where is the data.csv file that you used?

[mjacfardk]

Thank you brother, we are learning from you logical thinking and creativity ways rather than problem solving and coding

[rsworld]

Sqldatabasechain is not found using python311 in anaconda

[SounakBasuRoy]

Can you demonstrate using multiple databases, containing multiple table? Is there an impact on the performance when using large databases?

[fahadhassan]

what is difference between direct using openai API and using langchain...

[shailendraprajapati]

Mind-blowing! 🤯 SQL made easy! #Gamechanger

[geandersonlenz]

SQLQuery:This model's maximum context length is 4097 tokens, however you requested 6091 tokens (5835 in your prompt; 256 for the completion). Please reduce your prompt; or completion length.

[eric-theodore-cartman]

Building something similar but it's very poor but at answering follow up questions. Do you have any suggestions or guidelines for this (maybe some references)