Connector guide5-minute read11 MCP tools7 languages

How to Connect Odoo 14-18 (JSON-RPC) to Microsoft Copilot — via MCP

Odoo ERP 14 to 18 over the classic JSON-RPC endpoint: search, read, create and update any model, plus partners, sales orders, invoices and products. For Odoo Online, Odoo.sh and self-hosted Odoo older than 19 (works on 19 too). API key + user id.

Odoo 17, 18 or 19, self-hosted or on Odoo.sh? Install the AnythingMCP module from the Odoo Apps Store: from Odoo's Settings it opens the API key dialog and starts the setup with your Odoo address and database filled in.

HCBy HelpCode teamUpdated 5 min read Open-source on GitHub

No credit card · 7-day trial · Self-host alternative available

Odoo 14-18 (JSON-RPC)

Odoo ERP 14 to 18 over the classic JSON-RPC endpoint: search, read, create and update any model, plus partners, sales orders, invoices and products. For Odoo Online, Odoo.sh and self-hosted Odoo older than 19 (works on 19 too). API key + user id.

tools

11

Region

INTL

Category

ERP

Authentication

API credentials

Required env vars

ODOO_URLODOO_DBODOO_UIDODOO_API_KEY
Install in one click on Cloud

7-day free trial · No credit card

  • 7-day free trial
    No credit card required
  • GDPR & SOC 2 ready
    EU data residency, audit logs
  • Open-source on GitHub
    Open source · AGPL-3.0
  • Works with ChatGPT, Claude, Gemini
    Any MCP-compatible client

Skip the install. Get this working in under 2 minutes.

Start a free trial on cloud.anythingmcp.com, add the Odoo 14-18 (JSON-RPC) in one click, then point your AI client (Claude, ChatGPT, Copilot or Cursor) at the generated MCP endpoint. No Docker, no git clone, zero engineering experience required.

Start free trial

Summary

Odoo ERP 14 to 18 over the classic JSON-RPC endpoint: search, read, create and update any model, plus partners, sales orders, invoices and products. For Odoo Online, Odoo.sh and self-hosted Odoo older than 19 (works on 19 too). API key + user id.

Try asking

Example prompts for Odoo 14-18 (JSON-RPC)

Click any prompt to copy it. Paste into Claude, ChatGPT, Cursor, Gemini, Copilot or OpenClaw to run it against this connector.

Odoo 14-18 (JSON-RPC) · live via MCP
Share
Opus 4.7

Claude is AI and can make mistakes. Please double-check responses.

💡 No install? Use cloud.anythingmcp.com directly. Sign in, click Connectors → Odoo 14-18 (JSON-RPC), paste your credentials, mint an MCP API key — done. No Docker, no git clone, no local server.

Odoo 14-18 (JSON-RPC) + Microsoft Copilot

Odoo ERP 14 to 18 over the classic JSON-RPC endpoint: search, read, create and update any model, plus partners, sales orders, invoices and products. For Odoo Online, Odoo.sh and self-hosted Odoo older than 19 (works on 19 too). API key + user id.

Prerequisites

See the full setup instructions baked into the connector (visible in the in-app store when you select the connector). The required environment variables for this connector are:

ODOO_URL, ODOO_DB, ODOO_UID, ODOO_API_KEY

Step 1 — Get credentials

Which Odoo connector? This one is for Odoo 14 to 18 (and works on 19 too). It talks to Odoo's classic JSON-RPC endpoint /jsonrpc. For Odoo 19 and newer, the "Odoo" connector (JSON-2 API) is the simpler choice: it needs no user id. Your version is shown at the bottom of Settings.

What you need (four values)

  1. ODOO_URL: the address of your Odoo, scheme and host only, e.g. https://erp.example.com or https://mycompany.odoo.com. Not the address of a page inside Odoo: nothing after the host, no /web, no ?db= or #action=.

…(continued in the in-app connector instructions)

Step 2 — Install the adapter

curl -fsSL https://raw.githubusercontent.com/HelpCode-ai/anythingmcp/main/docker-compose.quickstart.yml -o docker-compose.yml
printf 'JWT_SECRET=%s\nENCRYPTION_KEY=%s\n' "$(openssl rand -hex 32)" "$(openssl rand -hex 32)" > .env
docker compose up -d

Step 3 — Add the connector in Microsoft Copilot

