Skip to content

🧩 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.

Database Registration

Automatic (Android)

On Android, Flocon automatically scans your app's internal sandbox for SQLite database files without requiring additional setup.

In-Memory / Custom Databases (Android)

To register an in-memory Room database or specify a custom display name:

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

floconRegisterDatabase(
    displayName = "In-Memory Dogs",
    openHelper = dogDatabase.openHelper
)

Kotlin Multiplatform (Desktop & iOS)

For KMP projects, register the database with its absolute filesystem path:

val dbFile = File(System.getProperty("java.io.tmpdir"), "app_database.db")

floconRegisterDatabase(
    displayName = "App DB",
    absolutePath = dbFile.absolutePath,
)

val dbPath = "${documentDirectory()}/app_database.db"

floconRegisterDatabase(
    displayName = "App DB",
    absolutePath = dbPath
)

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

val dbName = "dogs_database"
val database = Room.databaseBuilder(
    context.applicationContext,
    DogDatabase::class.java,
    dbName
).setQueryCallback({ sqlQuery, bindArgs -> 
    floconLogDatabaseQuery(
        dbName = dbName, 
        sqlQuery = sqlQuery, 
        bindArgs = bindArgs
    ) 
}, Executors.newSingleThreadExecutor())
.build()

floconLogDatabaseQuery(
    dbName = "my_custom_db",
    sqlQuery = "SELECT * FROM users WHERE id = ?",
    bindArgs = listOf(42)
)