If you want a free and open-source “Database Manager” for SQLite running on Mac OS X, I would suggest you to stick with Sqliteman. I think this is the best open-source tool to handle sqlite databases on Mac OS. Check their website for more information about features and screenshots.

How to install on Mac OS X

There is no version available for download on Sqliteman website and you’ll have to install using MacPorts:

hell:~ fmachado$ sudo port install sqliteman

 “QSqlDatabase: QSQLITE driver not loaded” error

I got this error and was a bit painful to figure out how to fix it. Anyway, if you get this error when trying to open a SQLite database, all you have to do is install “qt4-mac-sqlite3-plugin”.

hell:~ fmachado$ sudo port install qt4-mac-sqlite3-plugin

🙂