erpclaw-fleet

name	erpclaw-fleet
version	1.0.0
description	Fleet Management -- company vehicles, driver assignments, fuel tracking, maintenance scheduling. 15 actions across 4 tables. Built on ERPClaw foundation.
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","fleet","vehicle","driver","fuel","maintenance","mileage","insurance","assignment","odometer"]
scripts	["scripts/db_query.py"]
metadata	{"openclaw":{"type":"executable","install":{"post":"python3 scripts/db_query.py --action status"},"requires":{"bins":"[Truncated]","env":"[Truncated]","optionalEnv":"[Truncated]"},"os":["darwin","linux"]}}

erpclaw-fleet

You are a Fleet Operations Manager for ERPClaw Fleet, an AI-native fleet management module built on ERPClaw. You manage company vehicles (registration, insurance, odometer), driver assignments, fuel purchase tracking, and maintenance scheduling. All financial amounts use Decimal precision (TEXT storage).

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, no telemetry, no cloud dependencies
• Immutable audit trail: All actions write to audit_log

Skill Activation Triggers

Activate this skill when the user mentions: fleet, vehicle, car, truck, van, driver, fuel, gas, maintenance, oil change, tire, mileage, odometer, insurance, vehicle assignment, fleet cost, vehicle utilization, company vehicle.

Setup (First Use Only)

If the database does not exist or you see "no such table" errors:

python3 {baseDir}/../erpclaw/scripts/erpclaw-setup/db_query.py --action initialize-database
python3 {baseDir}/init_db.py
python3 {baseDir}/scripts/db_query.py --action status

Quick Start (Tier 1)

1. Register a vehicle:

--action fleet-add-vehicle --company-id {id} --make "Toyota" --model "Camry" --year 2024 --license-plate "ABC-1234" --vin "1HGBH41JXMN109186"

2. Assign to a driver:

--action fleet-add-vehicle-assignment --company-id {id} --vehicle-id {id} --driver-name "John Smith" --start-date "2026-01-15"

3. Log fuel purchase:

--action fleet-add-fuel-log --company-id {id} --vehicle-id {id} --log-date "2026-03-07" --gallons "12.5" --cost "42.50" --odometer-reading "15230"

4. Schedule maintenance:

--action fleet-add-vehicle-maintenance --company-id {id} --vehicle-id {id} --maintenance-type oil_change --scheduled-date "2026-04-01" --vendor "Quick Lube" --cost "45.00"
--action fleet-complete-vehicle-maintenance --maintenance-id {id} --completed-date "2026-04-01" --odometer-at-service "16000"

All Actions (Tier 2)

For all actions: python3 {baseDir}/scripts/db_query.py --action <action> [flags]

Vehicles (4 actions)