SQLens is a powerful Android Studio plugin designed to simplify the inspection and management of SQLite databases in running Android applications. With a modern, Material Design-inspired interface, it connects directly to your device via ADB to view, query, and export data effortlessly.

• Real-time Device & Database Discovery: Automatically detects connected devices (emulators & physical) and lists debuggable applications and their SQLite databases.
• Modern Data Browser: View table data in a clean, paginated grid with intelligent column sizing and handling for BLOBs and NULL values.
• Smart Query Editor: Execute custom SQL queries with a dedicated editor. Support for SELECT, INSERT, UPDATE, DELETE and more.
• Schema Viewer: Inspect table structures, including column types, primary keys, and foreign keys.
• Advanced Export: Export data to CSV, JSON, SQL, and Markdown formats.
• Quick Sync: One-click database synchronization to pull the latest data from the device.
• Material UI: A beautiful, dark-theme-aware interface that feels right at home in modern Android Studio versions (2024.1+).

1. Open Android Studio -> Settings/Preferences -> Plugins.
2. Click the Gear Icon -> Install Plugin from Disk....
3. Select the SQLens-1.0.0.zip file.
4. Restart Android Studio.

1. Open Tool Window: Go to View -> Tool Windows -> SQLens.
2. Connect Device: Ensure your Android device is connected and debugging is enabled.
3. Browse: Expand the device and app nodes to see databases. Double-click a table to view data.
4. Query: Switch to the Query tab to run custom SQL commands.

This repository contains two main modules:

• sqlite-viewer-plugin/: The source code for the SQLens IntelliJ/Android Studio plugin.
• sqlens-sample-app/: A sample Android application with a complex Room database (relations, indexes, BLOBs) used for testing the plugin.

• Initial release with core functionality.
• Device and App discovery via ADB.
• Table data viewer with pagination and filtering.
• Custom SQL execution.
• Export to CSV, JSON, SQL, Markdown.
• Modern, dark-theme-ready UI.

Apache License 2.0. See LICENSE for more information.

Built with ❤️ for Android Developers