Inventory Analysis MCP Server

An MCP (Model Context Protocol) server that connects to Odoo ERP to provide comprehensive inventory analysis, forecasting, and reporting capabilities.

Features

1. Stock Levels & Reorder Points

• Current stock levels with status classification (out of stock, critical, low, normal, overstock)

• Reorder alerts based on stock levels and reorder rules

• Days of stock calculations

• Stock summary statistics

2. Demand Forecasting

• Multiple forecasting methods:

  • Moving Average

  • Exponential Smoothing

  • Linear Regression

  • Holt-Winters (for seasonal data)

  • Auto-selection (best method based on data)

• Trend detection (increasing, decreasing, stable)

• Seasonality detection

• Confidence intervals for predictions

• Accuracy metrics (MAE, RMSE, MAPE)

3. ABC/XYZ Analysis

• ABC Classification (by annual consumption value):

  • A: High value items (~20% of items, ~80% of value)

  • B: Medium value items (~30% of items, ~15% of value)

  • C: Low value items (~50% of items, ~5% of value)

• XYZ Classification (by demand variability):

  • X: Stable demand (CV < 0.5)

  • Y: Variable demand (0.5 <= CV < 1.0)

  • Z: Highly unpredictable demand (CV >= 1.0)

• Combined matrix with management recommendations

4. Turnover & Aging Reports

• Turnover Analysis:

  • Turnover ratio calculation

  • Days of inventory

  • Classification: fast-moving, normal, slow-moving, dead stock

• Aging Analysis:

  • Inventory age buckets (0-30, 31-60, 61-90, 91-180, 181-365, >365 days)

  • Obsolescence risk assessment

  • Slow-moving and high-risk item identification

Installation

Prerequisites

• Python 3.10 or higher

• Access to an Odoo instance (v14+)

Setup

1. Clone or download this repository

2. Install dependencies:

   cd inventory_mcp_server pip install -e .

   Or using requirements.txt:

   pip install -r requirements.txt

3. Configure Odoo connection:

   cp .env.example .env # Edit .env with your Odoo credentials

Configuration

Environment Variables

Claude Desktop Configuration

Add to your claude_desktop_config.json:

Or using uv:

Available Tools

Stock Level Tools

Forecasting Tools

ABC/XYZ Tools

Turnover & Aging Tools

Usage Examples

Get Stock Alerts

Forecast Demand

ABC/XYZ Analysis

Identify Problem Stock

Odoo Requirements

The server requires the following Odoo modules:

• stock (Inventory)

• product (Products)

Optional for full functionality:

• purchase (for reorder rules)

• sale (for sales history)

Required Odoo User Permissions

• Read access to:

  • product.product

  • product.category

  • stock.quant

  • stock.move

  • stock.location

  • stock.warehouse.orderpoint

Development

Running Tests

Code Formatting

Type Checking

License

MIT License