Peliqan

Query and update Odoo with AI

Connect Odoo to Claude, ChatGPT, or any MCP client through Peliqan. Ask questions in plain English, get answers from a SOC 2 Type II warehouse, and write updates back to Odoo – no XML-RPC scripting, no module installs in production, no read-only compromises.

Pulling answers out of Odoo still takes too many clicks

Odoo runs your sales, accounting, inventory, and HR all in one place – but every quick question means logging in, switching modules, exporting reports, and pasting numbers into spreadsheets. Operations, finance, and CRM teams lose hours on questions Claude could answer in seconds.

Existing Odoo MCPs hit the live API

Open-source MCP repos go straight to Odoo XML-RPC - heavy queries can lock production and slow your team's CRM, ecommerce, and POS

Odoo's official MCP module costs and clutters production

Odoo's paid mcp_server module needs installation in your live database, plus per-user API key management - extra weight for what should be a simple AI integration

No cross-source joins

Combining Odoo with HubSpot, Exact Online, Google Ads, or Shopify means custom Python scripts and a separate warehouse

DIY MCP servers need ops work per database

GitHub repos require local Python, UV install, env vars, ngrok tunnels, and per-database API keys - fine for a single instance, painful for multi-company or partner setups

Query sales orders, invoices, inventory, CRM, and HR data in plain English

Write changes back - create quotes, update opportunities, post invoices, manage stock

Works with Odoo 15-19, Community + Enterprise, single or multi-database setups

SOC 2 Type II certified – enterprise-grade security

Type

Open-source modular ERP and business platform

Customers

7M+ users across 30+ core modules

Website

One MCP server. Read, write, and join across 250+ sources.

Peliqan syncs your Odoo data into a built-in Postgres warehouse, exposes it via MCP for instant AI access, and routes writebacks through Peliqan’s connector layer so your live Odoo instance stays protected from rate limits and unsafe writes.

Full read + write through MCP

Where most open-source Odoo MCPs are read-heavy with risky writes, Peliqan supports full writeback. Create quotes, post invoices, update CRM stages, manage stock, log timesheets - all from Claude, ChatGPT, or n8n. The only Odoo MCP with a cached warehouse and audited writebacks.

Cached warehouse, never the live API

Your AI queries a Postgres warehouse, not Odoo XML-RPC directly. No production locks, no slowdowns during ecommerce peaks or month-end close. Sync runs incrementally on your schedule (every 15 minutes by default).

Cross-source queries in one SQL statement

Join Odoo sales orders with HubSpot deals, Exact Online accounting, Google Ads spend, or Shopify orders in a single query. Federated via Trino, all in Peliqan's shared warehouse.

SQL + RAG on quotations and attachments

Combine structured SQL queries with semantic search across quotation PDFs, contract attachments, mail.message threads, and free-text fields. The only MCP that answers questions about both your Odoo data and your documents.

Claude + Odoo MCP
Claude + Odoo MCP
What's our open sales pipeline this quarter and which products are running low on stock for top customers?
✓ Querying odoo.crm_lead and odoo.stock_quant...

Open pipeline: €487,200 across 32 opportunities. Weighted forecast: €198,400.
4 products below reorder point with active deals attached:
  • Widget Pro - 12 in stock, 47 on quotes
  • Sensor Kit V2 - 8 in stock, 22 on quotes
  • Cable Bundle - 18 in stock, 31 on quotes...
Create a purchase order for Widget Pro - 100 units from Acme Suppliers - and update the deal stage for Nordic Tech to "Proposal sent".
✓ PO created and CRM stage updated via writeback

Key Odoo data available via MCP

Peliqan syncs Odoo models into structured warehouse tables that your AI can query directly – across CRM, sales, inventory, accounting, HR, and project modules.

Model What your AI can answer Writeback
crm.lead / crm.stageOpen pipeline, weighted forecast, stage conversion, win rates, stuck deals
sale.order / sale.order.lineSales orders, quote-to-cash velocity, revenue by product, customer mix
account.move / account.move.lineInvoices, journal entries, P&L, GL drill-down, period close, aging
res.partnerCustomers, suppliers, contacts, deal value per account, credit limits
stock.quant / stock.moveStock levels, reorder points, warehouse mix, slow-moving SKUs
purchase.orderOpen POs, supplier spend, on-time delivery, procurement cycle
project.project / project.taskProject profitability, task completion, timesheet vs estimate, milestones
hr.employee / hr.leaveHeadcount, leave balance, onboarding status, department breakdown
helpdesk.ticketOpen tickets, SLA breaches, agent load, customer satisfactionRead
ir.attachment / mail.messageQuotation PDFs, contracts, chatter threads - queryable via RAGRead

