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

Manually Editing the Stash Sqlite3 Database

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


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 marker tags (TODO: What to do then?)