Odoo MCP Unified Server

# 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) 1. **Install** ```bash cd E:\gitHub\odoo-mcp-unified python -m venv venv venv\Scripts\activate pip install -r requirements.txt pip install -e . ``` 2. **Configure** - Add to Claude Desktop config (`%APPDATA%\Claude\claude_desktop_config.json`): ```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" } } } } ``` 3. **Restart Claude Desktop** ### For Zeabur Deployment (SSE mode) 1. **Connect GitHub repo to Zeabur** 2. **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 ``` 3. **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 ```python # Get product.product records execute_method( model="product.product", method="search_read", args=[], kwargs={"fields": ["name", "list_price"], "limit": 10} ) ``` ### Analyze Sales Performance ```python analyze_sales_performance( params={ "start_date": "2024-01-01", "end_date": "2024-12-31", "group_by": "month" } ) ``` ### Check Supplier Performance ```python 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 ```bash pytest tests/ ``` ### Run Server Locally (stdio) ```bash 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) ```bash 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: ```bash export ODOO_VERIFY_SSL=false ``` ### Connection Timeout Increase timeout: ```bash 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 - [Model Context Protocol](https://modelcontextprotocol.io/) - [Odoo Documentation](https://www.odoo.com/documentation/) - [FastMCP](https://github.com/jlowin/fastmcp) --- **Made with ❤️ for Alpha Goods Corporation**