| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 665 |
| Technical Name |
odoo_ai_assistant_foerp |
| License | OPL-1 |
| Versions | 14.0 18.0 |
Odoo AI Assistant (A3 - Secure Query Engine)
A powerful AI-driven assistant with secure read-only access to your Odoo database
Key Features
- Conversational AI Assistant directly inside Odoo, similar to ChatGPT.
- Secure Query Engine ensuring safe, read-only access to your database.
- Mandatory read_group usage for BI operations (sum, count, average).
- Automatic conversation history and intelligent context tracking.
- Multi-model support (GPT-4o, GPT-4o mini, etc.).
- Schema explorer: ask what fields exist in any model.
- Draft emails and internal messages using AI.
How It Works
The module includes a secure and restricted Query Engine that the AI must use to perform any data-related operation. This prevents hallucinations and ensures all answers come from the actual Odoo database.
The AI is forced to use the internal tools:
- execute_odoo_read_group â sums, counts, averages, top products, KPIs.
- execute_odoo_search_read â list of customers, invoices, partners.
- get_model_structure â fields of any model.
- create_email_draft â generate draft emails using AI.
- get_financial_summary â accounting balances.
Every AI response is backed by **real queries**, making this assistant ideal for business intelligence, audits, sales insights, financial checks, and high-level analytics.
Example Interactions
- "How many Sales Orders were confirmed this month?"
â AI performs a real
read_groupquery. - "What are the top 5 most sold products?"
â Grouped quantity sum from
sale.order.line. - "List partners with credit limit above $50,000"
â Uses
search_read. - "Draft an email to John about unpaid invoices."
â Creates a
mail.maildraft automatically.
Configuration
- Install the module.
- Go to Artificial Intelligence â API Keys.
- Create an API key (OpenAI).
- Start chatting under Artificial Intelligence â Conversations.
Support
For assistance, customizations, or issues, feel free to contact us:
Email: foerp.solutions@gmail.com
Odoo AI Assistant (A3 - Secure Query Engine)
A secure, ChatGPT-powered assistant fully integrated into Odoo, designed to answer business questions using real, validated data from your database. The assistant includes a restricted and safe Query Engine, ensuring that all operations are performed using Odoo ORM methods only, without hallucinations.
Contents:
Introduction
The Odoo AI Assistant (A3 - Secure Query Engine) allows users to interact with Odoo using natural language. It provides:
- A conversational chat interface
- A secure data access layer (read-only)
- Enforced BI methods using read_group
- Automatic email drafting
- Multi-model LLM support (GPT-4o, GPT-4o mini, etc.)
- Schema discovery for safe querying
- Real-time data-driven insights
Key Features
- Conversational AI inside Odoo, similar to ChatGPT
- Secure Query Engine enforcing strict use of Odoo ORM
- Accurate business intelligence using read_group
- Real database-backed answers, no hallucinated calculations
- Automatic prompts with chat history
- Draft emails using AI
- List any model's fields using schema discovery
- Configurable OpenAI model in system settings
Installation
- Copy the module folder into your Odoo custom addons directory.
- Update Apps List.
- Install the module: “Odoo AI Assistant (A3 – Secure Query Engine)”.
Configuration
Navigate to:
Artificial Intelligence → API Keys
Create a new key:
- Service: OpenAI / ChatGPT
- API Key: your OpenAI secret
- Active: checked
Access the chat from:
Artificial Intelligence → Conversations
Usage Examples
- “How many confirmed Sales Orders do we have this month?” → The assistant uses execute_odoo_read_group.
- “Top 5 sold products by quantity.” → Groups sale.order.line by product.
- “Show customers with credit limit above $50,000.” → Uses search_read.
- “Draft an email to partner ID 7 about unpaid invoices.” → Creates a mail.mail draft.
Query Engine Architecture
The AI is strictly required to use Odoo tools:
- execute_odoo_read_group → BI: sums, counts, averages
- execute_odoo_search_read → lists of records
- get_model_structure → schema metadata
- get_financial_summary → accounting balances
- create_email_draft → draft messages
The backend executes the ORM calls, ensuring security and accuracy.
Security
- All AI queries use read-only ORM methods.
- The internal AI user has controlled, restricted permissions.
- No raw SQL is ever executed.
- Odoo access rights and record rules always apply.
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