SQLite Backup.scpt

do shell script "/Users/user-name/Library/Android/sdk/platform-tools/adb pull sdcard/Android/data/com.example.test/files/ /Users/user-name/Desktop/"
tell application "Finder" to open POSIX file "/Users/user-name/Desktop/files/sqlite/db_name.db"

Database file should be put in external directory for this to work. Below snippet shows how to change database file path only for debug build.

val db by lazy {
            val name = if (BuildConfig.DEBUG) {
                "${appContext.getExternalFilesDir(null).absolutePath}/sqlite/db_name.db"
            } else {
                "db_name.db"
            }
            Room.databaseBuilder(
                appContext,
                YourDatabse::class.java, name
            ).build()
        }

Also sqlite browser should be installed.