pull_db_from_device.sh

#!/usr/bin/env bash

# Setup
PACKAGE_NAME="###################################################"
DB_PATH="/data/data/$PACKAGE_NAME/databases"
DB_FILENAME="####################################################"


#cleanup after old runs(just in case)
adb shell "su -c \"rm /sdcard/$DB_FILENAME\""
adb shell "su -c \"cp $DB_PATH/$DB_FILENAME /sdcard/\""

DATETIME=$(date +%Y-%m-%d@%H-%M-%S)
LOCAL_PATH=/tmp/adb_db_pulls/$DATETIME_$DB_FILENAME
adb pull /sdcard/$DB_FILENAME $LOCAL_PATH

#cleanup
adb shell "su -c \"rm /sdcard/$DB_FILENAME\""

sqlitebrowser $LOCAL_PATH