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와 조합해 10배 효율

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
호출당 토큰: 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