v3.4.0 StableLocal-First Native MySQL Client

Data Grid Mastery: Column Jump, WHERE Filters & Details | VloamDb

Inspect, filter, and extract database records directly in the data grid with column jumping, WHERE presets, cell inspections, and instant SQL generators.

Jump to Column (Ctrl+F12 / ⌥⌘J) for Wide Tables

In production systems, wide tables frequently contain 50 to 100+ columns (status flags, audit timestamps, JSON metadata). Dragging horizontal scrollbars back and forth is exhausting and error-prone.

VloamDb provides a dedicated "Jump to Column" command: press Ctrl+F12 (Win) / ⌥⌘J (Mac) or click the toolbar icon while viewing any table:

🔍

Fuzzy Filter by Column Name & DataType

Type column names or SQL datatypes (e.g. time, status, json) for instantaneous filtering.

⚡

Instant Smooth Horizontal Scroll & Focus

Press Enter or double click. The data grid automatically performs smooth horizontal scrolling to that column and applies an eye-catching focus halo.

WHERE Filter Bar & Relative Time Presets

Most table inspections only require filtering by a status code or a recent timestamp. VloamDb provides an intelligent WHERE filter bar directly above the grid:

  • Column & Syntax Autocomplete:Autocomplete suggestions trigger as you type column names, supporting full WHERE expressions.
  • Recent WHERE History:Automatically persists recent WHERE queries for one-click re-use from the history dropdown.
  • Built-in Time Shortcuts:Instant presets for temporal columns: Last 1m, 5m, 15m, 1h, 4h, 1d, Today, Yesterday, Last 7d, Last 30d, This Month, Last Month.

Cell Details: Raw Values, JSON & URL Decoding

Database rows frequently contain nested JSON payloads, URL-encoded strings, or lengthy text blocks. Double-clicking a cell opens the Cell Details modal:

Raw Value

Inspect unformatted string values with one-click copy.

JSON Formatted

Syntax-highlighted, formatted JSON tree with validation.

URL Decoded

Automatically decodes percent-encoded query params and paths.

Load Full Truncated Value

Large payloads are truncated for grid smoothness; click "Load Full Value" to retrieve full blobs.

📋
Inspect Full Row Data

Right-click any row and choose "View Row Data" to inspect all columns in a beautifully formatted JSON modal.

Right-Click SQL Extraction (IN, UPDATE, INSERT)

Mouse cell selections paired with right-click actions eliminate manual typing:

ActionSelection ScopeGenerated Output
Copy as IN QueryMultiple selected cellsUser IN ('root', 'developer')(paste into WHERE)
Copy as UPDATE (Cells)Selected cellsUPDATE `t` SET `val` = 'x' WHERE `id` = 1;
Copy as INSERTSelected rowsINSERT INTO `t` (`c1`, `c2`) VALUES ('v1', 'v2');
Copy as DELETESelected rowsDELETE FROM `t` WHERE `id` = 1;
Filter / ExcludeSingle cellInstantly filters or excludes rows by this cell value

Status Bar Real-Time Statistics & Instant Filter

When evaluating numeric columns, writing extra SUM() or AVG() queries is unnecessary friction.

  • Multi-Cell Numeric Aggregates:Selecting multiple cells instantly computes Sum, Average, Min, Max, and Count on the fly.
  • In-Grid Instant Regex/Fuzzy Filter:Filter visible rows in real-time with highlighted keyword matches.
  • Manage Visible Columns:Toggle column visibility via the column selector drawer to focus on what matters.

Streaming Data Export & Table Size Inspection

VloamDb delivers production-ready export pipelines and table metadata inspectors:

Streaming Full Export (CSV / JSON)

Bypasses display LIMIT clauses, streaming records directly to disk with live progress and cancelability.

Table Size & DDL Viewer

Quickly inspect physical disk storage (MB) and copy exact CREATE TABLE DDLs.