Ask Odoo in plain English
Turn questions into executable PostgreSQL, answers, and charts over your Odoo data. Every answer shows the SQL behind it, your records stay on your server, and the AI respects Odoo access rights.
A real analyst, not a black box
It writes the SQL, runs it, charts the result, and shows its work, so your team can trust every answer.
The SQL engine
Natural language to executable PostgreSQL
Stop writing SQL for ad-hoc reports. The agent maps your Odoo schema, including complex Many2one and One2many relationships, and generates optimized SQL on the fly.
- Translates "Sales by country last Q3" into accurate, time-boxed SQL.
- If a query fails, it reads the PostgreSQL error and fixes the syntax before answering.
- Developers can view the raw SQL behind every answer to verify accuracy.
Privacy architecture
Zero data leakage. You own the API key
Your business records are not sent to OpenAI. Only the database schema (table names and field types) and your question leave Odoo. Customer data stays on your server.
- Bring-your-own-key: use your own OpenAI key and monitor token usage and cost.
- No training: your data is not used to train public models.
- No personally identifiable information is transmitted.
Instant visualization
Auto-generated charts and dashboards
Raw numbers are hard to read. The Analyst detects the best visualization for your result set and renders bar, line, or pie charts instantly.
- Interactive rendering powered by Chart.js.
- Export any chart as a high-res PNG or PDF.
- Pin any AI-generated chart to your Odoo dashboard in one click.
Context awareness
Multi-module intelligence
The AI understands cross-module relationships natively, so you can ask questions that span Sales, Inventory, and Accounting without defining joins by hand.
- Smart joins across tables (e.g., "stock levels for top-selling products").
- Automatically detects and queries Studio fields (x_studio_…).
- Respects Odoo access rights: if a user cannot see data in Odoo, the AI will not show it.
Technical fit
Compatibility
Odoo v15, v16, v17, v18, v19 (Community & Enterprise).
Hosting
Odoo.sh, on-premise, AWS/GCP cloud.
Model support
GPT-4o for complex reasoning, GPT-4o-mini for speed.
Usage monitoring
Built-in token meter and admin daily limits.
One-time purchase, no subscription from Niyu Labs. You bring your own OpenAI key and pay only your own usage.
- Full source code
- Unlimited users
- Free installation support
- Lifetime updates for the purchased version
5.0 from 5 verified customers
“Excelente support”
The module understands the question and gives a correct answer.
Translated from Spanish
Plus four more 5-star ratings from Tim Brandford, Byron Guerrero, Mehdi Abdennebi, aleem.
AI Data Analyst questions
What is the Niyu AI Data Analyst for Odoo?+
It is an Odoo module that turns plain-English questions into executable PostgreSQL against your Odoo database, then returns the answer and a chart. It maps your schema, including Many2one and One2many relationships and Studio fields, and shows the SQL behind every answer so you can verify it.
Can I trust the answers?+
The Analyst shows the generated SQL for every result, so an analyst or developer can read exactly how a number was calculated before relying on it. If a query fails, it reads the PostgreSQL error and corrects the syntax before answering.
Where does my Odoo data go?+
Only the database schema (table and field names) and your question are sent to the model. Your business records stay on your Odoo server. It uses a Bring Your Own Key model, so calls go through your own OpenAI key and respect Odoo user access rights.
Which Odoo versions does it support?+
Odoo 15, 16, 17, 18, and 19, on Community and Enterprise, hosted on Odoo.sh, on-premise, or your own cloud.
How much does it cost?+
A one-time purchase of $299 with full source code, unlimited users, free installation support, and updates for the version you bought. There is no monthly subscription from Niyu Labs; you pay your own OpenAI usage.
The rest of the AI layer for Odoo
AI MCP Server for Odoo
Connect ChatGPT, Claude, or Cursor to live Odoo data with governed access and a full audit trail.
Learn moreSmart StockAI Inventory Planning
Forecast demand from Odoo sales history and get buy and transfer recommendations before you stock out.
Learn moreAI ServicesCustom AI for Odoo
Need tailored analytics, agents, or pipelines? Our team builds AI solutions on your Odoo instance.
Learn more