A read-only analytics engine for ERPClaw that computes cross-module KPIs, financial ratios, and executive dashboards.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install erpclaw-analytics
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install erpclaw-analytics using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is erpclaw-analytics?
erpclaw-analytics acts as a virtual Business Analyst and KPI Specialist for the ERPClaw ecosystem. It is designed to bridge the gap between raw data and actionable insights by synthesizing information across multiple modules such as General Ledger, HR, Inventory, and Sales. As a specialized part of Openclaw Skills, it provides a unified view of business performance without ever writing to the database, ensuring 100% data integrity.
The skill is built with a privacy-first approach, operating fully offline and locally on your machine. It features a unique graceful degradation system: if optional modules like erpclaw-inventory or erpclaw-hr are missing, the skill continues to function, providing partial results and clear notifications rather than failing. This makes it a robust choice for growing businesses that need scalable analytics within their Openclaw Skills environment.
erpclaw-analytics Use Cases
- Monitoring real-time executive dashboards to track overall company health.
- Calculating essential financial ratios including liquidity, profitability, and efficiency metrics.
- Analyzing revenue trends, customer concentration, and top-performing items.
- Tracking operational efficiency through inventory turnover and aging analysis.
- Evaluating workforce metrics such as headcount analytics, payroll trends, and leave utilization.
How erpclaw-analytics Works
- The skill identifies the available ERPClaw modules by checking the local environment and dependencies.
- It connects to the local SQLite database in a strict read-only mode to ensure security.
- Upon user request, it executes parameterized SQL queries to gather data across the General Ledger and any installed optional modules.
- It processes raw data into calculated KPIs, financial ratios, or trend reports using the Python standard library.
- The results are formatted into clean, developer-friendly Markdown tables or JSON objects for immediate review.
erpclaw-analytics Setup
Ensure that erpclaw-setup and erpclaw-gl are already installed in your Openclaw Skills environment. To verify the installation and see which analytics modules are currently active based on your installed skills, run the following command:
python3 scripts/db_query.py --action status
You can also specify a custom database path if necessary by setting the ERPCLAW_DB_PATH environment variable.
erpclaw-analytics Data Schema & Taxonomy
The erpclaw-analytics skill does not own any tables and performs zero database writes. It consumes data from the following core and optional structures:
| Source Module | Tables Consumed |
|---|---|
| erpclaw-gl | account, gl_entry, fiscal_year, cost_center |
| erpclaw-selling | customer, sales_invoice, item |
| erpclaw-inventory | stock_ledger_entry, warehouse, item |
| erpclaw-hr | employee, leave_application, payroll_entry |
All numerical output follows strict formatting: Currencies use the $X,XXX.XX format, ratios are rounded to 2 decimal places, and percentages are shown with 1 decimal place.
erpclaw-analytics Advanced Features
- Graceful Degradation: Automatically skips metrics for missing modules without crashing the dashboard.
- Multi-Period Comparison: Supports comparing current performance against historical data via JSON-based period configurations.
- Company Scorecard: Generates letter grades for different business segments to provide an at-a-glance health check.
- Executive Shortcuts: Includes built-in sub-skills like
/erp-dashboardand/erp-scorecardfor rapid data retrieval. - Zero-Trust Security: Operates with 100% local data, no external API calls, and no telemetry, maintaining the privacy standards expected of Openclaw Skills.
SKILL.md
Loading
Related Openclaw Skills
ERPClaw AI Engine
An AI-powered business analyst that provides anomaly detection, cash flow forecasting, and relationship scoring for ERPClaw.
educlaw
An AI-native Student Information System (SIS) for managing the full academic lifecycle with built-in FERPA and COPPA compliance.
EduClaw State Reporting
A comprehensive management tool for K-12 state reporting, Ed-Fi integration, and data validation using Openclaw Skills.
EduClaw Advanced Scheduling
A comprehensive scheduling engine for educational institutions that automates master schedule creation, conflict resolution, and resource allocation.
ERPClaw Assets
An AI-native fixed asset management skill for tracking depreciation, maintenance, and asset lifecycles within the ERPClaw ecosystem.
ERPClaw Billing Skill
An AI-native billing analyst skill for managing metered usage, tiered pricing, and automated billing cycles within the ERPClaw ecosystem.
METADATA
Featured*
