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