YT MCP Server for Odoo

A Python MCP (Model Context Protocol) client that enables AI assistants like Claude, Cursor, and VS Code Copilot to interact with your Odoo ERP system.

Features

🔍 Search & Read - Query any Odoo model with natural language
✏️ Create & Update - Create and modify records via AI
🗑️ Delete - Remove records (with proper permissions)
📊 Bulk Operations - Create/update multiple records at once
🔢 Count & Browse - Count records or fetch by specific IDs
📝 Prompt Templates - Pre-defined prompts for common tasks
🔐 Secure - API key authentication with Odoo user permissions

Installation

Option 1: Local Development (Recommended)

# Navigate to the mcp_client directory
cd /path/to/yt_mcp_server/mcp_client

# Install in development mode
pip install -e .

# Or using uv
uv pip install -e .

Option 2: Direct from Path

# Install directly from local path
pip install /path/to/yt_mcp_server/mcp_client

Option 3: Run without Installing

# Run directly with Python
cd /path/to/yt_mcp_server/mcp_client
python -m yt_mcp_server_odoo

Configuration

Environment Variables

Variable	Required	Default	Description
`ODOO_URL`	Yes	`http://localhost:8069`	Your Odoo instance URL
`ODOO_API_KEY`	Yes	-	API key from MCP Server module
`ODOO_DB`	No	Auto-detect	Database name
`ODOO_USER`	No	-	Username (alternative to API key)
`ODOO_PASSWORD`	No	-	Password (alternative to API key)
`MCP_TRANSPORT`	No	`stdio`	Transport: `stdio` or `streamable-http`
`MCP_HOST`	No	`localhost`	Host for HTTP transport
`MCP_PORT`	No	`8000`	Port for HTTP transport
`DEFAULT_LIMIT`	No	`10`	Default records per query
`MAX_LIMIT`	No	`100`	Maximum records per query
`MAX_SMART_FIELDS`	No	`25`	Max fields for smart selection
`ODOO_YOLO`	No	`off`	YOLO mode: `off`, `read`, `true`

IDE Setup Guides

Claude Desktop

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json
Linux: ~/.config/Claude/claude_desktop_config.json

Option A: Using installed package

{
  "mcpServers": {
    "odoo": {
      "command": "python",
      "args": ["-m", "yt_mcp_server_odoo"],
      "env": {
        "ODOO_URL": "https://your-odoo.com",
        "ODOO_API_KEY": "your-api-key-here",
        "ODOO_DB": "your-database"
      }
    }
  }
}

Option B: Using local path directly

{
  "mcpServers": {
    "odoo": {
      "command": "python",
      "args": ["/path/to/yt_mcp_server/mcp_client/src/yt_mcp_server_odoo/__main__.py"],
      "env": {
        "ODOO_URL": "https://your-odoo.com",
        "ODOO_API_KEY": "your-api-key-here",
        "ODOO_DB": "your-database"
      }
    }
  }
}

Cursor

Location: ~/.cursor/mcp.json

{
  "mcpServers": {
    "odoo": {
      "command": "python",
      "args": ["-m", "yt_mcp_server_odoo"],
      "env": {
        "ODOO_URL": "https://your-odoo.com",
        "ODOO_API_KEY": "your-api-key-here",
        "ODOO_DB": "your-database"
      }
    }
  }
}

VS Code (with Copilot/Continue)

Location: .vscode/mcp.json in your workspace or ~/.vscode/mcp.json globally

{
  "servers": {
    "odoo": {
      "command": "python",
      "args": ["-m", "yt_mcp_server_odoo"],
      "env": {
        "ODOO_URL": "https://your-odoo.com",
        "ODOO_API_KEY": "your-api-key-here",
        "ODOO_DB": "your-database"
      }
    }
  }
}

Windsurf

Location: ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "odoo": {
      "command": "python",
      "args": ["-m", "yt_mcp_server_odoo"],
      "env": {
        "ODOO_URL": "https://your-odoo.com",
        "ODOO_API_KEY": "your-api-key-here",
        "ODOO_DB": "your-database"
      }
    }
  }
}

Zed

Location: ~/.config/zed/settings.json

{
  "context_servers": {
    "odoo": {
      "command": {
        "path": "python",
        "args": ["-m", "yt_mcp_server_odoo"],
        "env": {
          "ODOO_URL": "https://your-odoo.com",
          "ODOO_API_KEY": "your-api-key-here",
          "ODOO_DB": "your-database"
        }
      }
    }
  }
}

Custom/Programmatic

from yt_mcp_server_odoo import OdooMCPServer
from yt_mcp_server_odoo.config import OdooConfig

config = OdooConfig(
    odoo_url="https://your-odoo.com",
    odoo_api_key="your-api-key",
    odoo_db="your-database"
)

server = OdooMCPServer(config)
server.run()

Available MCP Tools

Tool	Description
`list_models`	List all MCP-enabled Odoo models
`search_records`	Search records with domain filters
`get_record`	Get a single record by ID
`create_record`	Create a new record
`update_record`	Update an existing record
`delete_record`	Delete a record
`count_records`	Count records matching a domain
`browse_records`	Get multiple records by IDs
`create_bulk`	Create multiple records at once
`update_bulk`	Update multiple records with different values
`list_prompts`	List available prompt templates

Usage Examples

Once configured, ask your AI assistant:

"Show me all customers from Spain"
"Create a new contact named John Doe at Acme Corp"
"Find unpaid invoices from last month over $1000"
"Update the phone number for partner ID 42"
"How many products do we have in stock?"
"Delete the draft quotation SO0123"

YOLO Mode (Development)

For development/testing, enable YOLO mode to bypass MCP model restrictions:

{
  "env": {
    "ODOO_YOLO": "read"
  }
}

Mode	Effect
`off`	Normal - only configured models accessible
`read`	Can read ANY model without MCP config
`true`	Full access to ALL models (dangerous!)

⚠️ Warning: YOLO mode bypasses MCP restrictions but still respects Odoo user permissions.

Getting Your API Key

Go to Settings > MCP Server in Odoo
Click Manage API Keys
Create a new API key for your user
Copy the key (shown only once!)

Troubleshooting

Connection Failed

Check ODOO_URL is accessible
Ensure MCP Server module is installed and enabled
Verify API key is valid

Model Not Found

Ensure model is enabled in MCP Server > Enabled Models
Check if YOLO mode should be enabled for development

Permission Denied

Verify API key user has access to the model
Check model permissions (read/write/create/delete)

License

LGPL-3.0