I'm trying to review the contents of the database after migrating from PermissionsEx 1.23.4 to LuckPerms v4.0.18 which appears to have migrated fine. What I'm trying to do is manually add users but if the user hasn't logged in, I'm not able to put them into a group since the user doesn't exist yet for the Spigot world I'm converting to LP. I've updated SQLite client to 3.10.1x64 but when trying to open the file, I get Invalid Format.

Server Setup: 1.12.2 BungeeCord/Spigot on Windows 10 Pro x64 (LuckPerms on Spigot only so far).
I'm added into the right group and can log in, but I need to be able to add users before they connect so they get defaulted into the proper group after they've been whitelisted. Couldn't find the wiki page that talks to this.

Thanks - Steve

Assuming you haven’t changed the storage type, it is h2 by default, not SQLite.

You can either change the storage type to SQLite or add a user by using their UUID in the command.

When changing the storage type either use the export/import feature (see wiki) or migrate again after changing.

Also the default group is always called default

awesome! Thank you for the detail and very quick response, I do appreciate it. I was trying to add the user by their name, not the UUID. Once I changed it to the UUID, I was able to add the account. :-)