constructclaw

name: constructclaw version: 1.0.0 description: Construction Project Management -- 159 actions across 12 domains. Job costing, estimating, bids, subcontractors, AIA billing, SOV, daily reports, change orders, RFIs, submittals, safety/OSHA, project controls with earned value, field ops, and project management. author: AvanSaber homepage: https://github.com/avansaber/constructclaw source: https://github.com/avansaber/constructclaw tier: 3 category: construction requires: [erpclaw] database: ~/.openclaw/erpclaw/data.sqlite user-invocable: true tags: [erpclaw, construction, job-costing, estimating, subcontractors, billing, safety, rfi, change-orders, earned-value, aia, osha, lien-waiver, prevailing-wage, wip, punch-list, submittal, field-ops] 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"]}}

constructclaw

Construction Project Manager for ConstructClaw -- comprehensive construction management on ERPClaw. Covers job costing, estimating, bids, subcontractor management, AIA progress billing, daily field reports, change orders (PCO/CCO), RFIs, submittals, safety/OSHA compliance, earned value management, field operations, and project portfolio management. All data in shared ERPClaw database.

Skill Activation Triggers

Activate when user mentions: construction, job costing, cost code, estimate, bid, subcontractor, pay application, lien waiver, schedule of values, SOV, progress bill, AIA billing, daily report, field report, change order, PCO, CCO, RFI, submittal, safety incident, OSHA, toolbox talk, earned value, CPI, SPI, project controls, WIP report, retention, retainage, punch list, prevailing wage, Davis-Bacon, certified payroll, equipment, permit, warranty, milestone.

Setup

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

Quick Start

--action construction-add-job --company-id {id} --name "Main St Office" --contract-amount "2500000.00"
--action construction-add-cost-code --company-id {id} --job-id {id} --code "03-100" --category labor --budget-amount "50000.00"
--action construction-add-subcontract --company-id {id} --job-id {id} --subcontractor-name "ABC Electric" --original-amount "150000.00"
--action construction-add-schedule-of-values --company-id {id} --job-id {id} --name "AIA G703"
--action construction-add-progress-bill --company-id {id} --job-id {id} --sov-id {id}
--action construction-submit-progress-bill --progress-bill-id {id}

All 159 Actions

Jobs & Cost Management (15 actions)

Estimating & Bids (13 actions)

Subcontractors (16 actions)

Billing & Retention (14 actions)

Daily Reports (10 actions)

Change Orders (10 actions)

RFIs & Submittals (10 actions)

Safety & OSHA (14 actions)

Project Controls (8 actions)

Field Operations (18 actions)

Project Management (18 actions)

Reports (13 actions)

Technical Details (Tier 3)

Tables (27): All use constructclaw_ prefix. Script: scripts/db_query.py routes to 12 modules. Data: Money=TEXT(Decimal), IDs=TEXT(UUID4). Prefixes: CCJOB-, CCEST-, CCBID-, CCSUB-, CCPA-, CCSOV-, CCPB-, CCDR-, CCPCO-, CCCCO-, CCRFI-, CCSUBM-, CCINC-.