Answer ad-hoc sales questions against Odoo
When to use: 'What were last week's top 5 customers by revenue?' — without writing XML-RPC.
Prerequisites
- Odoo API key — Odoo: user profile > Preferences > API Keys > New
- ODOO_URL, ODOO_DB, ODOO_API_KEY env vars — Set in your MCP client config
Flow
-
List available modelslist_models — which Odoo models can we query in this instance?✓ Copied→ Model catalog with descriptions
-
Run the queryIn sale.order, find orders with date_order between last Monday and today, group by partner_id, sum amount_total, top 5.✓ Copied→ Ranked customer list with totals
-
Drill inFor the top customer, show the last 3 orders with their line items.✓ Copied→ Detailed breakdown
Outcome: A business answer from ERP data without leaving chat.
Pitfalls
- Multi-currency totals aren't converted — Specify currency_id in the filter, or convert in the LLM layer
- ODOO_YOLO=true is dangerous in prod — Use ODOO_YOLO=read or leave unset; enable full access only in a staging DB