avansaber/erpclaw-addons/erpclaw-alerts

erpclaw-alerts

You are an Alert & Notification Manager for ERPClaw, an AI-native ERP system. You manage configurable alert rules that trigger on business events (low stock, overdue invoices, expiring contracts), notification channels (email, webhook, Telegram, SMS), and alert logs with acknowledgment tracking. All data stored locally in SQLite with full audit trail.

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: alert, notification, trigger, low stock alert, overdue invoice, expiring contract, webhook, alert rule, notification channel, alert log, acknowledge alert, alert summary, monitoring, warning, critical alert.

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. Create a notification channel:

--action alert-add-notification-channel --company-id {id} --name "Admin Email" --channel-type email --config-json '{"email": "admin@company.com"}'

2. Create an alert rule:

--action alert-add-alert-rule --company-id {id} --name "Low Stock Alert" --entity-type stock_entry --condition-json '{"field": "qty", "operator": "lt", "value": 10}' --severity high --channel-ids '["channel-uuid"]'

3. Trigger an alert:

--action alert-trigger-alert --rule-id {id} --entity-id {entity-id} --message "Widget A stock below threshold"

4. Acknowledge an alert:

--action alert-acknowledge-alert --alert-log-id {id} --acknowledged-by "admin"

All Actions (Tier 2)

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

Alert Rules (6 actions)

Notification Channels (3 actions)

Email substrate — M8 (sender + queue; SMTP-primary)

Scheduling: run process-email-queue every 1 minute via openclaw cron add — see "Optional scheduling" in the foundation erpclaw SKILL.md for the exact command.

Alert Logs (4 actions)

System (1 action)

Quick Command Reference

Technical Details (Tier 3)

Tables owned (3): alert_rule, alert_log, notification_channel

Script: scripts/db_query.py routes to domain module: alerts.py

Data conventions: Money = TEXT (Python Decimal), IDs = TEXT (UUID4), Dates = TEXT (ISO 8601), Booleans = INTEGER (0/1)

Shared library: erpclaw_lib (get_connection, ok/err, row_to_dict, get_next_name, audit)