SQLScout

SQLScout is a plugin for Android Studio and Intellij IDEA which allows you to connect to SQLite databases, browse tables and schemes.

Features

SQLScout is an extremely powerful tool for SQLite debugging. The core features:

SQLite Explorer

SQLite Editor

Data console

Database diagrams

SQLite explorer is a main window of SQLScout that shows databases, tables, and columns using a tree view. It allows you to overview a scheme of databases, upload a new database or synchronize existed. SQLite explorer also provides navigation options to other windows such as SQLite editor, data console, and database diagrams.

SQLite Editor includes a file-based and in-memory SQL editors. It is a powerful editor with a lot of features such as syntax highlighting, code completion, navigation to schema and alias definition.

Data console displays query results and allows you to edit table data, and to export its content to different formats.

Database diagrams window shows generated diagrams for databases with visualization of tables, columns and relationships.

Pros and Cons

SQLScout is a really powerful and well-documented tool for SQLite debugging. It includes a lot of features that can satisfy all your needs. But there is no functionality which allows you to inspect a database remotely. You have to physically connect your device. Since SQLScout is a plugin you need to install it just once and there is no need in integration for each of your projects. Trial period is 14 day and free plans are available only for open-source developers.