Getting Started

Start working with dbHarbor - SQL management tool for macOS

Open a database

Opening a database is a fairly straight forward process:

  1. Open the dbHarbor App

  2. Select a database from the list

  3. Or click on "Open another database" button and choose a database

Edit data

To edit table data inline, you can double-click on the data cell and enter new values. To add new table rows use the + button at the tables bottom. To remove one or more rows, select those and press ⌫ keyboard button or use the - button at the tables bottom.

The changes are not commited to database until you save it. Press ⌘ + S after editing to commit the changes to the database.

Saving data

dbHarbor does not commit changes you made in visual editor to the database immediately. To commit changes to the database press ⌘ + S or use the menu File->Save.

Indeed the changes you make by running SQL queries are commited to the database immediately.

Create and execute SQL Queries

dbHarbor opens by default an SQL Editor View. You can allway add an additional SQL Editor View by clicking on + button on the top right window corner.

There is many possibilities to run a query in dbHarbor.

  1. You can run all queries from SQL Editor View at once by pressing ⌘ + ⇧ + R

  2. You can run a query positioned under the cursor by pressing ⌘ + U

Create Tables

To create a table click on the '+' button in the left bottom corner of the sidebar and select "New Table…".

How to create a new SQLite table in dbHarbor

dbHarbor will open a table editor view in the new tab on the left side of the main window.

Visual SQLite Table Editor in dbHarbor

Visual table editor lets you change the table name, add or remove columns, change column types and properties. You can also add foreign keys using by clicking on the arrow in the column named "FK".

Creating Foreign Keys for an SQLite Table in dbHarbor

When you are ready to push created table to the database, just press ⌘ + S and the table will be commited to the database.

Filter Data

To filter table data press the table options button (s. screenshot bellow) and choose the "Filter" menu item.

You can apply multiple filters to quickly filter out the records you want to see.

Go to the filter view again to refine the filter or to turn it off.

Filtering SQLite table records in dbHarbor