Querying with SQLDatabaseChain chain

[ChibuikeOnuba]

I am trying to write a script that queries data from a Database using natural language.
I have connected my langchain to my database and I have the llm set up. But the query keeps throwing this error

TypeError                                 Traceback (most recent call last)
.
.
.
TypeError: Could not create `Blob`, expected `Blob`, `dict` or an `Image` type(`PIL.Image.Image` or `IPython.display.Image`).
Got a: <class 'tuple'>
Value: ('text', 'You are a MySQL expert. Given an input question, first create a ...')

this is my code

from langchain_experimental.sql import SQLDatabaseChain

db_chain = SQLDatabaseChain.from_llm(gemini_runnable, db, verbose=True)
query = db_chain("How many t-shirts do we have left for nike in extra small and white color?")

The expected output is a MySQL query and an answer

[dosubot[bot]]

The error you're encountering seems to be related to the type of object being passed or handled within the SQLDatabaseChain. Specifically, the error message indicates that a tuple was received where a Blob, dict, or Image type was expected.

Here are a few things to check and consider:

1. Check the gemini_runnable Variable: Ensure that the gemini_runnable variable is correctly initialized and is of the expected type. Unfortunately, I couldn't find specific information about the expected type for gemini_runnable in the repository, so you might want to verify its initialization and usage in your code.

2. Review the Input Types: The SQLDatabaseChain.from_llm method expects specific input types. Make sure that all inputs, especially the language model (llm) and the database connection (db), are correctly set up and match the expected types ^[1].

3. Inspect the Error Context: The error message suggests that a tuple is being passed where it shouldn't be. Check the parts of your code where data is being passed to the SQLDatabaseChain and ensure that the data types align with the expected types.

4. Debugging: Add print statements or use a debugger to inspect the types of variables being passed around, especially before the point where the error occurs. This can help identify where the unexpected tuple is coming from.

If these steps don't resolve the issue, you might want to look into any custom logic or additional libraries that could be affecting the data types being used in your script.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[ccurme]

I recommend following this guide: https://python.langchain.com/docs/tutorials/sql_qa/

[ChibuikeOnuba]

@ccurme Thanks for sharing this