Android Sqlite

A Model Context Protocol (MCP) server to connect AI agents directly to the embedded SQLite/Room databases of your Android applications.

What problem does this solve?

Accessing embedded databases (SQLite, Room, SQLDelight) on Android devices during development has historically been a cumbersome process. It requires running adb shell run-as commands, manually copying files, dealing with .db-wal (Write-Ahead Logging) files to prevent data loss, and then using external SQL clients to read the information.

This MCP server automates the entire process. It allows any AI agent (like Claude, Cursor, or Antigravity) to inspect tables, read schemas, and execute live SQL queries (SELECT, INSERT, UPDATE, DELETE) on your application's database, right from the chat window.

Features

• 📥 Secure Extraction: Uses adb exec-out run-as to safely extract data without corruption and without requiring root access.
• 🗄️ Smart Caching: Stores local copies organized in ~/.android-sqlite-mcp/cache/.
• 🔍 Search and Inspection: Tools to search installed packages, list databases, view tables, and retrieve full DDL schemas.
• ⚡ Queries (CRUD): Executes raw SQL queries locally and returns the results in JSON format to the AI.

Technical Prerequisites

1. Node.js: Version 18 or higher.
2. Android Debug Bridge (ADB): Must be installed and configured in your system's PATH (verify with adb version).
3. Device/Emulator: A device or emulator must be connected (adb devices).
4. Debuggable App: The Android app must be compiled in debug mode (android:debuggable="true").

Getting Started (Standard Configuration)

There is no need to manually download or build this repository. You can run the server on the fly using npx.

The standard format to register an MCP server in any client is the following:

{
  "mcpServers": {
    "android-sqlite": {
      "command": "npx",
      "args": ["-y", "android-sqlite-mcp"]
    }
  }
}

AI Client Installation Guides

{
  "mcpServers": {
    "android-sqlite": {
      "command": "npx",
      "args": ["-y", "android-sqlite-mcp"]
    }
  }
}

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