E-commerce
Orders, revenue, average ticket and best-selling products.
Databases
Dashboards from MySQL, with AI
Online stores, custom systems and web platforms often run on MySQL. Connect it to Hubviz and track sales, customers and operations in one dashboard.
7 days free · Cancel before the trial ends and pay nothing
How to connect: MySQL
-
Create the connection profile
Enter your MySQL access details in Hubviz Studio. The profile is saved for reuse in other projects.
-
Pick tables or write the query
Browse schemas, tables and views, or write the SQL. If you prefer, describe it in plain language and AI generates the query.
-
Ask for the dashboard
With the cube created, ask AI for the dashboard or build it in the visual editor and publish to Hubviz Web.
What you can do
- Explorer with schemas, tables, views, primary and foreign keys
- Custom query or direct table selection
- AI SQL generator based on the database structure
- Scheduled refresh with cron expressions
Customers
New customers, repeat purchases and distribution by region.
Operations
Order status, lead times and returns.
Targets
Actuals next to targets from a connected spreadsheet.
Frequently asked questions
Does Hubviz change data in MySQL?
No. Hubviz reads data for analysis. We recommend a database user with read-only permission.
Do I need to know SQL?
No. You can pick tables or describe the query in plain language for AI to generate the SQL.
Can I combine MySQL with a targets spreadsheet?
Yes. A project can have several sources, and cubes can be related to each other.
See also
SQL Server SQL Server queries and tables in dashboards. PostgreSQL PostgreSQL queries and tables in dashboards. Oracle Oracle queries and tables in dashboards. Firebird Firebird queries and tables in dashboards. SAP HANA SAP HANA queries and tables in dashboards. ODBC ODBC queries and tables in dashboards.
See all your company numbers in one place this week
You get 7 free days to connect your sources and build your first dashboards.