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

[@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.

[@d2clon]

Great demo, I would like to know more of how they build the training module. I assume this is an hybrid system with a Retriver connected to a VectorDB or ElasticSearch to find training chunks, with previous success queries, and then the Text-to-SQL module to actually generate the query.

[@airoundtable]

I cannot say with certainty since I haven't seen the code behind AYD. and I am not sure what you meant by the "training chunks". But my guess is more toward the same approach that LangChain has been working on. LLMs are good at generating queries for these databases and by passing the schema of the database to the LLM it can understand how to retrieve the answer to the user's question. Next level would be to also add some necessary description of the database to the system prompt to help the LLM navigate easier. And finally, with the help of few shot learning you can do the final adjustment of the LLM on your database. If the database is huge, in a custom solution, I would break it down into smaller databases and utilize the divide and conquer strategy to achieve a good performance.

[@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: kzbin.info/www/bejne/kKXPpZ2Jn6uDesksi=EGI6-t0asV10IVUZ Chat with GraphDB: kzbin.info/www/bejne/aX-zYp-iq9mlmKssi=sY_qReSx3YIWMXlM

[@MrSikesben]

Now this is interesting. I am definitely trying it out

[@airoundtable]

I hope you enjoy using it!

[@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.

[@diamonddogsgaming7059]

I am a beginner who wants to learn SQL. I found this tool really helpful, but I found out that I have exceeded my quota and to proceed I need to buy a subscription. Is there any other AI tool just like askyourdatabse that is free and does not require a subscription so I can continue learning to work on my own dataset?

[@airoundtable]

Unfortunately, I don't know any free framework. But I have tutorials on how to develop such systems from scratch that might be helpful

[@diamonddogsgaming7059]

@@airoundtable could you please provide links to that video so I can watch and learn from them?

[@airoundtable]

This is the one: kzbin.info/www/bejne/kKXPpZ2Jn6uDesksi=qs6tffChk8TnXx-9 But it is part of a series where I teach how to design applications with LLMs. So, in case this video is hard to follow for you, you can start from the earlier videos in the series and gradually build your knowledge around this.

[@diamonddogsgaming7059]

@@airoundtable thank you sir, I will try my best and follow your tutorials.

[@shue78123]

Very interesting, in your opinion what are the steps to take in order to convert the sql query results into a visualized chart?

[@airoundtable]

Thanks. Add agents specifically designed for data visualization to the system. That would be my first choice since current agents are very good a retrieving data but they just was not desgined to visualize the data.

[@Trymore-r4i]

i only asked few questions and was told to subscribe.How come that you were continously asking questions without being stopped

[@airoundtable]

I am using an active account in AYD. If you have activated your account, I am not sure where that subscribe request came from in your test

[@amirabbasmehrafshan9036]

Great as always

[@airoundtable]

Thanks!

[@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!