Odoo Connect MCP
Provides read-only access to an Odoo instance across enabled apps such as CRM, Sales, and Inventory, allowing the AI to look up and analyze business data like sales, opportunities, stock levels, and invoices while respecting per-app access controls.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Odoo Connect MCP Show me this month's confirmed sales, broken down by salesperson"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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 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 setupA page opens in your browser.
2. Fill in the page
Connection: your Odoo address, your email and an API key. The page explains how to create the key (detailed guide).
Access: for each installed app (CRM, Sales, Inventory…), pick None or Read. Sensitive apps (Accounting, Payroll, Employees, Messages) are off by default.
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.jsonon 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 doctorMessage | 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 |
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 setupLayout: 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 toolsaggregate_recordsTotals and groupsARead-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 connectionARead-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 recordsCRead-onlyIdempotent
Counts records matching a domain.
Inputs: model (required), domain.
describe_modelDescribe a modelARead-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 startedARead-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 appsARead-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 appARead-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 IDCRead-onlyIdempotent
Reads specific records by their IDs.
Inputs: ids (required), model (required), fields.
search_recordsSearch recordsARead-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
Scored across 9 tools
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.
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.
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.
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
Related MCP Connectors
Read, write and run Odoo actions from any AI app, as each user, with approval rules per colleague.
Connect any AI assistant to Odoo 16–19 via OAuth 2.0 + PKCE. 400 free calls, no local install.
Odoo MCP connector for ChatGPT and Claude: ask sales, invoices and stock in plain words. Read-only.
Odoo ERP for AI agents: hosted OAuth endpoint, gated writes, one endpoint for every instance.
Related MCP Servers
- AlicenseBqualityDmaintenanceEnables AI assistants to control any Odoo database via XML-RPC, with features for reading, writing, importing/exporting data, and generating intervention reports.32MIT
- FlicenseNot gradedqualityCmaintenanceEnables 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.-
- FlicenseNot gradedqualityCmaintenanceEnables 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.-
- FlicenseNot gradedqualityCmaintenanceEnables AI assistants to securely access and perform CRUD operations on Odoo data through natural language, with granular permissions and dual REST/XML-RPC support.-