Skip to main content
Glama
aadilakbar

MCP Odoo Bridge Server

by aadilakbar

MCP Odoo Bridge Server

MCP Odoo Python License

Licensed under the Apache License, Version 2.0 - See LICENSE for details.

A Model Context Protocol (MCP) server that enables AI assistants like Claude to interact with Odoo data using natural language.

🎯 What is MCP?

The Model Context Protocol is an open standard by Anthropic that enables AI assistants to securely connect to external data sources. This server acts as a bridge between Claude (or other MCP clients) and your Odoo instance.

Learn more: MCP Documentation


✨ Features

Feature

Description

πŸ” Search Records

Find records using natural language or Odoo domain syntax

πŸ“– Read Records

Get detailed record information by ID

πŸ“Š Count Records

Get counts matching criteria

βž• Create Records

Create new records (with permission)

✏️ Update Records

Modify existing records (with permission)

πŸ—‘οΈ Delete Records

Remove records (with permission)

πŸ“‹ List Models

Discover available models

πŸ”§ Get Fields

Understand model structure

⚑ Execute Methods

Run custom methods (if enabled)

πŸ” API Key Auth

Secure authentication via API keys

πŸ“ Audit Logging

All operations logged for compliance


πŸ“‹ Prerequisites

  1. Odoo instance (17.0, 18.0, or 19.0 recommended)

  2. Python 3.10+ installed

  3. AD Odoo MCP Bridge module installed in Odoo (see Odoo Module)


πŸš€ Installation

1. Clone the Repository

git clone https://github.com/yourusername/ad-mcp-bridge-server.git cd ad-mcp-bridge-server

2. Install Dependencies

pip install -e .

Or with uv:

uv pip install -e .

3. Install the Odoo Module

Install the ad_odoo_mcp_bridge module in your Odoo instance:

  1. Add the module folder to your Odoo addons path

  2. Go to Apps β†’ Install "AD Odoo MCP Bridge"


βš™οΈ Configuration

Environment Variables

The server requires the following environment variables:

Variable

Required

Description

Example

ODOO_URL

Yes

Your Odoo instance URL

https://mycompany.odoo.com

ODOO_API_KEY

Yes*

API key for authentication

0ef5b399e9ee9c11b053dfb6eeba8de473c29fcd

ODOO_USER

Yes*

Username (if not using API key)

admin

ODOO_PASSWORD

Yes*

Password (if not using API key)

admin

ODOO_DB

No

Database name (auto-detected if not set)

mycompany

ODOO_MAX_RECORDS

No

Default max records per query (default: 100)

200

ODOO_TIMEOUT

No

Request timeout in seconds (default: 30)

60

ODOO_YOLO

No

YOLO mode - bypasses MCP security (⚠️ DEV ONLY)

off, read, true

* Authentication: You must provide either ODOO_API_KEY or both ODOO_USER and ODOO_PASSWORD.

MCP Transport Options

Variable

Required

Description

Example

MCP_TRANSPORT

No

Transport type: stdio or streamable-http (default: stdio)

streamable-http

MCP_HOST

No

Host for HTTP transport (default: localhost)

0.0.0.0

MCP_PORT

No

Port for HTTP transport (default: 8000)

8080

YOLO Mode Values

Value

Description

off

All operations require explicit MCP Bridge permissions (default)

read

Allows read-only operations on all models without configuration

true

⚠️ DANGEROUS - Allows all operations including write/delete without restrictions

⚠️ Warning: YOLO mode bypasses security checks and should NEVER be used in production. It's intended only for local development and testing.

Create a .env File (Optional)

ODOO_URL=https://mycompany.odoo.com ODOO_DB=mycompany ODOO_API_KEY=your-api-key-here

πŸ”Œ Usage with Claude Desktop

Step 1: Generate API Key in Odoo

  1. Go to MCP Bridge β†’ Configuration β†’ API Keys

  2. Click Create β†’ Select user β†’ Generate Key

  3. Copy the key (shown only once!)

Step 2: Configure Claude Desktop

Edit claude_desktop_config.json:

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

{ "mcpServers": { "odoo": { "command": "python", "args": ["-m", "ad_mcp_bridge_server"], "cwd": "/path/to/ad-mcp-bridge-server/src", "env": { "ODOO_URL": "http://localhost:8069", "ODOO_DB": "your_database", "ODOO_API_KEY": "your-api-key" } } } }

