For SQLite GUI tools, the Firefox add-on “SQLite Manager” is convenient and recommended.

・Download: SQLite Manager :: Add-ons for Firefox

There seem to be several SQLite GUI tools for Mac, but based on the comparison articles I’ve read, I think “SQLite Manager” is probably the most user-friendly.

・SQLiteのDBファイルを編集できるGUIツール for OSX - ろばの穴・別館

・[Mac][DB]Mac環境でのSQLiteのクライアント比較 | 太のうぇぶでぶ -There is no border in the Internet!-

That’s all from the Gemba.