- Home
- Apps
- Odoo Modules
- AI Natural-Language Data Assistant (Ask Your Odoo)
Illustrative previewInternal Odoo copilot that answers plain-English questions over your data via a safe query catalog
— records, KPIs, and charts, never raw SQL.
What is AI Natural-Language Data Assistant (Ask Your Odoo)?
Internal Odoo copilot that answers plain-English questions over your data via a safe query catalog — records, KPIs, and charts, never raw SQL. Built to order by ECOSIRE for Odoo 17, 18, 19 — indicative price from $999.00 USD; request a quote for a scoped proposal.
Key Features
Built to order, done for you
No DIY setup — a working app, built, installed and supported by ECOSIRE.
- 1
You order
Start with a one-time build price. We scope it with you at kickoff.
- 2
We build & install
ECOSIRE builds, configures and installs it on your Odoo.
- 3
Go live + support
You go live in about one working week, with two weeks of go-live support. Defects in the code we deliver are fixed free of charge.
Technical Specifications
- Odoo Compatibility
- Odoo 17, Odoo 18, Odoo 19
- Editions
- Enterprise & Community
- License
- Licence confirmation required
- Python Requirement
- Python 3.10+
- Database
- PostgreSQL 12+
About this Product
Your team already has every answer sitting in Odoo — but getting it out means knowing which menu, which filter, which pivot, or waiting on a developer to write a report. The AI Natural-Language Data Assistant ("Ask Your Odoo") closes that gap. It is an internal copilot that lets any authorized user type a plain-English question — "How many quotations did we send last month?", "Show overdue invoices for the Dubai team", "Top 10 customers by revenue this quarter" — and get an instant answer card back: the matching records, a headline count or KPI, and a mini-chart where it helps.
The critical engineering decision is what sits under the hood. This module does NOT generate SQL from your prompt, and it does NOT hand your database to an LLM. Instead, ECOSIRE builds a curated, versioned catalog of parameterized queries — each one a reviewed Odoo ORM search/read_group expression bound to specific models (sale.order, account.move, crm.lead, stock.quant, and whatever else your business runs). The AI's only job is to classify the user's question into the right catalogued query and extract safe parameters (date ranges, teams, states, partners). Because no free-form SQL is ever produced, the entire class of prompt-injection-to-SQL-injection attacks is architecturally impossible — fully in line with Odoo's guidance never to use sql.raw() on untrusted input.
Every answer is scoped by the asking user's own permissions. Queries run through Odoo's ORM, so ir.model.access.csv rules and record rules (multi-company, sales-team ownership, per-record restrictions) apply automatically — a salesperson sees only their pipeline, a regional manager sees only their region, and finance data stays behind finance access. There is no back door around your security model because the assistant uses the same access layer as the rest of Odoo.
As a build-to-order engagement, ECOSIRE designs the query catalog around YOUR models and vocabulary — including custom modules and custom fields — builds the OWL/QWeb chat interface and inline answer cards, wires it into a dedicated Odoo menu, and (optionally) connects your chosen LLM provider or a self-hosted model via a thin, auditable adapter. We deliver on Odoo 17, 18, or 19, Community or Enterprise, with the module code, security definitions, documentation, and admin training handed over to you. This is not an existing apps.odoo.com download: it is a net-new module we build, install, and support for your specific database, with a typical one working week lead time.
What you get
- Complete Odoo module (17/18/19, Community or Enterprise) with a proper __manifest__.py, models, OWL/QWeb chat UI, views, and the LLM adapter service
- A query catalog tailored to your models and business vocabulary — each entry a reviewed, parameterized ORM query mapped to plain-English intents (built from a discovery workshop)
- Security definitions: ir.model.access.csv access rights plus any record rules needed so the assistant respects your existing multi-company and team scoping
- LLM provider integration configured to your choice (hosted API key or self-hosted endpoint) via the auditable adapter, with keys stored in your system parameters
- Installation and deployment on your Odoo instance (staging then production), including smoke-testing the catalog against real data
- Written documentation: how the catalog works, how to add/adjust catalogued queries, security model, and an admin runbook
- Live admin & power-user training session (recorded) covering asking good questions, saved questions, sharing, and reading audit logs
- Post-go-live support window with bug fixes and catalog tuning, plus a defined path for adding new question types after handover
Who this is for
Operations & Sales Manager
Needs same-day answers about pipeline, overdue invoices, and team performance without pinging a developer or building yet another pivot. Types a question, gets a scoped answer card, and drills into the records — all limited to the teams and companies they're allowed to see.
Finance & Controlling Lead
Wants trustworthy KPI numbers (AR aging, revenue by period, margin by product) that respect finance-only access rules. Values that answers come from reviewed queries through the ORM, not ad-hoc SQL a colleague could get wrong or abuse.
Odoo Admin / IT Manager
Responsible for data security and can't allow an AI to run free-form SQL or leak data across companies. Reassured by the no-SQL-generation design, ORM-enforced access, read-only guarantee, and full audit log — and appreciates a documented, maintainable module they can extend.
How AI Natural-Language Data Assistant (Ask Your Odoo) Compares
| Criterion | ECOSIRE | Custom Build | Competitor | Odoo Native |
|---|---|---|---|---|
| Ask questions in plain English | Included | Partial support | Partial support | Not included |
| No raw SQL generated (injection-safe by design) | Included | Partial support | Partial support | Included |
| Answers scoped by ir.model.access.csv & record rules | Included | Partial support | Partial support | Included |
| Tailored to your custom models & vocabulary | Included | Included | Not included | Not included |
| Inline answer cards: records, KPIs, mini-charts | Included | Partial support | Partial support | Partial support |
| Read-only guarantee (cannot write/update/delete) | Included | Partial support | Partial support | Not included |
| Audit log of every question, query & parameters | Included | Partial support | Not included | Not included |
| Saved & shareable questions across teams | Included | Partial support | Partial support | Not included |
| Self-hosted / private LLM option (no data to third parties) | Included | Partial support | Not included | Not included |
| Built, installed & supported for you (2–4 wk) | Included | Not included | Not included | Not included |
Frequently Asked Questions about AI Natural-Language Data Assistant
How long does delivery take, and what's the process?
This is a build-to-order module with a typical lead time of one working week depending on how many models and question types you need. The process is: a short discovery workshop to map your models, vocabulary, and priority questions; ECOSIRE builds the query catalog, OWL/QWeb interface, security rules, and LLM adapter; we install on your staging instance for review; then we deploy to production and hand over docs and training. Larger catalogs or heavy customization may extend the timeline, and we confirm the exact scope and date before we start.
What do I get for support and updates after go-live?
Every engagement includes a post-go-live support window for bug fixes and query-catalog tuning as your team discovers new questions they want to ask. We keep the module compatible with your Odoo edition and version during that window, and we provide a clear runbook and (optionally) an ongoing support/maintenance retainer for adding new question types, upgrading across Odoo major versions, or extending the catalog to new modules over time.
Does the AI write SQL against my database? Is this safe?
No. By design the assistant never generates or runs SQL. ECOSIRE builds a catalog of pre-written, parameterized queries using the Odoo ORM (search/read_group), and the LLM's only role is to pick the right catalogued query and extract safe parameters like date ranges and team names. This eliminates prompt-injection-to-SQL-injection risk entirely and follows Odoo's rule of never using raw SQL on untrusted input. The assistant is also read-only — it cannot create, update, or delete records.
Will it respect my users' access rights and multi-company setup?
Yes. Because every catalogued query runs through the Odoo ORM as the asking user, your ir.model.access.csv access rights and record rules apply automatically — multi-company boundaries, sales-team ownership, and any per-record restrictions. A salesperson only sees their own pipeline; finance data stays behind finance access. There is no bypass path, because the assistant uses the exact same security layer as the rest of Odoo.
Which Odoo versions and editions does this work with, and does it need Enterprise?
We build and deliver on Odoo 17, 18, and 19, and it works on both Community and Enterprise. The assistant relies on standard framework features — the ORM, security model, OWL/QWeb UI, and optionally automated actions — so it does not require Enterprise. If you're on Community we tailor the charting and UI to what's available; if you're on Enterprise we can lean on additional built-in components where useful.
Does my data get sent to an external AI provider?
Only the natural-language question text and the catalog's query descriptions (schema/labels) are sent to the LLM so it can classify intent — your actual record data is not sent to the model. The query itself then runs locally in Odoo through the ORM. If your policy requires it, ECOSIRE can wire the adapter to a self-hosted or private model so nothing leaves your infrastructure. API keys are stored in Odoo system parameters, and every question is captured in the audit log.
Can we add new questions or KPIs after launch?
Yes. The query catalog is designed to grow. ECOSIRE hands over documentation on how catalogued queries are structured, and each new question type is a reviewed, parameterized query we (or a trained admin) add and map to plain-English phrasings. This keeps every addition safe and auditable — new capability never means new free-form SQL. Catalog expansion is a common part of the post-launch support window or an ongoing retainer.
Related Modules
AI Natural-Language Data Assistant
Internal Odoo copilot that answers plain-English questions over your data via a safe query catalog — records, KPIs, and charts, never raw SQL.
- Plain-English question box that routes each query into a safe, pre-built parameterized query catalog — the LLM classifies intent and extracts parameters, it never writes SQL
- Curated query catalog bound to your real models (sale.order, account.move, crm.lead, stock.quant, project.task and your custom models) with reviewed ORM search/read_group expressions
- Inline answer cards showing matching records, headline counts, computed KPIs, and mini-charts (bar/line/pie) rendered in an OWL component
- Role-aware data scoping: every query executes through the Odoo ORM so ir.model.access.csv and record rules (multi-company, sales-team, per-record) apply automatically to the asking user



