Data Grid

Click a table or view in the explorer to open its rows in the data grid. You can find, edit, import, and export data without writing SQL.

Browse

Rows load one page at a time. Use the arrows in the status bar to move between pages, and change Limit to load more rows per page.

Click Columns to hide columns you do not need. Press Alt R (web) or ⌘ R (desktop) to reload the data.

Filter and sort

There are three ways to narrow the rows:

Filters: add one or more conditions, each with a column, an operator, and a value.
Sorts: add one or more sort columns, each ascending or descending.
Condition bar: type a SQL condition such as status = 'active' AND id > 100 and press Enter.

You can also right-click a cell to filter by its value (=, ≠, IS NULL, IS NOT NULL) or to sort by its column.

Query preview shows the exact SQL the grid sends, which you can copy into the SQL editor.

Edit rows

Double-click a cell to edit it. The cell is marked as changed.
Add a row with Alt N (web) or ⌘ ⇧ N (desktop), or duplicate an existing one from the right-click menu.
Delete rows from the right-click menu.
Press Alt S (web) or ⌘ S (desktop) to save all pending changes in one go, or discard them with Alt ⇧ D / ⌘ ⇧ D.

Nothing is written to the database until you save.

The right-click menu also sets a cell to NULL, to an empty value, or to the column default.

Special column types

Type	Editor
JSON	A formatted editor that checks the JSON before saving.
Binary	A hex view, with a preview when the bytes are an image.
Geometry	WKT input with a map preview.
Foreign key	A picker that lists rows from the referenced table.
Long text	Open the full editor from the right-click menu.

Columns that cannot be edited, such as generated columns, are read-only. With Safe Mode on, saving may ask for confirmation or your Safe Mode password.

Copy

Right-click a cell to copy the cell, the column name, or the whole row as CSV or TSV.

Import

Click Import in the action bar to load rows from a file into the open table.

Format	Expected content
CSV	A header row with column names, then one row per line.
JSON	An array of objects whose keys are column names.
SQL	`INSERT` statements.

Imports run as background jobs, with a progress window while they run.

Export

Click Export in the action bar to save the table as CSV, JSON, or SQL INSERT statements. Exports also run in the background. Download the file when the job finishes.

SQL editor
Schema and diagrams: change columns and indexes

SQL Editor

Schema and Diagrams