The AI Data Analyst for Odoo.
Turn natural language into executable SQL and instant charts. Zero hallucinations. 100% Privacy control. The intelligence layer for your ERP.
Prompt
Show me top 10 customers by revenue in Q3 2024 and plot a bar chart.
SQL Output
SELECT partner_id, SUM(amount_total) AS revenue
FROM sale_order
WHERE date_order BETWEEN ...
The Problem
Stop waiting for the IT team to build reports.
Manual exports to Excel are slow. Generic BI tools do not understand Odoo's complex data structure. The AI Analyst lives inside your dashboard, translating plain English into accurate PostgreSQL queries in milliseconds.
Query accuracy
99.8%
Average response
0.48s
Time saved per report
2.4 hours
Core Capabilities
The Engine.
Purpose-built for Odoo complexity, with deterministic SQL, privacy-first architecture, and instant visualization.
Natural Language to Executable PostgreSQL.
Stop writing SQL queries for ad-hoc reports. Our AI agent maps your specific Odoo schema (including complex Many2one and One2many relationships) and generates optimized SQL on the fly.
- Deterministic Logic: Translates "Sales by Country last Q3" into accurate, time-boxed SQL.
- Self-Correction Loop: If the generated SQL fails, the AI analyzes the PostgreSQL error log and fixes the syntax automatically before presenting the answer.
- Transparency: Developers can view the raw SQL query behind every answer to verify accuracy.
Zero Data Leakage. You own the API Key.
We do NOT send your business records to OpenAI. We only send the database schema (table names and field types) and your specific question. Your customer data never leaves your Odoo server.
- Bring-Your-Own-Key: Use your personal OpenAI API Key. Monitor token usage and costs directly on your dashboard.
- No Training: Your data is not used to train public models.
- GDPR Compliant: No Personally Identifiable Information (PII) is transmitted.
Auto-Generated Charts & Dashboards.
Raw numbers are hard to read. The AI Analyst automatically detects the best visualization for your data, rendering Bar, Line, or Pie charts instantly based on the result set.
- Interactive Rendering: powered by Chart.js.
- Export Ready: Download any chart as a high-res PNG or PDF for presentations.
- Dashboard Integration: Pin any AI-generated chart to your Odoo Dashboard with one click.
Multi-Module Intelligence.
The AI understands cross-module relationships natively. Ask questions that span Sales, Inventory, and Accounting without defining joins manually.
- Smart Joins: Queries across tables (e.g., "Show me Stock levels for Top Selling Products").
- Custom Field Support: Automatically detects and queries Studio fields (x_studio_...).
- Security First: Respects Odoo User Access Rights (ACLs). If a user is not allowed to see the data in Odoo, the AI will not show it to them.
The Engineer View
Technical Specs. Zero fluff.
Designed for production environments with strict privacy, performance, and governance requirements.
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. Admin daily limits.
Privacy Layer
Only schema metadata and the user question are transmitted. Your records never leave the Odoo server.
Use Cases
Social Proof.
From Sales to Finance to Engineering, teams move faster with AI Analyst inside Odoo.
The Sales Manager
I needed to know which customers bought Product A but not Product B in 2024. Usually this takes 3 Excel exports and a VLOOKUP. The AI Analyst gave me the list in 4 seconds.
The CFO
I do not trust AI with my numbers usually. But because Niyu shows the generated SQL, I can verify exactly how it calculated the margin before I put it in my report.
The Developer
I use it as a SQL scaffold. I ask it to write a complex join query, then I copy the SQL code and use it in my custom modules. It speeds up development by 50%.