| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 901 |
| Technical Name |
niyu-odoo-ai |
| License | OPL-1 |
| Website | https://niyulabs.com |
| Versions | 12.0 13.0 14.0 15.0 16.0 17.0 18.0 |
Niyu AI Analyst:
Your Odoo Data, Instantly Understood.
Query Any Odoo Data Point, Anytime, From Anywhere.
Stop sifting through menus or waiting for reports. Niyu AI seamlessly integrates into Odoo, letting you ask business questions in plain English and get immediate, actionable insights presented clearly and securely.
Install Niyu AI Analyst Now →How Niyu AI Works (Under the Hood)
Natural language in, safe SQL out—executed inside your Odoo DB. Your business data never leaves your environment.
1) Understand your schema
We read table/field names and types (including custom modules) to build a context map. No row-level data is sent out.
2) NL → SQL generation
Your question + schema → precise SQL for joins, filters, buckets, and aggregations, tailored to Odoo’s models.
3) Execute & visualize securely
SQL runs within Odoo; results render locally with your existing access rules & record ACLs.
Example
”Show revenue by month for FY 2025, grouped by country.”
SELECT date_trunc('month', so.date_order) AS month,
rp.country_id, SUM(so.amount_total) AS revenue
FROM sale_order so
JOIN res_partner rp ON rp.id = so.partner_id
WHERE so.state IN ('sale','done')
AND so.date_order >= '2024-04-01' AND so.date_order
Privacy & Controls
- Only schema & your question are sent to the LLM via your API key.
- No business rows leave Odoo; execution is local.
- Respects Odoo users, groups, record rules, multi-company.
What’s New in August 2025
Brain v2 – Harder Questions, Smarter Answers
Upgraded reasoning and SQL generation for complex joins, date buckets, nested filters, and edge cases.
Token Meter per Question
Each message shows prompt + completion tokens. Keep usage transparent and optimize prompts easily.
Predefined Questions Library
One-click starters by module (Sales, Invoicing, Inventory, HR). Ideal for onboarding and non-technical users.
Token Meter: Know What Each Question Costs
Each chat reply carries a compact badge showing tokens consumed (prompt + completion). Optionally show a split and estimated cost based on your model pricing.
| Sample Question | Prompt | Completion | Total |
|---|---|---|---|
| “Show revenue by month for FY 2025, grouped by country.“ | 1,120 | 640 | 1,760 |
| “Which customers haven’t ordered in the last 6 months?“ | 890 | 420 | 1,310 |
How it’s shown
A small badge (e.g., 1,760 tokens) appears on each answer. This is addition of all the token used input+output.
Why it matters
Keep usage transparent, coach teams on concise prompts, and control spend without restricting access.
Admin toggle*
Enable/disable Token Meter in Settings â Niyu AI Analyst. Visibility can be restricted to admins. (Coming soon)
Predefined Questions by Module
Kickstart insights with curated prompts mapped to common Odoo workflows. Perfect for non-technical users. Pre-defined questions can be customized from module XML or reach out to us and we will help.
Sales & CRM
- Top 10 customers by revenue this quarter
- Pipeline by stage with win rate
Invoicing
- Overdue invoices by account manager
- Monthly revenue vs refunds (YTD)
Inventory
- Low stock items with last 14-day sales
- Stock valuation by category
HR
- Leaves pending approval this week
- Upcoming contract renewals
Installation & Configuration
From install to first answer in a few clicksâno complex infra changes required.
- Get the module from the Odoo App Store.
- Installby adding in custom addons directory orthrough Odoo SH.
- Enter your Open AI API key in Settings → Niyu AI Analyst.
- Ask your first question (e.g., ”Top customers by revenue this quarter”).
Compatibility & Requirements
- Odoo 14 or later
- PostgreSQL (standard Odoo DB)
- Internet access for LLM API calls
- Custom models/fields supported
- On-prem & any cloud hosting
Deployment Notes
- Bring-your-own API key model
- No persistent storage of results
- Schema-only sharing with LLM
Frequently Asked Questions
What Odoo versions are supported?
Niyu AI Analyst is currently supported on Odoo Version 14 and later. Please check the module listing for the most up-to-date compatibility information.
How is my Odoo data kept secure?
Data security is paramount. Your actual Odoo business data *never* leaves your Odoo environment and is *never* stored on our servers or sent to OpenAI. Only non-sensitive information like your database schema (table and field names, their types) and your natural language query are sent to OpenAI via your API key to generate the correct SQL. The SQL query is then executed securely *within your Odoo database*. The results are displayed only to you in Odoo.
What types of questions can Niyu AI answer?
Niyu AI is designed to answer questions that can be resolved by querying data stored in your Odoo database. This includes questions about sales figures, inventory levels, customer data, order details, invoice status, lead information, and any data within standard or custom Odoo models. It excels at retrieving specific data sets, applying filters (by date, status, customer, etc.), sorting data, and performing aggregations (sum, count, average, min, max). Refrain from asking multiple questions in single promt. For highly complex analytical tasks or external reporting needs, consider integrating with tools like our BigQuery Connector.
Does it work with my custom Odoo modules and fields?
Yes, one of the key strengths of Niyu AI Analyst is you can add custom models and keywords to the code and it will start using those tables. It learns from the schema, including custom modules and fields you have created or installed, allowing you to query data unique to your business.
What are the technical requirements?
You need a running Odoo Version 14+ instance. The module requires access to the internet to communicate with the OpenAI API using your provided key. No complex server setup is required beyond standard Odoo hosting.
What are the costs involved?
You purchase the Niyu AI Analyst module license one-time from the Odoo App Store. The only ongoing operational cost is for your usage of the OpenAI API, which is billed directly by OpenAI based on your query volume. There are no additional recurring subscription fees from us for the AI analysis functionality itself.
Is a trial available?
Yes, you can reach out to us for demo and trial at info@niyulabs.com.
Where can I find documentation or support?
Detailed documentation is available in this product page and on our website https://niyulabs.com. For support, please contact us at info@niyulabs.com.
Transforming Odoo Data Access Starts Here.
Experience the revolutionary way to interact with your Odoo data. Empower your team, accelerate insights, and drive business growth.
Get Niyu AI Analyst on Odoo Apps →Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedThe team helped with whitelabeling this module into an IOS app.
There are no comments yet!