Windows Note: Use the full Python path if needed:

"command": "C:\\path\\to\\venv\\Scripts\\python.exe"

Step 3: Restart Claude Desktop

Close and reopen Claude Desktop. You should see the πŸ”§ Tools icon.

Step 4: Start Chatting!

Try these prompts:

  • "Show me all customers from the United States"

  • "What's the status of order SO/2024/0153?"

  • "Create a new lead for ABC Company"

  • "How many unpaid invoices do we have?"


πŸ”Œ Usage with VS Code

Create .vscode/mcp.json in your workspace:

{ "servers": { "odoo": { "command": "python", "args": ["-m", "ad_mcp_bridge_server"], "cwd": "/path/to/ad-mcp-bridge-server/src", "env": { "ODOO_URL": "http://localhost:8069", "ODOO_DB": "your_database", "ODOO_API_KEY": "your-api-key" } } } }

πŸ§ͺ Testing with MCP Inspector

Use the official MCP debugging tool:

npx @modelcontextprotocol/inspector python -m ad_mcp_bridge_server

This opens a web UI to test all tools interactively.


πŸ—οΈ Odoo Module

This MCP server requires the AD Odoo MCP Bridge module installed in Odoo.

Compatibility

Odoo Version

Status

19.0

βœ… Fully Supported

18.0

βœ… Supported

17.0

βœ… Supported

16.0

βœ… Supported

Module Features

  • Model Configuration: Choose which models AI can access

  • Permission Control: Set read/create/update/delete per model

  • API Key Management: Generate and manage API keys

  • Audit Logging: Track all AI operations

  • Rate Limiting: Control request frequency

  • YOLO Mode: Quick access mode for development

Module Installation

  1. Copy ad_odoo_mcp_bridge folder to your Odoo addons path

  2. Restart Odoo

  3. Go to Apps β†’ Remove "Apps" filter β†’ Search "MCP" β†’ Install


πŸ” Security

  • API Key Authentication: All requests require a valid API key

  • Permission Inheritance: AI inherits Odoo user's permissions

  • Audit Trail: All operations logged with IP, timestamp, and details

  • Rate Limiting: Configurable per-key request limits

  • Field Exclusions: Sensitive fields can be blocked


πŸ“š API Endpoints (Odoo Module)

The Odoo module exposes these JSON-RPC endpoints:

Endpoint

Description

GET /mcp/health

Health check

POST /mcp/info

Server information

POST /mcp/models

List enabled models

POST /mcp/fields

Get model fields

POST /mcp/search

Search records

POST /mcp/read

Read record by ID

POST /mcp/count

Count records

POST /mcp/create

Create record

POST /mcp/write

Update record

POST /mcp/unlink

Delete record

POST /mcp/execute

Execute method


πŸ› οΈ Development

Run Locally

cd src export ODOO_URL=http://localhost:8069 export ODOO_DB=mydb export ODOO_API_KEY=your-key python -m ad_mcp_bridge_server

Project Structure

ad-mcp-bridge-server/ β”œβ”€β”€ src/ β”‚ └── ad_mcp_bridge_server/ β”‚ β”œβ”€β”€ __init__.py β”‚ β”œβ”€β”€ __main__.py # Entry point β”‚ β”œβ”€β”€ config.py # Pydantic settings β”‚ β”œβ”€β”€ odoo_client.py # Odoo HTTP client β”‚ └── server.py # MCP server & tools β”œβ”€β”€ pyproject.toml β”œβ”€β”€ README.md └── .env.example

πŸ“– MCP Resources


🀝 Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

  1. Fork the repository

  2. Create your feature branch (git checkout -b feature/amazing-feature)

  3. Commit your changes (git commit -m 'Add some amazing feature')

  4. Push to the branch (git push origin feature/amazing-feature)

  5. Open a Pull Request


β˜• Support

Thank you for using this project! If you find it helpful and would like to support my work, kindly consider buying me a coffee. Your support is greatly appreciated!

And don't forget to give the project a ⭐ star if you like it!


πŸ“„ License

This project is licensed under the Apache License 2.0 - see the LICENSE file for details.


πŸ™ Acknowledgments


πŸ“ About

A Model Context Protocol (MCP) server that enables AI assistants to securely interact with Odoo ERP systems through standardized resources and tools for data retrieval and manipulation.

Made with ❀️ for the Odoo and AI community

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/aadilakbar/ad-mcp-bridge-server'

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