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)

小葱技能站7w4.net发现了升级插件。

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 系统的用户几乎无法使用。总体而言功能专一但覆盖面窄，实用性与局限性并存。