In this tutorial, you will learn how to create an SQLite database using a command line or dbHarbor: SQLite.
SQLite – CREATE Database using the command-line
sqlite3 command is used to create a new SQLite database.
Use the following syntax to create an empty SQLite database:
> sqlite3 {databasename}
So, if you want to create an SQLite database named “sakila.db”, open terminal and type following command:
> sqlite3 sakila.db
This command will create an empty sakla.db database in the current directory. sqlite3 command will provide a sqlite> prompt after creating a database file successfully.
Use .quit command to quit sqlite prompt:
> sqlite> .quit
Use dbHarbor: SQLite
dbHarbor for SQLite provides a simple user interface for creating and managing SQLite databases.
- Download and open dbHabor: SQLite from the Mac AppStore.
- Click on “Create a new database” button.

3. Enter the database name and click on the “Save” button.

That’s it. You have successfully created your SQLite database in just 60 seconds.
Searching for a good GUI Client to work with SQLite databases on macOS? Download the latest version of dbHarbor in the Mac AppStore.
If you don’t want to miss the latest news about our development journey or join the beta waiting list for an exclusive, early access version, signup for our newsletter. Promise not to SPAM😎