Android Sqlite Inspector

БесплатноНе проверен

Inspects and queries SQLite databases on Android devices via ADB, supporting listing databases/tables, describing schemas, and executing SELECT/INSERT/UPDATE/DE

автор: hortusys

GitHub Embed

Описание

Inspects and queries SQLite databases on Android devices via ADB, supporting listing databases/tables, describing schemas, and executing SELECT/INSERT/UPDATE/DELETE queries.

README

MCP server that inspects and queries SQLite databases on Android devices via ADB.

Prerequisites

Node.js 18+
ADB installed and in PATH
A debuggable Android app (debug builds)

Installation

npm install
npm run build

Configuration

Set via environment variables:

Variable	Description	Default
`ANDROID_PACKAGE`	App package name	`com.hortusys`
`ANDROID_DEVICE`	ADB device serial (for multiple devices)	(auto-detect)
`ADB_PATH`	Custom path to ADB binary	`adb`

Claude Code Setup

Add to ~/.claude/settings.json:

{
  "mcpServers": {
    "android-sqlite-inspector": {
      "command": "node",
      "args": ["/Users/andromeda/StudioProjects/android-sqlite-inspector/dist/index.js"],
      "env": {
        "ANDROID_PACKAGE": "com.hortusys"
      }
    }
  }
}

Available Tools

Tool	Description
`list_databases`	List all `.db` files in the app's databases directory
`list_tables`	List all tables in a database
`describe_table`	Show column schema for a table
`query`	Execute a SELECT query (returns JSON)
`execute`	Execute INSERT/UPDATE/DELETE (pushes changes back to device)

How It Works

Each read operation pulls a fresh copy of the database from the device via adb shell run-as <package> cat databases/<db>
Queries run locally using better-sqlite3
Write operations (execute) pull the db, modify locally, then push back via ADB

from github.com/hortusys/android-sqlite-inspector

Установить Android Sqlite Inspector в Claude Desktop, Claude Code, Cursor

Рекомендуется · одна команда, все IDE

unyly install android-sqlite-inspector

Ставит в Claude Desktop, Claude Code, Cursor и VS Code — сам разбирается с npx, uvx и сборкой из исходников.

Впервые? Поставь CLI: curl -fsSL https://unyly.org/install | sh

Или настроить вручную

Выполни в терминале:

claude mcp add android-sqlite-inspector -- npx -y android-sqlite-inspector

FAQ