You can check free tool Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview which I think is far superior to other GUI tools.
It works natively (!) on all 3 os: linux, mac and windows
* it works with SQLite as well as with mySQL/mariaDB, PostgreSQL and Valentina DB
It has a lots of advanced tools:
* Diagrams with forward engineering
* Schema Editor, which can change structure of your SQLite tables even if they have records
* Data Editor
* SQL Editor with syntax highlighting and auto-completion
* visual Query Builder
* SQL Dump
* and many others
I know how to get to the sqlite app on my system, but, to me that seems very clunky to try and code in. I had a course in SQL and used the SQL server 2008 and it seemed pretty straight forward after a couple of weeks working with that.
Has anyone had experience using any of the MAC SQLite Managers? Any suggestions on one of these? I would lie to do so work on my Mac for a change.
I see one listed in C-NET as the best, but, I always take the ratings with lots of grains of salt.