1 Manually Editing the Stash Sqlite3 database

Victor Hooi edited this page 2020-08-22 07:29:18 +10:00

Table of Contents

• Location
• Opening the database file
• 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?)