Computer Usage Summary

Private local app, project, and billable reports

liuyewang

@liuyewang

What This Skill Does

Generates daily or custom-range summaries of computer activity on macOS, Windows, and Linux by querying local ActivityWatch records. Reports app usage time, foreground sessions, AFK periods, and timelines, with fallbacks to live-state snapshots or Screen Time when ActivityWatch data is unavailable.

Replaces manual time tracking and screen recording tools by automatically reconstructing what you did from privacy-preserving local activity logs.

When to Use It

  • Generate a daily activity log showing which apps and windows were used and for how long
  • Create a weekly or monthly app usage report for productivity analysis
  • Export a paste-ready spreadsheet of app time or timeline rows for billing or timesheets
  • Check how much time was spent AFK versus active during a work session
  • Pull a timeline of foreground sessions to reconstruct what you worked on yesterday
  • Produce a project- or client-billed breakdown using optional local rules for matching window titles

Install

$ openclaw skills install @liuyewang/computer-usage-summary

Computer Usage Summary

Overview

Use local ActivityWatch data first. This skill supports macOS, Windows, and Linux wherever the local ActivityWatch API and Python 3.9+ are available. The intended privacy-balanced setup records only foreground apps, sanitized window titles, and AFK state. Do not install browser extensions, enable aw-sync, configure cloud storage, or expose the local API.

Accurate historical app time and AFK time exist only from the time ActivityWatch starts recording. Do not infer them from process uptime, macOS system logs, browser history, or undocumented databases.

Setup And Verification

Use this section only when ActivityWatch is missing, stopped, or needs repair.

  1. Inspect the local ActivityWatch application, its startup setting, local processes, and the current user's ActivityWatch data directory. Do not replace a working installation.
  2. Let the user choose an official installation source. Before launching it or enabling automatic startup, verify the publisher and operating-system security status. On macOS, use codesign --verify --deep --strict and spctl --assess --type execute. Stop if validation fails unless the user explicitly decides otherwise.
  3. Enable only the window and AFK watchers. Let macOS request Accessibility permission through its normal interface; never bypass or change privacy permissions programmatically.
  4. On Windows, run python -m pip install tzdata once so Python can resolve IANA time zones such as Asia/Singapore consistently.
  5. Confirm the local http://127.0.0.1:5600 server has currentwindow and afkstatus buckets containing events. The default AFK threshold is 180 seconds.

No-ActivityWatch Fallback

When the app, local API, buckets, or requested-range events are unavailable:

  • Mark active time, AFK time, sessions, and launch counts as unavailable, not zero.
  • A current frontmost-app or running-app snapshot is only evidence of the present, not the requested range.
  • Use Screen Time only when the user makes its visible totals available; label it Screen Time reported and do not read private databases.
  • Inspect browser history only for an explicit website-level request. Inspect recent documents or terminal history only after explicit, source-specific permission. Treat all such results as metadata clues, not durations.

Workflow

  1. Establish the local date range and time zone.
  2. Run scripts/activitywatch_summary.py --date today, use --period week or --period month around an anchor date, or use inclusive --start YYYY-MM-DD --end YYYY-MM-DD dates. Add --timezone Area/City for reproducible local timestamps. Keep --api-url on the loopback interface.
  3. Use active_seconds and afk_seconds only when ActivityWatch confirms them. Describe foreground_sessions as observed foreground intervals, not process launches.
  4. Use sanitized app names and window titles to reconstruct the timeline. A title is confirmed only when it directly supports the described activity.
  5. When the user needs project/client or billable reporting, offer an optional local JSON --rules file. Match only sanitized titles. Explain that the first matching rule wins and never create or upload rules without consent.
  6. For spreadsheet output, run one table per command:
    • --format markdown --table apps for chat.
    • --format tsv --table apps to copy directly into spreadsheet software.
    • --format tsv --table timeline for chronological rows.
    • --format csv --table apps --csv-bom --output report.csv for an Excel-friendly file, only when the user asks to save one.
    • --report client-timesheet for project/client billable rows.
    • --report weekly-review for a compact review table.
    • --report app-trend for local daily trend rows.
  7. When ActivityWatch is unavailable, return its structured reason. Markdown, TSV, and CSV outputs provide status, reason, and source columns.

