Android Data Management with ADB and Content Providers

Unlock the full potential of Android's Content Provider system using ADB commands. This detailed guide is designed for developers and tech enthusiasts who want to gain deeper insights into managing system settings, querying databases, and manipulating data with precision. Whether you're adjusting system preferences, accessing contact information, or managing SMS and call logs, these commands provide the tools you need to interact with Android's underlying data systems efficiently. Elevate your Android management skills and streamline your data operations with these expert techniques.

Set ringtone from /sdcard/

adb shell 'content write --uri content://settings/system/ringtone_cache < /sdcard/wuseman/sounds/wuseman/molle_jobba_jobba.ogg'

Set ringtone to foo.ogg over adb from PC

adb shell 'content write --uri content://settings/system/ringtone_cache' < host.ogg

Query settings for system

adb shell content query --uri content://settings/system/

View sim info by slot

adb shell content query --uri content://com.sec.ims.settings/global#simslot/1

Set vibrator for specifik settings/profile

adb shell content query --uri content://com.android.settings.personalvibration.PersonalVibrationProvider

List all names of secure settings

adb shell content query --uri content://settings/secure/ | awk -F "[=,]" '{print "adb shell content query --uri content://system/settings/"$4}'

Query all settings with gnu parallel

echo -e "secure\nsystem\nglobal"| parallel -k -j3 "adb shell content query --uri content://settings/{}"

Disable developer mode

adb shell content update --uri content://settings/global --where "name='development_settings_enabled'" --bind value:s:0

Add new setting with content

adb shell content insert --uri content://settings/secure --bind name:s:oem_unlock_allowed --bind value:s:1

Change "new_setting" secure setting to "newer_value"

adb shell content update --uri content://settings/secure --bind value:s:newer_value --where "name='new_setting'"

Status for developer mode

adb shell content query --uri content://settings/global --where "name='development_settings_enabled'"

Status for developer mode

content query --uri content://settings/global --where "name='development_settings_enabled'"

Find contents in sdk map and create samples for this cheatsheet

adb shell "su -c content query --uri content://com.samsung.rcs.autoconfigurationprovider/root/* |tr ' ' '\n'"

Print device number

adb shell "su -c content query --uri content://com.samsung.rcs.autoconfigurationprovider/root/application/1/im/fthttpcsuser"

Delete a certain setting

adb shell content delete --uri content://settings/secure --where "name='new_setting'"

Insert a setting and value to foo

adb shellcontent insert --uri content://settings/secure --bind name:s:user_setup_complete --bind value:s:1

Change setting to another setting

adb shell content update --uri content://settings/secure --bind value:s:newer_value --where "name='new_setting'

Read will be able to read all kind of file extensions like zip, mp3 etc

adb shell 'content read --uri content://settings/system/ringtone_cache' > foo.ogg

Print current type for a content, example:

adb shell content gettype --uri content://media/internal/audio/media/

Below will print all nbames and mmsproxy

adb shell su -c content query --uri content://telephony/carriers/sim_apn_list --projection name:mmsproxy

Print heapdump

adb shell content query --uri content://com.android.shell.heapdump/

Print calls

adb shell content query --uri content://call_log/calls

Print shadow calls

adb shell content query --uri content://call_log_shadow/calls

Print call filters

adb shell content query --uri content://call_log/calls/filter

Print call log

adb shell content query --uri content://call_log/calls

Print downloads

adb shell content query --uri content://downloads/my_downloads

Print all downloads

adb shell content query --uri content://downloads/all_downloads

Print current downloads

adb shell content query --uri content://downloads/

Print my all live

adb shell content query --uri content://my.app/live

Print sms changes

adb shell content query --uri content://sms-changes

Print sms

adb shell content query --uri content://sms

Print sms inbox

adb shell content query --uri content://sms/inbox

Print sms sent

adb shell content query --uri content://sms/sent

Print sms draft messages

adb shell content query --uri content://sms/draft

Print sms outbox

adb shell content query --uri content://sms/outbox

Print sms convertations

adb shell content query --uri content://sms/conversations

Print carrier information

adb shell content query --uri content://carrier_information/carrier

Print mms ids

adb shell content query --uri content://mms-sms/threadID

Print mms

adb shell content query --uri content://mms

Print mms inbox

adb shell content query --uri content://mms/inbox

Print sent mms

adb shell content query --uri content://mms/sent

Print mms drafts

adb shell content query --uri content://mms/drafts

Print mms outbox

adb shell content query --uri content://mms/outbox

Print mms via sms

adb shell content query --uri content://mms-sms/

Print mms via sms convertation

adb shell content query --uri content://mms-sms/conversations

Print mms via sms byphone

adb shell content query --uri content://mms-sms/messages/byphone

Print undelivered mms via sms

adb shell content query --uri content://mms-sms/undelivered

