Odoo AI Assistant
Model Context Protocol (MCP) server for Odoo — connect Claude, ChatGPT, Cursor, Codex & other AI agents to your Odoo data securely via API keys with granular access control.
Odoo AI Assistant turns your Odoo instance into a fully-featured Model Context Protocol (MCP) server. Any AI coding assistant that supports MCP (Claude Code, Claude Desktop, ChatGPT, Cursor, Codex CLI, OpenCode, Antigravity IDE, etc.) can connect to Odoo and perform CRUD operations, run methods, fetch reports, and more — all governed by fine-grained API key permissions.
Everything this module adds to your Odoo instance.
MCP Server (Streamable HTTP)
Full MCP v1.0 implementation over HTTP. Supports initialize, tools/list, tools/call JSON-RPC methods with Bearer token auth.
API Key Management
Generate, revoke & manage API keys per user. Set expiration dates, custom duration (1 day to 1 year), and view usage statistics in the backend.
Granular Access Control
Per-key CRUD permissions (Read, Create, Write, Delete, Execute). Whitelist allowed models, blacklist blocked models, and system-critical models (ir.model, ir.ui.view, etc.) are permanently locked.
Audit Log & Dashboard
Every MCP tool call is logged with tool name, payload, response, IP address, execution time and status. A beautiful dashboard shows usage trends at a glance.
Portal Connection Guide
Beautiful, user-friendly portal pages at /mcp/connect with ready-to-copy configuration snippets for 9+ AI tools — Claude Code, Claude Desktop, Codex CLI, Cursor, ChatGPT, OpenCode, Claude Web, Antigravity IDE & CLI.
Chatter Integration
Optionally log AI actions directly into the affected record's chatter. Every create, update, or delete is posted as a 🤖 AI Assistant notification.
Security Verification
Uses Odoo's native @check_identity decorator. Generating or revoking API keys always triggers a password prompt — both from the backend and the portal.
PDF Report Generation
AI agents can request PDF reports (invoices, sale orders, etc.) directly via the get_report_pdf tool. Returns base64-encoded PDF data.
All tools exposed to AI agents via the MCP protocol.
| Tool Name | Description | Permission |
|---|---|---|
| search_records | Search & read records from any allowed Odoo model with domain filters, field selection, limit, offset and ordering. | read |
| create_record | Create a new record in any allowed Odoo model with specified field values. | create |
| update_record | Update an existing record by ID with new field values. | write |
| delete_record | Delete a record by ID. Disabled by default — requires explicit Can Delete permission. | unlink |
| execute_method | Call any model method (e.g. action_confirm) with custom arguments. | execute |
| get_fields | Retrieve field definitions (type, label, required, relation, etc.) for any model. | read |
| read_group | Perform grouped aggregation queries (SUM, COUNT, AVG) on model data. | read |
| search_count | Count records matching a domain filter without loading data. | read |
| smart_context | Returns Odoo metadata — installed modules, available models, company info — helping AI agents understand the environment. | read |
| get_report_pdf | Generate and retrieve a PDF report (invoice, SO, etc.) as base64-encoded data. | read |
Each API key has independent permission toggles and model access controls.
CRUD Toggles
Read, Create, Write, Delete, Execute — each individually toggleable per key.
Model Whitelist / Blacklist
Choose which models AI can access. Blocked models override allowed ones.
System Blocked Models
ir.model, ir.ui.view, ir.rule, res.users & more — permanently locked, cannot be overridden.
Ready-to-copy configuration snippets are generated automatically for each integration.
Claude Code
Claude Desktop
Codex CLI
Cursor
ChatGPT
OpenCode
Claude Web
Antigravity IDE
Get connected in 3 steps.
Install Module
Install Odoo AI Assistant from the Odoo Apps menu. Dependencies (base, web, mail, portal) are installed automatically.
Generate API Key
Go to Settings → Users → Preferences and click Add AI Assistant Key, or visit /mcp/connect from the portal.
Copy Config Snippet
The success page shows ready-to-copy JSON/CLI/TOML configuration for your chosen AI tool. Paste it and start interacting with Odoo.
Visual overview of the Odoo AI Assistant configuration and usage.
1. API Key Generation (Odoo Backend)
Generate secure AI Assistant API keys directly from the User Preferences panel in Odoo backend.
2. Portal API Keys Management
Manage, view, and revoke your AI Assistant API keys easily from the customer portal security page.
3. Connection Portal Wizard
A clean, dedicated portal wizard that allows users to quickly generate their API keys.
4. Interactive Connection Guide
Select your preferred AI tool from the list of supported integrations to get tailored setup instructions.
5. Claude Web Configuration
Step-by-step guidance on setting up Claude Web with your custom Odoo API keys and system endpoints.
6. Claude Live Interaction & Query Execution (Live Demo)
Real-time execution showing Claude AI querying Odoo overdue invoices dynamically using the MCP server.
7. Claude Conversation & Analysis Output
Real-time execution details displaying how Claude interacts with the Odoo API and presents actionable insights.
8. ChatGPT Custom GPT Setup
Easy copy-paste OpenAPI schema configurations for ChatGPT custom GPTs.
9. ChatGPT Chat Assistant Interaction
Send queries and commands from ChatGPT to interact with your Odoo database securely.
10. ChatGPT Live Interaction & Blog Creation (Live Demo)
Real-time execution showing ChatGPT creating and publishing a complete, formatted blog post directly to the Odoo Website Blog via the MCP server.
11. AI Assistant Live Interaction & Dynamic Sales Dashboard (Live Demo)
Real-time execution showing the AI Assistant querying Odoo sales orders, aggregating performance metrics, and generating live analytical dashboards via MCP tools.
These models are permanently blocked for all API keys and cannot be overridden by users.
| Model | Reason |
|---|---|
| ir.model | Model registry — modifying could break schema |
| ir.model.fields | Field definitions — modifying could corrupt data |
| ir.ui.view | View definitions — modifying could break UI |
| ir.access | Access control lists — security critical |
| ir.rule | Record rules — modifying could expose data |
| ir.actions.server | Server actions — could execute arbitrary code |
| ir.cron | Scheduled actions — could run background code |
| ir.module.module | Module registry — modifying could break system |
| ir.config_parameter | System parameters — contains secrets & config |
| res.users | User accounts — password hashes & credentials |
| mcp.api.key | API key records — self-referential attack vector |
| mcp.audit.log | Audit logs — tampering would hide traces |
Turn Natural Language Prompts Into Direct Odoo Actions
Don't just ask AI questions — let AI perform real, automated work inside your Odoo database. From publishing marketing blogs to assembling real-time sales dashboards, see how your team can accomplish complex tasks in seconds.
Automated Odoo Blog Post Creation & Instant Publishing
Marketing and content teams can brainstorm, generate SEO-optimized articles, structure engaging headings, and publish directly to the Odoo Website Blog from Claude, ChatGPT, or any MCP client without logging into the Odoo backend or manual copy-pasting. Describe the topic and requirements, and the AI assistant automatically drafts the content, sets the author, and publishes the blog post to your Odoo website in seconds.
create_record('blog.post').
Dynamic Sales Dashboard & Real-Time KPI Generation
Executives and sales managers can generate complete performance dashboards, track monthly revenue, identify top-performing reps, and build customized KPI summary pages directly with natural language prompts. Connect seamlessly to your live Odoo data without manually creating complex spreadsheet reports or pivot tables.
read_group('sale.order')
& executes live queries.
🌟 More Everyday Business Tasks AI Can Handle For You
Overdue Invoice Chase
Find customers with unpaid invoices past 30 days and draft customized follow-up reminder messages in chatter.
Stock & PO Restock
Detect inventory items below reorder point across warehouses and automatically draft Purchase Orders.
CRM Lead Qualification
Score new incoming website leads, qualify high-intent buyers, and assign them to the right sales teams automatically.
Instant PDF Reports
Ask AI to fetch customer invoices, delivery slips, or SO quotation PDFs and download them instantly via MCP.
💡 Why Every Odoo Business Needs This Module
Eliminate manual data entry, accelerate decision-making, and give your teams an AI co-pilot that actually takes action inside Odoo with rock-solid security.
Technical Help , Queries & Support
For any other assistance related to the new Odoo feature, customization or Odoo Development.
