odoo-mcp-improved

Odoo MCP Improved

---

📋 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

---