Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to do things like remove all form autofill data except that from my banks and a few other sites. I'd also like to be able to remove all my Reddit history, for example.

Using the GUI in Chrome, I can remove all history, or I can click each entry individually - way too time consuming. I can also remove all of my autofill data, or none of it.

I understand that Chrome keeps things in an SQLite database. Can I connect to that somehow to remove thing using SQL queries? Or perhaps there is an extension?

Thanks

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

Messing with Chrome internal relational databases could make your browser act strangely. Backup before you start deleting things.

That information is stored in ~/Library/Application Support/Google/Chrome/Default, assuming Default is your profile folder.

There's a sqlite3 command line tool that can open the files containing the login and history data. In the SQLite console, .tables lists the tables and .dump creates a data dump. Otherwise, it accepts SQLite SQL.

sqlite3 ~/Library/Application\ Support/Google/Chrome/Default/History
sqlite> delete from urls;
sqlite> delete from visits;
sqlite> .quit

sqlite3 ~/Library/Application\ Support/Google/Chrome/Default/Login\ Data
sqlite> delete from logins;
sqlite> .quit

Note that the actual logins are stored in your systemwide keychain. Open Keychain Access to view its entries.

share|improve this answer
    
Thanks Daniel, that's good for the history although the structure of the autofill (Web Data database) is complicated enough that breakage is likely. Have a +1 for now I'll see if anyone has an extension which can help with the autofill stuff. –  Tim Kemp May 17 '12 at 14:33
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.