skills.rest
gh-xj
gh-xjCOMMUNITY
Explore all skills by this author →
GitHub

timing-analyzer

Analyze Timing.app SQLite data to produce deduplicated time insights.

Updated Aug 27, 2026
Search Tags:#SQL#reporting#visualization#deduplication#analyze#time-tracking#Timing.app
One-click install
npx skills add https://github.com/gh-xj/claude-skills --skill timing-analyzer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: timing-analyzer
Source: https://github.com/gh-xj/claude-skills/tree/main/.claude-plugin/skills/timing-analyzer
Command: npx skills add https://github.com/gh-xj/claude-skills --skill timing-analyzer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sqlite3, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Timing and analyzing personal time across Timing.app data is often noisy due to duplicate tracking. This Skill provides deduplicated, actionable insights by consolidating AppActivity (auto-tracked) with TaskActivity (manual entries) to reveal a truthful view of how you spend your time.

Core Features & Use Cases

  • Deduplicated time analysis: merges automatic and manual records without double-counting.
  • Time distribution reports: daily totals, hourly breakdowns, and category-level summaries.
  • Usage insights: identify dominant time sinks, top apps, and unassigned activities for cleaning up projects.
  • Knowledge resources: access to references, SQL queries, and cognitive frameworks to deepen analysis.

Quick Start

  • Ask for today’s deduplicated time distribution by category.
  • Request a daily or weekly breakdown by project and category.
  • Run the helper scripts to generate reports: run today.sh for today and week.sh for this week.

Frequently Asked Questions about timing-analyzer

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

FAQPage Schema
How do I deduplicate time tracking data from Timing.app to avoid double-counting?▼

Deduplicating Timing.app data requires merging auto-tracked AppActivity with manual TaskActivity entries. This consolidates overlapping records to reveal a truthful time distribution view without double-counting.

How do I generate daily and weekly time distribution reports from a local Timing.app SQLite database?▼

Generating time distribution reports involves querying the local Timing.app SQLite database to aggregate daily totals and category-level breakdowns. You can run helper scripts like today.sh or week.sh to produce these summaries.

Do I need a local Timing.app SQLite database to analyze my time tracking insights?▼

Yes, analyzing time tracking insights requires a local Timing.app SQLite database. The Skill directly queries this local database file to extract and deduplicate TaskActivity and AppActivity records for reporting.

What is the best way to identify dominant time sinks and top app usage in my time tracking data?▼

Identifying time sinks and top app usage requires analyzing deduplicated time tracking data to highlight dominant applications and unassigned activities. This helps you recognize usage patterns and clean up project categories.

Can I use custom SQL queries to analyze Timing.app data for specific productivity workflows?▼

Yes, you can use custom SQL queries to analyze Timing.app data for specific productivity workflows. The Skill provides SQL-driven workflows and access to reference queries to perform deeper deduplicated time analysis.

Related Skills

Explore More Data & Analytics Skills→
paulchiupaulchiu
3

search-shadow-transcripts

Search Shadow.app transcripts in a local SQLite database by keywords and date ranges.

Community
Intermediate
R3n3gade-aiR3n3gade-ai

financial-document-parser

Parse financial documents into structured JSON, Markdown, or CSV outputs.

Community
Intermediate
BirdywenBirdywen
1

sqlite-data

Create, query, analyze, and export SQLite data via the sqlite3 CLI.

Community
Intermediate
lvndrylvndry
47

digest

Generate topic-specific digests with headlines, summaries, sources, and links.

Community
Basic