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

[huangjia2019]

Issue you'd like to raise.

I am just trying to from langchain import LLMMathChain, SerpAPIWrapper, SQLDatabase, SQLDatabaseChain

Traceback (most recent call last):
File "/home/huangj/01_LangChain/LangChainCHSample/05_05_SQL_Chain.py", line 1, in
from langchain import OpenAI, SQLDatabase, SQLDatabaseChain
ImportError: cannot import name 'SQLDatabaseChain' from 'langchain' (/home/huangj/01_LangChain/langchain_env/lib/python3.8/site-packages/langchain/init.py)

Suggestion:

No response

[eyurtsev]

Hi @huangjia2019 , SQLDatabase chains have been moved into langchain experimental: https://github.com/langchain-ai/langchain/pull/8092/files

See:

https://github.com/langchain-ai/langchain/blob/master/MIGRATE.md

[dosubot]

Answer generated by a 🤖

Answer

I understand that you're encountering an ImportError when trying to import 'SQLDatabaseChain' from the 'langchain' module. This error typically occurs when the specified module or class is not found in the location you're trying to import from.

Based on the information you've provided, it appears that 'SQLDatabaseChain' is actually located under 'langchain.chains.sql_database.base', not directly under 'langchain'. Therefore, you should modify your import statement to reflect this. Here's how you can do it:

from langchain.chains.sql_database.base import SQLDatabaseChain

This is one potential solution based on the information available. If this doesn't resolve your issue, it's possible that there might be other factors at play.

If you believe this is a bug and it could impact other users, you're encouraged to make a pull request with the necessary changes. This would be a great contribution to the project and would help others who might encounter the same issue.

If my suggestion contradicts your experience or if the issue persists after trying the proposed solution, I recommend checking if you're using the latest version of LangChain. An upgrade might resolve the issue if it was caused by a bug that has been fixed in a more recent release.

Sources

• libs/langchain/langchain/utilities/sql_database.py
• libs/langchain/tests/integration_tests/chains/test_sql_database.py

---

This response is meant to be useful, save you time, and share context. It is not meant to be a precise solution, but rather a starting point for your own research.

Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant.

[leocasarsa]

FYI @eyurtsev - the docs may need to be updated, since the code in the page below does not run due to lack of SQLDatabaseChain

https://python.langchain.com/docs/modules/agents/agent_types/openai_functions_agent

[coding-ai]

from langchain_experimental.sql import SQLDatabaseChain for langchain==0.0.258 works

[buttermonster]

pip install langchain-experimental

you can solve it.

[tarasryb]

1. pip install -U langchain langchain_experimental
2. from langchain_experimental.sql import SQLDatabaseChain

[jangels]

langchain实战课 打卡 ~

[huangjia2019]

Thanks pip install langchain-experimental works, I will close this issue.

[Ashu3984]

cannot import name 'ensure_config' from 'langchain_core.runnables' (C:\Users\ashut\anaconda3\lib\site-packages\langchain_core\runnables_init_.py)