mcp-server-odoo MCP — 使用場景, 安裝 & 即時演示

為什麼要用

核心特性

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

即時演示

實際使用效果

server-odoo.replay ▶ 就緒

0/0

安裝

選擇你的客戶端

~/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
    }
  }
}

開啟 Claude Desktop → Settings → Developer → Edit Config。儲存後重啟應用。

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

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

Cursor 使用與 Claude Desktop 相同的 mcpServers 格式。專案級設定優先於全域。

VS Code → Cline → MCP Servers → Edit

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

點擊 Cline 側欄中的 MCP Servers 圖示，然後選 "Edit Configuration"。

~/.codeium/windsurf/mcp_config.json

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

格式與 Claude Desktop 相同。重啟 Windsurf 生效。

~/.continue/config.json

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

Continue 使用伺服器物件陣列，而非映射。

~/.config/zed/settings.json

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

加入 context_servers。Zed 儲存後熱重載。

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

一行命令搞定。用 claude mcp list 驗證，claude mcp remove 移除。

使用場景

實戰用法： mcp-server-odoo

Answer ad-hoc sales questions against Odoo

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

何時使用： '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 models

list_models — which Odoo models can we query in this instance?✓ 已複製

→ 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.✓ 已複製

→ Ranked customer list with totals
Drill in

For 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

搭配使用： notion

Clean up stale CRM leads in Odoo

👤 Sales ops ⏱ ~30 min intermediate

何時使用： Leads pile up with no activity; you want to reassign or archive.

步驟

Find stale leads

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

→ Stale lead list
Propose actions

Classify each: archive, reassign to team lead, or ping current owner.✓ 已複製

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

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

→ Dry-run summary; then confirm before update_record

結果： A cleaner pipeline with auditable changes.

注意事項

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

何時使用： Monthly dunning run.

步驟

Pull overdue invoices

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

→ 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.✓ 已複製

→ Per-invoice draft text

結果： Dunning emails ready to send (human still reviews).

組合

與其他 MCP 搭配，撬動十倍槓桿

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.✓ 已複製

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.✓ 已複製

工具

此 MCP 暴露的能力

工具	輸入參數	何時呼叫	成本
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

成本與限制

運行它的成本

API 配額: Bounded by Odoo server; no per-call cost
每次呼叫 Token 數: Smart-field responses keep responses under 1k tokens per record
費用: Free; you need an Odoo instance (community or enterprise)
提示: Always pass explicit fields= on big models like product.template to avoid pulling 200 fields.

安全

權限、密鑰、影響範圍

最小權限： API key or user with read rights on the models you query

憑證儲存： ODOO_API_KEY in env var; never commit to repo

資料出站： Calls to your Odoo instance only

切勿授予： 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.

故障排查

常見錯誤與修復

Access Denied on model

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

驗證： Odoo: Settings > Users > Access Rights

Database not found

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

驗證： 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.

驗證： Odoo: Apps > search mcp_odoo

替代方案

mcp-server-odoo 對比其他方案

替代方案	何時用它替代	權衡
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

mcp-server-odoo

為什麼要用

核心特性

即時演示

實際使用效果

安裝

選擇你的客戶端

使用場景

實戰用法： mcp-server-odoo

Answer ad-hoc sales questions against Odoo

前置條件

步驟

注意事項

Clean up stale CRM leads in Odoo

步驟

注意事項

Draft follow-ups for unpaid invoices

步驟

組合

與其他 MCP 搭配，撬動十倍槓桿

工具

此 MCP 暴露的能力

成本與限制

運行它的成本

安全

權限、密鑰、影響範圍

故障排查

常見錯誤與修復

替代方案

mcp-server-odoo 對比其他方案

更多

資源