• English

      • Data Browsing

      The result grid is rendered on Canvas for performance, and includes:

      • Pagination — when a source is opened (or a SQL query without automatic results), the grid pages through the data.
      • Column hiding — show or hide columns to focus on what matters.
      • Computed columns — in table browse, add SQL expressions such as a + 1 AS a1 from the toolbar; the grid runs SELECT *, … FROM table. Filtering follows your database’s SQL rules: SELECT aliases are often unavailable in WHERE (use the full expression, e.g. a + 1 > 0); ORDER BY may accept aliases depending on the dialect.
      • Transpose — flip rows and columns for a different view of the dataset.
      • Result filtering — filter within the loaded result set.
      • Column analysis — from a column header menu, open Column profile or pivot.
      • Per-cell value inspection — open any cell in the Value viewer for raw / JSON views and statistics.

      Copying data

      Select cells or a range, then right-click: Copy (plain text) sits at the top level, and the remaining formats live under the Advanced copy submenu to keep the menu short.

      Menu itemOutputHeader
      CopyPlain text (tab-separated, as selected)Follows the selection
      Advanced copy → Copy as CSV / Copy as TSVComma / tab separatedFollows the selection
      Advanced copy → Copy as CSV with headerComma separatedAlways included
      Advanced copy → Copy as Markdown tableGFM table (| escaped, newlines become <br>)Always included
      Advanced copy → Copy as HTML table<table> — pastes into docs and rich-text editorsAlways included
      Advanced copy → Copy as JSONArray of row objects keyed by column namen/a
      • Header source — when the selection includes the header row, real column names are used; otherwise it falls back to the column field, then to the column position (col0).
      • Values — the raw cell values: NULL / empty renders as an empty field in CSV / TSV / Markdown / HTML, and as null in JSON.
      • Transpose — a transposed view is transposed back into a regular table on copy: each row is one original column, named after its label cell.
      • Copying more than 2000 rows reports the row count, so a large copy never looks like it silently did nothing.

      Value viewer

      Inspect a cell in raw or JSON form, with a Calculate tab that computes per-selection statistics (min / max / mean / …) and exports them as Markdown — handy for quick sanity checks on a selection of values.