Skip to main content
The Data Grid displays table rows in a spreadsheet-like interface with powerful editing, filtering, and navigation features. Modify data directly in cells, track pending changes, and commit them in batches.

​
Viewing Table Data

1

Open a Table

Click any table in the sidebar to open it in the Data Grid view.
2

Browse Data

Scroll through rows using the scrollbar or arrow keys. The grid uses virtual scrolling for performance with large datasets.
3

View Cell Details

Click a row to view full column values in the right panel, especially useful for long text or JSON data.

​
Grid Controls

​
Column Operations

  • Sort: Click column headers to sort ascending/descending (hold Shift to multi-sort)
  • Resize: Drag the column border to adjust width
  • Reorder: Drag column headers to rearrange columns
  • Hide/Show: Click the column visibility button in the status bar to toggle columns

​
Row Selection

  • Single Row: Click any row to select it
  • Multiple Rows: Hold Cmd and click to select multiple rows
  • Range Selection: Hold Shift and click to select a range
  • Activate Row: Double-click to view row details in the right panel

​
Editing Data

​
Inline Editing

1

Enable Editing

Ensure Safe Mode is disabled for the connection. Editing controls appear automatically.
2

Edit a Cell

Double-click any cell or press Enter to start editing.
3

Modify Value

Type the new value. Use Tab to move to the next cell, Shift+Tab to move back.
4

Save Changes

Modified cells turn yellow. Press Cmd+S or click Apply in the status bar to commit all changes.

​
Cell Types

Standard text input. Empty values can be set to NULL by clearing the cell.

​
Pending Changes Tracking

Zequel tracks all modifications before they’re committed:
  • Yellow Highlight: Cells with pending edits
  • Green Background: New rows waiting to be inserted
  • Red Background + Strikethrough: Rows marked for deletion
  • Changes Count: Status bar shows total pending changes (edits + inserts + deletes)
Changes are preserved even if you switch to the Structure view or navigate away. They’re only discarded when you close the tab.

​
Adding Rows

1

Click Add Row

Click the + button in the status bar or press Cmd+N.
2

Fill Cells

A new row appears at the bottom with a green background. Fill in values for each column.
3

Auto-Increment Columns

Primary key columns with auto-increment show (auto). They’re populated by the database on insert.
4

Apply

Click Apply to insert the row into the database.

​
Deleting Rows

​
Single Row Delete

1

Select Row

Click the row you want to delete.
2

Mark for Deletion

Press Delete or right-click → Delete Row.
3

Confirm

The row turns red with strikethrough. Click Apply to permanently delete it.

​
Bulk Delete

1

Select Multiple Rows

Hold Cmd and click multiple rows, or use Shift for a range.
2

Delete Selection

Press Delete to mark all selected rows for deletion.
3

Review and Apply

All marked rows show in red. Click Apply to delete them from the database.
Deleted rows are permanently removed from the database when you click Apply. This action cannot be undone.

​
Applying and Discarding Changes

​
Apply Changes

Commit all pending modifications to the database:
  • Button: Click Apply in the status bar
  • Keyboard: Press Cmd+S
  • Scope: Applies all edits, inserts, and deletes in one transaction
For tables without primary keys, Zequel constructs WHERE clauses using all column values to ensure the correct row is updated.

​
Discard Changes

Revert all pending modifications:
  • Button: Click Discard in the status bar
  • Keyboard: Press Cmd+D
  • Effect: Removes all yellow highlights, green rows, and red strikethroughs

​
Undo/Redo

Quickly undo or redo individual changes:
  • Undo: Press Cmd+Z to undo the last edit, insertion, or deletion
  • Redo: Press Shift+Cmd+Z to redo an undone action
  • Granularity: Undo/redo works at the cell level for edits and row level for inserts/deletes

​
Copy and Paste

​
Copy Cell Values

1

Select Cells

Click a cell or select multiple cells/rows.
2

Copy

Press Cmd+C or right-click → Copy.
3

