Table-related Functions

Everything you do to tables and memos once they exist — selecting, moving, copying, coloring, and setting what each table shows — plus the canvas controls around them.
The table and memo commands come first, then table properties, indexes, automatic placement, and the database vendor, and the canvas itself last: zoom, panning, and the diff viewer.

Multiple Selection

Supports three methods:

• Ctrl + drag (Windows/Linux) or ⌘ + drag (Mac)
• Ctrl + click (Windows/Linux) or ⌘ + click (Mac)
• Ctrl + Alt + A (Windows/Linux) or ⌘ + ⌥ + A (Mac)

Memos are selected the same way, and that shortcut takes every table and memo at once.
A selection box marks an entity when it covers the middle of it, not when it merely touches an edge.

In a collaborative session, each participant's selection, focused cell, and selection box are drawn on the canvas in that participant's color — see Collaborative Editing.

Moving Multiple Tables

Drag with Ctrl + drag (Windows/Linux) or ⌘ + drag (Mac).
Dragging without it clears the selection and moves only the dragged table.

Copying/Pasting Tables and Memos

Copies the selected tables and memos and pastes them back as new ones.
Shortcuts: Ctrl + C (Windows/Linux) or ⌘ + C (Mac), Ctrl + V (Windows/Linux) or ⌘ + V (Mac)

A copied table keeps its name, comment, columns, and color; a copied memo keeps its text, size, and color.
Indexes and relationships are not copied, and a copy keeps the original name.
The pasted copies become the new selection, and pasting the same copy again offsets it by a further 50px each time, so repeated pastes do not stack on top of one another.

When columns are selected inside a focused table, the same shortcut copies those columns instead — see Table Editing.

Duplicating Tables and Memos

Hold Alt and drag a table or memo with the left mouse button.
A translucent preview follows the pointer, and releasing the button drops the copy where the preview sits.
If what you grab is already part of a selection, the whole selection is duplicated. Otherwise the selection is replaced by the entity under the pointer.
Alt + click without moving drops the copy 50px down and to the right, stepping further whenever that spot is already taken.

A duplicate carries the same things as a paste: names, comments, columns, colors, and memo sizes, but not indexes or relationships.

Table and Memo Deletion

Deletes the currently selected table or memo.
Shortcuts: Ctrl + Backspace (Windows/Linux) or Ctrl + Delete (Windows/Linux) or ⌘ + Backspace (Mac) or ⌘ + Delete (Mac)

Table and Memo Color Specification

You can designate colors to differentiate by category.
Click the color strip along the top of a table or memo to open the picker. The color is applied to every selected table and memo, not only the one you clicked.

Table View Options

Offers the following view options:

• Table Comment
• Column Comment
• DataType
• Default
• Not Null
• Unique
• Auto Increment
• Relationship

Table Properties

Opens the property panel of the selected table. Start from the table context menu or by using the shortcut Alt + Space. It provides three tabs: Indexes, Schema SQL, and Code Generator. The panel keeps the five most recently opened tables along the top, so you can move between them without reopening it.

Indexes

Indexes are defined in the Indexes tab of the table property panel and are included in the exported Schema SQL.

The left side lists the indexes on the table. Add one with +.
Each index has a UQ toggle that makes it unique, a name field, and an x that removes it.

The right side lists the table's columns with a checkbox each. Nothing is editable until an index is selected on the left.
Tick a column to add it to the selected index, and untick it to remove it.
The columns of the selected index are listed below. Drag them by the grip handle to reorder them, and click the ASC or DESC chip on a row to flip its sort order.

Automatic Table Placement

Spreads every table across the canvas so that connected tables sit near each other and overlapping ones are pulled apart.
Run it from the canvas context menu or from quick search.

A preview of the whole canvas opens while the layout settles, with Stop and Cancel on the notice it shows.
Stop keeps the positions as they stand at that moment, and the layout is applied on its own once it comes to rest. Cancel or Escape leaves the diagram as it was.
The result lands as a single history entry, so one undo puts every table back where it was.

It works by running a force simulation over the diagram: relationships pull tables together, and neighbors push each other apart.

Databases

Supported databases include:

• Databricks
• MSSQL
• MariaDB
• MySQL
• Oracle
• PostgreSQL
• Snowflake
• SQLite

These options determine the Schema SQL syntax for exporting, the DataType autocomplete, and the types that generated code and imported schemas resolve to.
Multi-word type names such as TIMESTAMP WITH TIME ZONE and INTERVAL DAY TO SECOND are kept intact when Schema SQL is imported, argument list included.

Zoom In/Out

Zooms with Ctrl + Wheel (Windows/Linux) or ⌘ + Wheel (Mac). The wheel alone scrolls the canvas.
Shortcuts: Ctrl + Plus (Windows/Linux) or ⌘ + Plus (Mac), Ctrl + Minus (Windows/Linux) or ⌘ + Minus (Mac)

Zoom ranges from 10% to 100%.
At 70% and below, tables collapse to a color bar and their name, and cell editing, the cell shortcuts, and copy and paste stop working until you zoom back in.

Getting Around the Canvas

Drag an empty area of the canvas to pan, or hold Space and drag anywhere, including over a table.
The minimap in the top-right corner always shows the whole canvas. Click it to move the view to that point, or drag the viewport rectangle to scroll.
If a table or memo ends up outside the canvas, a pin marker appears on the matching edge. Click it to bring that entity back to the point you clicked and select it.

Diff Viewer

You can compare previously saved documents with the current document.
Choose Diff Viewer from the canvas context menu and pick a .json document you exported earlier.

The view opens over the canvas: what changed on the left, then the saved document and the current one side by side.
Both sides are read-only, so nothing in your document is modified. Close the view with the Close button on the notice it opens with, or with Escape.