Skip to content

Instantly share code, notes, and snippets.

@optinsoft
Created March 13, 2025 12:34
Show Gist options
  • Select an option

  • Save optinsoft/f7665b0593eea392fca355ef3561c0db to your computer and use it in GitHub Desktop.

Select an option

Save optinsoft/f7665b0593eea392fca355ef3561c0db to your computer and use it in GitHub Desktop.
Extract visited domains from chrome history
/* Chrome History Sqlite Db: C:\Users\YOUR_USER_NAME\AppData\Local\Google\Chrome\User Data\Default\History */
select distinct substr(substr(' '||top_level_url,instr(' '||top_level_url, '//')+2),1,instr(substr(' '||top_level_url,instr(' '||top_level_url, '//')+2)||'/','/')-1) as domain
from visited_links
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment