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

Ready to run

npx skills add https://github.com/gh-xj/claude-skills --skill timing-analyzer

💬 Prompt for ChatGPT / Claude Chat▼

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.