Accessing the KODI SQL database?

[fzinken]

@rdk45

I’d like to create a table of contents for my Movie content. I’m experienced in SQL from working on my other Raspberry Pi units. Is there a way to access the KODI SQL database to extract data?

Check this thread

Is there a way to grab a nice list of all my media?

I’m unsure but I think sqlite3 is installed by default, else you have to install it. Run this commands and you get a list(only valid in kodi 18.x): sqlite3 ./.kodi/userdata/Database/MyVideos116.db "select c00, c14, c16 from movie_view where 1;" > movielist.txt This will give you a list, with LocalMovieName, Genre, OriginalTitle If you want to decode the c00 or other magic in you libary here is a referens page: KodiDB and here is for the movie_view PS. The “WHERE 1” is not needed, just adde…