Using Sheeta AI
Data Manipulation
You can change table data in the grid the way you would in a spreadsheet. Cell edits and new rows stay pending until you save them, so you can review or cancel them first.
Edit cells
- Double-click a cell, press Enter or start typing to edit it.
- Press Enter to confirm and move down, or Esc to stop editing.
- Press Backspace to clear the selected cells.
- Columns with a fixed set of values, such as enums, suggest the allowed values as you type.
Changed cells are highlighted, and the toolbar shows Save and Cancel. Press Cmd+S / Ctrl+S or click Save to write all pending changes. Click Cancel to discard them.
Paste data
Copy cells from Sheeta AI or a spreadsheet and press Cmd+V / Ctrl+V. Rows and columns are filled starting at the selected cell. If you copy a single value, it fills every selected cell. Values that fall outside the table are dropped.
Undo and redo
Before you save, press Cmd+Z / Ctrl+Z to undo an edit. Redo is Cmd+Shift+Z on macOS and Ctrl+Y on Windows.
Insert rows
- Right-click the grid and choose Add data, or press Cmd+N / Ctrl+N, to jump to the first empty row on the last page.
- Choose Insert rows to add blank rows. The number of rows matches the number of selected rows.
- Fill in the values and press Cmd+S / Ctrl+S to save.
To load many rows at once, see Importing Data.
Delete rows
Select one or more rows by clicking their row numbers or dragging over cells, then right-click and choose Delete Rows. After you confirm, the rows are deleted right away. Row deletes do not wait for Save and cannot be undone.
Manage tables and columns
Right-click a table in the Database sidebar for Edit Table (rename), Duplicate Table, Truncate Table and Delete Table. Truncate removes all rows and keeps the table. Each of these asks you to confirm first.
In the grid, click Add column in the header to add a column, or open a column's menu for Edit column and Delete column.
Read-only data
Database views and query results cannot be edited. Their grids still support copying, exporting and hiding columns.