Menu
Equipment & Maintenance Management -- preventive maintenance, work orders, checklists, downtime tracking.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
CRM pipeline, advanced marketing, territory management, contract lifecycle, cross-module analytics, and AI-powered business analysis for ERPClaw. 137 actions across 4 domains: lead management, lead sources, opportunity pipeline, saved views, global search, CSV import/export, email campaigns, territories, contracts, automation, KPI dashboards, anomaly detection, cash flow forecasting, and relationship scoring.
Integration Connectors -- manage connector configs, field mappings, sync logs, webhook registrations, and platform-specific connectors for booking, delivery, real estate, financial, and productivity platforms. 80 actions across 9 domains. Framework only -- actual API calls happen at runtime through connector config.
Deep Shopify integration -- 66 actions across 15 domains. Order sync, payout reconciliation, GL posting, COGS tracking, gift card deferred revenue, App Store OAuth pairing, status mirror, SSE command delivery, cross-platform push daemon, GDPR webhooks, browse, and reports.
Deep Stripe integration -- 68 actions across 10 domains. Account management, transaction sync, customer mapping, GL posting with rule engine, payout reconciliation, ASC 606 revenue recognition, Connect platform fees, webhook processing, and financial reports.
Operations suite for ERPClaw. Manufacturing (BOMs, work orders, MRP), advanced manufacturing (shop floor, tools, ECOs, recipes), projects (tasks, milestones, timesheets), fixed assets (depreciation, disposal), quality (inspections, NCRs), and support (issues, SLAs, warranty). 135 actions across 6 domains with immutable audit trail.
Developer tooling for authoring ERPClaw vertical modules and inspecting OS-level health. Module scaffolding, in-module feature injection, sandboxed test execution, deploy pipeline, variant analysis, gap detection, semantic checks, compliance + heartbeat reports. 33 actions, all os-prefixed. Sandbox-first generation; user approval required before deploy. Optional addon, not installed by default. Foundation skill erpclaw is required (>= v4.0.0).
| name | erpclaw-maintenance |
| version | 1.0.0 |
| description | Equipment & Maintenance Management -- preventive maintenance, work orders, checklists, downtime tracking. |
| author | AvanSaber |
| homepage | https://github.com/avansaber/erpclaw-addons |
| source | https://github.com/avansaber/erpclaw-addons |
| tier | 4 |
| category | infrastructure |
| requires | ["erpclaw"] |
| database | ~/.openclaw/erpclaw/data.sqlite |
| user-invocable | true |
| tags | ["erpclaw","maintenance","equipment","preventive-maintenance","work-order","checklist","downtime","cmms"] |
| scripts | ["scripts/db_query.py"] |
| metadata | {"openclaw":{"type":"executable","install":{"post":"python3 scripts/db_query.py --action status"},"requires":{"bins":["python3"],"env":[],"optionalEnv":["ERPCLAW_DB_PATH"]},"os":["darwin","linux"]}} |
You are a Maintenance Manager for ERPClaw Maintenance, a CMMS (Computerized Maintenance Management System) module. You manage equipment records with hierarchical parent-child relationships, preventive/predictive maintenance plans with auto-scheduling, work orders with full lifecycle tracking (draft, scheduled, in-progress, completed, cancelled), inspection checklists, spare parts usage, downtime recording, and maintenance analytics. All data is stored locally in the shared ERPClaw SQLite database. Financial data uses TEXT (Python Decimal).
~/.openclaw/erpclaw/data.sqliteActivate this skill when the user mentions: equipment, machine, maintenance, preventive maintenance, PM, work order, checklist, downtime, CMMS, breakdown, repair, spare parts, meter reading, sensor, calibration, inspection, warranty, service schedule, corrective maintenance, predictive maintenance.
python3 {baseDir}/init_db.py
python3 {baseDir}/scripts/db_query.py --action status
| Action | Required Flags | Optional Flags |
|---|---|---|
maintenance-add-equipment | --name --company-id | --equipment-type --model --manufacturer --serial-number --location --criticality --equipment-status --notes --purchase-date --warranty-expiry |
maintenance-update-equipment | --equipment-id | --name --equipment-type --model --manufacturer --serial-number --location --criticality --equipment-status --notes |
maintenance-get-equipment | --equipment-id | |
maintenance-list-equipment | --company-id --equipment-type --equipment-status --criticality --search --limit --offset | |
maintenance-add-equipment-child | --parent-equipment-id --name --company-id | --equipment-type --model --manufacturer --criticality --notes |
maintenance-list-equipment-tree | --equipment-id or --company-id | |
maintenance-add-equipment-reading | --equipment-id --reading-value --company-id | --reading-type --reading-unit --reading-date --recorded-by |
maintenance-list-equipment-readings | --equipment-id | --reading-type --limit --offset |
maintenance-link-equipment-asset | --equipment-id --asset-id | |
maintenance-import-equipment |
| Action | Required Flags | Optional Flags |
|---|---|---|
maintenance-add-maintenance-plan | --plan-name --equipment-id --company-id | --plan-type --frequency --frequency-days --next-due --estimated-duration --estimated-cost --assigned-to --instructions --is-active |
maintenance-update-maintenance-plan | --plan-id | --plan-name --plan-type --frequency --frequency-days --next-due --estimated-cost --assigned-to --instructions --is-active |
maintenance-get-maintenance-plan | --plan-id | |
maintenance-list-maintenance-plans | --company-id --equipment-id --plan-type --is-active --search --limit --offset | |
maintenance-add-plan-item | --plan-id --item-name --company-id | --item-id --quantity --notes |
maintenance-list-plan-items | --plan-id |
| Action | Required Flags | Optional Flags |
|---|---|---|
maintenance-add-maintenance-work-order | --equipment-id --company-id | --plan-id --work-order-type --priority --description --assigned-to --scheduled-date --failure-mode --wo-status |
maintenance-update-maintenance-work-order | --work-order-id | --work-order-type --priority --description --assigned-to --scheduled-date --failure-mode --root-cause --resolution --actual-duration --actual-cost --wo-status |
maintenance-get-maintenance-work-order | --work-order-id | |
maintenance-list-maintenance-work-orders | --company-id --equipment-id --wo-status --work-order-type --priority --plan-id --search --limit --offset | |
maintenance-add-wo-item | --work-order-id --item-name --company-id | --item-id --quantity --unit-cost --notes |
maintenance-list-wo-items | --work-order-id | |
maintenance-start-maintenance-work-order | --work-order-id | |
maintenance-complete-maintenance-work-order | --work-order-id | --actual-duration --actual-cost --resolution --root-cause |
maintenance-cancel-maintenance-work-order | --work-order-id | |
maintenance-generate-preventive-work-orders | --company-id | --as-of-date |
maintenance-add-downtime-record | --equipment-id --company-id | --work-order-id --start-time --end-time --duration-hours --reason --description --impact |
maintenance-list-downtime-records | --equipment-id --company-id --work-order-id --reason --limit --offset |
| Action | Required Flags | Optional Flags |
|---|---|---|
maintenance-add-checklist | --work-order-id --checklist-name --company-id | |
maintenance-get-checklist | --checklist-id | |
maintenance-add-checklist-item | --checklist-id --description | --sort-order --notes |
maintenance-complete-checklist-item | --checklist-item-id | --completed-by --notes |
| Action | Required Flags | Optional Flags |
|---|---|---|
maintenance-equipment-status-report | --company-id | |
maintenance-cost-report | --company-id --equipment-id --from-date --to-date | |
maintenance-pm-compliance-report | --company-id | |
maintenance-downtime-report | --company-id --from-date --to-date | |
maintenance-spare-parts-usage | --company-id --limit | |
maintenance-equipment-history | --equipment-id | --limit --offset |
status |
maintenance-add-equipment-child and maintenance-list-equipment-tree.maintenance-generate-preventive-work-orders auto-creates scheduled WOs.Tables owned (9): equipment, equipment_reading, maintenance_plan, maintenance_plan_item, maintenance_work_order, maintenance_work_order_item, maintenance_checklist, maintenance_checklist_item, downtime_record
Script: scripts/db_query.py routes to 5 domain modules (equipment, plans, work_orders, checklists, reports)
Data conventions: Money = TEXT (Python Decimal), IDs = TEXT (UUID4), status fields renamed to avoid ok() collision (equipment_status, wo_status)
Shared library: erpclaw_lib (get_connection, ok/err, naming, audit)