adb useful commands

android, programming

List devices (including emulations)

> adb devices
List of devices attached
emulator-5554   device

List directories via shell (emulation)

> adb -e shell ls -l
dr-x------ root     root              2013-03-03 22:28 config
drwxrwx--- system   cache             2012-01-18 01:10 cache
lrwxrwxrwx root     root              2013-03-03 22:28 sdcard -> /mnt/sdcard
drwxr-xr-x root     root              2013-03-03 22:28 acct
drwxrwxr-x root     system            2013-03-03 22:28 mnt
lrwxrwxrwx root     root              2013-03-03 22:28 d -> /sys/kernel/debug
lrwxrwxrwx root     root              2013-03-03 22:28 etc -> /system/etc
drwxr-xr-x root     root              2010-06-30 14:06 system
drwxr-xr-x root     root              1969-12-31 16:00 sys
drwxr-x--- root     root              1969-12-31 16:00 sbin
dr-xr-xr-x root     root              1969-12-31 16:00 proc
-rwxr-x--- root     root        12995 1969-12-31 16:00 init.rc
-rwxr-x--- root     root         1677 1969-12-31 16:00 init.goldfish.rc
-rwxr-x--- root     root       107412 1969-12-31 16:00 init
-rw-r--r-- root     root          118 1969-12-31 16:00 default.prop
drwxrwx--x system   system            2012-04-14 17:45 data
drwx------ root     root              2010-01-27 16:59 root
drwxr-xr-x root     root              2013-03-03 22:28 dev

Copy files from device/emulation

> adb -e pull /data/data/org.van/databases/notables.db c:temp
17 KB/s (4096 bytes in 0.231s)

Note the location of databases (Sqlite3):

/data/data/<package name>/database/

More

ADB page