V2.0 create_react_agent doesn't execute generated query on sql database about langchain

[knarayanamoorthy-wowcorp]

Hi, I was also facing somewhat similar issue with the SQL generation. But my issue was mostly centered around wrong table name format (double quotes being added to the table names that are passed to SQL_DB_SCHEMA), which resulted in incomplete execution, displaying intermediate result to the user. To your question around DB details being passed to agent, the variable "tools" has necessary details about the DB along with the individual functions / tools needed for the SQL generation. Following are my suggestions.

1. Review the log ( print(s)) in the debug console. Please check if the tables names are in correct format when passed to SQL_DB_SCHEMA function
2. You may add description to the individual tool that fails to perform the intended task (in my case it was InfoSQLDatabaseTool). So I modified the description of the tool as follows(there might be a better way of doing this)

desc = (
"""ALWAYS use this tool second AFTER 'sql_db_list_tables'. Input to this tool is a comma-separated list of tables with no schema, no double or single quotes. Output is the schema and sample rows for those tables. Be sure that the tables actually exist by calling 'sql_db_list_tables' first! Example Input: table1, table2, table3"""
)

    tools[1].description = desc        

3. Use Langsmith to trace the create_react_agent funtion. Helps you understand the flow and potentially address the issue

Hope this helps.

Regards,
Kiran

[susandong]

Any updates?