skills.rest
pypeaday
pypeadayCOMMUNITY
Explore all skills by this author →
Website𝕏@pypeadayGitHub

progress-tracker

Track long-running task progress in SQLite via a Python CLI.

2|Updated Jun 29, 2021
Search Tags:#SQLite#blockers#handoff#notes#task-management#progress-tracking
One-click install
npx skills add https://github.com/pypeaday/dotfiles --skill progress-tracker-pypeaday
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: progress-tracker
Source: https://github.com/pypeaday/dotfiles/tree/main/opencode/.config/opencode/skill/progress-tracker
Command: npx skills add https://github.com/pypeaday/dotfiles --skill progress-tracker-pypeaday

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sqlite-utils>=3.35.

What problem does it solve?

This Skill helps teams manage long-running tasks by using a SQLite database to track progress, notes, and handoff context across agent sessions.

Core Features & Use Cases

  • Session-based task tracking: Create, update, and monitor tasks with statuses (pending, in_progress, done, blocked) and priority.
  • Context and handoff: Generate a handoff view with the last notes, blockers, and recent decisions to inform the next agent.
  • Queryable insights: Store notes, decisions, and context in relational tables for audits and reporting.
  • Use Case: Imagine a long-running data migration; you can add tasks, attach progress notes, set blockers, and export a status summary for the next team member.

Quick Start

Initialize the tracker and begin a session:

  1. uv run .agent/tracker.py init
  2. uv run .agent/tracker.py add "Migrate users table" --priority high
  3. uv run .agent/tracker.py start 1
  4. uv run .agent/tracker.py note 1 "Started migration script with batch processing"

Frequently Asked Questions about progress-tracker

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I track progress and blockers for long-running tasks in SQLite?▼

Maintain context for long-running tasks by generating a handoff view in SQLite that includes the last notes, blockers, and recent decisions. This relational storage ensures the next agent or team member receives full situational awareness.

How do I manage task status and priority for engineering workflows using a Python CLI?▼

Manage task status and priority using a Python CLI to execute SQL operations via sqlite-utils. You can create tasks, update statuses like pending or blocked, and attach progress notes directly from the command line.

What's the best way to maintain handoff context across agent sessions for data migrations?▼

Maintain context for long-running tasks by generating a handoff view in SQLite that includes the last notes, blockers, and recent decisions. This relational storage ensures the next agent or team member receives full situational awareness.

Does progress tracking with sqlite-utils support deterministic updates and simple schemas?▼

Progress tracking with sqlite-utils supports deterministic updates through a simple relational schema. It stores tasks, notes, and decisions in queryable tables, satisfying requirements for reliable status reporting and audits.

Can I query notes and decisions stored in SQLite for task audits and reporting?▼

You can query notes and decisions stored in SQLite relational tables for task audits and reporting. The simple schema allows direct SQL operations to extract insights on session-based work and historical progress.

Related Skills

Explore More Software Engineering Skills→
oakossoakoss
14

trekker

Manage AI agent tasks and session state via SQLite CLI commands.

Official
Advanced
pwnk77pwnk77
59

Progress Tracker

Track task completion and generate automated project status reports.

Community
Intermediate
justinsenseijustinsensei
1

obsidian-ingest-log

Log new Obsidian vault inputs and update project notes via Python scripts.

Community
Advanced
NVIDIA-TAONVIDIA-TAO
83

REPLACE-WITH-PLATFORM-NAME

Automate GPU job deployment on REPLACE-PLATFORM via APIs and Docker.

Official
Intermediate