SQL Chain Example | 🦜🔗 LangChain UseCases

Показать описание

SQL Chain Example | 🦜🔗 LangChain UseCases

In this video, I will walk you through a SQL Chain example. I will demonstrate how you can use the SQLDatabaseChain for answering questions over a database. I will be using SQLite and Chinook database. We will also create a database, .db using .sql file. Happy learning and chaining 😎

👉🏼 Links:

⏰ Time stamps:
00:00 👋🏼 Introduction
01:30 ⚙️ Setup
01:54 📚 Creating database in SQLite from .sql file
04:55 🤔💻 SQL Chain part
12:04 🙏 Conclusion

🔗 Other videos you might find helpful:

▶️ Connect with me:

#langchain #llm #openai #sql #sqlite3

Рекомендации по теме

Комментарии

How does SQLDatabaseChain knows about the database structure (tables, etc)?

ИгорьТ-хм

Tapai ko video haru Sarai ramro cha bro! Keep up the good work.

AO-iphi

I made a function to compare between LLMs results and humans results. is sql Query already exist in the database or is it you who makes them ?

hadjersa

how we could get answer in json format please advice

veeru

Hi, thanks for the video.
I have 2 questions:

Question 1: what is the difference between "SQLDatabaseChain" and "SQLDatabaseToolkit"?

Question 2: I get an error when i try using the create_sql_agent in the below code.

toolkit = SQLDatabaseToolkit(db=db)
agent_executor = create_sql_agent(
llm=OpenAI(temperature=0),
toolkit=toolkit,
verbose=True
)

ValidationError: 1 validation error for SQLDatabaseToolkit
llm
field required (type=value_error.missing)

Can you please help here? Appretiate your help

AliQureshi-ng

Thank you, would querying a large database with say 1million row use up a lot of tokens / is there any for of caching that can be done with ChatGPT ?

python

Excellent info, ,, pls do one video in querying JSON Documents . No one has done any video

rajivraghunathan

Can we plot a graph of thr output data

Anna

Unfortunately, in reality this functionality is very early days and doesn't work very well, generating joins across non-existent columns and SQL that is engine specific. It's only good for playing around with at the moment.

colofthedead

nice video! i try this with ggml-gpt4all-l13b-snoozy.bin and i have this problem : SQLQuery:The prompt size exceeds the context window size and cannot be processed.
The prompt size exceeds the context window size and cannot be processed. any ideas?

mariocuezzo

SQL Chain Example | 🦜🔗 LangChain UseCases

SQL Chain Example | 🦜🔗 LangChain UseCases

Chat with SQL and Tabular Databases using LLM Agents (DON'T USE RAG!)

Natural Language to SQL | LangChain, SQL Database & OpenAI LLMs

Advanced SQL Generation with LangChain & Redis

Connecting Langchain to any SQL Database Demo

LangChain SQL Webinar

Mastering Natural Language to SQL with LangChain and LangSmith | NL2SQL | With Code 👇

SQL Chain Implementation in LangChain | Query SQL Database using gpt3 | Complete Tutorial

Advanced SQL Tutorial | Subqueries

My Jobs Before I was a Project Manager

End To End Text To SQL LLM App Along With Querying SQL Database Using Google Gemini Pro

A Quick Beginner's Guide To LangChain's SQL Chain Using A SQLite Database w Google Drive +...

LangChain, SQL Agents & OpenAI LLMs: Query Database Using Natural Language | Code

Text to SQL Agent for Data Visualization

TOP 23 SQL INTERVIEW QUESTIONS & ANSWERS! (SQL Interview Tips + How to PASS an SQL interview!)

LangChain SQL Database agent with OpenAI to query PostgreSQL

Building an Agent to Query a SQL Database and Analyze Data

SQL Research Assistant

Langchain ReAct Agent: Chat with SQL Database

'The role of SQL in Supply Chain Analytics'

Viewing and Interpreting Blocking Chains in SQL Monitor

Build an SQL Agent with Llama 3 | Langchain | Ollama

Vector Databases simply explained! (Embeddings & Indexes)

Advanced SQL Tutorial | Temp Tables