L-5 Chat with database using LangChain

[@yasutakaueda3928]

Integrating database data with LLMs greatly expands the range of applications. Thank you for providing such valuable information.

[@CodeWithAarohi]

Glad it was helpful!

[@sangeethag8228]

You explain complex topics in simple, step-by-step videos. Truly impressive! This channel deserves way more recognition!

[@CodeWithAarohi]

Thank you! I’m glad my videos are helpful. Your support means a lot!

[@tech_devsecops]

Ma'am you demonstrated this in a really simple and great way.

[@CodeWithAarohi]

Thanks a lot 😊

[@architectingme]

Thank you for sharing. I will try this on SQL server

[@CodeWithAarohi]

Good luck!

[@aminelongo242]

Really helpful video ! Thank you Aarohi

[@CodeWithAarohi]

My pleasure 😊

[@Pallavi9187]

Mam love u so much 😭

[@careersuccessng3678]

Great Job Aarohi! How about connecting to MS SQL server used by most enterprises

[@soravsingla8782]

Phenomenal

[@abdulqayyumshah9217]

Amazing!

[@CodeWithAarohi]

Thank you!

[@muhammadahsan2751]

I tried these steps with MSSQL Server and found below error, Could you please help to resolve this.
chain = create_sql_query_chain(llm, db)
The error i get is very long but at the end it says TypeError: Expected a Runnable, callable or dict.Instead got an unsupported type:

[@DevShahin-zm8ni]

I want to make a report generating software using LLM on my ERP where nearly 200 tables are exists. In my report generating software I give a propmt and LLM will analysis this promps and make a sql query on the basis of my ERP databases. Can I do it using this procedure?

[@19saikalyan84]

Hello
Can't we do directly by uploading the datasets in an csv file in the sql workbench
hope you react to this.....!!

[@eneso8657]

Do you know how can add memory to sql agent ?
I have tried some ways but I could’nt

[@rishabhsheoran6959]

Hey Aarohi! How do we handle the cases where the LLM generates a wrong query other than exception handling?

[@CodeWithAarohi]

You can train your LLM for such queries using few-shot learning.

[@vickyrajeev9821]

Thanks

[@amrzakaria5290]

Thanks a lot , Can you connect to PostgreSQL DB ,Pls give me steps.

[@CodeWithAarohi]

pip install langchain psycopg2
import psycopg2
from langchain import LangChain
# Connect to your PostgreSQL database
conn = psycopg2.connect(
dbname="demodb",
user="root",
password="root123",
host="localhost",
port="5432"
)

[@amrzakaria5290]

Thanks.

[@oscarpirateman]

Is anybody else getting an error when running the line:
chain = create_sql_query_chain(llm, db)
The error i get is very long but at the end it says TypeError: Expected a Runnable, callable or dict.Instead got an unsupported type:
I cant find any solution for it

[@muhammadahsan2751]

Yes, The same error is appearing while i am trying execute the code,

[@arnavthakur5409]

Ma'am is there any possibility of getting trained under you as we are a group of 8 professionals working with an IT company

[@CodeWithAarohi]

Please email me at [e-mail]

[@mrnayan_2775]

Hello I'm facing some error with the tiktoken package.

[@CodeWithAarohi]

what is the error?

[@hendoitechnologies]

kindly post video about Claude 3.5 sonnet API video for developers

[@CodeWithAarohi]

Noted!

[@Beliver5894-l8h]

how can we get final response in full sentence eg: the total customer count is ---
can you also include some prompt engg technique

[@CodeWithAarohi]

I will cover this in my upcoming videos.

[@Beliver5894-l8h]

@@CodeWithAarohi thank you..will be helpful

[@harshitdtu7479]

i am not able to connect by db can u please help me

[@CodeWithAarohi]

Share the error

[@Umairkhan-j8p]

Can you connect to MongoDB ,Please give me steps.

[@CodeWithAarohi]

python.langchain.com/v0.2/docs/integrations/document_loaders/mongodb/

[@ChrisLocke1969]

but what if my table names and fields are HGSD1245GSDF? game over. AI is all hype, can we stop now?? :(

[@CodeWithMahmoud]

You still can give first 5 rows like example to the llm and it will know what type of data in , and it will work 😊

[@Pallavi9187]

​@@CodeWithMahmoudHey hi do u know that issues when we r using openai api key limit exceed ? Using in langchain

[@mudgilgaurav]

Thanks for the walkthrough, it's very useful for beginners. I installed all dependencies using the requirement.txt which installs langchain 0.0.284 and I have python 3.11, while creating the SQL chain I am getting following issue
#Convert question to SQL query
from langchain.chains import create_sql_query_chain
chain = create_sql_query_chain(llm, db)
Error - TypeError: Expected a Runnable, callable or dict.Instead got an unsupported type: