erpclaw-maintenance

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).

Security Model

Local-only: All data stored in ~/.openclaw/erpclaw/data.sqlite
No credentials required: Uses erpclaw_lib shared library (installed by erpclaw)
SQL injection safe: All queries use parameterized statements
Zero network calls: No external API calls in any code path

Skill Activation Triggers

Activate 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.

Setup (First Use Only)

python3 {baseDir}/init_db.py
python3 {baseDir}/scripts/db_query.py --action status

Actions (Tier 1 -- Quick Reference)

Equipment (10 actions)

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`

Maintenance Plans (6 actions)

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`

Work Orders (12 actions)

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`

Checklists (4 actions)

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`

Reports (7 actions)

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`

Key Concepts (Tier 2)

Equipment Hierarchy: Parent-child relationships for sub-assemblies. Use maintenance-add-equipment-child and maintenance-list-equipment-tree.
Preventive Maintenance: Plans with frequency (daily to annual). maintenance-generate-preventive-work-orders auto-creates scheduled WOs.
Work Order Lifecycle: draft -> scheduled -> in_progress -> completed/cancelled. Starting a WO sets equipment to maintenance; completing restores to operational.
Checklists: Attach step-by-step inspection lists to work orders. Track completion per item.
Downtime Tracking: Record equipment downtime with reason codes. Reports show total hours per equipment.
Naming Prefixes: EQP- (equipment), MPL- (plans), MWO- (work orders).

Technical Details (Tier 3)

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)