Mac system comes with Sqlite3 query

The system has its own sqlite. Easy to use, just open the terminal command-line tool and start working with the SQLite database.

Here is a simple example. Input in terminal: Sqlite3 demo.db; This opens the SQLite and creates a library called demo, which adds a table to the library: Create TABLE Admininfo (ID integer primary key, name text); Note that each command is terminated with a semicolon; Insert a record in this table: INSERT into Admininfo (ID, name) VALUES (1, ' Stormer '); Query table records: SELECT * from Admininfo; It's simple. The other commands can be found in a manual.  If it is too inconvenient to use the command line can find a GUI software to manage the SQLite database. PS://In the Mac under the command to create a database file to the specified location sqlite3/volumes/work/webdb.sqlite;

Mac system comes with Sqlite3 query (GO)