Getting Started with SQLite on macOS / Mac OS X

SQLite is a compact, cross platform, self-contained relational database management system that is available in the public domain. SQLite is included in macOS and Mac OS X by default. It is located in the /usr/bin directory and called sqlite3.

Using SQLite, users can create file-based databases that can be transported across machines, platforms, etc. The only thing needed to then view or edit these databases is the SQLite command line program, or another tool capable of communicating with SQLite.

SQLite databases can be created by using the sqlite3 program in /usr/bin. To get to this program, you can open up a terminal window (Applications -> Utilities -> Terminal) and then type the following:
cd /usr/bin/

sqlite3

You can exit the command line program by holding the control button and typing z.

Creating and editing databases is cumbersome using the command line program, so a graphical tool like RazorSQL that is capable of communicating with SQLite makes it much easier to manage your SQLite databases.

RazorSQL is available from here

https://razorsql.com/download.html

With RazorSQL, users can create new or edit existing SQLite databases. It also provides an SQLite browser for showing all tables, views, triggers, etc. and an SQL editor for writing queries and statements to execute against the SQLite database.