pythonadvanced
LangChain SQL Database Agent
Create an AI agent that answers natural language questions by querying a SQL database.
pythonPress ⌘/Ctrl + Shift + C to copy
from langchain_openai import ChatOpenAI
from langchain_community.utilities import SQLDatabase
from langchain_community.agent_toolkits import create_sql_agent
db = SQLDatabase.from_uri('sqlite:///chinook.db')
llm = ChatOpenAI(model='gpt-4o-mini', temperature=0)
agent_executor = create_sql_agent(
llm=llm,
db=db,
agent_type='tool-calling',
verbose=True,
max_iterations=5,
)
questions = [
'How many customers are from Germany?',
'What are the top 3 best-selling tracks?',
]
for q in questions:
result = agent_executor.invoke({'input': q})
print(f'Q: {q}')
print(f'A: {result["output"]}\n')Use Cases
- NL2SQL
- database Q&A
- text-to-SQL agents
Tags
Related Snippets
Similar patterns you can reuse in the same workflow.
pythonintermediate
LangChain create_sql_query_chain
Generate SQL from natural language using LangChain's create_sql_query_chain with schema awareness.
Best for: NL to SQL
#langchain#nl2sql
pythonintermediate
LangChain Tool-Using Agent
Build a LangChain agent with custom tools for web search, calculator, and Python REPL.
Best for: AI agents
#langchain#agent
pythonadvanced
LangChain ReAct Agent Pattern
Implement a ReAct (Reason+Act) agent that thinks step-by-step before calling tools.
Best for: reasoning agents
#langchain#react
pythonadvanced
LangChain Agent with Persistent Memory
Build an AI agent that persists conversation context across sessions using LangChain memory stores.
Best for: persistent agents
#langchain#agent