odoo-mcp-improved

hachecito/odoo-mcp-improved

3.3

If you are the rightful owner of odoo-mcp-improved and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

Odoo MCP Improved is an enhanced Model Context Protocol server designed for seamless integration with Odoo ERP systems, providing advanced tools for sales, purchases, inventory, and accounting.

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

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

ToolDescription
search_sales_ordersSearch for sales orders with advanced filtering
create_sales_orderCreate a new sales order
analyze_sales_performanceAnalyze sales performance by period, product, or customer
get_customer_insightsGet detailed insights about a specific customer

Purchase Tools

ToolDescription
search_purchase_ordersSearch for purchase orders with advanced filtering
create_purchase_orderCreate a new purchase order
analyze_supplier_performanceAnalyze supplier performance metrics

Inventory Tools

ToolDescription
check_product_availabilityCheck stock availability for products
create_inventory_adjustmentCreate inventory adjustment entries
analyze_inventory_turnoverCalculate and analyze inventory turnover metrics

Accounting Tools

ToolDescription
search_journal_entriesSearch for accounting journal entries
create_journal_entryCreate a new journal entry
analyze_financial_ratiosCalculate key financial ratios

πŸ”— Resources Reference

Sales Resources

URIDescription
odoo://sales/ordersList sales orders
odoo://sales/order/{order_id}Get details of a specific sales order
odoo://sales/productsList sellable products
odoo://sales/customersList customers

Purchase Resources

URIDescription
odoo://purchase/ordersList purchase orders
odoo://purchase/order/{order_id}Get details of a specific purchase order
odoo://purchase/suppliersList suppliers

Inventory Resources

URIDescription
odoo://inventory/productsList products in inventory
odoo://inventory/stock/{location_id}Get stock levels at a specific location
odoo://inventory/movementsList inventory movements

Accounting Resources

URIDescription
odoo://accounting/accountsList accounting accounts
odoo://accounting/journal_entriesList 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