SQLScout (SQLite Support)

Compatible with: IntelliJ IDEA PhpStorm WebStorm PyCharm RubyMine GoLand Android Studio
Feb 13, 2019
70 086
First-class SQLite support for Android Studio and IntelliJ IDEA.

View, manage and update SQLite databases in your Android device (in real time) and file system, from Android Studio and IntelliJ IDEA.

Download plugin

Recent change notes

Version 5.1.0
  • Added support for opening SQLite databases Write-Ahead Logging (WAL). Please note that this fix affects opening databases in the file system or downloaded from Android devices (e.g. Room databases). Opening Android databases through SQLScout's "Live Device Connection" has always supported WAL.
Version 5.0.0
  • Added support for Android Studio 3.3.
  • Updated SQLite JDBC driver to version 3.25.2. This version supports Sqlite's UPSERT and window functions. Please note that the "Live Device Connection" feature does not use SQLScout's embedded JDBC driver, but theSQLite engine in the Android device instead.
  • SQL language support improvements:
    • SELECT statements are allowed inside functions.
    • Added support for parsing UPSERT clauses (UPSERT was added to SQLite 3.24.0).
    • Added support for parsing window functions (window functions were added to SQLite 3.25.0).
  • SQL editor improvements:
    • Code completion offers binary operators when appropriate.
    • Code completion and syntax highlighting support for UPSERT clauses.
    • Code completion and syntax highlighting support for window functions.
Version 4.4.2
  • Fixed usages of APIs removed in Android Studio 3.2.
  • Added support for debugging SQLite databases in Android applications built with Xamarin.
Version 4.4.1
  • Improved handling of database connection errors. When SQL Scout fails to connect to a database:
    • The database's icon in the "SQLite Explorer" is decorated with a red "X".
    • Hovering over the database's icon in the "SQLite Explorer" displays the connection error message.
    • "SQLite Explorer" no longer attempts to reconnect to a Data Source with a failed database connection to avoid spamming the "Event Log" with error messages.
    • The "connection error" message in the "Event Log" contains hyperlinks to:
      1. Remove the database from the "SQLite Explorer"
      2. Select the database in the "SQLite Explorer"
Version 4.4.0
  • Added support for Android Studio 3.2 Beta 2, while keeping backwards compatibility with Android Studio 3.1.x.
  • Fixed bug where uploading database file to device failed with "file already exists" error.
Version 4.3.0
  • "Live Device Connection" now works with Samsung and non-rooted devices (this version of SQLScout requires SQLScout Server 4.1 or newer.)
  • When creation of a "Live Device" connection fails due to a failed connection to the app, SQLScout now displays a dialog suggesting that an instance of SQLScoutServer may be missing in the application's Activity. The dialog includes a link to our documentation, and code samples that can be copied/pasted.
Version 4.2.0
  • If SQLScout server is not found as a dependency, SQLScout now automatically adds both com.idescout.sql:sqlscout-server and com.idescout.sql:sqlscout-server-noop to the application's debug and release build types, respectively.
  • Fixed bug where SQLScout preferences/settings were not stored in the correct location.
  • Room Migration:
    • Version of Room to use is now a configurable preference/setting.
  • SQL editor:
    • Added support for EXPLAIN and EXPLAIN QUERY PLAN.
    • Strings now can be used as column aliases.
    • Functions can be used as table references in 'from' clauses.
Version 4.1.2
  • When creating a "Live Device" connection, now SQLScout checks whether the current selected build variant has SQLScout's server declared as dependency.
Version 4.1.1
  • Removed check where Android applications need to be launched from the IDE before connecting to a database.
  • Local data sources are now automatically removed if the database files they point to no longer exist.
  • Added additional logging to troubleshoot issues with Samsung devices.
  • Updated Xerial JDBC driver to version 3.21.01.
Version 4.1.0
  • Support for Android Studio 3.1.
  • Room Migration:
    • Added support for nullability when generating Entity classes from a database schema:
      • Kotlin: field types are marked as nullable (using the ? keyword)
      • Java: getters and setter-parameters are annotated with @NonNull and @Nullable (from the package android.support.annotation)
    • Generated code is automatically formatted.
  • SQL editor:
    • Added support for compound queries using the UNION, UNION ALL, INTERSECT or EXCEPT operators. Support includes parsing, syntax highlighting and code completion.
    • Fixed parsing and syntax highlighting of block comments.
  • Added support for connecting to databases by opening database files (with extensions ".db" and ".sqlite") from the file system or Android Studio's Device Explorer view.
Version 4.0.0
  • Support for database views.
  • Ability to save BLOBs as local files.
  • "File saved" notifications (SQL files, diagrams and BLOBs) now include a link to reveal the saved file in the system's file manager.
  • Support for SQLScout Server 4.0.0, which replaces XML with FlatBuffers for client/server communication in "Live Device" connections. This change fixes several bugs related to String encodings, invalid XML characters present in database columns, and BLOB handling.
  • Added support for automatically adding SQLScout Server and the IDEScout Maven repository to build.gradle files.
  • Fixed deadlock in IDE when attempting to create a new "Live Device" connection.
  • Fixed bug where "Room Migration" action was never enabled if the initial database sync failed to find ADB.
  • Fixed bug in "Room Migration" where migration got interrupted when project contained Kotlin code.
Version 3.3.1
  • "Room Migration" wizard now works with projects that do not have a root module.
  • Database Console can now delete and update rows in tables without primary keys.
Version 3.3.0
  • Added support for executing SQL statements inside Room's @Query annotation.
  • "Room Migration" wizard now can handle column names that are Java or Kotlin keywords.
  • Added support for executing parameterized SQL statements.
  • Added support for expressions using 'IN' operator.
  • Improved code completion for subqueries.
Version 3.2.0
  • Added support for automated migration to Android's Room persistence library.
Version 3.1.2
  • Added support for Android Studio 3.0.1.
Version 3.1.1
  • Fixed plugin jar timestamp issue.
Version 3.1.0
  • Added ability to connect to any database in an Android device, from the 'Device File Explorer' view.
  • Now it is possible to download database files from devices using Android 7 or later.
  • Android database files can now be downloaded to a user-specified folder.
  • Better error messages for failed license validations.
Version 3.0.0
  • Compatible with Android Studio 3.0.0.
  • Port used for 'Live Database' connection is now configurable.
  • Improvements to SQL editor:
    • Added support for comments.
    • Improved support for subqueries.
    • Added support for 'between' operator.
    • Added support for 'when' operator.
Version 2.0.8
  • Compatible with Android Studio 2.3.0.
  • Bug fixes.
Version 2.0.7
  • Bug fixes.
Version 2.0.6
  • Support for Android 7 (Nougat.)
  • Now 'Live Device Connection' can handle large tables (e.g. 20,000 records.)
  • Fixed handling of null values.
  • Bug fixes.
Version 2.0.5
  • Compatible with Android Studio 2.2.0.
  • Bug fixes.
Version 2.0.4
  • Unified "trial" and "registered" versions. Users no longer need to download 2 versions of the plugin.
Version 2.0.3
  • Fixed license number check.
Version 2.0.2
  • Minor bug fixes.
Version 2.0.1
  • Fixed assertion error thrown when querying an empty table from the 'SQLite Explorer'.
Version 2.0.0
  • Added ability to manage and update databases in Android devices, in real time.
  • Editor gutter now displays an "Execute Statement" action next to each SQL statement.
  • Bug fixes.