Editing Data

Data Explorer supports inline data editing for compatible sources. Changes are staged locally and only committed when you save — so you can review, undo, and adjust before anything is written.

Editable vs. Read-only

The breadcrumb header shows the current state:

Editable sources:

• Database tables (with or without a primary key)
• Database views
• Individual files (CSV, JSON, Parquet)

Read-only sources:

• Table groups (folders containing multiple part files) — select an individual file within the group to edit it

Toolbar

When an editable source is open, the toolbar provides these actions:

The Save and Cancel buttons only appear when there are staged changes.

Inserting Rows

1. Click + Add row in the toolbar, or press Ctrl+I (⌘+I).
2. Fill in the column values in the panel that opens.
3. Click Insert to stage the row, or Insert & add another to continue adding rows.

The new row appears in the grid highlighted in green. It is not yet written to the database — it remains staged until you save.

Editing Cells

1. Double-click any cell in an editable table, or navigate to it with arrow keys and press Enter.
2. Type the new value.
3. Press Enter to confirm, Tab to confirm and move to the next cell, or Escape to cancel without staging.

Edited cells are highlighted so you can see at a glance what has changed. Hovering over an edited cell shows a tooltip with the old and new value.

Undoing a cell edit

Press Ctrl+Z (⌘+Z) to revert the most recent cell edit. Each press reverts one edit in reverse order. You can also right-click a changed cell and choose Revert cell from the context menu.

Deleting Rows

1. Select one or more rows (click, Shift+Click, or Ctrl+A).
2. Press Delete, or right-click and choose Delete selected rows.

Deleted rows are visually struck through in the grid. They remain staged — not yet removed from the database — until you save.

Reviewing Staged Changes

Click the review button (panel icon next to Save) to open the Pending Changes drawer. It shows:

• A summary: N inserts • N updates • N deletes
• Tabs to filter by type: All / Inserts / Updates / Deletes
• Per-row detail: old → new values for each changed field
• Undo button on each row to revert that single change
• Undo all to revert all changes of a given type

Keyboard shortcut: Press Ctrl+Enter (or ⌘+Enter) while the drawer is open to apply all changes immediately.

Saving Changes

Press Ctrl+S (⌘+S) or click Save in the toolbar to write all staged changes to the database or file.

• A progress indicator appears while the write is in progress.
• On success, the grid refreshes automatically to show the committed data.
• If an error occurs, the staged changes are preserved so you can correct and retry.

Discarding Changes

Click Cancel in the toolbar to discard all staged changes without saving. For larger change sets (more than 3 rows), a confirmation prompt is shown.

You can also discard changes by type using the dropdown arrow next to Discard all in the pending-changes drawer footer.

Keyboard Shortcuts

On macOS, substitute ⌘ for Ctrl in all shortcuts.

For row selection, copying, and the full context menu reference, see Viewing Data.

Related docs

• Viewing Data — Data grid, sorting, filtering, export
• Examining Table Structure — Columns, keys, indexes, DDL