android-sqlite-inspector
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| ADB_PATH | No | Custom path to ADB binary | adb |
| ANDROID_DEVICE | No | ADB device serial (for multiple devices) | (auto-detect) |
| ANDROID_PACKAGE | No | App package name | com.hortusys |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| resources | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_databasesA | List all SQLite database files for the Android app (com.hortusys) |
| list_tablesA | List all tables in a SQLite database. Pulls a fresh copy from the device. |
| describe_tableA | Show the schema (columns, types, constraints) for a specific table. |
| queryA | Execute a read-only SQL SELECT query. Returns results as JSON. Pulls a fresh copy from the device before querying. |
| executeA | Execute an INSERT, UPDATE, or DELETE SQL statement. Pulls the database, modifies it locally, then pushes it back to the device. |
| room_infoA | Show Room database metadata: schema version, identity hash, and managed entities. |
| multi_queryA | Execute multiple read-only SQL SELECT queries in a single call. More efficient than calling query multiple times. |
| query_paginatedA | Execute a SELECT query with LIMIT/OFFSET pagination. Returns results plus total row count. |
| schema_diffA | Compare schemas of two databases. Shows added/removed tables and columns. |
| exportA | Execute a SELECT query and export results to a local file as JSON or CSV. |
| list_devicesA | List all Android devices/emulators connected via ADB. |
| list_packagesA | List third-party packages installed on the device. Useful for finding the correct package name. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 12 tools
Most tools target distinct actions and resources, but the query variants (query, multi_query, query_paginated, export) overlap in purpose and could be confused if descriptions are not read carefully. The read-only vs. write distinction between query and execute is clear, and schema_diff/room_info are well-separated from the rest.
The list_* tools follow a clear, consistent pattern, and describe_table, schema_diff, and export are also descriptive. However, room_info breaks the verb-noun pattern, and the query variants mix styles (query, multi_query, query_paginated) though they remain readable.
Twelve tools is well-scoped for an Android SQLite inspector, covering discovery, schema inspection, querying, and modification without unnecessary bloat. Each tool has a meaningful role in the workflow.
The tool surface covers the full inspection lifecycle: device discovery, package/database/table enumeration, schema details, read/write operations, pagination, batch queries, Room metadata, schema diffing, and export. No obvious dead ends or critical missing operations are apparent for the stated purpose.