检查其他资源

• 为这个问题添加了一个非常描述性的标题。
• 使用集成搜索在LangChain文档中搜索。
• 使用GitHub搜索查找类似的问题，但没有找到。
• 我确信这是LangChain中的一个bug,而不是我的代码。
• 通过更新到LangChain的最新稳定版本(或特定集成包)无法解决此错误。

示例代码

从这个教程：https://python.langchain.com/v0.2/docs/tutorials/sql_qa/

from langchain_community.agent_toolkits import SQLDatabaseToolkit
from langchain_core.messages import SystemMessage
from langchain_core.messages import HumanMessage
from langgraph.prebuilt import create_react_agent
toolkit = SQLDatabaseToolkit(db=db, llm=llm)
tools = toolkit.get_tools()
SQL_PREFIX = """You are an agent designed to interact with a SQL database.
 Given an input question, create a syntactically correct SQLite query to run, then look at the results of the query and return the answer.
 Unless the user specifies a specific number of examples they wish to obtain, always limit your query to at most 5 results.
 You can order the results by a relevant column to return the most interesting examples in the database.
 Never query for all the columns from a specific table, only ask for the relevant columns given the question.
 You have access to tools for interacting with the database.
 Only use the below tools. Only use the information returned by the below tools to construct your final answer.
 You MUST double check your query before executing it. If you get an error while executing a query, rewrite the query and try again.
DO NOT make any DML statements (INSERT, UPDATE, DELETE, DROP etc.) to the database.
To start you should ALWAYS look at the tables in the database to see what you can query.
 Do NOT skip this step.
 Then you should query the schema of the most relevant tables."""
system_message = SystemMessage(content=SQL_PREFIX)
agent_executor = create_react_agent(llm, tools, messages_modifier=system_message)
for s in agent_executor.stream(
 {"messages": [HumanMessage(content="Which country's customers spent the most?")]}
):
 print(s)
 print("----")

错误信息和堆栈跟踪(如果适用)

llm返回了幻想般的查询结果，但生成的sql查询看起来是合理的。没有出现任何错误信息。

描述

我正在使用上面的代码创建sql代理，代码运行，它生成合理的sql查询，但查询结果都是幻想般的，而不是基于数据库的实际结果。想知道代理是如何连接到数据库的，因为代理参数中不包括数据库，为什么sql_db_query工具无法在sql数据库上执行。