Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!
Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.
Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!
[Solved] How to access/edit the Sonarr database
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2741
Topic starter
April 4, 2019 11:55 PM
Sometimes curiosity gets the best of me, and this is such a case ... I just wanted to know if and how I can look at the content of the database used by Sonarr.
Sonarr uses the SQLite engine, so first task would be to actually find the database file.
The Sonarr SQLite database file is called "nzbdrone.db" and can be found here (per Sonarr Wiki):
Windows
C:\ProgramData\NzbDrone
Ubuntu
/home//.config/NzbDrone
(~/.config/NzbDrone)
MacOS
/Users//.config/NzbDrone
(~/.config/NzbDrone)
Synology
/usr/local/nzbdrone/var/.config/NzbDrone
or
/volume1/@appstore/nzbdrone/var/.config/NzbDrone
QNAP
/share/MD0_DATA/homes/admin/.config/NzbDrone
or
/share/CACHEDEV1_DATA/SONARR_CONFIG
The database file can be viewed/edited with any SQLite tool, like SQLiteBrowser ...