​
Insert

To insert a new row:
  1. Right-click anywhere in the table view
  2. Click the “New row” button
New row A new row then appears at the bottom. Double-click a column to enter value for it, or leave it blank to use the column’s default value. The new row will be highlighted in green while it is not committed. New row revealed

​
Update

To update a column’s value, double-click the column. This will reveal an input field where you can enter a new value: Update value Columns with uncommitted changes are highlighted in yellow: Updated value highlighted

​
Delete

To mark a row for deletion:
  1. Right-click the row
  2. Click the “Delete row” button
Alternatively, select a row by left-clicking it, then use the ⌫ (backspace) shortcut. Delete row Rows marked for deletion are highlighted in red while the change is not committed: Row to be deleted is highlighted

​
Commit

Inserts, updates, and deletions are not executed immediately. You have to explicitly commit them to the database. To do so, either use the ⌘S shortcut or:
  1. Right-click anywhere in the table view
  2. Click the “Commit” button
Commit changes

​
Preview changes

To preview the exact SQL statements that will be executed when you commit changes:
  1. Right-click anywhere in the table view
  2. Click the “Preview changes” button
Preview changes button You will then see an overlay like this: Change preview

​
Discard changes

To discard all uncommitted changes of the selected database connection:
  1. Right-click anywhere in the table view
  2. Click the “Discard changes” button
Discard changes