What finance teams build with Odoo MCP

sales and crm

Pipeline reviews on demand

"Summarise this week's pipeline movement in Odoo CRM, flag opportunities slipping past close date, and show me what changed since last Monday." Claude queries your Odoo warehouse and returns a clean Slack-ready summary in seconds.

Useful for: Sales managers, founders

Inventory and procurement

Reorder Agent

Build an AI agent that runs hourly, checks Odoo stock levels against reorder points and committed quotes, drafts purchase orders, and posts them for approval. Peliqan writeback creates the PO directly in Odoo.

Powered by: n8n + Peliqan MCP

Finance

Cash collection assistant

"Pull all overdue Odoo invoices over 30 days, group by customer, draft personalised reminder emails, and log a follow-up activity on each partner record." Joins account.move, res.partner, and mail.activity in one query and one writeback.

Useful for: Controllers, AR specialists

Multi-company / partner ops

Cross-database reporting

For Odoo partners and multi-company groups - ask Claude to compare gross margin, AR aging, or stock turnover across all client databases in one query. No per-database logins, no manual stitching.

Useful for: Odoo partners, group CFOs

Always-fresh copy, never the live API

Peliqan keeps a working copy of your Odoo data in a Postgres warehouse, refreshed on your schedule. AI queries the warehouse for speed and safety. When AI needs to make a change, Peliqan routes the writeback through its connector layer – never letting AI hit the live Odoo XML-RPC API directly.

AI never hits the Odoo API directly

All queries route through Peliqan's warehouse. Writebacks route through Peliqan's connector. Your live Odoo instance never sees a raw AI request.

No production locks or slowdowns

Heavy AI workloads don't compete with your CRM, ecommerce, or POS for Odoo XML-RPC throughput. The warehouse absorbs query load - even during peak ecommerce or month-end close.

Always fresh, on your schedule

Incremental syncs run as often as every 5 minutes. You decide the cadence based on how fresh your sales, finance, or operations team needs the data.

Full data, every record

Every Odoo model, every record, every database. Ready for cross-source joins, Text-to-SQL, and RAG on attached PDFs and chatter threads.

AI Clients
Claude
ChatGPT
AI Agents
MCP Protocol
Protocol Layer
Peliqan MCP Server
Query - Writeback - Cross-source joins
SQL Query
Cache Layer
Peliqan Data Warehouse
Full read-only copy - Always in sync
Postgres
Trino
SQL + RAG
ELT Sync
Source Apps
Odoo
AFAS
Salesforce
250+
Live systems stay safe - AI only queries the read-only cache

How to set up the Odoo MCP server

1

Connect Odoo in Peliqan

Click the Odoo connector in Peliqan and enter your URL, database name, and API key (or username + password). Works with Odoo Online, Odoo.sh, and self-hosted – Community or Enterprise, versions 15-19. Setup guide →

2

Select and materialize tables

Choose which Odoo models to sync – sale.order, crm.lead, account.move, stock.quant, project.task, hr.employee. Peliqan materializes them into Postgres on your schedule (default: every 15 minutes). Stay well clear of Odoo XML-RPC bottlenecks. Materializing tables →

3

Create your MCP API handler

Use Peliqan’s built-in MCP template to expose the Odoo models and operations your AI agents need. Set role-based permissions for read, write, or both – column-level masking for sensitive fields like partner emails or HR salaries supported. AI agents docs →

4

Connect Claude or ChatGPT

Run pip install mcp-server-peliqan, add your Peliqan API credentials, and start querying Odoo with natural language. Open source on  GitHub.

Peliqan vs other Odoo MCP options

