Answer ad-hoc sales questions against Odoo
Когда использовать: 'What were last week's top 5 customers by revenue?' — without writing XML-RPC.
Предварительные требования
- 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
Поток
-
List available modelslist_models — which Odoo models can we query in this instance?✓ Скопировано→ 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.✓ Скопировано→ Ranked customer list with totals
-
Drill inFor the top customer, show the last 3 orders with their line items.✓ Скопировано→ Detailed breakdown
Итог: A business answer from ERP data without leaving chat.
Подводные камни
- 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