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