mdq - Mobile Device Query

MDQ stands for Mobile Device Query and is a command line tool for displaying information about Android and Apple devices.

Usage

Check

To fully use MDQ, you need to install ADB and Xcode beforehand. Check the software installation status.

$ mdq check

List

It's easy to use.

$ mdq list
[
  {
    "id": 1,
    "udid": "ANDROID_UDID",
    "serial_number": "ANDROID_UDID",
    "name": "Pixel 7",
    "authorized": true,
    "platform": "Android",
    "marketing_name": null,
    "model": "Pixel 7",
    "build_version": "16",
    "build_id": "BP31.250502.008",
    "battery_level": 88,
    "total_disk": 118015217664,
    "used_disk": 19287748608,
    "available_disk": 98727469056,
    "capacity": 16,
    "human_readable_total_disk": "109.91 GB",
    "human_readable_used_disk": "17.96 GB",
    "human_readable_available_disk": "91.95 GB",
    "mac_address": "ff:ff:ff:ff:ff:ff",
    "ip_address": "192.168.1.1",
    "ipv6_address": "IPV6_1,IPV6_2,IPV6_3,IPV6_3",
    "wifi_network": "MyNet"
  },
  {
    "id": 2,
    "udid": "APPLE_UDID",
    "serial_number": "XXX",
    "name": "iPhone 16 Pro",
    "authorized": true,
    "platform": "iOS",
    "marketing_name": "iPhone 16 Pro",
    "model": "iPhone17,1",
    "build_version": "18.4.1",
    "build_id": "22E252",
    "battery_level": null,
    "total_disk": 128000000000,
    "used_disk": null,
    "available_disk": null,
    "capacity": null,
    "human_readable_total_disk": "128.0 GB",
    "human_readable_used_disk": null,
    "human_readable_available_disk": null,
    "mac_address": null,
    "ip_address": null,
    "ipv6_address": null,
    "wifi_network": null
  }
]

You can filter using SQL.

$ mdq list -q="select * from devices where platform='iOS'"
[
  {
    "id": 1,
    "udid": "APPLE_UDID",
    "serial_number": "XXX",
    "name": "iPhone 16 Pro",
    "authorized": true,
    "platform": "iOS",
    "marketing_name": "iPhone 16 Pro",
    "model": "iPhone17,1",
    "build_version": "18.4.1",
    "build_id": "22E252",
    "battery_level": null,
    "total_disk": 128000000000,
    "used_disk": null,
    "available_disk": null,
    "capacity": null,
    "human_readable_total_disk": "128.0 GB",
    "human_readable_used_disk": null,
    "human_readable_available_disk": null,
    "mac_address": null,
    "ip_address": null,
    "ipv6_address": null,
    "wifi_network": null
  }
]

View apps installed on your device. Apple Devices displays the apps installed with Xcode.

$ mdq list -q='select * from apps'

Take a screenshot on Android.

$ mdq list --cap='/Users/xxxxx/'

Install the app.

$ mdq list --install='/Users/xxxxx/example.apk'
$ mdq list --install='/Users/xxxxx/example.ipa'

Uninstall the app.

$ mdq list --uninstall='com.example.app'

Specification

Details of the devices table.

name	android	apple devices
udid	Serial number	hardwareProperties.udid
serial_number	Serial number	hardwareProperties.serialNumber
name	device_name	deviceProperties.name
authorized	"False" if additional authentication is required.	Always "True"
platform	Always "Android"	hardwareProperties.platform
marketing_name	Always "null"	hardwareProperties.marketingName
model	ro.product.model	hardwareProperties.productType
build_version	ro.build.version.release	deviceProperties.osVersionNumber
build_id	ro.build.id	deviceProperties.osBuildUpdate
battery_level	battery	Always "null"
total_disk	df	hardwareProperties.internalStorageCapacity
available_disk	df	Always "null"
used_disk	total_disk - total_disk	Always "null"
capacity	(used_disk / total_disk) * 100	Always "null"
human_readable_total_disk	total_disk	total_disk
human_readable_available_disk	available_disk	Always "null"
human_readable_used_disk	used_disk	Always "null"
mac_address	MAC address (may be a random MAC address)	Always "null"
ip_address	IPv4 Address	Always "null"
ipv6_address	IPv6 Address	Always "null"
wifi_network	Wi-Fi Network	Always "null"

Details of the apps table. Apple Devices displays the apps installed with Xcode.

name	android	apple devices
udid	Serial number	hardwareProperties.udid
name	Always "null"	name
package_name	Package name	bundleIdentifier
version	Always "null"	version