Connecting Langchain to any SQL Database Demo

Demo on how to give Langchain access to any SQL database. Basically this lets you connect OpenAI to a SQL Database.

In these examples I have given Langchain access to my production postgres database.

#langchain #openai

[josephmadrinkian]

@Tosh, great video, but Im curious to know how are you setting the URL to the DB?

[heydibyendu]

Hi @toshvelaga. That's short yet effective lesson. Does the same structure work in javascript? I put database on Amazon, get the URL and run a sql chain?

[yazanrisheh]

Can you show us how can we do it with very large relational databases since I assume theres a context limit. It would be amazing to know how would you split and fit it in the context then query it while ensuring that the model isn't hallucinating since I guess it might hallucinate if theres a big data given to it

[madaebnana]

I am searching on implementing he same concept with Postgres database .. any idea or a tip would be highly appreciated, Thank you

[rsworld]

Sqldatabasechain is not found . I am using jupyterlab anaconda python311 version. What could be wrong

[v.svishnu]

Is it safe to connect lang chain with our production database

[sunil_modi]

That's great Tosh, But i am trying this to query database that contains hundreds of table but it gives token limit error.
how to remove this error

[yoongfu]

I’m using the SQLDatabase Chain too, but the execution time is too long, do you know how to reduce it?

[johnpower]

how do I use a local llm like llama-2?

[BassamAdel-wggr]

How to return SQLQuery from the chain just wanna get that :(( any idea ?

[parantikaghosh]

Getting ImportError: cannot import name 'SQLDatabaseChain' from 'langchain'

[anuragbhandari]

the SqlDatabaseChain does not support presotdb, do you know any workaround for making it work with prestodb?

[akashchandrasekar]

Hi @Tosh i am trying to connect mssql it is not working can you help me

[rajatgupta]

Not able to make it work with JavaScript.

[ShadArfMohammed]

the code is outdated already, and not reproducible.

[guaranamedia]

Min 1:00, give it some time to "THINK"? Tell me you're on your 40s without telling me you're on your 40s :D

[narendranath]

Great, Thumbnail is completely misleading. Thought i would see how can we connect sqlserver from colab using langchain. You never touched it!!!