Wow! this looks like an advanced version of what you designed. I'm sure you designed this product.
@airoundtable4 ай бұрын
:)) 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
@dswithanand4 ай бұрын
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"?
@askyourdatabase4 ай бұрын
Yes, you can do that.
@d2clon4 ай бұрын
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.
@airoundtable3 ай бұрын
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.
@ayushmishra58614 ай бұрын
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.
@airoundtable4 ай бұрын
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
@MrSikesben2 ай бұрын
Now this is interesting. I am definitely trying it out
@airoundtable2 ай бұрын
I hope you enjoy using it!
@protimaranipaul71074 ай бұрын
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?
@airoundtable4 ай бұрын
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.
@shue781233 ай бұрын
Very interesting, in your opinion what are the steps to take in order to convert the sql query results into a visualized chart?
@airoundtable3 ай бұрын
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-r4i3 ай бұрын
i only asked few questions and was told to subscribe.How come that you were continously asking questions without being stopped
@airoundtable3 ай бұрын
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