Your server URL: in AnythingMCP, open MCP Servers → the server this connector is on, and copy its URL (https://cloud.anythingmcp.com/mcp/…). Use it wherever this guide shows YOUR_SERVER_ID.

Microsoft Copilot uses MCP servers through agents built in Copilot Studio: you add AnythingMCP to an agent as a tool, then publish the agent to Microsoft 365 Copilot and Teams. Copilot Studio connects from Microsoft's cloud over Streamable HTTP, which AnythingMCP supports.

  1. In Copilot Studio, open your agent (or create one), go to Tools and choose Add a tool → New tool → Model Context Protocol.
  2. Enter a Server name (for example AnythingMCP), a Server description that says what the connector does, and the Server URL https://cloud.anythingmcp.com/mcp/YOUR_SERVER_ID. Copilot Studio uses the description to decide when to call the server.
  3. Under authentication, choose API key, set Type to Header and the header name to X-API-Key, then select Create.
  4. In Add tool, choose Create a new connection, paste an MCP API key from AnythingMCP (MCP Servers → your server → API keys) and select Add to agent.
  5. Try it in the agent's Test pane: ask for something that needs the Odoo 14-18 (JSON-RPC) tools.
  6. Select Publish, then Channels → Microsoft 365 and Microsoft Teams, keep Make agent available in Microsoft Copilot selected and choose Add channel. See agent in Teams installs it for you; in Microsoft 365 Copilot, type @ and pick the agent.

Prefer per-user sign-in? Choose OAuth 2.0 → Dynamic discovery instead of an API key: each user then signs in to AnythingMCP the first time the agent calls it.

Self-hosting? Use your instance's public HTTPS address instead of https://cloud.anythingmcp.com. Copilot Studio connects from Microsoft's cloud, so localhost does not work.

Available tools

ToolWhat it does
odoo_search_readSearch and read any Odoo model in one call
odoo_readRead specific records of a model by their ids — the follow-up call when a search has returned ids and you now want the detail of a few of…
odoo_search_countCount the records of a model matching a domain, without transferring them
odoo_fields_getDescribe a model's fields: name, type, label, whether it is required or readonly, and the related model for relational fields
odoo_list_partnersList partners — Odoo's customers, suppliers and contacts — with name, e-mail, phone, city and country
odoo_list_sale_ordersList sales orders with their customer, date, state and total
odoo_list_invoicesList customer invoices and vendor bills with their partner, date, due date, state and residual amount — the answer to 'what is still unpaid'
odoo_list_productsList products with their internal reference, sale price, cost, product type and unit of measure
odoo_createCreate a record in any Odoo model and return its id
odoo_writeUpdate existing records in any Odoo model
odoo_call_methodCall a public method on an Odoo model: the escape hatch for workflow actions such as action_confirm on a sale order, action_post on an…

FAQ

Which Copilot is this for? Microsoft 365 Copilot at work, through agents built in Copilot Studio. The Microsoft Copilot app for personal accounts has no option to add your own MCP server.

What do I need? A work account with access to Copilot Studio (a license or a trial) to build the agent. People who use it in Microsoft 365 Copilot or Teams need access to the agent: share it with them, or ask an admin to publish it to the organization. If your organization applies data policies to Power Platform connectors, they cover MCP servers too.

The agent doesn't call the tools. Check that the header name is exactly X-API-Key and that the key belongs to the same MCP server as the URL, and make the server description specific: Copilot Studio uses it to decide when to call the server. Publish the agent again after each change; in an open chat, type "start over" to get the new version.

Next steps

Was this guide helpful?

Your Odoo 14-18 agent is one click away.

Install the connector, paste the key, prompt Microsoft Copilot. Free for 7 days, no credit card.

Related guides

OJ
Connectors

How to Connect Odoo 14-18 (JSON-RPC) to Meta Muse — via MCP

Odoo ERP 14 to 18 over the classic JSON-RPC endpoint: search, read, create and update any model, plus partners, sales orders, invoices and products. For Odoo Online, Odoo.sh and self-hosted Odoo older than 19 (works on 19 too). API key + user id.

OJ
Connectors

How to Connect Odoo 14-18 (JSON-RPC) to ChatGPT — via MCP

Odoo ERP 14 to 18 over the classic JSON-RPC endpoint: search, read, create and update any model, plus partners, sales orders, invoices and products. For Odoo Online, Odoo.sh and self-hosted Odoo older than 19 (works on 19 too). API key + user id.

OJ
Connectors

How to Connect Odoo 14-18 (JSON-RPC) to Claude — via MCP

Odoo ERP 14 to 18 over the classic JSON-RPC endpoint: search, read, create and update any model, plus partners, sales orders, invoices and products. For Odoo Online, Odoo.sh and self-hosted Odoo older than 19 (works on 19 too). API key + user id.

OJ
Connectors

How to Connect Odoo 14-18 (JSON-RPC) to Cursor — via MCP

Odoo ERP 14 to 18 over the classic JSON-RPC endpoint: search, read, create and update any model, plus partners, sales orders, invoices and products. For Odoo Online, Odoo.sh and self-hosted Odoo older than 19 (works on 19 too). API key + user id.

OJ
Connectors

How to Connect Odoo 14-18 (JSON-RPC) to Gemini — via MCP

Odoo ERP 14 to 18 over the classic JSON-RPC endpoint: search, read, create and update any model, plus partners, sales orders, invoices and products. For Odoo Online, Odoo.sh and self-hosted Odoo older than 19 (works on 19 too). API key + user id.

OJ
Connectors

Odoo 14-18 (JSON-RPC) to MCP — Drive Odoo 14-18 (JSON-RPC) from any AI Agent

Odoo ERP 14 to 18 over the classic JSON-RPC endpoint: search, read, create and update any model, plus partners, sales orders, invoices and products. For Odoo Online, Odoo.sh and self-hosted Odoo older than 19 (works on 19 too). API key + user id.