Default Conversational Output

For conversational summaries, always use the following four sections, in this order, unless the user explicitly asks for a simpler or shorter output:

  1. Today at a glance
    • State the local date and time zone.
    • Report confirmed active time, away time, and evidence coverage.
    • In fallback mode, state that unavailable values are unavailable; do not estimate them.
  2. What you did
    • Give a chronological list of meaningful activity windows.
    • Include the time window, activity, supporting app or sanitized title, confidence, and evidence label (confirmed ActivityWatch, Screen Time reported, live snapshot, or metadata clue).
  3. App table
    • Include app name, observed foreground sessions, active time, first seen, last active, and source note when ActivityWatch data is available.
    • If data is unavailable, keep this section and show the structured reason with unavailable metrics rather than omitting the table.
  4. Caveats
    • State the relevant privacy and evidence limits, including that foreground sessions are observed intervals rather than process-launch counts and that tracking starts only when ActivityWatch starts.

Keep these sections even when one contains little or no data. A request such as "简单一点", "简要输出", "只要结论", or "只给表格" is an explicit request for a reduced format; then omit or compress only the sections the user asks to remove. Do not infer a reduced format merely because the request is short.

For a requested export (TSV, CSV, or a saved report), follow the export format the user requested instead of wrapping it in these conversational headings. If the user asks for both a summary and an export, provide the four conversational sections first and then the requested export.

Privacy Rules

  • Treat window titles as sensitive. Remove URLs, truncate long titles, and never include complete browser URLs.
  • Keep default sanitized titles for a useful timeline; use --hide-titles if the user wants a title-free export.
  • Use the smallest useful amount of title context; application and summary tables do not need titles.
  • Escape spreadsheet cells that could be interpreted as formulas.
  • Keep reports local to the current conversation. Do not export, upload, or share activity data without explicit user approval.

Top skills in this category

Smart Model Switching

@millibus

Auto-route tasks to the cheapest Claude model that works correctly. Three-tier progression: Haiku → Sonnet → Opus. Classify before responding. HAIKU (default): factual Q&A, greetings, reminders, status checks, lookups, simple file ops, heartbeats, casual chat, 1-2 sentence tasks. ESCALATE TO SONNET: code >10 lines, analysis, comparisons, planning, reports, multi-step reasoning, tables, long writing >3 paragraphs, summarization, research synthesis, most user conversations. ESCALATE TO OPUS: architecture decisions, complex debugging, multi-file refactoring, strategic planning, nuanced judgment, deep research, critical production decisions. Rule: If a human needs >30 seconds of focused thinking, escalate. If Sonnet struggles with complexity, go to Opus. Save 50-90% on API costs by starting cheap and escalating only when needed.

216.7k

Humanizer

@biostartechnology

Remove signs of AI-generated writing from text. Use when editing or reviewing text to make it sound more natural and human-written. Based on Wikipedia's comprehensive "Signs of AI writing" guide. Detects and fixes patterns including: inflated symbolism, promotional language, superficial -ing analyses, vague attributions, em dash overuse, rule of three, AI vocabulary words, negative parallelisms, and excessive conjunctive phrases.

710129k

Elite Longterm Memory

@nextfrontierbuilds

Ultimate AI agent memory system for Cursor, Claude, ChatGPT & Copilot. WAL protocol + vector search + git-notes + cloud backup. Never lose context again. Vibe-coding ready.

23564k

Model Usage

@steipete

Use CodexBar CLI local cost usage to summarize per-model usage for Codex or Claude, including the current (most recent) model or a full model breakdown. Trigger when asked for model-level usage/cost data from codexbar, or when you need a scriptable per-model summary from codexbar cost JSON.

11439k

description: 将用户讲稿一键生成乔布斯风极简科技感竖屏HTML演示稿。当用户需要生成PPT、演示文稿、Slides、幻灯片,或要求科技风/极简风/乔布斯风格的演示时触发此技能。输出为单个可直接运行的HTML文件。

@wwlyzzyorg

将讲稿一键生成乔布斯风极简科技感竖屏HTML演示稿

8534k