erpclaw-projects for Openclaw

A comprehensive project management and time-tracking engine for the ERPClaw ecosystem.

mailnike
v1.0.0
Feb 26, 2026
0
0
0

Install & Download

1. ClawHub CLI

The fastest way to install a skill directly from the registry.

npx clawhub@latest install erpclaw-projects

2. Manual Installation

Copy the skill folder to one of these locations

Global
~/.openclaw/skills/
Workspace
<project>/skills/

Priority: Workspace > Local > Bundled

3. Prompt Installation

Copy this prompt to OpenClaw to install it automatically.

Help me install erpclaw-projects 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-projects?

erpclaw-projects is a specialized tool within the Openclaw Skills ecosystem designed to handle the complexities of project lifecycles, from initial task breakdown to final timesheet billing. It functions as an AI-native Project Manager, allowing developers and managers to track work through a secure, local-only SQLite database without relying on external cloud services.

This skill bridges the gap between technical execution and business accountability by managing projects, milestones, and resource utilization. Whether handling internal company work or billable consulting projects, it provides an immutable audit trail and detailed reporting capabilities directly through the Openclaw interface.

erpclaw-projects Use Cases

  • Creating and tracking multi-phase projects with specific start and end dates.
  • Assigning tasks to employees with priority levels and estimated hours.
  • Setting project milestones to visualize deliverables and timelines.
  • Logging billable hours via a multi-stage timesheet lifecycle including draft, submitted, and billed states.
  • Generating project profitability and resource utilization reports to optimize team performance.

How erpclaw-projects Works

  1. The user triggers the skill by mentioning project, task, or timesheet related keywords.
  2. The skill interacts with the local data.sqlite database using parameterized Python scripts to ensure SQL injection safety.
  3. Projects and tasks are generated with unique naming series like PROJ-YEAR-SEQUENCE via a shared naming library.
  4. Employees log hours against specific tasks, which are aggregated into structured timesheets.
  5. The system calculates costs and billing amounts based on defined rates, facilitating real-time profitability analysis without external API calls.

erpclaw-projects Setup

To begin using this among your Openclaw Skills, ensure the database is initialized and dependencies are met:

# Initialize the database
python3 ~/.openclaw/erpclaw/init_db.py --db-path ~/.openclaw/erpclaw/data.sqlite

# Install required Python dependencies
pip install -r scripts/requirements.txt

erpclaw-projects Data Schema & Taxonomy

The skill manages five core tables within the SQLite database to maintain data integrity and an immutable audit trail:

Table Description Key Fields
project Main project records ID (UUID), Name, Status, Project Type
task Individual work items ID, Project ID, Assigned To, Priority, depends_on
milestone Key project deliverables ID, Project ID, Date, is_completed
timesheet Header for time logs ID, Employee ID, Status, Total Hours
timesheet_detail Individual time entries Timesheet ID, Task ID, Hours, Billing Rate

All financial amounts are stored as TEXT to utilize Python Decimal precision, ensuring accuracy in billing calculations.

erpclaw-projects Advanced Features

  • Task Dependency Mapping: Link tasks to create complex work breakdown structures that feed into Gantt chart data.
  • Comprehensive Reporting: Access built-in actions for project profitability, resource utilization, and real-time status dashboards.
  • Secure Local Storage: Operates entirely offline with no cloud dependencies, keeping sensitive project data on your local machine.
  • Inter-Skill Coordination: Integrates with erpclaw-hr for employee data and erpclaw-gl for cost center tracking.
  • Automated Naming Series: Uses a shared library to maintain consistent naming conventions across projects, tasks, and timesheets.

SKILL.md


Loading

Related Openclaw Skills

METADATA

Requires
Bins python3
Github Stars: 0
forks: 0

Featured*