O'Dashboard
A BI tool for Odoo. Build queries, visualize data, create dashboards, no SQL required.
O’Dashboard is a data visualization tool built specifically for Odoo. The pitch is simple: let non-technical people ask questions about their Odoo data and get visual answers, without writing SQL or waiting for a developer to build a custom report.
It’s part of O’Solutions, a product suite for the Odoo ecosystem that I build with Julien Masson and Renaud de Boeck.
The problem
Odoo has built-in reporting, but it’s rigid. You get predefined views, and customizing them means writing Python code or buying custom modules. On the other end, generic BI tools like Metabase or Superset can connect to your PostgreSQL database, but they have no understanding of Odoo’s data model. They see sale_order_line, not “Sales Order Lines with product names and customer info.” You lose all the business context.
O’Dashboard sits in between. It understands Odoo models, field types, and relations, so the query builder can offer meaningful options instead of raw table columns.
How it works
- Build a question — pick an Odoo model (e.g.
sale.order.line), configure joins to related models, select the columns you want. Or switch to raw SQL if you prefer. - Visualize — choose from 20+ visualization types: tables, bar charts, line graphs, pie charts, funnels, KPI cards, maps.
- Dashboard — drag questions into dashboards, organize them by team or project, share with colleagues.
Data sources
O’Dashboard supports multiple data sources from a single interface:
- Odoo app source — an Odoo module (
odashboard) installed on the instance that enables direct PostgreSQL-level queries with full Odoo model awareness - External PostgreSQL — connect any PostgreSQL database, useful for cross-system reporting or non-Odoo data
- JSON-RPC (in development) — query through Odoo’s standard API, though this is more limited by nature
Users can connect multiple Odoo instances and external databases, and query them all from one place.
Architecture
The backend is a FastAPI service that handles query building, execution, and source management. The frontend is a Vite + React SPA with the visual query builder and chart rendering. The system connects to Odoo databases either directly via PostgreSQL (through the companion Odoo module) or through external connections.
Pricing
Free tier gives you 1 dashboard and 1 user. The Pro plan at 80 EUR/month unlocks unlimited dashboards and users. O’Dashboard is part of the O’Solutions ecosystem, which also includes O’Chat (multi-instance communication) and O’Toolkit (AI-powered content tools), all sharing a unified token system for AI features.
Current status
The visual query builder, SQL mode, and dashboard composer are functional. We’re actively developing the JSON-RPC source and refining the Odoo model introspection. Compatible with Odoo 16, 17, 18, and 19, both Community and Enterprise editions.