Odoo MCP Studio — More Than Just MCP Server- Build Modules · Create Live Dashboards · Connect Claude, ChatGPT & AI Agents
by KSRO labs https://ksrolabs.com$ 229.52
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 6772 |
| Technical Name |
mcp_server_odoo |
| License | LGPL-3 |
| Website | https://ksrolabs.com |
| Versions | 14.0 15.0 16.0 17.0 18.0 19.0 |
MCP Server for Odoo - Connect Claude, ChatGPT & AI agents to live ERP data Connect Claude/ChatGPT to Odoo - securely
Turn Odoo into an AI tool server. Connect Claude/ChatGPT (and any MCP client) to live ERP data - with scoped keys and audit logs.
Expose one stable endpoint (/mcp) with scoped API keys, permission enforcement, validation, and audit logs. Your AI can read/write Sales, CRM, Accounting, Inventory, and custom models - then generate dashboards, portal pages, exports, and even installable Odoo modules (least privilege by default).
Ideal for
Built for teams who need secure, governed AI access to Odoo without building a custom API from scratch.
Ship AI-to-Odoo integrations quickly with a standard MCP endpoint.
Enforce governance, auditability, and least-privilege access.
Connect Claude, ChatGPT, and n8n to live Odoo data safely.
Product Tour: Portal Pages, Menus & Module Builder
These are the features customers buy MCP for: shareable portals, BI-ready outputs, and AI-driven module generation — all governed by scoped keys, rate limits, and audit logs.
Public pages from live Odoo data
Click to open full size
Dedicated MCP menu (not just Settings)
Click to open full size
Generate installable Odoo modules (ZIP)
Click to open full size
What this module does
MCP Server for Odoo exposes a single, stable endpoint (POST /mcp) that turns your Odoo instance into a tool server for AI agents. MCP-capable clients (Claude Desktop, ChatGPT, Gemini, n8n, LangChain, crewAI, AutoGen, and more) can interact with real Odoo data without custom API development, without bypassing security, and without embedding AI inside Odoo itself.
What You Can Build with MCP + Odoo
Turn Odoo into an AI-ready tool server. Connect Claude, ChatGPT, Gemini, Cursor/Claude Code, n8n, LangChain, crewAI (and more) to live Odoo data — with governance and audit logs.
Dashboards inside Odoo
Generate KPI tiles, tables, and interactive ECharts visuals — with filters and drill-down to Odoo records.
Public pages from live Odoo data
Create shareable portal pages that render server-side and stay always up-to-date (KPIs, charts, tables).
Pivot, time-series, funnel, cohort
Opinionated helpers for analytics queries that people actually buy MCP for: pivot, timeseries, top-N, cohort, funnel, and export.
Automations that respect ACLs
Create/update records via scoped keys, run batch operations, and offload heavy work to async background jobs.
Generate installable Odoo modules
Build a validated module spec, generate a ZIP, and install (or download) — including models, security, menus, and views.
Standalone dashboards & portals
Build shipping schedules, executive dashboards, or customer portals outside Odoo — backed by live ERP data through one MCP endpoint.
Visualize Odoo Data with AI — Generate Charts in Claude or Cursor and sync with your Odoo for better insight.
💡 Instantly save dashboards inside Odoo using the companion BI app (MCP Analytics).
You Get:
- Real-Time Charts — Pie, bar, line, heatmap. Built automatically from your data.
- Drill-Down Capability — Click a region, see details. Interactive exploration.
- Auto-Refresh — Always shows live Odoo data. No stale reports.
- Save to Odoo — Dashboards stored inside your instance. Pin to your workspace.
- Zero Coding — No SQL. No BI tool. Just ask Claude.
Ready to Unlock AI-Powered Odoo?
Don’t just install the module — implement it correctly with expert guidance. Email us now and we’ll personally help you configure, secure, and deploy your MCP Server properly.
🌐 https://ksrolabs.com
Enterprise Features, Security & Performance
Built for high-scale production deployments with comprehensive security governance, enterprise-grade performance, and horizontal scalability across unlimited workers.
⚡ Distributed Rate Limiting
- Redis-backed with in-memory fallback
- Per-second & per-minute configurable
- Per-key overrides for trusted clients
- 200+ req/sec throughput
🔄 Token Rotation
- Zero-downtime key rotation
- Multiple active tokens per key
- Configurable grace periods (7 days)
- Auto expiration notifications
💾 Schema Caching
- 5-minute intelligent cache
- 96% faster: 2ms vs 50ms
- Auto-invalidates on changes
- 4x throughput boost
✓ Core Capabilities
- MCP-standard JSON-RPC endpoint
- Full CRUD operations (create, read, update, delete)
- Model discovery & field metadata (cached)
- Domain-based and ID-based queries
- Batch requests for multi-call workflows
- Horizontal scalability (1 to 100+ workers)
🛡️ Security & Governance
- Multi-layer: Per-key scopes + Odoo ACLs + record rules
- Field allowlists & domain filters (least privilege)
- Distributed rate limiting (200+ req/sec)
- Full audit logs with payload capture
- IP allow/deny lists per key
- Automatic token expiration with notifications
📈 Scalability
- Works seamlessly with 1 to 100+ workers
- Redis-backed with automatic fallback
- No session affinity required
- Multi-region deployment ready
⚡ Performance Metrics
- Cached: ~2ms (96% faster)
- Uncached: ~50-100ms baseline
- Throughput: 4x improvement
- Cache hit ratio: 80-90% typical
✅ Enterprise Guarantee: Production-ready with 4x API throughput, 96% faster requests, zero-downtime rotation, and multi-worker scalability. Tested and verified in real-world deployments.
Setup & usage
Configure once, then integrate safely with any MCP-capable client.
Setup in 6 steps
- Install the module.
- Enable Enable MCP Server in Settings.
- Grant the MCP Server Administrator group to trusted users.
- Create an API key and copy the token (shown once).
- Grant model access in Key Model Access (least privilege).
- Optional: configure IP rules, rate limits, and payload size limits.
Example MCP request
Supported tools
Tools are model-agnostic and enforce per-key scopes, field allowlists/domain filters, and Odoo ACLs/record rules.
- list_models, describe_model (cached)
- search_records, get_record
- create_record, update_record, delete_record
- aggregate_records
- batch_create, batch_update, batch_delete, batch_search
- submit_job, get_job_status, get_job_result, cancel_job
- pivot (pivot-table style results)
- timeseries (date buckets + optional gap filling)
- topn, cohort, funnel
- export_dataset (CSV/XLSX with size limits + audit)
- analytics_create_dashboard, analytics_add_widget, analytics_list_dashboards, analytics_get_dashboard_data
- create_portal_page, update_portal_page, list_portal_pages, delete_portal_page, get_portal_schema
- generate_module_spec, build_module_zip, install_module_zip
What's new in v1.3
Major new capabilities for dashboards, portals, reporting/BI, and module building — plus production-grade performance.
- ✓ Portal Pages - public URLs at /mcp-page/<slug> (KPIs, charts, tables)
- ✓ Module Builder - generate validated specs + installable ZIP modules
- ✓ Reporting/BI tools - pivot, timeseries, topn, cohort, funnel
- ✓ Server-side exports - export_dataset (CSV/XLSX) with size limits + audit
- ✓ Bulk operations - batch tools + async background jobs
- ✓ Distributed rate limiting via Redis with fallback
- ✓ Schema caching - faster tool discovery & metadata
- ✓ Zero-downtime token rotation with grace periods
Deployment & Performance
Designed from the ground up for production use with horizontal scalability and observability.
Horizontal scalability
- Works with 1 worker, 10 workers, or 100+ workers
- Redis-backed distributed rate limiting (no coordination needed)
- Shared cache for model schemas across all workers
- No session affinity or sticky sessions required
- Automatic fallback if Redis unavailable
Performance benchmarks
- Cached requests: ~2ms (96% faster)
- Uncached requests: ~50-100ms (standard)
- Throughput: 4x improvement with caching
- Cache hit ratio: 80-90% typical
- Latency percentiles: p50: 3ms, p95: 25ms, p99: 80ms
Capabilities
Built for secure AI connectivity with governance, least privilege, and predictable tooling.
Core capabilities
- MCP-style JSON-RPC endpoint for tool discovery and execution
- CRUD tools for controlled read/write operations
- Model discovery & description for agent planning
- Reporting/BI helpers (pivot, timeseries, top-N, cohort, funnel, export)
- Portal pages at /mcp-page/<slug> (KPIs, charts, tables)
- Module Builder for validated specs + installable ZIP modules
- Batch & async tools for efficient multi-call flows and long-running jobs
Valuable safeguards
- Per-key scopes and standard Odoo ACLs/record rules
- Field allowlists and domain filters for least privilege
- Distributed rate limits with Redis backing (or in-memory fallback)
- Token rotation with zero-downtime grace periods
- Schema caching with automatic invalidation
- Audit logs with optional payload capture and retention policy
Connect multiple LLMs and agent frameworks: Claude, ChatGPT, Gemini, custom LLMs, LangChain, and crewAI.
How It Looks
A clean admin interface for configuring keys, managing access, and monitoring API usage — available via a dedicated MCP menu (recommended for non-admin operators) and also surfaced in Settings.
Admin Access & Configuration
Grant MCP Administrator permissions to authorized users. Configure via standard Odoo groups.
Click image to open full size
API Key Lifecycle
Create keys, view tokens, rotate safely with grace periods. Full version tracking.
Click image to open full size
MCP Server Settings
Global rate limits, payload caps, and Redis configuration.
Click image to open full size
Granular Model Scopes
Restrict each key to specific models, operations, and add domain filters.
Click image to open full size
FAQ
Q: Does this bypass Odoo security?
A: No. Odoo ACLs, record rules, and groups still apply. Scopes only reduce what a key can access - they do not elevate permissions.
Q: Can I connect ChatGPT, Claude, or Gemini?
A: You can connect any MCP-capable client/agent to your Odoo instance by pointing it to the /mcp endpoint and providing the API key token.
Q: Is this module AI inside Odoo?
A: No. This is a secure integration gateway (MCP server). AI runs externally and calls approved tools through Odoo governance.
Q: Can I rotate API keys safely without downtime?
A: Yes! The module supports zero-downtime token rotation with grace periods. Old tokens continue working for a configurable duration (default 7 days) while new tokens are deployed. Automatic notifications alert you 3 days before expiration.
Q: Will this work with multiple Odoo workers or load balancers?
A: Yes! The module uses Redis-backed distributed rate limiting and caching (with automatic fallback to in-memory if Redis is unavailable). Perfect for high-availability, multi-worker deployments. No shared state issues.
Q: How much faster will the API be with caching?
A: Schema caching provides 96% faster responses on cached requests (~2ms vs ~50ms). Overall API throughput improves 4x. Cache automatically invalidates when permissions change, so you always see current access rules.
Q: Do I need Redis for this to work?
A: No. Redis is optional. The module automatically falls back to in-memory caching and rate limiting if Redis is unavailable or disabled. Works perfectly fine without it, though Redis is recommended for high-scale deployments.
Odoo AI Consultancy Partner
We're not just a tool provider—we're your Odoo AI consultancy partner. We help organizations unlock the full potential of AI within their Odoo ecosystem, from MCP Server implementation to enterprise-scale AI orchestration.
Whether you're starting your AI journey or scaling AI across departments, our team of Odoo and MCP experts will guide you through every step with strategic consulting, hands-on implementation, and ongoing support.
Our Consultancy Services
🎯 MCP Strategy & Planning
Design your Odoo AI integration strategy. Identify high-impact AI use cases, scope implementation, and plan rollout across teams.
🚀 Implementation & Setup
End-to-end MCP Server deployment. Configuration, API key scoping, security hardening, and production readiness validation.
⚡ AI Agent Customization
Build and customize AI agents (Claude, ChatGPT) for your Odoo workflows. Sales automation, CRM intelligence, finance processing, and more.
🔒 Security & Governance
Audit API key scopes, implement least-privilege access, enforce rate limiting, and establish compliance workflows for AI operations.
📊 Ongoing Support & Optimization
Performance tuning, monitoring setup, token rotation management, and team training for sustained AI-driven productivity.
We Help You Implement This – 100% FREE Setup Support
Installing the module is easy. Setting it up correctly for production AI usage is critical. We personally help you configure, secure, and deploy your MCP Server properly — at no extra cost.
What we help you with (FREE)
- Complete MCP Server configuration
- Secure API key creation with proper scopes
- Model-level least privilege setup
- Rate limiting + token rotation configuration
- Claude Desktop deployment guidance
- Connecting Claude / ChatGPT / Gemini clients properly
- Production best-practice review
We want your implementation to succeed and unlock the full AI potential of your Odoo.
Why Contact Us?
MCP is powerful — but misconfiguration can limit its capabilities. When implemented correctly, this module can:
- Enable governed AI automation inside Odoo
- Power secure AI copilots for Sales, CRM & Accounting
- Unlock cloud-based AI orchestration workflows
- Deliver enterprise-grade observability & control
See What's Possible for Your Business
These aren't hypotheticals—they're proven patterns that forward-thinking companies are deploying right now. Let's discuss how to bring them to life in your Odoo.
Schedule an AI Strategy Session
Please log in to comment on this module