General

What's the best use cases for AskYourDatabase?

For internal use, people who need to do ad-hoc data queries but are not technical enough to write SQL queries, like CEO, customer support, or sales.
For customer-facing use cases, people who need to explore their own data, but it often requires a lot of work to develop a dashboard that can be capable of doing that.
By integrating our chatbot, you can provide a more interactive and user-friendly way for your customers to explore their data.
This is especially useful for a lot of data management softwares, like CRMs, ERPs, or BI tools.

How to use AskYourDatabase?

Currently, AskYourDatabase has Chatbot version and Desktop version.
If your use cases are more for customer-facing, you can use the Chatbot version. If it's internal, using Desktop app is a more straightforward and secure way.

Is it safe to allow AI to access my database?

Although AI can generate wrong SQL queries, AskYourDatabase has developed several features to prevent the damage of wrong queries:
1. For any query that will modify the data, we will ask for your confirmation before executing it.
2. We provide the fine-grained access control feature, which lets you control which tables and columns are accessible for AI.
3. We will sanitize the SQL queries before executing them, such as removing the DROP TABLE command, adding the LIMIT clause, etc.

Does it work well with production database with hundreds of tables?

AskYourDatabase works very well for large and production databases, no matter how many tables you have. And more importantly is we provide the self learning and custom training feature which lets you train the model to understand your database better. You can learn more here: Get better results

How do you keep data secure?

For Desktop app we connect to your database from your local network, and store the credentials on your local machine.
For cloud version, we store all of your credentials in an encrypted format on your databases, all data was transfered on TLS 1.2.
Furthermore, currently we are doing two things to completely solve your security concerns:
1. Pursuing the SOC 2 certification
2. Shipping the support for open-source models like Llama 3 and Mistral, making the solution fully on-premise deployable.

What information do we collect?

We do not collect, store, or transmit any of your request data like your database credentials, queries, or results.
We do collect and store your email address, name, and billing information.