Chat with Your Database Using AskYourDatabase and LLM agents (A Review)

In this video, I review AskYourDatabase (AYD), a no-code and low-code app that allows you to chat with various databases, including MySQL, PostgreSQL, MongoDB, SQL Server, and Snowflake. This chatbot uses LLM agents built with GPT-3.5 and GPT-4 to interact with databases using natural language.
00:00 General Overview
02:54 Test prep (Sakila DB)
04:59 Connecting our DB to AYD
07:04 Adding DB documentation and extra examples to the LLMs
09:15 Testing AYD desktop app
11:46 Performance in the presence of a typo in the query
15:17 Performance in case the answer is too long
17:54 Performance with complex queries containing a chain of questions
21:34 Asking AYD to generate images
26:18 Integrating the AYD chatbot into a custom app and testing it
Resources:
AYD website: www.askyourdatabase.com/?utm_...
AYD documentation: www.askyourdatabase.com/docs?...
AYD chatbot dashboard: www.askyourdatabase.com/dashb...
MySQL Workbench: dev.mysql.com/downloads/workb...
Sakila DB installation: dev.mysql.com/doc/sakila/en/s...
ngrok installation: ngrok.com/download
#LLM #GPT #chatbot #agent #database #ai

[@thedatascientist-lg4ls]

Wow! this looks like an advanced version of what you designed. I'm sure you designed this product.

[@airoundtable]

:)) No this is not my product and I am not part of the team behind AYD. But you are right, it has more features than what we designed in the previous video

[@dswithanand]

This is quite interesting. Thanks for sharing this.
I have a couple of questions:
1. Can we integrate this chatbot with our company website?
2. Can we customize the output? For example, if a product is not available, can it display a message like "The respective product is not available" or "Sorry, I can't help you with that"?

[@askyourdatabase]

Yes, you can do that.

[@amirabbasmehrafshan9036]

Great as always

[@airoundtable]

Thanks!

[@protimaranipaul7107]

Thanks! Super Interested, But curious 1) We provide the connection to database but how do we ensure data privacy? 2) What are ways to connect to multiple databases. DO you have come across other open source product like this?

[@airoundtable]

Thanks. For security and data privacy please have a look at AYD's blog here:
www.askyourdatabase.com/blog/how-does-askyourdatabase-protect-your-data
2. If you want to connect to multiple databases individually, this is straightforward. However, if you aim to connect to multiple databases simultaneously, allowing the LLM agent to access and retrieve information from them at the same time, I didn't see that feature available. If your goal is to extract meaningful information using shared knowledge between these databases, this falls under the scope of a knowledge graph problem, which requires a tailored approach for each scenario.
I personally haven't seen any open-source product like AYD. The only alternative approach that I am familiar with is to design the whole system from scratch.

[@ayushmishra5861]

hey, I have not built any AI agent before. I am familiar with Langchain.
This particular scenario is fascinating and interesting to me, but I am afraid that video is a good start for follow along.
Can you please suggest what video of yours I can start from to learn and build AI agents.

[@airoundtable]

Hello. The previous two videos were focused on designing LLM agents for interacting with Databases. In case you want to design them by yourself, I recommend those two:
Chat with SQL DB:
ruclips.net/video/ZtltjSjFPDg/видео.htmlsi=EGI6-t0asV10IVUZ
Chat with GraphDB:
ruclips.net/video/3NP1llvtrbI/видео.htmlsi=sY_qReSx3YIWMXlM

[@SugengWahyudi]

can this use opensource LLM like llama3?

[@askyourdatabase]

Yes its supported

[@SonaliBhanudasMali]

New project using llm plzzzz

[@airoundtable]

I am working on it. Coming soon!