Odoo dashboards from a prompt
Describe a metric and the builder writes the SQL, picks the chart, and drops it on a responsive grid. It runs live on your Odoo database, so dashboards update the moment data changes. Free, with source code.
Revenue
$182k
Orders
1,204
Win rate
38%
A dashboard you build by talking
AI widget generation
Just describe the chart
Do not fiddle with axes and domains. Type "total revenue by salesperson this quarter" and the AI writes the SQL, picks the right chart, and places it on your board.
- Validates field names against your schema before rendering.
- Formats currency, dates, and percentages automatically.
- Power users can tweak the generated SQL by hand.
Flexible canvas
Drag, drop, resize
A true grid-based layout engine. Move KPIs around, stretch charts to full width, or stack metric cards side by side, and build a command center that fits your screen.
- Snap-to-grid precision for clean alignment.
- Dashboards stack correctly on mobile.
- KPI cards, data tables, bar/line/donut charts, and lists.
Real-time execution
Zero latency, live SQL
Unlike BI tools that rely on nightly syncs, the builder runs directly on your Odoo PostgreSQL database, so when a sale happens the dashboard updates instantly.
- No ETL or data-warehouse middleware required.
- Uses Odoo's read_group and optimized SQL for speed.
- Respects Odoo access rules; users only see data they can access.
Actionable interactivity
Click to drill down
Static charts are dead ends. Click any bar or slice to jump straight to the underlying Odoo records for deeper investigation.
- Click a "high-priority tickets" card to open the Helpdesk view.
- A global date-range filter updates every chart at once.
- Export the whole dashboard as a PDF for meetings.
Dashboards teams build
Sales
A Monday-morning board with team pipeline, win rate, and calls made, built by typing what you want, with no IT ticket.
Inventory
A grid of stock below the reordering rule and incoming shipments, so stockouts are caught before they happen.
Leadership
A single screen with cash flow, run rate, and open support tickets, for a daily pulse check.
Technical fit
Compatibility
Odoo v16, v17, v18, v19 (Community & Enterprise).
Hosting
Odoo.sh, on-premise, AWS/GCP cloud.
Security
Role-based access control. AI inputs sanitized to prevent SQL injection.
Dependencies
None. Uses the standard Odoo Web framework (OWL) and Chart.js.
Need help choosing, or a custom setup? Talk to us or book a call.
Free download with full source code. See the rest of the catalogue.
AI Dashboard Builder questions
What is the Niyu AI Dashboard Builder for Odoo?+
It is a free Odoo module that turns plain-English prompts into live, SQL-backed dashboards and charts inside Odoo, built on the Odoo Web framework (OWL) and Chart.js.
Do I need to write SQL or Python?+
No. You describe the metric you want and the builder generates the query and widget. Developers can still inspect and adjust the underlying SQL.
Is it really free?+
Yes. The Dashboard Builder is a free utility with the source code included. Download it after a quick email-gated step.
Which Odoo versions does it support?+
Odoo Community and Enterprise on recent versions, on Odoo.sh, on-premise, and cloud hosting.