adb_sqlite_inspect
Inspect a Room or SQLite database inside an installed Android app to list databases, view schema, or run a read-only query.
Instructions
Safely inspect a Room or SQLite database inside an installed app. Lists package databases, shows schema, or executes one validated read-only query. Requires a debuggable app (run-as) or root; queries a bounded private snapshot with device sqlite3 or an isolated host SQLite process.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | No | One read-only SELECT, WITH, EXPLAIN, or allowlisted PRAGMA statement | |
| access | No | Access method. auto prefers run-as and falls back to root. | auto |
| action | No | List databases, show sqlite_master schema, or run a read-only query | list |
| device | No | Device serial | |
| maxRows | No | Maximum rows returned for SELECT/WITH queries (1-1000, default 100) | |
| database | No | Database filename inside the package databases directory (no path separators) | |
| packageName | Yes | Installed Android package whose databases directory may be inspected |