v3.4.0 StableLocal-First Native MySQL Client

Fast SQL Console, Script Tree & Snippets | VloamDb Manual

A high-performance SQL workspace designed for developers. Smooth typing, instant statement detection, multi-result tabs, and scoped scripts.

Why Explicit SQL Over Implicit Cell Mutations

Developers migrating from older GUI tools often wonder: "Why doesn’t VloamDb allow double-clicking grid cells to edit database rows directly?"

This is VloamDb’s core engineering principle. Direct in-place cell editing introduces catastrophic hazards in real-world production systems:

No Explicit Transactions or Review

Typos mutate data immediately without explicit transaction boundaries or peer review.

Full-Table Overwrite Without Primary Keys

Without a primary key, GUI tools generate fragile WHERE clauses that can accidentally overwrite an entire table.

VloamDb’s Safe Workflow

Right-click cells to "Copy as UPDATE". VloamDb crafts a deterministic SQL statement for you to review and safely execute.

Three Execution Modes & Stopping Queries

VloamDb features a purpose-built SQL editor with intelligent syntax parsing and three execution workflows:

ModemacOS ShortcutWindows ShortcutScope
Run Statement⌘ + EnterCtrl + EnterAuto-detects statement boundary at cursor position; runs only that query.
Run Selection⌘ + EnterCtrl + EnterWhen text is highlighted, executes only the selected snippet.
Run Full Script⌘ + ⇧ + EnterCtrl + Shift + EnterExecutes all statements in the active script file sequentially.
⏹️
Cancel Long-Running Queries Anytime

If a slow unindexed query hangs, the Run icon switches to a red Stop button. Click it to cancel query execution immediately.

Multi-Result Tabs Without Overwriting

In legacy tools, running a new query immediately overwrites your previous result set, forcing tedious re-runs when cross-referencing datasets.

VloamDb organizes multiple query results into parallel tabs ("Result 1", "Result 2"). Compare outputs side by side without re-running queries.

Database-Scoped Scripts & Directory Tree

VloamDb features a local, organized SQL script repository:

  • Scoped to Active Database:Scripts are scoped per database and persisted in local SQLite. Safe against crashes.
  • Nested Folders & Drag-and-Drop:Create multi-level folders to organize scripts and drag to reorder.
  • Ephemeral Drafts vs Saved Scripts:Console tabs created via "+" are scratchpads; press <kbd>⌘S</kbd> / <kbd>Ctrl+S</kbd> to persist them.

SQL Snippets: Placeholders & Tab Navigation

Snippets drastically accelerate repetitive DDL and DML authoring. Type a trigger prefix (e.g. <code>addcol</code>, <code>sel</code>, <code>page</code>) and press <kbd>Tab</kbd> or Enter to expand.

Placeholder SyntaxBehaviorExample
$1, $2, $3Cursor stops. Tab moves forward to $2, Shift+Tab moves backward.WHERE `id` = $1 AND `status` = $2
${1:defaultValue}Placeholder with preselected default value.LIMIT ${1:10} OFFSET ${2:0}
$0Final exit stop when all placeholders are filled.SELECT * FROM $1;$0

Navigate to "Settings > Snippets" to view built-in templates and register custom team snippets.

Execution History & Calendar Recall

When debugging incidents, you frequently need to recall "that slow query executed earlier today".

VloamDb provides a dedicated Query History drawer with custom calendar navigation, time pickers, and a "Now" shortcut. Double-click any query row to load it back into the active console.