| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 1961 |
| 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 19.0 |
Odoo AI Analyst
Chatbot:
💬 Chat • 📊 SQL • 📈 Charts
Ask questions in any language and get accurate answers, the exact SQL, and instant charts—directly from your Odoo.
Install Niyu AI Analyst Now →Oct 2025 Update: New UI, Chart Generation, Export to PDF/CSV, Token Meter, Faster SQL & Odoo 19.0 Compatibility.
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.
Beauty, Meet Brains. The All-New Interface.
We didn't just make it look better; we made it smarter and more transparent. Experience our sleekest design yet, and for the first time ever, see the exact SQL query generated for every question you ask. No more black box. Validate the logic, learn how it works, and trust the results.
A Stunning New Look
Clean, modern, and fast. The interface has been completely redesigned to feel like a native, premium part of your Odoo experience. Data is presented with clarity, making insights jump off the screen.
Total SQL Transparency
Trust is earned, not given. Every answer now includes an expandable Show SQL option. See the raw PostgreSQL query we generated and executed in your database. It's the ultimate proof of accuracy and security.
Click. See. Understand.
Every answer is now a potential dashboard. With a single click on Show Charts, Niyu AI intelligently analyzes your results and automatically generates the most effective visualizationsâbe it a bar chart for comparisons, a line chart for trends, or a pie chart for proportions. Stop interpreting tables and start seeing the story in your data.
Automatic Chart Selection
Niyu intelligently picks the best chart type (Bar, Line, Pie, etc.) based on your data structure to provide the clearest insights instantly.
Interactive & Sharable
Hover over data points for details, and export your charts to PDF or CSV, making it easy to share your findings with the entire team.
From Insight to Action
Visualizing trends and outliers helps you make faster, more confident decisions directly from your Odoo data without any extra steps.
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.
{ "construction", "design", "hotel"] }
Export with a Click.
Your insights shouldn't be trapped in a chat window. Every response from Niyu AI comes with one-click export buttons, allowing you to instantly generate professional PDF reports or CSV files for deeper analysis in your favorite tools.
Presentation-Ready PDFs
Instantly generate a clean, professionally formatted PDF of any AI-generated table or chart. Perfect for sharing in meetings, emailing to stakeholders, or including in your company reports without any extra work.
Deep Dive with CSV
Export the raw data from any response as a CSV file. Seamlessly import it into Excel, Google Sheets, or other BI tools to perform your own calculations, create custom pivot tables, and conduct deeper analysis.
Speak Your Language. We Understand.
Break down communication barriers and empower your global teams. Niyu AI Analyst understands and responds in virtually any language, providing a consistent, intuitive experience for every user, no matter where they are.
Global Team Empowerment
Whether your team is in Tokyo, Berlin, or São Paulo, they can ask questions in their native tongue. This fosters inclusivity and ensures that valuable insights aren't lost in translation.
Zero Configuration Needed
There are no language packs to install or settings to configure. The AI automatically detects the language of the query and responds in kind. It's an intelligent system that simply works out of the box.
Contextually Aware
The AI doesn't just translate; it understands business context. Whether you ask for "facturas" (Spanish) or "invoices" (English), it knows to query the `account.move` model in Odoo.
Granular Permissions, Total Control.
Niyu AI respects your Odoo hierarchy. Easily grant access to team members while ensuring all queries adhere to existing data security rules.
Simple, Secure Access via the "User" Role
There is one straightforward access level: AI Analyst User. Assigning this role to an employee gives them access to the Niyu AI Analyst app. Importantly, all their queries will automatically respect their existing Odoo permissions and record rules. They can only see the data they are already authorized to see.
How to Grant Access (Admin):
- Navigate to Settings > Users & Companies > Users.
- Select the desired user to open their profile.
- Scroll down to the Niyu Labs AI section.
- From the dropdown menu, select AI Analyst User.
- Click Save.
Niyu AI Analyst: Evolution of Intelligence
Witness the continuous innovation that makes Niyu AI your indispensable Odoo data partner. Every update brings powerful new capabilities and refinements.
🚀 This monumental update brings a dazzling new UI, unprecedented data transparency, powerful export capabilities, and a significant leap in AI intelligence. Prepare for an Odoo experience like never before!
-
✨
Revolutionary New UI: A completely redesigned, modern, and intuitive user interface for an unparalleled Odoo experience.
-
🧠
Enhanced AI Intelligence (Smart Answers & Brain v2): Experience vastly improved reasoning, SQL generation, and context-aware responses, expertly handling complex joins, date buckets, and nuanced data requests.
-
👁
Full SQL Query Transparency: See the exact PostgreSQL query generated for every answer, offering total transparency and trust in the AI's logic.
-
📥
One-Click PDF & CSV Export: Instantly export any AI-generated table or chart data to professional PDF reports or raw CSV files for deeper analysis.
-
📖
Comprehensive Chat History: Seamlessly track and revisit all your past queries and their results with a persistent, easy-to-access chat history.
-
🪙
Token Meter per Question: Transparently view prompt + completion tokens for each interaction, helping to optimize usage and cost.
-
📚
Predefined Questions Library: Jumpstart your analysis with a curated library of one-click questions, categorized by Odoo module, ideal for new users.
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
Explore Our Other Innovations
Supercharge your Odoo experience with our suite of intelligent tools designed for modern data challenges.
Niyu AI Dashboard Builder
Stop sifting through raw data. Simply tell Niyu AI what you want to see, and watch it magically construct stunning, interactive dashboards and reports in seconds.
Learn More →
Pro BigQuery Connector
Unlock the full potential of your Odoo data. Export millions of records to BigQuery for advanced analytics, BI, and machine learning. Features powerful filtering, efficient batching, and automated scheduling.
Learn More →Frequently Asked Questions
What Odoo versions are supported?
Odoo 14 and later. Check the module listing for the most up-to-date compatibility information.
How is my Odoo data kept secure?
Your business data never leaves your Odoo environment. We only send non-sensitive schema metadata (table/field names and types) and your natural-language question to the AI using your OpenAI API key to generate SQL. That SQL is executed inside your Odoo database, and results are shown only to you in Odoo.
Does it work on Odoo.sh and On-Prem?
Yes. Niyu AI Analyst runs on Odoo.sh and self-hosted / On-Prem environments.
What types of questions can Niyu AI answer?
Anything that can be answered from data already in your Odoo DB: Sales, Invoices, AR, Inventory, Purchase, CRM/Leads, Projects, HR and any custom apps. It handles filters (date/status/owner), sorting, group-by, and aggregations (sum/count/avg/min/max).
Tip: ask one clear question per prompt for best results. For heavy analytics or blending external sources, consider our BigQuery Connector.
Can I use it with custom modules and custom fields?
Yes. It reads your schema (including custom models/fields). You can also extend a keyword map (via settings or config) so the AI maps business terms (e.g., “hotel”) to the right models/fields (e.g., property.hotel).
Can I see or copy the SQL?
Yes. SQL transparency is a core feature-you can view and copy the exact SQL produced for any answer.
Is it read-only? Can it change my data?
Niyu AI Analyst is designed for read-only analysis. The generated SQL is intended to retrieve data, not modify it.
What are the technical requirements?
- Odoo 12+ up to your current version
- Outbound internet from the Odoo server to the OpenAI API
- Your OpenAI API key (kept in your Odoo settings)
- No special server changes beyond standard Odoo hosting.
How fast is it?
Typical answers arrive in seconds. Final latency depends on your DB size, indexes, and question complexity. Long-running queries behave like any report/query on your DB.
What export options are available?
You can export results to PDF and CSV for sharing, reviews, and meetings.
What are the costs involved?
- One-time purchase: Niyu AI Analyst (purchase on the Odoo App Store)
Is a trial available?
Yes. Demos and limited trials are available on request. Email info@niyulabs.com or book a demo from our product page.
Where can I find documentation or support?
This product page includes detailed steps and examples. More docs are on https://niyulabs.com.
Support: info@niyulabs.com (business hours, priority response for active trials, existing and new customers).
What is your update & support policy?
Free upcoming features. Free installation support. We provide 90-day bug-fix support from purchase and minor updates within the same Odoo major version series. Changelogs are published on the App Store page and our website.
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!