Addons#.db

The Addons#.db database contains the information on all Kodi addons such as skins, scraper, video-addons etc

The current stable release of Kodi is using the following version of the database:

Kodi v20 - Addons33.db

Warning: The databases are critical components of Kodi. We strongly urge that you do not interfere with them, unless you have knowledge and experience with database designs.

addonlinkrepo

Links the Add-on to the Repository

Column Name	Data Type	Description n
idRepo	integer	Foreign key to repo table
idAddon	integer	Foreign key to addons table

addons

Details relating to the add-on

Column Name	Data Type	Description
id	integer	Primary Key
metadata	blob
addonID	text	ID of the Add-on
version	text	Add-on version
name	text	Add-on friendly name
summary	text	Short friendly description
news	text	Notes
description	text	Extended description of add-on

installed

Add-ons that have been installed, showing status and usage details

Column Name	Data Type	Description
id	integer	Primary Key
addonID	text	Foreign key to addons table
enabled	boolean	0/1 - No / Yes
installDate	text	Date add-on was installed
lastUpdated	text	Date add-on was last updated
lastUsed	text	Date add-o was last used
origin	text	Originating Repository A hash (if it's b6a50484-93a0-4afb-a01c-8d17e059feda) means ORIGIN_SYSTEM blank means MANUAL (or from ZIP) install anything else is installed from a REPOSITORY. See: Github
disabledReason	Integer	NONE = 0 USER = 1 INCOMPATIBLE = 2 PERMANENT_FAILURE = 3 See: Github

package

Details of downloaded zip files for installation. Can be used to roll-back to previous versions. Does not include add-ons installed using Install via zip file method.

Column Name	Data Type	Description
id	integer	Primary Key
addonID	text	Foreign key to addons table
filename	text	Path and name of add-on zip file
hash	text	Hash security check of zip file

repo

Details related to the Repository

Column Name	Data Type	Description
id	integer	Primary Key
addonID	text	Foreign key to addons table
checksum	text	Hash of the repository
lastcheck	text	Last time Repository was checked for updates
version	text	Installed version of the repository
nextcheck	text	Next scheduled check for updates

update_rules

How non-official repositories are updated

Column Name	Data Type	Description
id	integer	Primary Key
addonID	text	Foreign key to addons table
updateRule	Integer	Any = 0 used internally, not to be explicitly set User Disabled Auto Update = 1 automatic updates disabled via AddonInfo dialog Pin Old Version = 2 user downgraded to an older version See: Github

version

Database details

Column Name	Data Type	Description
idVersion	integer	Database version
iCompressCount	integer	Number of times database has been compressed

Return to top