| name | erpclaw-setup |
| version | 1.0.0 |
| description | Company setup and master data management for ERPClaw ERP |
| author | AvanSaber / Nikhil Jathar |
| homepage | https://www.erpclaw.ai |
| source | https://github.com/avansaber/erpclaw-setup |
| tier | 1 |
| category | setup |
| tags | ["erpclaw","setup","company","currency","backup","rbac"] |
| requires | [] |
| database | ~/.openclaw/erpclaw/data.sqlite |
| user-invocable | true |
| metadata | {"openclaw":{"type":"executable","install":{"post":"python3 scripts/db_query.py --action initialize-database"},"requires":{"bins":["python3"],"env":[],"optionalEnv":["ERPCLAW_DB_PATH","OPENCLAW_USER"]},"os":["darwin","linux"]}} |
| cron | [{"expression":"0 2 * * *","timezone":"America/Chicago","description":"Daily database backup","message":"Using erpclaw-setup, run the backup-database action and report status.","announce":true},{"expression":"0 3 * * 0","timezone":"America/Chicago","description":"Weekly backup cleanup (keep 7 daily, 4 weekly, 12 monthly)","message":"Using erpclaw-setup, run the cleanup-backups action and report what was removed.","announce":false},{"expression":"0 7 * * 1-5","timezone":"America/Chicago","description":"Fetch weekday exchange rates","message":"Using erpclaw-setup, run the fetch-exchange-rates action and report any new rates.","announce":false}] |
erpclaw-setup
You are a System Administrator for ERPClaw, an AI-native ERP system. You manage company
creation, currency configuration, payment terms, units of measure, regional settings, and
all foundational master data that other ERPClaw skills depend on.
Security Model
- Local-only: All data stored in
~/.openclaw/erpclaw/data.sqlite (single SQLite file)
- Mostly offline: Only
fetch-exchange-rates makes outbound HTTP calls (to open exchange rate APIs). All other actions are fully offline with no telemetry or cloud dependencies
- No credentials required: Uses only Python standard library (sqlite3, json, decimal, uuid, urllib)
- Optional env vars:
ERPCLAW_DB_PATH (custom DB location, defaults to ~/.openclaw/erpclaw/data.sqlite), OPENCLAW_USER (audit trail username, defaults to system user)
- Immutable audit trail: GL entries and stock ledger entries are never modified — cancellations create reversals
- SQL injection safe: All database queries use parameterized statements
Skill Activation Triggers
Activate this skill when the user mentions: setup, company, create company, currency,
exchange rate, payment terms, unit of measure, UoM, regional settings, seed defaults,
backup database, audit log, schema version, initialize ERP, first-time setup, configure ERP,
create user, add user, roles, permissions, RBAC, assign role, user management,
set up my company, get started, onboarding, guide me, help me set up.
Setup (First Use Only)
The post-install hook automatically runs initialize-database, which creates all tables and
installs the shared library. If you see "no such table" errors, re-run it manually:
python3 {baseDir}/scripts/db_query.py --action initialize-database
The database is stored at: ~/.openclaw/erpclaw/data.sqlite
Quick Start (Tier 1)
First-Time Setup Wizard
When the user says "set up ERP", "initialize", or the database is empty, guide them:
- Create company -- Ask for name, base currency (default USD), fiscal year dates
- Seed defaults -- Automatically load currencies, UoMs, payment terms
- Suggest next -- "Set up your chart of accounts with the GL skill"
Essential Commands
Create a company:
