🧩 Database Explorer & SQL Editor

Flocon provides direct access to your application's local databases (SQLite, Room, SQLDelight), with an interactive desktop interface for exploring schemas, querying data, and logging live SQL statements.

Overview

Database Explorer Schema

SQL Editor

Key capabilities: - Automatic Detection: Automatically locates all SQLite databases on Android. - Schema Visualizer: Lists tables, primary keys, indexes, and column types. - Interactive SQL Workspace: Write and execute custom SQL queries with formatted tabular results. - Saved Queries: Bookmark frequently used queries. - Live Query Logging: Monitor queries executed by your app and ORMs in real time.

Setup

Add the database core and the module matching your Room version:

Room 2 (androidx.room)Room 3 (androidx.room3)

dependencies {
    debugImplementation("io.github.openflocon:flocon-database-core:LAST_VERSION")
    debugImplementation("io.github.openflocon:flocon-database-room:LAST_VERSION")
    releaseImplementation("io.github.openflocon:flocon-database-core-no-op:LAST_VERSION")
    releaseImplementation("io.github.openflocon:flocon-database-room-no-op:LAST_VERSION")
}

dependencies {
    debugImplementation("io.github.openflocon:flocon-database-core:LAST_VERSION")
    debugImplementation("io.github.openflocon:flocon-database-room3:LAST_VERSION")
    releaseImplementation("io.github.openflocon:flocon-database-core-no-op:LAST_VERSION")
    releaseImplementation("io.github.openflocon:flocon-database-room3-no-op:LAST_VERSION")
}

Then install the plugin. room() (from io.github.openflocon.flocon.database.room, or .room3) adds the Room provider:

startFlocon(context) {
    install(FloconDatabase) {
        room()
    }
}

Database Registration

Automatic (Android)

With room(), Flocon automatically scans your app's databases folder for SQLite database files on Android.

Room Databases (all platforms)

To register a Room database (in-memory databases included) with a display name:

val dogDatabase = Room.inMemoryDatabaseBuilder(context, DogDatabase::class.java).build()

Flocon.databasePlugin.register(
    displayName = "In-Memory Dogs",
    database = dogDatabase,
)

register(displayName, database) comes from io.github.openflocon.flocon.database.room (Room 2) or io.github.openflocon.flocon.database.room3 (Room 3).

Room 3 on the web (Wasm)

Room 3 runs on Wasm with WebWorkerSQLiteDriver (androidx.sqlite:sqlite-web), which talks to a SQLite Web Worker. There is no file system, so the databases are not discovered: register each Room database with register(displayName, database) (the plugin still has to be installed with install(FloconDatabase) { room() }):

val dogDatabase = Room.databaseBuilder<DogDatabase>(name = "dogs.db")
    .setDriver(WebWorkerSQLiteDriver(createWorker()))
    .build()

Flocon.databasePlugin.register(displayName = "dogs", database = dogDatabase)

See FloconAndroid/sample/wasm for a complete setup (worker, npm package and KSP for wasmJs).

SQLite Files (Kotlin Multiplatform)

Any SQLite file can be registered with its absolute path:

Flocon.databasePlugin.register(
    FloconFileDatabaseModel(
        id = "app_db",
        displayName = "App DB",
        absolutePath = dbFile.absolutePath,
    )
)

Real-Time Query Logging

Flocon can display all SQL queries executed by your app in real-time — great for verifying generated queries from Room or detecting slow multi-table joins.

Database Query Logging

Room 2 (Android)Manual Query Logging

val database = Room.databaseBuilder(
    context.applicationContext,
    DogDatabase::class.java,
    "dogs_database"
)
    .floconLogs() // io.github.openflocon.flocon.database.room.extensions.floconLogs
    .build()

Room 3 has no query callback: use the manual logging.

Flocon.databasePlugin.logQuery(
    dbName = "my_custom_db",
    sqlQuery = "SELECT * FROM users WHERE id = ?",
    bindArgs = listOf(42)
)

Room only accepts one query callback per database. If your app already sets its own setQueryCallback, call logQuery from it to forward the queries to Flocon:

Room.databaseBuilder(context, DogDatabase::class.java, "dogs_database")
    .setQueryCallback({ sqlQuery, bindArgs ->
        Flocon.databasePlugin.logQuery("dogs_database", sqlQuery, bindArgs)
        myOwnLogger.log(sqlQuery)
    }, Executors.newSingleThreadExecutor())
    .build()