OEE Enterprise Agent

MCP-based production monitoring agent for manufacturing OEE (Overall Equipment Effectiveness). Connects to SQL Server, MES APIs, and incident management systems.

Overview

This agent provides real-time OEE monitoring (Availability, Performance, Quality), downtime root-cause analysis, shift performance benchmarking, and automated alerts when thresholds are breached.

Related MCP server: CMMS MCP Server

Architecture

SQL MCP Server  ──┐
MES REST API    ──┼──►  OEE Enterprise Agent  ──►  Teams Alerts
Incident Mgmt   ──┘                              ──►  Jira/ServiceNow

Quick Start

npm install
npm run init        # Initialize SQLite database
npm run populate    # Generate sample test data
npm run query:7day  # Show 7-day OEE report
npm run query:kpi   # Show real-time KPI dashboard

Scripts

Tools

• query_daily_oee — OEE metrics by line/date/shift

• get_downtime_analysis — Downtime RCA grouped by reason

• send_alert — Send Teams alert to engineers

• create_ticket — Create Jira/ServiceNow incident

• call_mes_api — Fetch machine alarms and line status

• notify_shift_lead — Send shift summary

Configuration

Copy .env.example to .env and configure:

SQL_SERVER=localhost\SQLEXPRESS
SQL_DATABASE=OEE_PROD

Data Source

By default, the agent uses a local JSON-based store (oee-production.db.json). For production, configure the SQL MCP server to connect to your SQL Server instance.

License

MIT