Skip to main content
Glama
yugmatech

yt-mcp-server-odoo

by yugmatech

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

Related MCP server: Odoo MCP Server

Installation

# 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

  1. Go to Settings > MCP Server in Odoo

  2. Click Manage API Keys

  3. Create a new API key for your user

  4. 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

A
license - permissive license
-
quality - not tested
C
maintenance

Maintenance

Maintainers
Response time
1dRelease cycle
2Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/yugmatech/yt-mcp-server-odoo'

If you have feedback or need assistance with the MCP directory API, please join our Discord server