Odoo Mcp Server

Odoo MCP Server

An MCP (Model Context Protocol) server that connects AI agents to Odoo ERP instances. Works with Claude Code, Cursor, Windsurf, and any MCP-compatible client.

Supports Odoo 17-18 (JSON-RPC) and Odoo 19+ (JSON-2 API) — auto-detects the best protocol.

Quick Start

# Run directly (uv handles dependencies automatically)
ODOO_URL=https://my.odoo.com ODOO_DB=mydb ODOO_USER=admin ODOO_PASSWORD=secret \
  uv run odoo_mcp_server.py

No virtualenv or pip install needed — the script has inline metadata that uv resolves automatically.

Configure in Claude Code

Add to your project's .mcp.json:

{
  "mcpServers": {
    "odoo": {
      "type": "stdio",
      "command": "uv",
      "args": ["run", "--python", "3.11", "--script", "/path/to/odoo_mcp_server.py"],
      "env": {
        "ODOO_URL": "https://your-instance.odoo.com",
        "ODOO_DB": "your-database",
        "ODOO_USER": "admin",
        "ODOO_PASSWORD": "your-password"
      }
    }
  }
}

Or for Odoo 19+ with API key auth:

{
  "mcpServers": {
    "odoo": {
      "type": "stdio",
      "command": "uv",
      "args": ["run", "--python", "3.11", "--script", "/path/to/odoo_mcp_server.py"],
      "env": {
        "ODOO_URL": "https://your-instance.odoo.com",
        "ODOO_DB": "your-database",
        "ODOO_USER": "admin",
        "ODOO_API_KEY": "your-api-key"
      }
    }
  }
}

Configure in Cursor / Windsurf

Add to ~/.cursor/mcp.json or equivalent:

{
  "mcpServers": {
    "odoo": {
      "command": "uv",
      "args": ["run", "--python", "3.11", "--script", "/path/to/odoo_mcp_server.py"],
      "env": {
        "ODOO_URL": "https://your-instance.odoo.com",
        "ODOO_DB": "your-database",
        "ODOO_USER": "admin",
        "ODOO_PASSWORD": "your-password"
      }
    }
  }
}

Environment Variables

| Variable | Required | Description | |---|---|---| | ODOO_URL | Yes | Odoo instance URL | | ODOO_DB | Yes | Database name | | ODOO_USER | Yes | Login username | | ODOO_PASSWORD | One of these | Password (Odoo 17-18) | | ODOO_API_KEY | required | API key (Odoo 19+, preferred) | | ODOO_READONLY | No | Set to true to disable all write operations |

Read-Only Mode

Set ODOO_READONLY=true to disable create, update, delete, and execute tools. Useful for safe browsing of production instances:

{
  "mcpServers": {
    "odoo": {
      "type": "stdio",
      "command": "uv",
      "args": ["run", "--python", "3.11", "--script", "/path/to/odoo_mcp_server.py"],
      "env": {
        "ODOO_URL": "https://production.odoo.com",
        "ODOO_DB": "prod",
        "ODOO_USER": "readonly-user",
        "ODOO_PASSWORD": "secret",
        "ODOO_READONLY": "true"
      }
    }
  }
}

Available Tools

Core CRUD

| Tool | Description | |---|---| | odoo_search_read | Query records with domain filters, field selection, pagination | | odoo_search_count | Count matching records without fetching data | | odoo_export | Bulk export up to 2000 records per call for spreadsheets | | odoo_create | Create new records | | odoo_update | Update existing records by ID | | odoo_delete | Delete records by ID | | odoo_execute | Run any model method (actionconfirm, actionpost, etc.) |

Discovery

| Tool | Description | |---|---| | odoo_list_models | Discover available models with keyword filter | | odoo_get_fields | Inspect field definitions for any model | | odoo_doctor | Health diagnostics (version, modules, users, crons, errors) | | odoo_connection_info | Show current connection details |

