Databases

Kodi Databases Databases Addons Epg MyMusic MyVideos Textures TV ViewModes See also: NFO Files MySQL Shared Library

Development Userdata

Databases

Introduction

Kodi uses SQLite, an open source light-weight SQL database-engine, to store all the library, add-on, EPG, textures and PVR related data using a number of specific databases. By default, the database files (*.db) are stored in the Kodi data folder\Userdata folder, specifically in \Database\.

Using the Databases

The databases are automatically maintained by Kodi. It is recommended that Kodi users do not access the database without good working knowledge of relational databases and SQL.

Database software is required to access the SQL databases. DB Browser for SQLite is available for Windows, macOS, Linux and FreeBSD.

Accessing the Databases with Kodi Python

Many Python plugins (and some scripts) can use the information in the Kodi database to offer users additional convenience and functionality. The easiest way to access the databases via Kodi Python is using JSON-RPC API

Database Versions

The following tables shows what database version is used for various Kodi versions. This can be useful to see what versions of Kodi can use MySQL sharing. Note that future release database versions are subject to change during development.

Kodi version	Date	Addons	EPG	MyMusic	MyVideos	Textures	TV	ViewModes	ADSP
v10 - Dharma	December 2010	1	N/A	7	37	1	N/A	1	N/A
v11 - Eden	March 2012	15	N/A	18	60	6	N/A	4	N/A
v12 - Frodo	January 2013	15	7	32	75	13	22	4	N/A
v13 - Gotham	May 2014	16	7	46	78	13	22	6	N/A
v14 - Helix	December 2014	16	8	48	90	13	26	6	N/A
v15 - Isengard	July 2015	19	10	52	93	13	29	6	N/A
v16 - Jarvis	February 2016	20	11	56	99	13	29	6	0
v17 - Krypton	February 2017	27	11	60	107	13	29	6	0
v18 - Leia	January 2019	27	12	72	116	13	32	6	0
v19 - Matrix	December 2020	33	13	82	119	13	38	6	N/A
v20 - Nexus	11 January 2023	33	16	82	121	13	40	6	N/A
v21 - Omega	2 April 2024	33	16	83	131	13	44 (v21.0) 46 (v21.1)	6	N/A
v22 - Piers	TBD	33	20	83	133	14	47	6	N/A

Legend
Green	Current release
Blue	Future release

See also

• Releases
• https://github.com/xbmc/xbmc/commits/master/xbmc/video/VideoDatabase.cpp - Tracking the Video Database schema version
• https://github.com/xbmc/xbmc/commits/master/xbmc/music/MusicDatabase.cpp - Tracking the Music Database schema version

Return to top