Skill: browser-history — Search Chrome History

Search Das's Chrome browsing history to find URLs, videos, sites he's visited before.

Chrome History Location

~/Library/Application Support/Google/Chrome/Default/History

SQLite database. Can be queried directly if Chrome isn't locking it.

---

Search Commands

Basic search (URL or title contains term)

sqlite3 ~/Library/Application\ Support/Google/Chrome/Default/History \
  "SELECT url, title FROM urls WHERE url LIKE '%TERM%' OR title LIKE '%TERM%' ORDER BY last_visit_time DESC LIMIT 10;"

YouTube videos only

sqlite3 ~/Library/Application\ Support/Google/Chrome/Default/History \
  "SELECT url, title FROM urls WHERE url LIKE '%youtube.com/watch%' AND (url LIKE '%TERM%' OR title LIKE '%TERM%') ORDER BY last_visit_time DESC LIMIT 10;"

Most visited (all time)

sqlite3 ~/Library/Application\ Support/Google/Chrome/Default/History \
  "SELECT url, title, visit_count FROM urls ORDER BY visit_count DESC LIMIT 20;"

Recent visits

sqlite3 ~/Library/Application\ Support/Google/Chrome/Default/History \
  "SELECT url, title FROM urls ORDER BY last_visit_time DESC LIMIT 20;"

---

If Database is Locked

Chrome locks the History file while running. Options:

1. Copy first:

   cp ~/Library/Application\ Support/Google/Chrome/Default/History /tmp/chrome_history
   sqlite3 /tmp/chrome_history "SELECT ..."
   

2. Use WAL mode (usually works even when Chrome is open): The sqlite3 command often works anyway due to WAL mode.

---

Open URL in Chrome

open -a "Google Chrome" "URL_HERE"

Hide/Minimize Chrome

osascript -e 'tell application "System Events" to set visible of process "Google Chrome" to false'

---

Common Searches for Das

What	Search Term
Brain.fm focus music	brain.fm
YouTube videos	youtube.com/watch
GitHub repos	github.com
Transcript API	transcriptapi or youtubetotranscript