name: task-manager description: Manage tasks in SQLite database. Use for adding, listing, completing, or blocking tasks. Triggers on task management, todo operations, or heartbeat task processing.
Task Manager
SQLite-backed task management at ~/workspace/data/tasks.db.
Status Legend
| Mark | Status | Meaning |
|---|---|---|
[~] |
BACKLOG | Not ready, waiting to be prioritized |
[ ] |
READY | Actionable now |
[*] |
IN-PROGRESS | Currently working |
[x] |
COMPLETED | Done |
[!] |
BLOCKED | Cannot proceed (has dependencies) |
CLI Commands
All commands use: bun ~/workspace/skills/task-manager/scripts/db-tasks.js
List Tasks
bun ~/workspace/skills/task-manager/scripts/db-tasks.js list [filter]
Filters: backlog, ready, in-progress, completed, blocked, all (default)
Add Task
bun ~/workspace/skills/task-manager/scripts/db-tasks.js add "<task description>" [backlog|ready]
Status defaults to backlog (recommended for new tasks).
Update Task Status
bun ~/workspace/skills/task-manager/scripts/db-tasks.js update "<pattern>" <status>
Statuses: backlog, ready, in-progress, completed, blocked
Complete Task
bun ~/workspace/skills/task-manager/scripts/db-tasks.js complete "<pattern>"
Marks matching task as completed.
Delete Task
bun ~/workspace/skills/task-manager/scripts/db-tasks.js delete "<pattern>"
Count Tasks
bun ~/workspace/skills/task-manager/scripts/db-tasks.js count
Returns: Backlog: N | Ready: N | In Progress: N | Completed: N | Blocked: N
Heartbeat Integration
- Run
list readyto get actionable tasks - Research the task before starting (use documentation, search, or browser automation as needed)
- If unclear or missing prerequisites:
update "<task>" blockedand add a work note explaining why - If clear: update to
in-progresswhen starting - On success:
complete "<task>" - On failure:
update "<task>" blocked
Architecture
- Database:
~/workspace/data/tasks.db(SQLite with WAL mode) - CLI:
skills/task-manager/scripts/db-tasks.js - Dashboard API:
moltboard/src/app/api/tasks/route.ts
Cron Jobs
Set up using MoltBot cron. See MoltBot Cron Jobs documentation.
Task Worker (every 3 minutes)
moltbot cron add "moltboard-worker" "*/3 * * * *" \
"./skills/task-manager/scripts/cron-worker.sh"
Picks up Ready tasks and processes them one at a time.
Project Sync (every 15 minutes)
moltbot cron add "moltboard-sync" "*/15 * * * *" \
"bun ./skills/task-manager/scripts/project-sync-cron.js"
Syncs GitHub issues for projects with github_repo_url configured.
Migration
If migrating from todo.md:
bun ~/workspace/scripts/init-db.js # Initialize database
bun ~/workspace/scripts/migrate-tasks.js # Import from todo.md