Print drafted mms via sms

adb shell content query --uri content://mms-sms/draft

Print locked mms via sms

adb shell content query --uri content://mms-sms/locked

Priint serach results for mms via sms

adb shell content query --uri content://mms-sms/search

Print device carriers

adb shell su -c content query --uri content://telephony/carriers

Print device carriers apn list for simcard

adb shell su -c content query --uri content://telephony/carriers/sim_apn_list --projection name:mmsproxy

Print device carriers dpc

adb shell content query --uri content://telephony/carriers/dpc

Print device carriers filtered

adb shell content query --uri content://telephony/carriers/filtered

Print device carriers enforce manage

adb shell content query --uri content://telephony/carriers/enforce_managed

Print device preferapnset subids

adb shell content query --uri content://telephony/carriers/preferapn/subId

Print device preferapnset subid

adb shell content query --uri content://telephony/carriers/preferapnset/subId

Print cellbroadcastas

adb shell content query --uri content://cellbroadcasts

Print cellbroadcasts history

adb shell content query --uri content://cellbroadcasts/history

Print cellbroadcasts öegacy

adb shell content query --uri content://cellbroadcast-legacy

Print cellbroadcasts service state

adb shell content query --uri content://service-state/

Print cellbroadcasts carrier-id

adb shell content query --uri content://carrier_id

Print cellbroadcasts all info about carrier-id

adb shell content query --uri content://carrier_id/all

Print cellbroadcasts simcard info

adb shell content query --uri content://telephony/siminfo

Print all contact settings available

adb shell content query --uri content://contacts/settings

Contact list

adb shell content query --uri content://contacts/people

Print contacts by filter

adb shell content query --uri content://contacts/people/filter

Print deleted contacts

adb shell content query --uri content://contacts/deleted_people

Print contacts that has an email of im id added

adb shell content query --uri content://contacts/people/with_email_or_im_filter

Print contact group

adb shell content query --uri content://contacts/groups

Print deleted contact groups

adb shell content query --uri content://contacts/deleted_groups

Print all phone numbers

adb shell content query --uri content://contacts/phones

Print all phone number filters

adb shell content query --uri content://contacts/phones/filter

Print all group memberships

adb shell content query --uri content://contacts/groupmembership

Print all contacts groupmemberships in raw format

adb shell content query --uri content://contacts/groupmembershipraw

Print contact methods

adb shell content query --uri content://contacts/contact_methods

Print contacts email address

adb shell content query --uri content://contacts/contact_methods/email

Print contacxts presence

adb shell content query --uri content://contacts/presence

Print contacts organizations

adb shell content query --uri content://contacts/organizations

Print contacts photo path

adb shell content query --uri content://contacts/photos

Print fcontacts extensions

adb shell content query --uri content://contacts/extensions

Get google contacts with full info

adb shell content query --uri content://com.android.contacts/data --projection display_name:data1:data4:contact_id

Get google contacts and print notes for every contact

adb shell content query --uri content://contacts/phones/  --projection display_name:number:notes
adb shell content query --uri content://contacts/people/

Count people in contact list

adb shell bash content query --uri content://contacts/people/ |wc -l

List the phone numbers

adb shell content query --uri content://contacts/phones/

List the groups

adb shell content query --uri content://contacts/groups/

List group membership

adb shell content query --uri content://contacts/groupmembership/

List organizations

adb shell content query --uri content://contacts/organizations/

Trick device that setup already has been done (FRP Bypassing)

adb shellcontent insert --uri content://settings/secure --bind name:s:user_setup_complete --bind value:s:1

adb shell am start -n com.google.android.gsf.login/

adb shell am start -n com.google.android.gsf.login.LoginActivity

Dump global settings

adb shell content query --uri content://settings/global

Dump secure settings

adb shell content query --uri content://settings/seure

Print target dir to all applications settings dir that can be edited manually

adb shell content query  --uri content://media/external/file  --projection _data

Query secure settings Select "name" and value columns from secure settings where name is equal to new_setting and sort the result by name in ascending order

adb shell content query  --uri content://settings/secure  --projection name:value

Remove "new_setting" secure setting

adb shell content delete  --uri content://settings/secure --where "name='new_setting'"

Download current ringtone and play on PC via ffplay:

content read  --uri content://settings/system/ringtone_cache' > a.ogg  |xargs ffplay a.ogg

Auto rotation on

adb shell content insert --uri content://settings/system --bind name:s:accelerometer_rotation --bind value:i:1

Auto rotation off

adb shell content insert --uri content://settings/system --bind name:s:accelerometer_rotation --bind value:i:0

Rotate to landscape

adb shell content insert --uri content://settings/system --bind name:s:user_rotation --bind value:i:1

Rotate portrait

adb shell content insert --uri content://settings/system --bind name:s:user_rotation --bind value:i:0