MCP Connector for Odoo — Governed MCP Server & API Gateway for Claude, ChatGPT & AI Agents
by WebbyCrown Solutions https://webbycrown.com$ 171.84
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 6409 |
| Technical Name |
odoo_mcp_connection |
| License | LGPL-3 |
| Website | https://webbycrown.com |
| Versions | 14.0 15.0 16.0 17.0 18.0 19.0 |
+91 (942) 867-7503
Odoo MCP Connection
MCP server for Claude, ChatGPT & AI agents — governed ERP tool gateway with scoped keys, audit logs & 26 tools.
MCP gateway overview
Install Odoo MCP Connection, assign MCP Manager, then open
Odoo MCP Connection → API Keys → create a key → copy the bearer token → point your MCP client at
https://your-odoo/mcp?db=your_database.
What this module adds
A full-stack MCP JSON-RPC 2.0 gateway on standard Odoo:
POST /mcp with scoped API keys, app/module access,
per-model CRUD, field allowlists & domain filters,
token rotation with grace period, IP allow/deny, audit logs,
rate limiting (memory + optional Redis), schema cache,
26 MCP tools (CRUD, BI, batch, async jobs, module builder, portal pages),
OAuth clients → POST /mcp/oauth/token, public pages at
/mcp-page/<slug>, Generated Modules UI, API Console on key forms,
and a dedicated MCP Server application menu — all respecting Odoo ACLs and record rules.
Core capabilities
| Protocol: initialize, tools/list, tools/call, ping on POST /mcp | CRUD: search, get, create, update, delete + list_models + describe_model |
| BI: pivot, timeseries, topn, cohort, funnel, export_dataset (CSV/XLSX) | Batch: batch_search/create/update/delete; async bulk jobs with status APIs |
| Builder: generate_module_spec, build_module_zip, install_module_zip, create_portal_page | Security: API keys, model/module access, token history, IP lists, audit retention cron |
| Multi-DB: ?db= or X-Odoo-Database; auth=none routes bind DB from token or client_id | Endpoints: /mcp, /mcp/health, /mcp-page/<slug>, /mcp/oauth/token |
Depends: base, base_setup, mail, web · LGPL-3 · Demo data on install |
|
Technical highlights
| 26 MCP tools — core, BI, batch, async, builder |
| Role ladder: MCP User → MCP Manager (+ Settings Admin implied) |
| aggregate_records for server-side metrics without raw exports |
| Optional Redis for shared rate limits & schema cache across workers |
| Independent open-source · not affiliated with KSRO Labs |
Key benefits
- AI-ready ERP access: Connect Claude, Cursor, ChatGPT, and any MCP client to live Odoo records through one governed endpoint.
- Security by design: Scoped keys, model CRUD, field allowlists, domains, IP rules, rotation, and full audit trail — inside Odoo ACLs.
- Beyond CRUD: Pivot, cohort, funnel, timeseries, exports, batch ops, and async jobs for analytics and heavy workloads.
- Operator-friendly: Dedicated MCP app menu, API Console on keys, in-app Help, and Settings for Redis, limits, and retention.
- Extensible automation: Portal page builder, module ZIP generator/installer, and OAuth clients for integrated auth flows.
Menus, tools & main features
API Keys & API Console
- Create scoped bearer tokens with per-key model access, module access, field allowlists, and domain filters.
- Token rotation with grace period; token history for safe rollover.
- API Console on the key form — copy MCP endpoint URL (includes
?db=) and authorization header.
26 MCP tools
Full JSON-RPC tool gateway
26 MCP tools
Core · BI · Batch & async · Builder — one POST /mcp endpoint
|
8
Core
|
6
BI
|
8
Batch
|
4
Builder
|
- Core (8): search_records, get_record, create_record, update_record, delete_record, list_models, describe_model, aggregate_records.
- BI (6): pivot, timeseries, topn, cohort, funnel, export_dataset.
- Batch & async (8): batch_search/create/update/delete, submit_job, get_job_status, get_job_result, cancel_job.
- Builder (4): generate_module_spec, build_module_zip, install_module_zip, create_portal_page.
OAuth, portal & generated modules
- OAuth Clients — configure clients; exchange tokens via
POST /mcp/oauth/token. - Portal Pages — publish dashboards at
/mcp-page/<slug>(demo:demo-contacts). - Generated Modules — specs and ZIP builds from MCP builder tools; install from the UI.
Bulk jobs, audit & settings
- Bulk Jobs — track async MCP job queue (pending, done, failed) from the backend.
- Audit Logs — every tool call logged; retention cron; MCP User read-only on own entries.
- Settings → Odoo MCP Connection — Redis URL, rate limits, schema cache, audit retention.
- Help — in-app MCP documentation for operators and integrators.
MCP Server application menu
- API Keys · OAuth Clients · Portal Pages
- Generated Modules · Bulk Jobs · Audit Logs · Help
- Settings administrators automatically inherit MCP Manager via
base.group_system.
Feature parity checklist
| Feature | Status |
|---|---|
| POST /mcp JSON-RPC (initialize, tools/list, tools/call, ping) | ✓ |
| Core CRUD + list_models + describe_model + aggregate_records | ✓ |
| BI + export_dataset + batch + async jobs | ✓ |
| Portal pages, module builder, OAuth, API Console | ✓ |
| API keys, module access, rotation, IP lists, audit, Redis | ✓ |
| Demo data: keys, OAuth, portal, ZIP module, jobs, audit samples | ✓ |
HTTP endpoints
| POST /mcp | MCP JSON-RPC 2.0 |
| GET /mcp/health | Health check |
| GET /mcp-page/<slug> | Public portal dashboards |
| POST /mcp/oauth/token | OAuth-style token exchange |
FAQs
Who should use Odoo MCP Connection?
Teams connecting AI assistants (Claude, ChatGPT, Cursor, custom agents) to Odoo for automation, reporting, and integrations — with governance suitable for production ERP data.
How do multi-database instances work?
Include ?db=your_database on every MCP URL, or send the X-Odoo-Database header. Routes use auth='none' and resolve the database from ?db=, client_id, or the bearer token — no Odoo web session required.
Do I need Redis?
No — in-memory rate limits and schema cache work out of the box. Enable Redis under Settings when you run multiple workers and need shared limits and cache across processes.
Is demo data included?
Yes — demo API keys, OAuth client mcp_demo_client_001, portal page /mcp-page/demo-contacts, generated module ZIP, bulk jobs, and sample audit logs ship with the module for training and integration testing.
Quick start
- Add addons path → Update Apps list → Install Odoo MCP Connection.
- Assign MCP Manager (Settings administrators receive it automatically).
- Odoo MCP Connection → API Keys → Create → Copy bearer token.
- Configure MCP client:
https://your-odoo.example.com/mcp?db=your_databasewithAuthorization: Bearer <token>.
Explore our other addons
Contact & support
Questions?
Sales: +91 (942) 867-7503
Please log in to comment on this module