How to create an SQLite Database. Use dbHarbor to save time.

  • by

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.

  1. Download and open dbHabor: SQLite from the Mac AppStore.
  2. Click on “Create a new database” button.
Create a new SQLite database in dbHarbor: SQLite
Create a new SQLite database in dbHarbor: SQLite

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

Save created database in dbHarbor: SQLite
Save created database in dbHarbor: SQLite

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😎

Leave a Reply

Your email address will not be published. Required fields are marked *