📌Overview

Purpose: To provide a robust MCP server implementation that seamlessly integrates AI assistants with Odoo ERP systems using the Model Context Protocol.

Overview: The Odoo MCP server enables efficient communication and interaction with Odoo data and functionalities, offering developers a comprehensive framework for integrating various AI capabilities into their Odoo environments. It leverages XML-RPC for secure communication, supports flexible configuration options, and ensures reliable performance with stateless operations.

Key Features:

Comprehensive Odoo Integration: Provides full access to Odoo models, records, and methods, facilitating extensive data manipulation and retrieval.
XML-RPC Communication: Establishes a secure connection to Odoo instances, ensuring reliable data transactions.
Flexible Configuration: Allows configuration through files and environment variables to accommodate various deployment scenarios.
Resource Pattern System: Implements URI-based access to Odoo data structures, simplifying the retrieval of information.
Error Handling: Offers clear and informative error messages for common Odoo API issues, enhancing development efficiency.
Stateless Operations: Maintains a clean request/response cycle for improved reliability in integration processes.

Odoo MCP Server

An MCP server implementation integrating with Odoo ERP systems, enabling AI assistants to interact with Odoo data and functionality through the Model Context Protocol.

Features

Comprehensive Odoo Integration: Full access to Odoo models, records, and methods
XML-RPC Communication: Secure connection to Odoo instances via XML-RPC
Flexible Configuration: Support for config files and environment variables
Resource Pattern System: URI-based access to Odoo data structures
Error Handling: Clear error messages for common Odoo API issues
Stateless Operations: Clean request/response cycle for reliable integration

Tools

execute_method

Execute a custom method on an Odoo model
Inputs:
- model (string): The model name (e.g., 'res.partner')
- method (string): Method name to execute
- args (optional array): Positional arguments
- kwargs (optional object): Keyword arguments
Returns: Dictionary with the method result and success indicator

search_employee

Search for employees by name
Inputs:
- name (string): The name (or part of the name) to search for
- limit (optional number): Maximum number of results to return (default 20)
Returns: Object containing success indicator, list of matching employee names and IDs, and any error message

search_holidays

Searches for holidays within a specified date range
Inputs:
- start_date (string): Start date in YYYY-MM-DD format
- end_date (string): End date in YYYY-MM-DD format
- employee_id (optional number): Optional employee ID to filter holidays
Returns: Object containing success indicator, list of holidays found, and any error message

Resources

odoo://models

Lists all available models in the Odoo system
Returns: JSON array of model information

odoo://model/{model_name}

Get information about a specific model including fields
Example: odoo://model/res.partner
Returns: JSON object with model metadata and field definitions

odoo://record/{model_name}/{record_id}

Get a specific record by ID
Example: odoo://record/res.partner/1
Returns: JSON object with record data

odoo://search/{model_name}/{domain}

Search for records that match a domain
Example: odoo://search/res.partner/[["is_company","=",true]]
Returns: JSON array of matching records (limited to 10 by default)

Configuration

Odoo Connection Setup

Create a configuration file named odoo_config.json:

{
  "url": "https://your-odoo-instance.com",
  "db": "your-database-name",
  "username": "your-username",
  "password": "your-password-or-api-key"
}

Alternatively, use environment variables:
- ODOO_URL: Your Odoo server URL
- ODOO_DB: Database name
- ODOO_USERNAME: Login username
- ODOO_PASSWORD: Password or API key
- ODOO_TIMEOUT: Connection timeout in seconds (default: 30)
- ODOO_VERIFY_SSL: Whether to verify SSL certificates (default: true)
- HTTP_PROXY: Force the ODOO connection to use an HTTP proxy

Usage with Claude Desktop

Add this to your claude_desktop_config.json:

{
  "mcpServers": {
    "odoo": {
      "command": "python",
      "args": [
        "-m",
        "odoo_mcp"
      ],
      "env": {
        "ODOO_URL": "https://your-odoo-instance.com",
        "ODOO_DB": "your-database-name",
        "ODOO_USERNAME": "your-username",
        "ODOO_PASSWORD": "your-password-or-api-key"
      }
    }
  }
}

Docker

{
  "mcpServers": {
    "odoo": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "ODOO_URL",
        "-e",
        "ODOO_DB",
        "-e",
        "ODOO_USERNAME",
        "-e",
        "ODOO_PASSWORD",
        "mcp/odoo"
      ],
      "env": {
        "ODOO_URL": "https://your-odoo-instance.com",
        "ODOO_DB": "your-database-name",
        "ODOO_USERNAME": "your-username",
        "ODOO_PASSWORD": "your-password-or-api-key"
      }
    }
  }
}

Installation

Python Package

pip install odoo-mcp

Running the Server

# Using the installed package
odoo-mcp

# Using the MCP development tools
mcp dev odoo_mcp/server.py

# With additional dependencies
mcp dev odoo_mcp/server.py --with pandas --with numpy

# Mount local code for development
mcp dev odoo_mcp/server.py --with-editable .

Build

Docker build:

docker build -t mcp/odoo:latest -f Dockerfile .

Parameter Formatting Guidelines

When using the MCP tools for Odoo, pay attention to these parameter formatting guidelines:

Domain Parameter:
- Supported domain formats:
  - List format: [["field", "operator", value], ...]
  - Object format: {"conditions": [{"field": "...", "operator": "...", "value": "..."}]}
  - JSON string of either format
- Examples:
  - List format: [["is_company", "=", true]]
  - Object format: {"conditions": [{"field": "date_order", "operator": ">=", "value": "2025-03-01"}]}
  - Multiple conditions: [["date_order", ">=", "2025-03-01"], ["date_order", "<=", "2025-03-31"]]
Fields Parameter:
- Should be an array of field names: ["name", "email", "phone"]
- The server will try to parse string inputs as JSON

License

This MCP server is licensed under the MIT License.

mcp-odoo