L-5 Chat with database using LangChain

This tutorial will teach you how to interact with your database using LangChain, LLM and mysql database. We will create a app which will take the input in english which will then be processed by an LLM model to generate SQL queries. These queries will retrieve data from a MySQL database and present the results on our screen.

### Get an API key:

### mysql:

### mysql workbench:

#langchain #llms #chatbot #mysql #mysqlworkbench #generativeai

[yasutakaueda]

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

[tech_devsecops]

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

[careersuccessng]

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

[aminelongo]

Really helpful video ! Thank you Aarohi

[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: <class
I cant find any solution for it

[amrzakaria]

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

[hendoitechnologies]

kindly post video about Claude 3.5 sonnet API video for developers

[arnavthakur]

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

[ChrisLocke]

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

[rishabhsheoran]

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

[harshitdtu]

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

[Umairkhan-jp]

Can you connect to MongoDB, Please give me steps.