Model Customization

| Tool | Description | |---|---| | odoo_model_info | Get comprehensive model metadata in one call — fields, views, actions, defaults, sort order | | odoo_set_default | Set, update, or clear a field's default value (handles ir.default + JSON encoding) | | odoo_get_view | Get the fully rendered (merged) form/tree/search view XML | | odoo_modify_action | Change a window action's domain, context, sort order, limit, or view modes |

Example Usage

Once configured, ask your AI agent:

• "List all sale orders from this month"
• "Show me the fields on res.partner"
• "Create a new contact named Acme Corp"
• "Run a health check on the Odoo instance"
• "Export all products to a spreadsheet"
• "Confirm sale order 42"

Model Customization Examples

• "What's the default sort order for sale.order?"
• "Change the default invoice policy on products to 'delivery'"
• "Show me the form view for res.partner"
• "What window actions exist for account.move? Change the default sort to date desc"
• "List all custom fields on res.partner"
• "What fields are required on sale.order?"

Model Customization Tools — Detailed Reference

odoomodelinfo

Returns everything about a model in one call, eliminating the need for multiple exploratory queries.

odoo_model_info(model="sale.order")

Returns:

• default_order — the model's _order attribute (e.g. "date_order desc, id desc")
• rec_name — the field used for display name in dropdowns
• field_count — total number of fields
• fields_by_type — field count grouped by type (many2one: 12, char: 8, ...)
• custom_fields — user-created fields (x_ prefix or state=manual)
• relational_fields — all Many2one, One2many, Many2many with their targets
• required_fields — fields that must be filled
• views — base views (form, tree, search) with IDs and priorities
• actions — window actions with their domain, context, and view modes
• defaults — current ir.default values set for this model's fields

odoosetdefault

Manages field defaults via ir.default with proper JSON encoding. The most common source of agent errors when done manually.

# Set global default
odoo_set_default(model="product.template", field_name="invoice_policy", value="delivery")

# Set user-specific default
odoo_set_default(model="sale.order", field_name="warehouse_id", value=2, user_id=5)

# Remove a default
odoo_set_default(model="product.template", field_name="invoice_policy", value=null)

The tool:

1. Finds the field_id in ir.model.fields (validates the field exists)
2. JSON-encodes the value automatically
3. Creates or updates the ir.default record
4. Returns before/after values for confirmation

odoogetview

Returns the fully rendered view XML after all inheritance is applied — what the user actually sees, not the raw fragments stored in ir.ui.view.

odoo_get_view(model="sale.order", view_type="form")
odoo_get_view(model="res.partner", view_type="tree")
odoo_get_view(model="account.move", view_type="search")

Returns:

• arch — the complete merged XML
• view_id — the base view ID
• fields_in_view — list of field names present in the view

odoomodifyaction

Changes how a model appears in the UI by modifying its window action (ir.actions.act_window).

# List actions for a model (read-only)
odoo_modify_action(model="sale.order")

# Change default sort order
odoo_modify_action(action_id=42, order="date_order desc")

# Change default filter and page size
odoo_modify_action(action_id=42, domain="[['state','=','sale']]", limit=200)

# Add default grouping via context
odoo_modify_action(action_id=42, context="{'group_by': 'partner_id'}")

The tool returns before/after values so you can verify what changed.

How It Works

AI Agent (Claude, Cursor, etc.)
    ↕ MCP Protocol (stdio)
Odoo MCP Server
    ↕ JSON-RPC / JSON-2 API
Odoo Instance

The server authenticates once at startup and maintains a persistent connection. All tools use the same authenticated session.

Requirements

• Python 3.11+
• uv (recommended) or pip install fastmcp httpx

License

MIT

Source & license

This open-source MCP server is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: oconsole
• Source: oconsole/odoo-mcp-server
• License: MIT

Install and usage instructions live in the source repository linked above.