Connect MySQL to clariBI
Give clariBI a read-only MySQL or MariaDB user, choose the tables, and it copies them next to your other sources and builds a dashboard for them.
| Connection | Built in. Host, port (3306 if empty), database, user name and password, plus an optional table list. |
| Access | SELECT statements only. Use a user that can only read the tables you want to share. |
| Rows | Each sync copies up to your plan's row cap per table (3,000 rows on Free and Trial, up to 100,000 on Enterprise). |
| Network | The server must be reachable from the internet. Private and local addresses (10.x, 192.168.x, 127.0.0.1) are refused. |
| Plans | Every plan, including Free, within its data source limit. Asking questions in plain English needs the trial or Starter and above. |
About MySQL
MySQL is an open-source relational database, common as the main database behind web applications. MariaDB started as a fork of MySQL and connects the same way.
clariBI connects over the network, reads the tables in the database you name, and runs SELECT statements only. The password is stored encrypted. We tested the connector against MariaDB 10.11.
Vendor site: mysql.com, mariadb.org
What clariBI syncs
When you connect, clariBI tests the connection and syncs right away: it reads the tables, columns and types in the database and copies every table, or only the tables you list. In MySQL the database is the schema, so there is no schema field.
A sync re-reads each table and copies up to your plan's row cap (3,000 on Free and Trial, 5,000 on Lite, 10,000 on Starter, 50,000 on Professional and 100,000 on Enterprise), so point clariBI at summary tables or views (daily revenue, weekly signups) rather than raw event tables. There is no incremental sync. Click Sync now to copy fresh rows. clariBI also syncs on its own when the copy is more than a day old and a question, a dashboard refresh or a report uses it.
The database must accept connections from the internet on its port. clariBI refuses private, local and internal addresses such as 10.x, 192.168.x and 127.0.0.1, so a server reachable only inside your network or VPN cannot be connected. Allow clariBI through your firewall; write to support@claribi.com for the address. A connection attempt gives up after 15 seconds, and queries run with a statement timeout.
How to connect MySQL
Create a read-only user
In MySQL or MariaDB, create a user for clariBI and grant it SELECT on the database or on the tables you want to share, and nothing else.
Enter the connection
In clariBI, open Settings > Integrations > Add Data Source > Databases > MySQL and enter host, port, database, user and password. Add a table list if you want to limit what is read. Click Test Connection, then Create Data Source.
Sync the tables
clariBI copies the tables right away and builds a dashboard for them. You can ask questions once the first sync finishes.
Questions you can ask
Asking in plain English uses AI credits, so it needs the trial or a Starter, Professional or Enterprise plan. Totals and trends are computed from the synced rows; the AI plans the question, picks the chart and writes the explanation.
- "Which products in the orders table sold most last month?"
- "How do weekly orders in our shop database compare with Meta Ads spend?"
About the MySQL connector
Can clariBI write to my database?
clariBI only runs SELECT statements and blocks queries with write keywords. A user with read-only grants makes sure of it on the database side.
Does it work with MariaDB?
Yes. Choose MySQL in the form and enter the MariaDB server's details. We tested with MariaDB 10.11.
Why is there no schema field?
In MySQL a database and a schema are the same thing. clariBI reads the tables in the database you name.
How many rows does a sync copy?
Up to a row cap per table that depends on your plan: 3,000 on Free and Trial, 5,000 on Lite, 10,000 on Starter, 50,000 on Professional and 100,000 on Enterprise. Larger tables are copied in part, so summary tables and views give complete answers.
Can clariBI reach a database on a private network?
No. clariBI connects over the internet and refuses private, local and internal addresses such as 10.x, 192.168.x and 127.0.0.1. Give the server a public host name or address and allow clariBI through your firewall.
Which other databases can clariBI connect?
PostgreSQL, SQL Server and Oracle, with the same form. SQLite is not offered; export those tables as CSV and upload them.
Which clariBI plans include MySQL?
Every plan can connect it, within its data source limit: 3 on Free, 5 on Lite, 10 on Starter, 50 on Professional and 100 on Enterprise. Each source gets an automatic dashboard on every plan. Asking questions in plain English and AI reports need the trial or a Starter, Professional or Enterprise plan.
Try MySQL in clariBI
The trial lasts 14 days, includes 50 AI credits and needs no card. When it ends, your account moves to the Free plan and keeps its data and dashboards.