There are several Odoo MCP servers out there – community-built open-source repos and Odoo’s own paid mcp_server module. Here’s how they compare to Peliqan.

 
Open-source MCP repos Odoo mcp_server module Peliqan MCP
Writeback to OdooDirect XML-RPCDirect, in-Odoo✓ Audited writeback
Cached warehouse✗ Live API✗ Live API✓ Postgres + Trino
Cross-source queries✓ 250+ sources
RAG on attachments✓ SQL + RAG combined
No module install requiredOptional✗ Required
Multi-database / multi-companyManualPer-instance✓ Automatic
HostingSelf-hostedIn-Odoo✓ EU-hosted SaaS
BI + ETL + reverse ETL✗ MCP only✗ MCP only✓ Full data platform

Enable MCP for Odoo

Learn how to enable the MCP server for Odoo in Peliqan. See how to connect AI assistants like Claude to your live Odoo CRM, sales, accounting, inventory, and HR data in just a few steps.

The full Peliqan Odoo integration

MCP is one part of what Peliqan offers for Odoo. The full integration gives you a complete data platform for ERP reporting, finance automation, and AI-powered analytics.

Connect your favourite BI tool, write data transformations in SQL or Python, and set up data quality checks – all on the same platform.

ELT connector

Full sync into built-in warehouse

MCP server

Claude, ChatGPT, n8n, Make

Text-to-SQL

Plain English financial queries

Reverse ETL

Push data back to Odoo

RAG + Graph RAG

Semantic search on documents

Data quality

SQL checks + Slack/email alerts

Your AI agents. 250+ business apps. One MCP server.

Connect Exact Online, AFAS, Salesforce, and more to any MCP client – without writing API code, managing rate limits, or sacrificing governance.

Live in minutes - pip install, paste your token, query.

Read + write - pull data and push updates back to source.

Governed by default - SOC 2 Type II · GDPR · EU-hosted.

Odoo MCP, answered

What is the Odoo MCP server?

The Odoo MCP server is a Model Context Protocol endpoint that exposes your Odoo ERP data to AI agents like Claude, ChatGPT, and Cursor. Peliqan’s Odoo MCP server lets AI query CRM, sales, accounting, inventory, and HR models in plain English, and write updates back to Odoo – without writing XML-RPC integration code or installing modules in production.

Authenticate Odoo in Peliqan with your URL, database name, and API key (or username + password), pick the models to sync, and add the Peliqan MCP endpoint to Claude Desktop, ChatGPT, Cursor, or n8n. Most teams go from Odoo authentication to first AI query in under 30 minutes. Full setup steps are in the guide above.

Yes. Peliqan works with Odoo Community and Odoo Enterprise across versions 15-19. The connector talks to Odoo’s standard external API (XML-RPC and JSON-RPC), so it doesn’t require any Odoo Enterprise-only modules. It also works on Odoo Online, Odoo.sh, and self-hosted deployments.

No. Unlike Odoo’s own paid mcp_server App Store module, Peliqan doesn’t require any module install in your live Odoo database. Authentication uses Odoo’s standard external API key system. Your production instance stays exactly as it is.

No. Peliqan caches your Odoo data in a built-in Postgres warehouse and AI queries hit the cache, not Odoo XML-RPC directly. Your CRM, ecommerce, POS, and ERP users never compete with AI for production throughput. This is a key difference from open-source MCPs like ivnvxd/mcp-server-odoo, which go straight to the live API. Sync runs incrementally on your schedule (every 15 minutes by default).

Peliqan supports both read and write. Your AI agent can query Odoo data and also create quotes, post invoices, update CRM stages, manage stock, log timesheets, and trigger other Odoo external API actions, with full audit logging. Writebacks route through Peliqan’s connector layer for safety – so AI can never accidentally lock your live database with malformed write calls.

Yes. Peliqan handles multi-company and multi-database Odoo automatically. One Peliqan workspace can sync several Odoo databases and your AI agent can query across them – perfect for Odoo partners running implementations for multiple clients, or groups with separate Odoo databases per company. No per-database API key juggling, no module reinstalls.

Peliqan is EU-hosted, SOC 2 Type II certified, and GDPR-compliant. Row-level and column-level access control let you mask or exclude sensitive fields (partner emails, HR salaries, payment details) from AI agents while still allowing operational queries. Every AI query and writeback is logged with full audit trail.

No. Peliqan includes a built-in Postgres + Trino warehouse. Your Odoo data lands there automatically – no Snowflake, BigQuery, or dbt project required. If you already have a warehouse, Peliqan can sync to it as well, so your existing BI dashboards and reporting stay intact.