# 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
```bash
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:

```bash
cp config.yaml.example config.yaml
vim config.yaml
```

The config should contain:
```yaml
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
```bash
./build.sh
```

### 4. Test Connection
```bash
# 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`:

```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