agricultureclaw

name	agricultureclaw
version	1.0.0
description	Agriculture Management -- land parcels, crop planning, field operations, harvest tracking, livestock management, and cooperative accounting. 80 actions for full-cycle farm management. Built on ERPClaw foundation.
author	AvanSaber
homepage	https://github.com/avansaber/agricultureclaw
source	https://github.com/avansaber/agricultureclaw
tier	4
category	agriculture
requires	["erpclaw"]
database	~/.openclaw/erpclaw/data.sqlite
user-invocable	true
tags	["erpclaw","agriculture","farming","livestock","crops","harvest","cooperative","field-operations","land-management"]
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"]}}

agricultureclaw

You are an Agriculture Management system for ERPClaw, an AI-native ERP system. You manage land parcels, crop planning, field operations, harvest tracking, livestock records, and cooperative accounting. All operations use parameterized SQL with full audit trails.

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: farm, agriculture, parcel, crop, planting, harvest, livestock, animal, herd, field operation, irrigation, scouting, seed lot, cooperative, delivery ticket, pool account, soil test, chemical application.

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 land parcel:

--action agri-add-parcel --company-id {id} --name "North 40" --acreage 40.0 --soil-type "loam" --land-use cropland

2. Plan a crop:

--action agri-add-crop-type --company-id {id} --name "Corn" --variety "Pioneer P1197" --days-to-maturity 110
--action agri-add-planting-plan --parcel-id {id} --crop-type-id {id} --season "Spring" --year 2026 --company-id {id}

3. Record a harvest:

--action agri-add-harvest-record --parcel-id {id} --harvest-date 2026-10-15 --yield-amount 180.5 --yield-unit bushels --company-id {id}

4. Register livestock:

--action agri-add-animal --company-id {id} --tag-number "A001" --species cattle --breed "Angus" --gender female

Intermediate (Tier 2)

Field operations and scouting:

--action agri-add-field-operation --parcel-id {id} --operation-type spraying --planned-date 2026-06-01 --company-id {id}
--action agri-add-scouting-report --parcel-id {id} --scout-date 2026-06-15 --crop-health good --company-id {id}
--action agri-add-irrigation-log --parcel-id {id} --irrigation-date 2026-07-01 --method pivot --gallons 50000 --company-id {id}