mcp-server-odoo MCP — Casos de uso, Instalar & Demo ao vivo

Por que usar

Principais recursos

Works with Odoo 16+ (standard mode needs the MCP Odoo module) or any version in YOLO mode
Smart field selection — default 15 most relevant fields per model, no noise
Read-only mode via ODOO_YOLO=read — safe for connecting to production
API key auth (preferred) or username/password
Locale support via ODOO_LOCALE for multilingual Odoo instances

Demo ao vivo

Como fica na prática

server-odoo.replay ▶ pronto

0/0

Instalar

Escolha seu cliente

~/Library/Application Support/Claude/claude_desktop_config.json · Windows: %APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "server-odoo": {
      "command": "uvx",
      "args": [
        "mcp-server-odoo"
      ],
      "_inferred": true
    }
  }
}

Abra Claude Desktop → Settings → Developer → Edit Config. Reinicie após salvar.

~/.cursor/mcp.json · .cursor/mcp.json

{
  "mcpServers": {
    "server-odoo": {
      "command": "uvx",
      "args": [
        "mcp-server-odoo"
      ],
      "_inferred": true
    }
  }
}

Cursor usa o mesmo esquema mcpServers que o Claude Desktop. Config de projeto vence a global.

VS Code → Cline → MCP Servers → Edit

{
  "mcpServers": {
    "server-odoo": {
      "command": "uvx",
      "args": [
        "mcp-server-odoo"
      ],
      "_inferred": true
    }
  }
}

Clique no ícone MCP Servers na barra lateral do Cline, depois "Edit Configuration".

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "server-odoo": {
      "command": "uvx",
      "args": [
        "mcp-server-odoo"
      ],
      "_inferred": true
    }
  }
}

Mesmo formato do Claude Desktop. Reinicie o Windsurf para aplicar.

~/.continue/config.json

{
  "mcpServers": [
    {
      "name": "server-odoo",
      "command": "uvx",
      "args": [
        "mcp-server-odoo"
      ]
    }
  ]
}

O Continue usa um array de objetos de servidor em vez de um map.

~/.config/zed/settings.json

{
  "context_servers": {
    "server-odoo": {
      "command": {
        "path": "uvx",
        "args": [
          "mcp-server-odoo"
        ]
      }
    }
  }
}

Adicione em context_servers. Zed recarrega automaticamente ao salvar.

claude mcp add server-odoo -- uvx mcp-server-odoo

Uma linha só. Verifique com claude mcp list. Remova com claude mcp remove.

Casos de uso

Usos do mundo real: mcp-server-odoo

Answer ad-hoc sales questions against Odoo

👤 Ops managers, founders using Odoo as their source of truth ⏱ ~10 min beginner

Quando usar: 'What were last week's top 5 customers by revenue?' — without writing XML-RPC.

Pré-requisitos

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

Fluxo

List available models

list_models — which Odoo models can we query in this instance?✓ Copiado

→ Model catalog with descriptions
Run the query

In sale.order, find orders with date_order between last Monday and today, group by partner_id, sum amount_total, top 5.✓ Copiado

→ Ranked customer list with totals
Drill in

For the top customer, show the last 3 orders with their line items.✓ Copiado

→ Detailed breakdown

Resultado: A business answer from ERP data without leaving chat.

Armadilhas

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

Combine com: notion

Clean up stale CRM leads in Odoo

👤 Sales ops ⏱ ~30 min intermediate

Quando usar: Leads pile up with no activity; you want to reassign or archive.

Fluxo

Find stale leads

In crm.lead, find leads where stage_id is not 'Won' and last activity > 60 days ago.✓ Copiado

→ Stale lead list
Propose actions

Classify each: archive, reassign to team lead, or ping current owner.✓ Copiado

→ Classification per lead
Apply in batches (read-only first!)

Dry run only: show what would change if I archived the 'archive' bucket.✓ Copiado

→ Dry-run summary; then confirm before update_record

Resultado: A cleaner pipeline with auditable changes.

Armadilhas

Archiving leads other teams depend on — Always dry-run first; tag archived leads rather than delete

Draft follow-ups for unpaid invoices

👤 AR and finance ⏱ ~25 min intermediate

Quando usar: Monthly dunning run.

Fluxo

Pull overdue invoices

In account.move, find invoices where state='posted', payment_state='not_paid', invoice_date_due < today - 15.✓ Copiado

→ Overdue list with partner + amount
Draft a polite follow-up per customer

For each, draft an email in the customer's preferred language using ODOO_LOCALE settings.✓ Copiado

→ Per-invoice draft text

Resultado: Dunning emails ready to send (human still reviews).

Combinações

Combine com outros MCPs para 10× de alavancagem

server-odoo + notion

Pull a sales snapshot from Odoo, post to Notion for stakeholders

Run last-month sales by product category from Odoo, post as a Notion table under Finance / Monthly.✓ Copiado

server-odoo + postgres

Cross-reference Odoo data with a warehouse replica for heavy analytics

For top-10 Odoo customers, pull their web-session counts from the Postgres analytics DB.✓ Copiado

Ferramentas

O que este MCP expõe

Ferramenta	Entradas	Quando chamar	Custo
list_models	(none)	First-run discovery	1 XML-RPC call
search_records	model: str, domain?: filter, fields?: str[], limit?: int	Any read query	1 XML-RPC call
get_record	model, id	Known id, need full detail	1 call
create_record	model, values: object	Only with ODOO_YOLO=true or API key granting write	1 call (write)
update_record	model, id, values	Writes — confirm first	1 call (write)
delete_record	model, id	Rarely — archive is usually better	1 call (write, destructive)
list_resource_templates	(none)	Explore available resource URIs	free

Custo e limites

O que custa rodar

Cota de API: Bounded by Odoo server; no per-call cost
Tokens por chamada: Smart-field responses keep responses under 1k tokens per record
Monetário: Free; you need an Odoo instance (community or enterprise)
Dica: Always pass explicit fields= on big models like product.template to avoid pulling 200 fields.

Segurança

Permissões, segredos, alcance

Escopos mínimos: API key or user with read rights on the models you query

Armazenamento de credenciais: ODOO_API_KEY in env var; never commit to repo

Saída de dados: Calls to your Odoo instance only

Nunca conceda: ODOO_YOLO=true in production

XML-RPC is cleartext unless ODOO_URL uses https — always use https in prod.
User/password auth is supported but prefer API keys.

Solução de problemas

Erros comuns e correções

Access Denied on model

API key user doesn't have access rights for that model. Grant or switch user.

Verificar: Odoo: Settings > Users > Access Rights

Database not found

Set ODOO_DB explicitly; auto-detection fails when db listing is disabled.

Verificar: curl -d '{"jsonrpc":"2.0","method":"call","params":{"service":"db","method":"list"}}' $ODOO_URL/jsonrpc

MCP Odoo module not installed

In standard mode, install the mcp_odoo community module, or switch to ODOO_YOLO=read mode.

Verificar: Odoo: Apps > search mcp_odoo

Alternativas

mcp-server-odoo vs. outros

Alternativa	Quando usar	Troca
Direct XML-RPC via fetch MCP	You only need one specific query	No smart field selection; boilerplate-heavy
postgres MCP on Odoo's DB	You want raw SQL and can connect to the underlying Postgres	Bypasses Odoo ACLs — dangerous without care

Mais

Recursos

📖 Leia o README oficial no GitHub

🐙 Ver issues abertas

🔍 Ver todos os 400+ servidores MCP e Skills