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: 12 years ago
                    Posts: 3009
	             
                
            	
		        	         
	        
	            
	                                     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 ...