How to Locate Your Stash Database Schema

[BlahB5309]

Note: This guide assumes that you have not modified your stash instance’s installation since creation. If you have done so, then you shouldn’t even need this guide anyways.

Finding the Schema

1. Open file explorer and go to the drive that contains your system files. By default, this is called C:
2. Open the folder titled “Users”
3. Open the folder according to your Windows username.
4. Look for a folder titled “.stash”. Open it.
5. There, you should find a file titled "stash-go" with filetype “.sqlite”. That’s your database schema file.
   If that’s all you needed to do, then congratulations. You did it! If you need the path of this database schema, continue reading.
6. Right-click on the database schema file, and click the “Properties” option in the context menu.
7. In the Properties Dialog, look for a field labeled “Location:”. Highlight and copy the text next to it. That text should look something like: C:\Users\username\.stash
8. Wherever you need to paste this path, add “\stash-go.sqlite” to the end, and voila! There’s your schema path.
   Hope this helps!

[feederbox826]

You can also find it under System → Database → Database Path

[Maista]

@BlahB5309

• Right-click on the database schema file, and click the “Properties” option in the context menu.
• In the Properties Dialog, look for a field labeled “Location:”. Highlight and copy the text next to it. That text should look something like: C:\Users\username.stash
• Wherever you need to paste this path, add “\stash-go.sqlite” to the end, and voila! There’s your schema path.

And as a Windows pro-tip you can hold the Shift key when right-clicking on the file and pick “Copy as path” to speed up these last steps

[BlahB5309]

Actually did not know that. Thanks!