Database Tool
Use database tool to query your own business data
Database tool is a powerful feature that allows your chatbot to connect to your own database and query business data in real-time. You can ask in human language and the chatbot will translate your query into SQL, execute it against your database, and return the query results and charts.
Prerequisites
- You have a database that is accessible from the internet or expose the host via SSH tunneling service such as ngrok.
- Your have the database credentials (username and password).
Create Database Tool
To create a database tool, navigate to the Database tab in your chatbot's dashboard. Click + Add Database to open the dialog window for creating your database tool.
Select a supported database type.
Provide connection information of your database such as host, port, database name, and credentials.
If connection is successful, tables in the database will be listed. You can select tables that you feel safe to expose.
Confirm your database connection settings.
Security Notes
- It is more risky to expose your database to the internet. Consider using a SSH tunnel for secure access.
- Avoid exposing databases that have no authentication or use weak passwords.
- Do not use root user credentials.