Skip to main content
Glama
Odoo Connect MCP

Odoo Connect MCP

by Tristan439

Odoo Connect MCP

Talk to your Odoo from Claude, ChatGPT or any MCP-compatible AI. You choose exactly what the AI can see, app by app. Your key stays on your computer.

Version française

🧪 Version 0.1: read-only. The AI can look up and analyze your Odoo, but cannot change it yet.


Setup in 3 steps (5 minutes)

You need: Node.js (the "LTS" button) and your Odoo (Online, Odoo.sh or self-hosted, version 16 to 19).

1. Start the setup

Open a terminal (Mac: Terminal app · Windows: PowerShell) and paste:

npx -y odoo-connect-mcp setup

A page opens in your browser.

2. Fill in the page

  1. Connection: your Odoo address, your email and an API key. The page explains how to create the key (detailed guide).

  2. Access: for each installed app (CRM, Sales, Inventory…), pick None or Read. Sensitive apps (Accounting, Payroll, Employees, Messages) are off by default.

  3. Connect your AI: click Set up Claude Desktop, or copy the command for Claude Code.

3. Restart your AI and ask

"What can you see in my Odoo?"

That's it. 🎉

🤖 Prefer to be guided by your AI?

Paste the content of SETUP-PROMPT.md into Claude or ChatGPT: it walks you through one step at a time.


Related MCP server: MCP Server for Odoo

Example questions

  • "Confirmed sales this month, by salesperson"

  • "Which opportunities have no planned activity?"

  • "Which products are out of stock?"

  • "Find the farm in Cookshire that asked for a quote"

Built-in prompts (the "/" or "+" menu of your AI): sales summary, follow-ups, low stock, overdue invoices.

Changing access

Run npx -y odoo-connect-mcp setup again, change, save, then restart your AI. The AI can never change its own access.

Security

  • Closed by default: sensitive apps are off, and technical models (ir.*, users, groups, settings) are never reachable.

  • Never more than Odoo allows: the AI has at most your Odoo user's rights. The page can only reduce them.

  • Enforced server-side: an app set to "None" is refused, even through a related field (e.g. employee_id.name).

  • Your key stays with you: stored in a file only you can read (~/.config/odoo-mcp/config.json, or %APPDATA%\odoo-mcp\config.json on Windows). Nothing is sent anywhere except your Odoo.

  • Tip: create an API key just for the AI, with an expiry date. You can revoke it any time in Odoo.

Troubleshooting

npx -y odoo-connect-mcp doctor

Message

Fix

"Odoo refused the login"

Check the email and key. If the key expired, create a new one.

"Cannot reach…"

Copy the exact address from your browser.

"several databases"

Enter the database name under Advanced options.

The AI doesn't see Odoo

Fully quit the AI app (not just the window) and open it again.

"Access not allowed"

That's your access setting: run setup again to open it.

Roadmap

  • 0.1: read access, per-app access page, automatic Claude Desktop/Code setup, Odoo 16–19

  • 0.2: changes with confirmation ("Read + Edit"), per-model settings, hidden fields, "only my records", one-click Claude Desktop install (.mcpb)

  • 0.3: web version for ChatGPT and claude.ai ("Deploy to Cloudflare" button, Docker)

  • 0.4: business prompts, guides with screenshots

Developers

git clone <this repo> && cd odoo-mcp && npm install
npm test                    # tests against a simulated Odoo (JSON-RPC 17 and JSON-2 19)
node bin/odoo-connect-mcp.js setup

Layout: src/odoo.js (Odoo client), src/apps.js (app catalogue), src/access.js (access rules), src/server.js (MCP tools), src/setup/ (setup page).

Environment variables (ODOO_URL, ODOO_DB, ODOO_USER, ODOO_API_KEY, ODOO_MCP_LANG, ODOO_MCP_CONFIG) override the config file.

MIT License.

Available Tools

9 tools
aggregate_recordsTotals and groupsA
Read-onlyIdempotent

Computes totals/averages/counts grouped by fields (like a pivot table). Example: model "sale.order", group_by ["user_id"], measures ["amount_total:sum"]. Dates can be grouped with ":day", ":week", ":month", ":quarter", ":year".

Inputs: model (required), group_by (required), limit, domain, +1 more.

check_connectionCheck Odoo connectionA
Read-onlyIdempotent

Tests the connection to Odoo and explains any problem in plain words. Use it first when something fails.

Inputs: no named parameters.

count_recordsCount recordsC
Read-onlyIdempotent

Counts records matching a domain.

Inputs: model (required), domain.

describe_modelDescribe a modelA
Read-onlyIdempotent

Lists the fields of a model with their label, type and related model. Call this before searching a model you have not used yet.

Inputs: model (required).

getting_startedGetting startedA
Read-onlyIdempotent

Explains what you can ask about this Odoo given the access the user granted, with example questions. Use when the user asks what you can do.

Inputs: no named parameters.

list_appsList appsA
Read-onlyIdempotent

Lists the Odoo apps, whether they are installed, and the access level the user granted for each (none/read).

Inputs: no named parameters.

list_modelsList models of an appA
Read-onlyIdempotent

Lists the technical models (tables) you may read in an app, e.g. app="sales" → sale.order, sale.order.line.

Inputs: app (required).

read_recordsRead records by IDC
Read-onlyIdempotent

Reads specific records by their IDs.

Inputs: ids (required), model (required), fields.

search_recordsSearch recordsA
Read-onlyIdempotent

Searches records of a model with an Odoo domain and returns their fields. Returns total count and has_more for pagination.

Inputs: model (required), limit, order, domain, +2 more.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A3.7/5.0

    Scored across 9 tools

    Disambiguation4/5

    Most tools are clearly distinct across discovery, schema inspection, and record querying. The only mild overlap is between getting_started and list_apps/list_models, since all three help explain what access and data are available.

    Naming Consistency4/5

    Names are consistently snake_case and mostly follow a verb_noun pattern such as list_apps, describe_model, search_records, and count_records. getting_started is a reasonable onboarding name but breaks the otherwise predictable verb_noun convention.

    Tool Count5/5

    Nine tools is well-scoped for a read-only Odoo connector, with each tool earning its place. The set covers diagnostics, onboarding, discovery, schema inspection, and querying without unnecessary bloat.

    Completeness5/5

    For the apparent read-only domain, the surface is complete: it covers connection checks, app/model/field discovery, searching, reading, counting, and aggregating records. Pagination and access-level reporting are also included, leaving no obvious dead ends.

    Maintenance

    ActivityMaintained
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      B
      quality
      D
      maintenance
      Enables AI assistants to control any Odoo database via XML-RPC, with features for reading, writing, importing/exporting data, and generating intervention reports.
      32
      MIT
    • F
      license
      Not graded
      quality
      C
      maintenance
      Enables AI assistants to securely access and interact with Odoo data through natural language, supporting full CRUD operations, OAuth 2.1 and API key authentication, and granular per-model permissions.
      -
    • F
      license
      Not graded
      quality
      C
      maintenance
      Enables AI assistants to securely connect to Odoo and perform CRUD operations, custom tool calls, and data queries through natural language, with OAuth 2.1 and API key authentication.
      -
    • F
      license
      Not graded
      quality
      C
      maintenance
      Enables AI assistants to securely access and perform CRUD operations on Odoo data through natural language, with granular permissions and dual REST/XML-RPC support.
      -