docs/tutorials/sql_qa/

[giscus[bot]]

docs/tutorials/sql_qa/

This guide assumes familiarity with the following concepts:

https://python.langchain.com/docs/tutorials/sql_qa/

[ksteward]

I noticed that this documentation / tutorial listed a bunch of LLMs, but did not list any Llama-3* models.
Do we know if LangChain's SQL database module(s) will work with any Llama-3* models? My initial tests suggested "no" but could well be wrong. I can successfully uses the modules with OpenAI GPT-4o.

[Hamza5]

The official tutorials always use OpenAI.
Llama-3 can be used through Groq. I used the 8b model while following the tutorial and it worked with some problems. It was not intelligent enough to construct the correct SQL that matches my description. It always hallucinated some table and column names that didn't exist. Even though agent corrects itself after getting an error, it seems that it fails to understand what I want.

[ianzhaoyue]

I stuck at the last step of convert-question-to-sql-query, where it gives me an ValueError: no signature found for builtin type <class 'dict'> when invoking write_query({"question": "How many Employees are there?"})

[SharoMonk]

I have particularly found out that various LLMs have varying capacities and capabilities. First thing i do anytime i encountered an error is to change my model. It solves my problems most of the times.
I uses ChatGroq, ChatFireworks, ChatMistrai and ChatXAI models in that order and i have recently added ChatGoogleGenerativeAI. Try it.

[carlosmontoliu]

Excellent! Working smoothly inside a complex Azure WebApp :D

[ksteward]

@carlosmontoliu, are you saying that you CAN get a Llama-3 model to successfully interact with a SQL database? If so, can you reveal which LLM model and which langchain module you used?
Thanks!
-k

[SharoMonk]

I used ChatGroq(model='llama3-8b-8192') and it worked with very little glitches.

[Akinola92]

Can anyone help me figure out why the following isn't retuning any table names after I've saved the db to my Google Drive?

print(db.get_usable_table_names())

Thanks

[Akinola92]

Figured out it was due to the encoding of the Chinook_Sqlite.sql file !

[ksteward]

SharoMonk, So are you saying that model='llama3-8b-8192' successfully used the Langchain SQL database module? from my cell phone -- please excuse typos

…

On Mon, Dec 30, 2024, 11:44 AM SharoMonk ***@***.***> wrote: I used ChatGroq(model='llama3-8b-8192') and it worked with very little glitches. — Reply to this email directly, view it on GitHub <#28698 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AABOAVSBSVGRTVWKTFGVTWT2IFZ6PAVCNFSM6AAAAABTQ4HDT6VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNRZHAZTINA> . You are receiving this because you commented.Message ID: ***@***.*** com>

[punsoca]

Hey guys- does this section replace the SQLDatabaseChain? I had been trying out the SQLDatabaseChain YouTube tutorials from as recent as August 2024 but my output no longer matching the tutorials.

[sreenathelloti]

How to integrate dynamicfewhot prompting while implementing multi agetn supervisor workflow

[erodriguezds]

Does any of the "Agents" examples work for anybody? I'm using OpenAI LLM, I have followed all of the examples from the "Agents" section, without modification. It blows up inside the stream iteration. I get to see the first step (output from step["messages"][-1].pretty_print()), and then it blows up with the following error:
openai.BadRequestError: Error code: 400 - {'error': {'message': "Invalid type for 'messages[1].content[0]': expected an object, but got a string instead.", 'type': 'invalid_request_error', 'param': 'messages[1].content[0]', 'code': 'invalid_type'}}