Odoo MCP Improved

Enhanced Model Context Protocol (MCP) server for Odoo ERP with advanced tools for sales, purchases, inventory and accounting

📋 Table of Contents

Overview
Features
Installation
Configuration
Usage
Tools Reference
Resources Reference
Prompts
Docker Support
Claude Desktop Integration
License

🔍 Overview

Odoo MCP Improved is a comprehensive implementation of the Model Context Protocol (MCP) for Odoo ERP systems. It provides a bridge between large language models like Claude and your Odoo instance, enabling AI assistants to interact directly with your business data and processes.

This extended version enhances the original MCP-Odoo implementation with advanced tools and resources for sales, purchases, inventory management, and accounting, making it a powerful solution for AI-assisted business operations.

✨ Features

Core Capabilities

Seamless Odoo Integration: Connect directly to your Odoo instance via XML-RPC
Comprehensive Data Access: Query and manipulate data across all Odoo modules
Modular Architecture: Easily extensible with new tools and resources
Robust Error Handling: Clear error messages and validation for reliable operation

Business Domain Support

Sales Management: Order tracking, customer insights, and performance analysis
Purchase Management: Supplier management, order processing, and performance metrics
Inventory Management: Stock monitoring, inventory adjustments, and turnover analysis
Accounting: Financial reporting, journal entries, and ratio analysis

Advanced Functionality

Analytical Tools: Business intelligence capabilities across all domains
Specialized Prompts: Pre-configured prompts for common business scenarios
Resource URIs: Standardized access to Odoo data through URI patterns
Performance Optimization: Caching and efficient data retrieval

📦 Installation

Using pip

pip install odoo-mcp-improved

From Source

git clone https://github.com/hachecito/odoo-mcp-improved.git
cd odoo-mcp-improved
pip install -e .

Using Docker

docker build -t mcp/odoo:latest -f Dockerfile .

⚙️ Configuration

Environment Variables

export ODOO_URL=https://your-odoo-instance.com
export ODOO_DB=your_database
export ODOO_USERNAME=your_username
export ODOO_PASSWORD=your_password

Configuration File

Create an odoo_config.json file in your working directory:

{
  "url": "https://your-odoo-instance.com",
  "db": "your_database",
  "username": "your_username",
  "password": "your_password"
}

🚀 Usage

Running the Server

# Using the module
python -m odoo_mcp

# Using Docker
docker run -i --rm \
  -e ODOO_URL=https://your-odoo-instance.com \
  -e ODOO_DB=your_database \
  -e ODOO_USERNAME=your_username \
  -e ODOO_PASSWORD=your_password \
  yourusername/odoo-mcp-improved

Example Interactions

# Sales Analysis
Using the Odoo MCP, analyze our sales performance for the last quarter and identify our top-selling products.

# Inventory Check
Check the current stock levels for product XYZ across all warehouses.

# Financial Analysis
Calculate our current liquidity and profitability ratios based on the latest financial data.

# Customer Insights
Provide insights on customer ABC's purchase history and payment patterns.

🛠️ Tools Reference

Sales Tools

Tool	Description
`search_sales_orders`	Search for sales orders with advanced filtering
`create_sales_order`	Create a new sales order
`analyze_sales_performance`	Analyze sales performance by period, product, or customer
`get_customer_insights`	Get detailed insights about a specific customer

Purchase Tools

Tool	Description
`search_purchase_orders`	Search for purchase orders with advanced filtering
`create_purchase_order`	Create a new purchase order
`analyze_supplier_performance`	Analyze supplier performance metrics

Inventory Tools

Tool	Description
`check_product_availability`	Check stock availability for products
`create_inventory_adjustment`	Create inventory adjustment entries
`analyze_inventory_turnover`	Calculate and analyze inventory turnover metrics

Accounting Tools

Tool	Description
`search_journal_entries`	Search for accounting journal entries
`create_journal_entry`	Create a new journal entry
`analyze_financial_ratios`	Calculate key financial ratios

🔗 Resources Reference

Sales Resources

URI	Description
`odoo://sales/orders`	List sales orders
`odoo://sales/order/{order_id}`	Get details of a specific sales order
`odoo://sales/products`	List sellable products
`odoo://sales/customers`	List customers

Purchase Resources

URI	Description
`odoo://purchase/orders`	List purchase orders
`odoo://purchase/order/{order_id}`	Get details of a specific purchase order
`odoo://purchase/suppliers`	List suppliers

Inventory Resources

URI	Description
`odoo://inventory/products`	List products in inventory
`odoo://inventory/stock/{location_id}`	Get stock levels at a specific location
`odoo://inventory/movements`	List inventory movements

Accounting Resources

URI	Description
`odoo://accounting/accounts`	List accounting accounts
`odoo://accounting/journal_entries`	List journal entries
`odoo://accounting/reports/{report_type}`	Get financial reports

💬 Prompts

Odoo MCP Improved includes specialized prompts for different business scenarios:

Sales Analysis Prompts

Sales trend analysis
Customer segmentation
Product performance evaluation
Sales team performance

Inventory Management Prompts

Stock optimization
Reordering suggestions
Warehouse efficiency analysis
Product movement patterns

Human Resources Prompts

Staff planning
Scheduling optimization
Performance evaluation
Resource allocation

Financial Analysis Prompts

Ratio interpretation
Cash flow analysis
Budget variance analysis
Financial health assessment

🐳 Docker Support

Running with Docker

docker run -i --rm \
  -e ODOO_URL=https://your-odoo-instance.com \
  -e ODOO_DB=your_database \
  -e ODOO_USERNAME=your_username \
  -e ODOO_PASSWORD=your_password \
  yourusername/odoo-mcp-improved

Docker Compose

version: '3'

services:
  odoo-mcp-improved:
    image: yourusername/odoo-mcp-improved:latest
    environment:
      - ODOO_URL=https://your-odoo-instance.com
      - ODOO_DB=your_database
      - ODOO_USERNAME=your_username
      - ODOO_PASSWORD=your_password

🤖 Claude Desktop Integration

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "odoo": {
      "command": "python",
      "args": ["-m", "odoo_mcp"],
      "env": {
        "ODOO_URL": "https://your-odoo-instance.com",
        "ODOO_DB": "your_database",
        "ODOO_USERNAME": "your_username",
        "ODOO_PASSWORD": "your_password"
      }
    }
  }
}

For Docker:

{
  "mcpServers": {
    "odoo": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e", "ODOO_URL",
        "-e", "ODOO_DB",
        "-e", "ODOO_USERNAME",
        "-e", "ODOO_PASSWORD",
        "yourusername/odoo-mcp-improved"
      ],
      "env": {
        "ODOO_URL": "https://your-odoo-instance.com",
        "ODOO_DB": "your_database",
        "ODOO_USERNAME": "your_username",
        "ODOO_PASSWORD": "your_password"
      }
    }
  }
}

📄 License

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

This repo is extended from mcp-odoo - Lê Anh Tuấn

Odoo MCP Improved - Empowering AI assistants with comprehensive Odoo ERP capabilities