| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 1608 |
| 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 your table/field names and types (including custom modules) to build a context map. No row-level data is ever sent out.
2) Translate Your Language to SQL
Your question + schema **+ your custom keyword map** are used to generate precise SQL, turning your business jargon into a query Odoo understands.
3) Execute & Visualize Securely
The generated SQL runs entirely within Odoo, and the results are rendered locally, respecting all of your existing access rules & record ACLs.
Example: Using a Custom Map
See how a custom map ("shipments" → "stock.picking") turns a simple question into a powerful query:
"Show me all late shipments to Azure Interior"
SELECT sp.name, sp.scheduled_date FROM stock_picking sp JOIN res_partner rp ON rp.id = sp.partner_id WHERE rp.name = 'Azure Interior' AND sp.state NOT IN ('done', 'cancel') AND sp.scheduled_date NOW();
Privacy & Controls
- Only schema, your question, and custom maps are sent to the LLM.
- No business data (rows/records) ever leaves your Odoo instance.
- Execution is local and fully respects Odoo user permissions.
Your Business, Your Terms. Make the AI Adapt.
Why should your team learn Odoo's technical jargon? It's time the AI learned yours. Whether you call a `stock.picking` a "dispatch" or a `helpdesk.ticket` a "case," the Custom Keyword Map acts as your personal translator. It seamlessly syncs Niyu AI with your company's unique vocabulary, making every query intuitive and instantly understood.
The "Aha!" Moment
🎯 Pinpoint Accuracy, Every Time
Say goodbye to ambiguous queries. By creating a direct link between your terms ("delivery") and Odoo's models (`stock.picking`), you guarantee the AI targets the exact data you need, eliminating errors and rework.
🌍 Democratize Data Access
Unlock insights for everyone, not just the experts. Your sales team can ask about "shipments" and HR can query "new hires" using the language they already know. No Odoo expertise required.
⚡ Work at the Speed of Thought
Stop rephrasing and start getting answers. When the AI understands you perfectly the first time, you eliminate friction and accelerate your entire decision-making process.
The 30-Second Setup
This isn't complex coding; it's just creating a simple dictionary for the AI. In Settings â Niyu AI Analyst, you'll find a text box where you can instantly map your business terms to their corresponding Odoo models. It takes seconds to set up, but the impact is permanent.
{ "shipment": "stock.picking", "shipments": "stock.picking", "claim": ["crm.claim", "helpdesk.ticket"] }
Granular Permissions, Total Control.
Niyu AI respects your Odoo hierarchy. Empower your team with the insights they need while maintaining complete administrative oversight of who can do what.
Standard User View
Grant team members access to the AI Analyst in their menu. They can immediately start asking questions and getting answers, strictly within the bounds of their existing Odoo data permissions.
Manager Control Panel
Managers have full user capabilities plus access to the settings panel. From there, they can easily grant or revoke access for other users with a simple checkbox, ensuring tight control.
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 penalizedPracticle
tried this Odoo AI Analyst in our odoo instance for a week. it’s not flashy, but is a great product, understands plain English, and responds with proper results. The summaries are clear enough for non-tech folks (C-level in my firm).
A few edge cases needed nudging, but support was responsive — I asked for “token usage per query” and they added it for free. overall: practical, saves me time, and is cheap, doesn’t get in the way.
do you have demo web for this module ?
Hello
i'm interest with this software.
kind regards
Giri
Re: do you have demo web for this module ?
Hello Girianto,
Thanks for reaching out. I see you have reached out via email also.
I have replied and requested for your availability for demo. Lets connect and you may try out the module on our systems before you buy.
Best Regards
Demo db request
Hello
I would like to have demo database access.
Thank you.
Re: Demo db request
Sure,
We would love to provide the demo. Please reach out to us at info@niyulabs.com and suggest a time to connect.
Thanks