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.
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:
| Action | Selection Scope | Generated Output |
|---|---|---|
| Copy as IN Query | Multiple selected cells | User IN ('root', 'developer')(paste into WHERE) |
| Copy as UPDATE (Cells) | Selected cells | UPDATE `t` SET `val` = 'x' WHERE `id` = 1; |
| Copy as INSERT | Selected rows | INSERT INTO `t` (`c1`, `c2`) VALUES ('v1', 'v2'); |
| Copy as DELETE | Selected rows | DELETE FROM `t` WHERE `id` = 1; |
| Filter / Exclude | Single cell | Instantly 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.