sarakhanx/odoo-mcp-server

Odoo MCP Server

A Model Context Protocol (MCP) server that provides Claude with direct access to Odoo ERP system capabilities. Perfect for businesses using Odoo to manage their operations through natural language interactions.

🚀 Features

📦 Inventory Management

• Get current inventory levels and stock information
• Search product details and specifications
• Monitor stock movements and availability
• Create inventory adjustments (coming soon)

🛒 Purchase Management

• View and filter purchase orders by status
• Get vendor/supplier information and contacts
• Purchase analytics and reporting
• Create new purchase orders (simplified version)

🏭 Manufacturing (MRP)

• View manufacturing orders and production schedules
• Get Bill of Materials (BOM) information
• Monitor work centers and capacity
• Production planning overview
• Create manufacturing orders (simplified version)

🛠️ Installation & Setup

Prerequisites

• Go 1.21 or higher
• Access to Odoo 17 instance
• PostgreSQL database (optional for direct DB access)

1. Clone and Build

git clone <repository-url>
cd odoo-mcp-server
go mod tidy
go build -o odoo-mcp-server

2. Configuration

Copy example config and edit with your Odoo connection details:

cp config.yaml.example config.yaml
vim config.yaml

The config should contain:

odoo:
  url: "https://your-odoo-server.com"
  database: "your_database_name"
  username: "your_username"
  password: "your_password"

discord:
  webhook_url: "https://discord.com/api/webhooks/YOUR_ID/YOUR_TOKEN"

webhook:
  port: "8080"
  enabled: true

3. Build Servers

./build.sh

4. Test Connection

# Test MCP Server
./odoo-mcp-server

# Test Webhook Server (for Discord notifications)
./odoo-webhook-server

🎯 Usage with Claude (Cursor)

Configure Cursor MCP

Add to your Cursor settings or create .cursor-mcp.json:

{
  "mcpServers": {
    "odoo": {
      "command": "/path/to/your/odoo-mcp-server",
      "args": [],
      "env": {}
    }
  }
}

Example Queries

Inventory Management:

"Show me current inventory levels for all products"
"What's the stock level for product ABC123?"
"Get product information for knockdown houses"

Purchase Management:

"Show me recent purchase orders"
"List all vendors/suppliers"
"Get purchase analytics for this month"
"Find vendor information for Company XYZ"

Manufacturing:

"Show manufacturing orders in progress"
"Get BOM information for product DEF456"
"What's the current production planning?"
"Show me all work centers and their capacity"

🏗️ Available Tools

Inventory Tools - ข้อมูลสินค้าและสต๊อก

• get_inventory_levels - ดูระดับสต๊อกปัจจุบัน
• get_product_info - ข้อมูลสินค้าแบบละเอียด
• create_inventory_adjustment - ปรับปรุงสต๊อก (กำลังพัฒนา)

Purchase Tools - การจัดซื้อ

• get_purchase_orders - ดูใบสั่งซื้อ
• create_purchase_order - สร้างใบสั่งซื้อใหม่
• get_vendor_info - ข้อมูลผู้ขาย/ซัพพลายเออร์
• get_purchase_analytics - รายงานการจัดซื้อ

MRP Tools - การผลิต

• get_manufacturing_orders - ดูใบสั่งผลิต
• get_bom_info - ข้อมูล Bill of Materials
• create_manufacturing_order - สร้างใบสั่งผลิต
• get_work_centers - ข้อมูลศูนย์การทำงาน
• get_production_planning - แผนการผลิต

🔧 Architecture

Claude (Cursor) ←→ MCP Protocol ←→ Go Server ←→ Odoo XML-RPC API
                                              ↓
                                         PostgreSQL DB

📊 Perfect for Knock-Down Business

This MCP server is especially designed for businesses dealing with:

• Knock-down houses/buildings (บ้านน็อคดาวน์)
• Knock-down furniture/cabinets (ตู้น็อคดาวน์)
• Modular construction products
• Assembly-required products

Business Use Cases

• Inventory Planning: "How many 3x4 meter house frames do we have in stock?"
• Purchase Planning: "Create a purchase order for cabinet hardware from Supplier ABC"
• Production Scheduling: "What's our manufacturing schedule for next week?"
• Vendor Management: "Show me all suppliers for steel components"

🚦 Status & Roadmap

✅ Completed

• Basic MCP protocol implementation
• Odoo XML-RPC integration
• Core inventory, purchase, and MRP tools
• Configuration management
• Error handling and logging

🔄 In Progress

• Enhanced BOM component listing
• Full purchase order creation workflow
• Complete manufacturing order creation
• Direct PostgreSQL queries for performance

📋 Planned

• Sales order management
• Accounting integration
• Advanced analytics and dashboards
• Multi-company support
• Custom field mapping

🤝 Contributing

Feel free to contribute! This is designed to be a comprehensive Odoo MCP integration.

📝 License

MIT License - Use freely for your business automation needs!

เพื่อธุรกิจของคุณแอ๋ม - From your programming buddy! 🎪 # odoo-mcp-server