sqlwidget

SQL Widgets lets you build fully customized visual indicators on the Dolibarr home page in just a few clicks, with no coding required.

Create three types of widgets powered by your own SQL queries:

• Numbers — KPI tiles with a main value, two optional sub-indicators, an icon (Dolibarr picto, FontAwesome or emoji) and free color choices. They integrate directly into Dolibarr's native statistics area.
• Tables — Data lists with configurable columns, automatic type formatting (text, integer, price with currency, percentage), colored status badges and clickable links to Dolibarr records.
• Charts — Bar, line or doughnut visualizations rendered via Chart.js, with a customizable color palette.

Access is secured by user group: each widget is visible only to the groups you authorize. Data formatting automatically respects the language and currency configured in Dolibarr.