Skip to main content Link Search Menu Expand Document (external link)

Manually Editing the Stash Sqlite3 Database


Table of Contents
  1. Location
  2. Opening the database file
  3. Deleting all tags

Location

The Stash Sqlite3 database file is located at ~/.stash/stash-go.sqlite.

Before making changes to the Stash sqlite3 database - please make a backup first!

You can use the sqlite3 client to directly edit this file.


Opening the database file

cd ~/.stash
sqlite3 stash-go.sqlite

Deleting all tags

If you need to delete all tags, you can use the following commands:

sqlite> DELETE FROM scenes_tags;
sqlite> DELETE FROM tags;

Please note that this will not work if you have Scene market tags (TODO: What to do then?)