skills.rest
JimmyTranDev
JimmyTranDevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

test-android-db-inspector

Pull and inspect SQLite databases from Android emulators via adb and sqlite3.

1|Updated Sep 12, 2025
Search Tags:#sqlite#android#adb#emulator#qa-testing#database-inspection
One-click install
npx skills add https://github.com/JimmyTranDev/dotfiles --skill test-android-db-inspector
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: test-android-db-inspector
Source: https://github.com/JimmyTranDev/dotfiles/tree/main/src/opencode/skills/test-android-db-inspector
Command: npx skills add https://github.com/JimmyTranDev/dotfiles --skill test-android-db-inspector

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Pull SQLite databases from Android emulators, inspect schemas, query data, and verify database state.

Core Features & Use Cases

  • Pull and inspect databases from running Android emulators via adb and sqlite3
  • Inspect schemas, run common queries, and verify data integrity across apps
  • Validate database state during debugging and QA across multiple devices/emulators

Quick Start

Run a connection to a running emulator, pull the target app's databases, then open them with sqlite3 to inspect data.

Frequently Asked Questions about test-android-db-inspector

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I inspect an SQLite database from an Android emulator?▼

To inspect an SQLite database from an Android emulator, you can pull the database file using adb and open it directly with sqlite3 to view schemas and run queries. This allows you to verify app data and migration integrity during debug sessions.

What do I need to pull and query SQLite databases from Android emulators?▼

You need adb available in your PATH, the sqlite3 command-line tool installed, and an active emulator running the target app package. The app package must also be accessible via adb pull or run-as to extract its database files.

Can I verify database migration integrity on an Android emulator?▼

Yes, you can verify database migration integrity on an Android emulator by pulling the SQLite database and inspecting the schema. This process helps validate that data structures and tables match expected states across debug sessions.

Does database inspection work across multiple Android packages?▼

Yes, database inspection works across multiple packages by pulling SQLite databases from different target apps on the emulator. You can inspect schemas and run sample queries on each app to validate data integrity across your testing environments.

Why can't I pull the SQLite database from my Android emulator?▼

If you cannot pull the SQLite database from your Android emulator, it is likely because adb is not in your PATH, sqlite3 is missing, or the target app package is not accessible via run-as or adb pull due to permission restrictions.

Related Skills

Explore More Software Engineering Skills→
jitraponjitrapon
11

android-device-debug

Build, install, launch, and inspect Android apps on devices or emulators.

Community
Advanced
BirdywenBirdywen
1

sqlite-data

Create, query, analyze, and export SQLite data via the sqlite3 CLI.

Community
Intermediate
hyperb1isshyperb1iss
32

android

Automate Android device management and debugging via ADB and shell commands.

Community
Advanced
newkubnewkub

drizzle

Manage database schemas, queries, and migrations with TypeScript-first Drizzle ORM.

Community
Advanced