Langchain tutorial. Query a database with OpenAI's ChatGPT

preview_player
Показать описание
Here is a quick overview of how to query data in a relational database (Postgres in our case) with the help of OpenAI's ChatGPT and Langchain. I double-check the results provided by the LLM and stress multiple times that outputs are non-deteministic and that you should be using all sorts of safeguards when relying on the results generated by LLMs :)

#llm #langchain #openai #chatgpt #dataengineering #dataarchitecture

Рекомендации по теме
Комментарии
Автор

very good video, will watch the next one about a deeper sql context.

nicolasfelipe
Автор

Hey Denys, great video!
Is it possible to query a postgreSQL database?

quengelbeard
Автор

Can you make video using Local LLM (open Source instead of Open AI) to do the same. TIA

anuvratshukla
Автор

I would never trust the LLm to write the sql query. I would create all the sql queries behind a JDBC and write restful api with search parameters. Can langchain do that?

steftrando
Автор

How dobi add memory? For example
Question 1. Who how many salesmen do we have

Answer 3

Question2. Can i get their names?

As you can see, the second question rely on the first ..
How do we achieve that? Thanks

Aidev
Автор

have you been able to get this working with Llama through langchain?

jzam