It's not for everyone but I can think of 2 use cases immediately:

1. If you're a developer, then you're probably using sqlite to store data and having a GUI for checking/modifying the database is probably handy.

2. Most application by other developers (even massive companies) use sqlite to store data under the hood even if the file doesn't appear to be named `.sqlite`. So if you want to tweak certain settings that aren't exposed to the end user, then you can use this to do that in a more user friendly way rather than crack out a command line tool for sqlite changes.