razbakov/skills/daily-review-app-usage
skills/daily-review-app-usage/SKILL.md
Query macOS knowledgeC.db for yesterday's app focus time and append to browser history file. Part of the daily review workflow.
$ install --global
skillsauthnpx skillsauth add razbakov/skills skills/daily-review-app-usageInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 18, 2026, 5:01 AM33.7s1 file scanned
SKILL.md
- description:
- Query macOS knowledgeC.db for yesterday's app focus time and append to browser history file. Part of the daily review workflow.
- user_invocable:
- true
Daily Review — App Usage
Queries the macOS Knowledge Store database for app focus time and appends the results to sessions/YYYY-MM-DD-browser.md.
Trigger
Invoked as part of /daily-review or independently via /daily-review-app-usage.
Context
- Working directory:
~/Projects/ikigai - Session storage:
sessions/ - Date: Use yesterday's date (YYYY-MM-DD)
- Requirement: Full Disk Access for
/usr/bin/sqlite3(System Settings > Privacy & Security > Full Disk Access)
Process
Skip check
Skip if sessions/YYYY-MM-DD-browser.md already exists and contains an "App Usage" section. Report "already exists, skipping" and stop.
1. Query macOS Knowledge Store
sqlite3 ~/Library/Application\ Support/Knowledge/knowledgeC.db "
SELECT
ZOBJECT.ZVALUESTRING as app,
ROUND(SUM(ZOBJECT.ZENDDATE - ZOBJECT.ZSTARTDATE) / 3600.0, 1) as hours,
ROUND(SUM(ZOBJECT.ZENDDATE - ZOBJECT.ZSTARTDATE) / 60.0, 0) as minutes
FROM ZOBJECT
WHERE ZSTREAMNAME = '/app/usage'
AND date(ZOBJECT.ZSTARTDATE + 978307200, 'unixepoch', 'localtime') = 'YYYY-MM-DD'
GROUP BY ZOBJECT.ZVALUESTRING
ORDER BY hours DESC
LIMIT 20
"
Replace YYYY-MM-DD with yesterday's actual date.
If the query fails (no Full Disk Access), skip and note the failure in the review.
2. Append to browser history file
Append results to sessions/YYYY-MM-DD-browser.md as an "App Usage" section with a table:
## App Usage
| App | Time |
|-----|------|
| Chrome | 4h 22m |
| Zed | 4h 20m |
Map bundle IDs to friendly names:
com.google.Chrome-> Chromedev.zed.Zed-> Zedcom.conductor.app-> Conductorcom.mitchellh.ghostty-> Ghosttycom.apple.Safari-> Safaricom.tinyspeck.slackmacgap-> Slackcom.hnc.Discord-> Discordus.zoom.xos-> Zoom
Include total active screen time at the bottom.
Output
Confirmation that app usage was appended, or a note that it was skipped/failed.
Related Skills
razbakov/skills/handoff
tools
VerifiedTrustedCommunity
--- name: handoff description: Get an agent past a browser/UI wall it can't (or must not) cross on its own — a login-gated dashboard, a CAPTCHA, a 2FA prompt, an API that keeps rejecting the write, or an irreversible click that policy says a human must make. This skill is an ESCALATION LADDER, not a first move: it tells you to try the automated browser surfaces FIRST (Chrome-in-Claude, computer-use, an autonomous browser sub-agent) and only fall back to the Handoff app — a wrapper browser that h
3SKILL.mdUpdated Jul 17, 2026
razbakov/summarize-youtube
documentation
VerifiedTrustedCommunity
Summarize one or more YouTube videos from their links. Use this whenever the user pastes a youtube.com or youtu.be URL (or several) and wants to know what it's about — phrasings like "summarize to telegram", "tldr these videos", "what do these say", "summary of this talk", or just dropping links with no instruction at all. Fetches each video's real transcript via yt-dlp (not the page text, which never contains the transcript), cleans the captions, and writes a per-video summary. Default delivery is Telegram; honor any other surface the user names ("to my notes", "just here in chat", "email it"). Trigger even when the user only pastes bare links — bare YouTube links almost always mean "tell me what's in these".
3SKILL.mdUpdated Jun 15, 2026
razbakov/skills/daily-digest
data-ai
VerifiedTrustedCommunity
Daily Digest — Chief-of-Staff role consolidates the six top-managers into one Telegram message to the Commander, instead of six. Implements the protocol from agent-proactivity.md.
3SKILL.mdUpdated Jun 15, 2026
razbakov/instagram-launch-grid
development
VerifiedTrustedCommunity
Seed a new or empty Instagram account with a 9-post grid (3×3) so the profile looks established the moment a new visitor lands. Designed for festivals, new businesses, product launches, conferences, communities — any time an empty IG profile would hurt conversion from external traffic (QR scans, flyer drops, cross-promo). Generates assets via /image-from-gemini (per content-publishing rules — never HTML), writes captions with hashtag sets, and outputs a posting order + cadence plan. Trigger generously: phrases like '9 posts for instagram', 'fill my IG', 'starter grid', 'launch grid', 'instagram seed', '9-post grid', 'IG account not to look empty', 'first instagram posts', 'feed bootstrap', '3x3 grid', 'instagram launch content'. Even if the user mentions only one piece (just the images, just the captions, just the order), use this skill — the grid only works as an integrated bundle.
3SKILL.mdUpdated May 21, 2026