I always forget this command, so I decided to make a small note about it.
There is a great Firefox extension called sqlite-manager, which obviously allows you to manage SQLite databases.
You can run Firefox, then select the SQLite Manager from the menu, then close the main window if you don’t need it. But there is an easier way that runs the extension directly:
or on OS X: