Qrulla Docs

Working with data

Data grid

Browse, filter, sort and edit a table's rows, with every change saved together and safely.

Open a table

Double-click or Enter on a table in the tree (or right-click → “View data”). The grid loads rows as you scroll, so it works the same with tables of millions of rows. F5 reads them again.

“Query in the editor” opens an SQL editor with the query for what you're looking at.

Filter and sort

  • Sort: click a column header; Shift + click sorts by several.
  • Filter by a value: right-click a cell → “Only this value”, “Only the NULLs” or “All but this value”.
  • Filter builder: the “Filter” button opens, in the right panel, conditions combined with “All (AND)” or “Any (OR)”, and groups inside groups. Operators: equals, contains, starts with, is between, is in the list, is NULL, and more.
  • Edit as SQL: write the WHERE condition yourself. In visual mode, values are never mixed into the SQL.
  • Save a filter: “Save this filter as…” names it to use it again.

Filters and sorting run on the server: the grid only brings what matches.

Columns

Drag a header to move the column. From its menu you can hide it, pin the columns up to it (they stay put as you scroll right) and copy its name or its values: one per line, with the name on top, without repeats or as a list ready for IN (…).

Edit

  1. Double-click a cell to edit it. Long or JSON cells are easier in “Edit in a window”, which also formats JSON.
  2. “Add row” and “Delete row” (Ctrl+Del) prepare new or deleted rows. Right-click a cell to make it NULL, empty or a new UUID.
  3. Ctrl+Z undoes a cell's last change. “Discard changes” undoes them all.
  4. “Save” (Ctrl+S) shows what will be done and applies it in a single transaction: if anything fails, nothing is saved.

If a row changed or was deleted on the server since you read it, nothing is saved and Qrulla asks you to refresh: that way you don't overwrite someone else's work.

A table without a primary key opens read-only, because there's no safe way to identify each row.

In MongoDB, which has no transactions on a single server, Qrulla checks before saving that each document is still there; if one is missing, nothing is saved.

Views

“View” switches between Table, Detail (the picked row in the right panel) and Form (one record at a time, with buttons to move, add and delete). Form changes stay pending as in the table, until “Save”.

Copy and paste cells

Ctrl+C copies the picked cells as tab-separated text, which pastes well into Excel. The “Copy in format” menu also offers CSV, JSON, INSERT and UPDATE by primary key, with or without headers.

Ctrl+V pastes rows copied from Excel or another table into the cells; they stay pending so you can review and save them.

When you pick several cells with numbers, the bar below shows their sum, average, minimum and maximum.

Ctrl+F searches a text in the loaded rows and jumps from one match to the next.

Export

“Export” saves what you see (with its filter and sort) as CSV, JSON, Excel or SQL. See Import and export.

Something missing or unclear? Write to support@qrulla.com.