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

Odoo MCP Unified Server