A very useful GUI for browsing sqlite DB either on Mac or Windows:
sqlite browser let you:
- browse DB content
- modify DB content
- execute SQL commands
One thing to note, you can edit the content of your DB using this tool. After you make some modifications, make sure click on 'Write Changes' on the top to apply the changes to the DB.