Build dashboards with SQL
SQL is an open-source relational database management system. It is popular for being very beginner friendly and has become one of the most popular database options out there
How do I activate this integration?
First Step
Login to your Onvo account, go to the Integrations page click on Connect
next to the SQL Database card.
Second Step
You will then be shown a configuration modal where you can enter the SQL
credentials and click on Connect SQL DB.
Third Step
You can now head over to the Data sources page and click on New data source.
Fourth Step
Fill in a name for the data source, an optional description and choose SQL
as the type. Then click on Connect.
Fifth Step
In the page that appears, fill in the SQL query and click on Save changes.
You should now see your data descriptions and sample data appear.
What can I do with this integration?
You can pull in data from multiple tables/databases as data sources on Onvo to build your dashboards and reports. Any datasource using the MySQL integration will be kept in sync with the underlying data to keep your dashboards live.
You can create beautiful, interactive dashboards using your MySQL data. Just ask for the kind of visualisation you want in natural language to create a widget on the dashboard. You can also ask for data pre-processing before visualisation. We also allow for questions in natural language to your data on MySQL.
How do I create a dashboard using multiple tables?
On Onvo, you can do this in two ways:
- You can write an SQL query with a join on a single datasource so that the datasource has all the relevant data to begin with
- You can optionally create 2 separate data sources and make sure you mention the field used to correlate the data in the "fields" tab. This will enable the AI to write the necessary code to join the data without having to write complicated join queries.
Config parameters
Database server address (e.g., "localhost" or "192.168.1.1").
Database username for authentication (e.g., "myuser").
Password for connecting to the database server.
Name of the target database (e.g., "mydatabase").
SQL query to execute on the database. Example: "SELECT * FROM mytable WHERE column = 'value'".
Security considerations
It is recommended to setup a separate user on your database with just read access to the tables you require for your dashboard. In addition, if possible, restrict the incoming IP addresses to the database.
If you do restrict access by IP addresses, make sure to whitelist 35.209.78.5 for Onvo AI to access your database.