| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 435 |
| Technical Name |
niyu-odoo-ai |
| License | OPL-1 |
| Website | https://niyulabs.com |
| Versions | 12.0 13.0 15.0 16.0 17.0 18.0 |
Go Beyond Standard Reports: Generate SQL with AI!
Instantly translate your plain English questions into executable SQL queries, right inside Odoo.
Key Advantages
- Ask Anything, Get SQL: Type what data you need; our AI crafts the PostgreSQL query for you.
- See Your Data Live:Instantly run the generated SQL and view results in a table â no waiting.
- Empower Your Analysis: Perfect for developers, analysts, or anyone needing specific, ad-hoc data views beyond standard reports.
- Export & Go:Directly export your query results to Excel for further work.
- Simple & Secure:Uses your own OpenAI key; data and queries stay within your Odoo environment's control.
AI SQL Generator is built for you. It's the most direct way to have a "conversation" with your Odoo database
AI Analyst for Odoo Data
Ask Questions, Get Answers – Instantly Inside Odoo.
Instant Answers. Zero Report Building.
Stop wasting time clicking through screens or exporting data. Just ask your question in plain English and get the answer you need directly from your Odoo database in seconds.
E.g., Ditch the report wizard. Simply ask:
"What was our total sales revenue last month?"
Consider it done.
Uncover Insights, Make Smarter Decisions.
Go beyond standard dashboards. Ask nuanced questions to identify trends, spot opportunities, or find issues hidden in your data â like slow-moving inventory or newly inactive customers.
Intel Drop: "List products with stock > 10 that haven't sold in 6 months."
Query Data Without Leaving Odoo
Analyze while you work. Get immediate context without switching applications. Ask about a customer while viewing their profile, or check stock levels directly from a sales order form (coming soon).
Seamless Query: While on a client call, whisper: "Show recent orders for [Customer Name]."
Ignite Your Inquiry & Obliterate Frustrations
Example Queries (What Can You Ask?):
- ✨ Show the top 5 customers by sales revenue this quarter.
- 📈 How many leads were created last week?
- 🔍 What is the current stock quantity for product '[Product Name]'?
- List unpaid customer invoices older than 30 days.
- 🎯 Which salespeople closed the most deals last month?
Pain Points Solved:
Eliminate Reporting Bottlenecks:
Get immediate answers instead of waiting for complex reports to be built or run.
Reduce Reliance on Experts:
Empower any user to query data without needing deep Odoo knowledge or developer help.
Break Down Data Silos:
Access and combine information from different Odoo areas (Sales, Inventory, etc.) through simple questions.
Discover Hidden Trends:
Ask the specific questions standard dashboards don't cover to find actionable insights.
Niyu AI Analyst: Your Odoo Supermind.
This isn't just software. It's your unfair advantage. Your Odoo data holds empires of insight. Niyu AI Analyst hands you the keys. Effortless discovery, decisive action, exponential growth. The future of your business, illuminated.
Unlock Instant Clarity
Direct Odoo Data Access
Queries run directly against your live Odoo database via ORM for real-time results. Data stays secure within your system.
Natural Language Queries
Simply type your business questions like you'd ask a colleague. No code or complex filters required.
Deep Odoo Schema Awareness
Understands your specific Odoo models, fields (monetary, date, relational), and connections for pinpoint accuracy.
Integrated UI
Ask questions and receive answers directly within a clean, intuitive interface inside your Odoo environment.
Simple Setup
Install the module, enter your OpenAI API key in Odoo settings, and start asking. No external accounts needed.
Mastering Your AI Analyst
Unlock the full potential of Niyu AI with these tips for effective analysis and crystal-clear insights.
Be Specific
Clearer questions yield better answers. Instead of "product info", ask "stock level for product X" or "sales revenue for product Y".
Use Timeframes
Add context like "last month", "this quarter", "yesterday", or "since June 1st" for precise results.
Focus Your Queries
For best results, avoid combining fundamentally different requests with "AND". Use "WITH" to link related details (e.g., "products WITH their stock levels").
Start Simple
Begin with straightforward questions about core data (customers, products, sales) before tackling highly complex multi-step analyses.
Review & Verify
While powerful, AI interpretation isn't infallible. Briefly check if the answer aligns logically with your question and data.
Important Points to Note::
-
🔑
Your OpenAI Key, Your Power Source: Niyu AI taps into OpenAI's brilliance. Plug in your key via Odoo settings. You're the pilot.
-
💰
OpenAI Usage, Your Control: Costs are tied to your OpenAI usage (GPT-4-Turbo recommended for peak performance). Monitor your OpenAI dashboard. You own the spend.
-
🛡
Your Data Sanctity: Uncompromised.
- Your raw Odoo data NEVER leaves your system for third-party storage. OpenAI API calls are initiated by YOU, with YOUR key.
- To translate your intent, your query text & relevant Odoo schema snippets (metadata, not your records) are sent to OpenAI via your key.
- For sharp summaries, Niyu AI retrieves necessary data *locally*, then sends only that curated snippet to OpenAI (via your key) for articulation.
-
🧠
Your AI Co-Strategist: LLMs are potent. Responses are context-driven. For complex queries, results are a powerful guide, not gospel. Your strategic judgment reigns supreme.
Frequently Asked Questions (FAQs):
01 What do I need to use this module?
An Odoo instance (v18 or newer recommended) and your own active API key from OpenAI.
02 Is my data sent anywhere?
Only your query text, relevant Odoo schema snippets (field/model names & types), and the specific data retrieved to answer your question are sent to OpenAI via your API key for processing. Your underlying database is not directly exposed or transferred elsewhere.
03 What Odoo modules does it understand?
Initially focused on core modules like Sales, CRM, Inventory, Accounting, Contacts/Partners, and Product using their standard fields. Support for other installed modules is being actively expanded.
04 Does this cost money?
The module itself may have a purchase price on the Odoo App Store. Ongoing operational costs are determined by your usage of the OpenAI API, billed directly to your OpenAI account. There are no separate Niyu Labs subscription fees.
05 What if I ask a very complex or vague question?
The AI will attempt to answer based on the schema context. If it cannot confidently generate a query (due to ambiguity or missing context), it will provide an explanation and may suggest ways to rephrase your question for better clarity.
06 How does this compare to traditional BI tools?
This focuses on instant, conversational Q&A directly within Odoo, complementing BI tools. It's designed for quick answers and data exploration without complex report setup, not for building elaborate, static dashboards (though future versions might add charts).
07 How accurate is it?
Accuracy depends on question clarity, Odoo data/schema quality, and OpenAI model capabilities. It's a powerful assistant, but critical decisions should always involve human verification.
Your Guide to Niyu AI Analyst
Explore the comprehensive documentation to get started, master features, and troubleshoot effectively.
Introduction
Understand the core functionality of the AI Analyst module and its primary benefit: transforming your natural language questions into actionable answers directly within Odoo.
Installation & Configuration
- Standard Odoo module installation steps.
- Locating settings: Settings -> General Settings -> AI Analyst.
- Obtaining & securely entering your OpenAI API key.
How to Use
- Navigating to the main interface: AI Analyst Menu -> Ask AI.
- Basic UI layout: Input Box, Ask Button, Response Area.
- Understanding success vs. failure/clarification responses.
Effective Questioning
- A curated list of 5-10 good example queries.
- Tips for specificity, timeframes, using "WITH", and starting simple.
Troubleshooting
- Common errors: API key issues, query generation failures.
- Addressing slow responses or unexpected answers.
Privacy, Security & Limitations
- Clear reiteration of data sent to OpenAI.
- User responsibility for OpenAI key/costs.
- Understanding AI limitations (single ORM queries, ambiguity, etc.).
Crave Bespoke AI Dominance in Your Odoo Universe?
We architect custom AI symphonies. Let's orchestrate yours.
Connect with Us: info@niyulabs.comOdoo 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