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;"
本技能來自小蔥技能站7w4.net。

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: bash 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

這是一個質量中等的 Chrome 歷史搜尋工具，文件清晰、命令實用，適合需要快速查詢瀏覽記錄的 Chrome 使用者。但它僅支援 macOS 系統上的 Chrome 瀏覽器，對使用其他瀏覽器或 Windows/Linux 系統的使用者幾乎無法使用。總體而言功能專一但覆蓋面窄，實用性與侷限性並存。