Odoo MCP Unified Server 🚀

Unified Odoo Model Context Protocol (MCP) Server with dual transport support (stdio + SSE), enhanced business tools, and type-safe configuration management.

✨ Features

🔌 Dual Transport Support

stdio: For Claude Desktop integration
SSE: For web deployment (Zeabur, Railway, etc.) - No Supergateway needed!

🛠️ Complete Tool Set (17+ Tools)

Core Tools (3)

execute_method - Execute any Odoo method (most powerful)
search_employee - Search for employees
search_holidays - Search for holidays/time-off

Sales Tools (3)

search_sales_orders - Search sales orders
create_sales_order - Create new sales order
analyze_sales_performance - Analyze sales performance with trends

Purchase Tools (3)

search_purchase_orders - Search purchase orders
create_purchase_order - Create new purchase order
analyze_supplier_performance - Analyze supplier on-time delivery

Inventory Tools (2)

get_stock_levels - Get current stock levels
predict_stock_needs - Predict future stock needs

Accounting Tools (2)

get_financial_summary - Get financial overview
analyze_receivables - Analyze accounts receivable

📦 Resources (4)

odoo://models - List all available models
odoo://model/{model_name} - Get model information
odoo://record/{model_name}/{record_id} - Get specific record
odoo://search/{model_name}/{domain} - Search records

⚙️ Configuration Management

Type-safe configuration with Pydantic
Support for environment variables and JSON config
Validation on startup

🚀 Quick Start

For Claude Desktop (stdio mode)

Install

cd E:\gitHub\odoo-mcp-unified
python -m venv venv
venv\Scripts\activate
pip install -r requirements.txt
pip install -e .

Configure - Add to Claude Desktop config (%APPDATA%\Claude\claude_desktop_config.json):

{
  "mcpServers": {
    "odoo-unified": {
      "command": "E:\\gitHub\\odoo-mcp-unified\\venv\\Scripts\\python.exe",
      "args": ["E:\\gitHub\\odoo-mcp-unified\\run_server.py"],
      "env": {
        "ODOO_URL": "https://alpha-goods-corporation.odoo.com",
        "ODOO_DB": "alpha-goods-corporation",
        "ODOO_USERNAME": "your-username",
        "ODOO_PASSWORD": "your-password",
        "MCP_TRANSPORT": "stdio"
      }
    }
  }
}

Restart Claude Desktop

For Zeabur Deployment (SSE mode)

Connect GitHub repo to Zeabur
Set environment variables:

ODOO_URL=https://your-company.odoo.com
ODOO_DB=your-database
ODOO_USERNAME=your-username
ODOO_PASSWORD=your-password
MCP_TRANSPORT=sse
PORT=8000

Deploy - Zeabur will automatically:
- Build using Dockerfile
- Expose SSE endpoint at /sse
- No Supergateway needed!

📋 Environment Variables

Required

ODOO_URL - Odoo instance URL
ODOO_DB - Database name
ODOO_USERNAME - Username
ODOO_PASSWORD - Password

Optional

MCP_TRANSPORT - Transport mode: stdio or sse (default: stdio)
ODOO_TIMEOUT - Request timeout in seconds (default: 60)
ODOO_VERIFY_SSL - Verify SSL certificates (default: false)
PORT - Server port for SSE mode (default: 8000)
HOST - Server host for SSE mode (default: 0.0.0.0)
LOG_LEVEL - Logging level (default: INFO)

📖 Usage Examples

Execute Any Odoo Method

# Get product.product records
execute_method(
    model="product.product",
    method="search_read",
    args=[],
    kwargs={"fields": ["name", "list_price"], "limit": 10}
)

Analyze Sales Performance

analyze_sales_performance(
    params={
        "start_date": "2024-01-01",
        "end_date": "2024-12-31",
        "group_by": "month"
    }
)

Check Supplier Performance

analyze_supplier_performance(
    params={
        "supplier_id": 123,
        "start_date": "2024-01-01",
        "end_date": "2024-12-31"
    }
)

🏗️ Project Structure

odoo-mcp-unified/
├── src/odoo_mcp/
│   ├── __init__.py
│   ├── __main__.py
│   ├── server.py              # Main MCP server
│   ├── config.py              # 🆕 Configuration management
│   ├── odoo_client.py         # Odoo XML-RPC client
│   ├── extensions.py          # Extension registration
│   ├── models.py              # Pydantic models
│   ├── prompts.py             # MCP prompts
│   ├── resources.py           # MCP resources
│   ├── tools_sales.py         # Sales tools
│   ├── tools_purchase.py      # Purchase tools
│   ├── tools_inventory.py     # Inventory tools
│   └── tools_accounting.py    # Accounting tools
├── run_server.py              # 🆕 Unified server runner (stdio + SSE)
├── requirements.txt           # Fixed FastMCP version
├── pyproject.toml
├── Dockerfile                 # 🆕 Zeabur-ready
└── README.md

🔧 Development

Run Tests

pytest tests/

Run Server Locally (stdio)

export ODOO_URL=https://your-company.odoo.com
export ODOO_DB=your-database
export ODOO_USERNAME=your-username
export ODOO_PASSWORD=your-password
python run_server.py

Run Server Locally (SSE)

export MCP_TRANSPORT=sse
export PORT=8000
python run_server.py
# Access: http://localhost:8000/sse

🐛 Troubleshooting

✅ Using Latest Stable Versions

This project uses the latest stable versions of FastMCP (>=0.7.0) and MCP (>=1.0.0):

Modern FastMCP API without deprecated parameters
Enhanced performance and stability
Latest features and improvements

SSL Certificate Error

If you see SSL errors:

export ODOO_VERIFY_SSL=false

Connection Timeout

Increase timeout:

export ODOO_TIMEOUT=120

📦 What's New in v2.0

🆕 Compared to odoo-mcp-improved

✅ SSE Transport support (Zeabur deployment without Supergateway)
✅ Unified config.py module (type-safe configuration)
✅ Dual transport mode in single codebase
✅ Enhanced documentation

🆕 Compared to mcp-odoo

✅ All basic features (execute_method, resources)
✅ 12+ additional business tools
✅ Extension system
✅ SSE support
✅ Better error handling

📄 License

MIT License

🤝 Contributing

Contributions welcome! Please open an issue or PR.

🔗 Links

Made with ❤️ for Alpha Goods Corporation