OS X defaults and managed preferences.

Table schema

Name Type Description
domain TEXT Application ID usually in format
key TEXT Preference top-level key
subkey TEXT Intemediate key path, includes lists/dicts
value TEXT String value of most CF types
forced INTEGER 1 if the value is forced/managed, else 0
username TEXT (optional) read preferences for a specific user
host TEXT ‘current’ or ‘any’ host, where ‘current’ takes precedence

Query examples

select * from preferences where domain = 'loginwindow'
select preferences.* from users join preferences using (username)