Paste

Paste into Excel, Google Sheets, or any text editor. Values are tab-separated.

​
Paste Rows from Clipboard

Import data from spreadsheets:
1

Copy Data

Copy rows from Excel or Google Sheets (include headers).
2

Paste Rows

Right-click in the grid → Paste Rows, or press Cmd+V.
3

Column Matching

Zequel matches clipboard column headers to table columns (case-insensitive).
4

Insert

Rows are inserted immediately. Refresh the grid to see them.
Pasted data supports both tab-separated (TSV) and comma-separated (CSV) formats. Headers must match table column names.

​
Foreign Key Navigation

Navigate relationships between tables:
1

Identify FK Column

Cells in foreign key columns show a → icon on hover.
2

Click to Navigate

Click the icon to jump to the referenced table, filtered to the related row.
3

View Related Data

A new tab opens showing the referenced table with a filter applied.
Example: In an orders table, click the → next to customer_id to open the customers table filtered to that customer.

​
Filtering Data

​
Add Filters

1

Open Filter Panel

Click the filter icon in the status bar or press Cmd+F.
2

Select Column

Choose a column from the dropdown.
3

Choose Operator

Pick an operator: =, !=, <, >, <=, >=, LIKE, IS NULL, IS NOT NULL.
4

Enter Value

Type the filter value (skip for IS NULL/IS NOT NULL).
5

Apply

Click Apply Filters to reload the grid with filtered data.

​
Multiple Filters

Add multiple filters to narrow results:
  • Filters combine with AND logic
  • Click + Add Filter to add more conditions
  • Remove filters individually with the × button

​
Clear Filters

Click Clear Filters to remove all active filters and show all rows.

​
Pagination

Navigate large tables efficiently:
  • Page Size: Set in Settings → Grid Settings (default: 1,000 rows)
  • Navigation: Use the status bar arrows to move between pages
  • Jump to Page: Click the page indicator to jump to a specific page
  • Total Count: The status bar shows total rows (e.g., “1-1000 of 50,000”)
Changing the page size in Settings applies immediately and adjusts pagination.

​
Exporting Data

​
Export Current Page

Export only the rows currently visible:
1

Open Context Menu

Right-click in the grid → Export Page.
2

Choose Format

Select CSV, JSON, or SQL.
3

Configure Options

Set delimiter (CSV), pretty print (JSON), or schema options (SQL).
4

Save

Choose a destination and click Export.

​
Export Full Table

Export all rows (not just the current page):
1

Click Export

Click the export button in the status bar.
2

Select Format

Choose CSV, JSON, or SQL.
3

Export

Zequel streams all rows directly from the database to the file.
Full table exports can take time for tables with millions of rows. The export runs in the background.

​
Context Menu

Right-click on any cell or row for quick actions:
  • Copy: Copy cell value to clipboard
  • Copy Row: Copy entire row (tab-separated)
  • View Cell: Open large values in a popup viewer
  • Edit Cell: Start editing (same as double-click)
  • Delete Row: Mark row for deletion
  • Navigate FK: Jump to referenced table (if applicable)
  • Export Page: Export current page data

​
Keyboard Shortcuts

ShortcutAction
EnterStart editing cell
TabMove to next cell
Shift+TabMove to previous cell
Cmd+SApply changes
Cmd+DDiscard changes
Cmd+ZUndo
Shift+Cmd+ZRedo
Cmd+CCopy cell/row
Cmd+VPaste rows
Cmd+NAdd new row
DeleteDelete selected row(s)
Cmd+FOpen filter panel

​
Best Practices

Always review pending changes (yellow/green/red highlights) before clicking Apply. Changes are permanent.
Apply filters before editing large tables to reduce the data loaded into the grid.
Make multiple edits, then click Apply once to commit them all in a single transaction.
Be aware of foreign key constraints when deleting rows. Deletes may fail if referenced by other tables.

Build docs developers (and LLMs) love

Get started for freeTalk to us