Skip to content

Releases

dbui v0.6.0

Choose a tag to compare

@JosueRhea JosueRhea released this 26 Oct 21:49

New

  • Assistant panel (⌘I, or ✦ in the titlebar) that answers questions about the open connection, using the Claude Code you already have installed
  • The assistant can list tables, describe them and run queries, and nothing else: no shell, files or web
  • Three access modes, switchable mid-chat: Read only (the default), Ask before each write, and Full access
  • A read-only connection never lets the assistant write, and a production connection always asks first, even in Full access
  • Assistant replies render as markdown: headings, lists, tables, links and code blocks

Fixes

  • PRAGMA query_only counts as a write, so a read-only connection refuses it

Installing

  1. Download dbui-0.6.0-universal.dmg and drag dbui to Applications.
  2. Run:
xattr -dr com.apple.quarantine /Applications/dbui.app

Updating from 0.2.8 or earlier: the in-app updater can't install this release. Download the .dmg and replace the app by hand once. Updates work from inside the app after that.

dbui v0.5.1

Choose a tag to compare

@JosueRhea JosueRhea released this 21 Oct 14:52

Fixes

  • Copying rows and pasting them back into the same table stages duplicates the way ⌘D does: a generated key is left for the table instead of clashing with the original row
  • ⌘C then ⌘V after clicking a row now pastes that row, instead of saying the clipboard holds no rows

Installing

  1. Download dbui-0.5.1-universal.dmg and drag dbui to Applications.
  2. Run:
xattr -dr com.apple.quarantine /Applications/dbui.app

Updating from 0.2.8 or earlier: the in-app updater can't install this release. Download the .dmg and replace the app by hand once. Updates work from inside the app after that.

dbui v0.5.0

Choose a tag to compare

@JosueRhea JosueRhea released this 25 Sep 15:27

New

  • Connect through an SSH tunnel
  • Tag connections by environment, with a confirmation before writing to production
  • File connections into groups in the connection picker
  • EXPLAIN drawn as a plan tree, with ⌘⌥E to explain the current statement
  • ER diagram of a schema
  • Server activity panel that can cancel queries or end sessions
  • Functions, triggers, sequences, types and extensions in the sidebar tree
  • Dump a database to a SQL file, and run SQL files
  • :name parameters are asked for before a statement runs
  • Pin a query result as a tab of its own
  • Export a capped query result in full, streamed from the server
  • JSON cells open as a foldable tree in the row details
  • SQL completion opens as you type, next to the caret; ctrl-space opens it too
  • The SQL editor runs on one pinned connection and shows when a transaction is open
  • SQL editor results stop at 10,000 rows instead of loading everything

Fixes

  • Postgres enum, domain and array columns read correctly
  • A table can be opened again after a column is added to it
  • A statement after a large query no longer waits for the rest of its rows
  • SQL is split the way each engine reads it: backslashes in strings, procedure and trigger bodies, DELIMITER lines
  • A read-only connection refuses writes from the SQL editor
  • The connection sheet no longer carries a database name into SQLite's File field, and hides TLS for SQLite
  • A long file path stays inside its field, and Tab skips hidden fields

Installing

  1. Download dbui-0.5.0-universal.dmg and drag dbui to Applications.
  2. Run:
xattr -dr com.apple.quarantine /Applications/dbui.app

Updating from 0.2.8 or earlier: the in-app updater can't install this release. Download the .dmg and replace the app by hand once. Updates work from inside the app after that.

dbui v0.4.0

Choose a tag to compare

@JosueRhea JosueRhea released this 23 Sep 16:12

New

  • Translucent window: glass titlebar, sidebar and status bar with the content in a rounded card
  • Tint and blur settings for the glass, in the settings menu and the command palette
  • Closing a tab stops what it was loading, on the server too
  • Faster page loads on remote databases

Fixes

  • The window no longer draws at half size after dragging it to a screen with a different resolution
  • The footer no longer stays on "Loading…" after closing a loading tab
  • A table load replaced by a newer one is stopped instead of left running
  • Placeholders and sidebar text are easier to read over the glass

Installing

  1. Download dbui-0.4.0-universal.dmg and drag dbui to Applications.
  2. Run:
xattr -dr com.apple.quarantine /Applications/dbui.app

Updating from 0.2.8 or earlier: the in-app updater can't install this release. Download the .dmg and replace the app by hand once. Updates work from inside the app after that.

dbui v0.3.0

Choose a tag to compare

@JosueRhea JosueRhea released this 23 Sep 05:32

New

  • Stop a running query: ⌘. or the Stop button, cancelled on the server too
  • Per-connection query timeout
  • Find and replace in the SQL editor (⌘F, ⌥⌘F)
  • ⌘/ to comment and uncomment lines
  • Auto-closing brackets and quotes
  • ↑/↓ keep their column across short lines
  • Export to CSV, JSON or SQL INSERTs — whole table or query result
  • Import CSV as staged rows
  • Saved queries (⌘⇧S to save, ⌘⇧O to open)
  • Edit table structure: add, edit and drop columns
  • List, add and drop indexes
  • Create tables
  • SQL preview before every structure change
  • Animations for menus, dialogs, tabs, results and the schema tree
  • Highlights on copied, edited and committed rows
  • Loading bar while a query runs
  • Sliding underline on the active tab
  • Drag preview when reordering tabs and columns
  • New reload icon

Fixes

  • Restored tabs that weren't in front now load when opened
  • MySQL string defaults now keep their quotes (Copy CREATE TABLE, structure edits)
  • Pasted or imported rows with a repeated column header no longer overwrite the first value
  • Loading a history entry or saved query can be undone with ⌘Z
  • Reload button now matches the size of the buttons next to it

Installing

  1. Download dbui-0.3.0-universal.dmg and drag dbui to Applications.
  2. Run:
xattr -dr com.apple.quarantine /Applications/dbui.app

Updating from 0.2.8 or earlier: the in-app updater can't install this release. Download the .dmg and replace the app by hand once. Updates work from inside the app after that.

dbui v0.2.8

Choose a tag to compare

@JosueRhea JosueRhea released this 16 Sep 17:36

This build is unsigned. It is not notarized by Apple, so macOS will
refuse to open it until you clear the quarantine flag. See
Installing below. The in-app updater will not offer this
release — install it by hand.

  • Fixed: a RETURNING clause was missed when it fell after a line break or
    hard against a (, silently discarding the returned rows
  • Fixed: RETURNING falsely matched inside a string literal
  • Fixed: a dollar-quoted ($$ ... $$) function body was split into separate
    statements at its own semicolons
  • Fixed: SQLite rejected edits that reset a cell to its column default
  • Fixed: an interval with a time part was cast to the wrong type and rejected
  • Fixed: a locked or denied keychain prompt could wipe every saved password
  • Fixed: a corrupted connections file could let a new connection overwrite an
    existing one's saved password
  • Fixed: Copy as JSON dropped a column's values when two columns shared a name
  • Fixed: SQL completion could crash on non-ASCII text
  • Fixed: SQL completion could fill up with keywords and hide tables and
    schemas
  • Fixed: closing a tab under an unsaved-changes prompt could commit the wrong
    tab
  • Fixed: reloading a table could silently discard an unsaved edit
  • Fixed: switching tabs while editing a cell could write the edit into the
    wrong row
  • Fixed: switching connections mid-save or mid-load could corrupt another
    connection's tab
  • Fixed: keyboard shortcuts could fire behind an open dialog, including
    running a query behind a "discard changes?" prompt

Installing

This release is not signed or notarized, so Gatekeeper blocks it on first
open. After dragging dbui to Applications:

xattr -dr com.apple.quarantine /Applications/dbui.app

dbui v0.2.7

Choose a tag to compare

@JosueRhea JosueRhea released this 14 Sep 23:53

This build is unsigned. It is not notarized by Apple, so macOS will
refuse to open it until you clear the quarantine flag. See
Installing below. The in-app updater will not offer this
release — install it by hand.

One report — "⌘S doesn't work after filtering rows" — and three ways the commit
could return without saying anything.

⌘S says what it did

A key that does nothing is indistinguishable from a key that is broken, and
save_pending_edits had three exits that returned in silence.

The one that was a real bug: a row dbui cannot identify — a view, or a
table with no primary key — accepted typing into every field and staged
nothing at all. The refusal reached a small red line in the sidebar, and only
after ⌘S had already answered "no changes to commit on this tab" to a screen
full of edits. It now stops before the batch and says "Cannot commit — table
has no primary key"
.

The other two: pressing ⌘S while the previous batch is still in flight — which
is exactly the press someone makes when the first one looked like it did
nothing — now says "Already committing — one moment", and pressing it with
no tab open says so rather than shrugging.

The filter is not what breaks a commit

Filtering a table, editing one of the rows left, and committing works. That was
worth proving rather than asserting, so it is now proved three times over:
against a SQLite file, and — behind DBUI_LIVE_TESTS=1 — against PostgreSQL
and MySQL, each driving the real window through ⌘F, a WHERE, an edit and ⌘S,
then reading the row back on a second connection to confirm it reached the
server.

The UI suite had only ever run against a file. The half it could not reach is
the engine's: a primary key that introspects differently, or a value the server
plans as the wrong type, arrives as a dead ⌘S and shows up on no SQLite run.

Installing

This release is not signed or notarized, so Gatekeeper blocks it on first
open. After dragging dbui to Applications:

xattr -dr com.apple.quarantine /Applications/dbui.app

Then open it normally. Alternatively, try to open it once, then go to System
Settings → Privacy & Security and click Open Anyway.

Signed and notarized builds will return in a later release. Until then the
in-app updater will not offer this version — it requires a notarized build
carrying the same Team Identifier as the copy you are running, and it refuses
anything that fails that check.

Verify your download against SHA256SUMS:

shasum -a 256 -c SHA256SUMS

dbui v0.2.6

Choose a tag to compare

@JosueRhea JosueRhea released this 10 Sep 17:03

This build is unsigned. It is not notarized by Apple, so macOS will
refuse to open it until you clear the quarantine flag. See
Installing below. The in-app updater will not offer this
release — install it by hand.

Two halves of one complaint: the window laid itself out in whatever order the
server sent, and it never said when it was holding more than it showed.

Columns move

A column is carried by its heading and lands where it is dropped. The rows
follow it, because what moved is the order the grid draws in and not the order
the result arrived in.

Where you put them is remembered by name, so it survives the next page, the
next reload and the next launch. A column the table has since dropped takes its
place with it; a new one arrives at the end, where the server put it.

A press that never travels is still a click, and a click on a heading still
sorts.

Tabs move

The same, along the strip, and the order is part of what a restart puts back.

Right-clicking a tab gives it the rest: Close, Close Others, Close to
the Right
, Close All — the same four in ⌘⇧P, aimed at the tab in front.
A close that takes several tabs at once asks once, for the batch, instead of
once per tab and calling four answers consent.

Query results sort

A table's sort is a clause the server runs. A query's is not: its order is
whatever its own ORDER BY says, and re-reading it with one bolted on would be
rewriting your SQL behind your back.

Clicking a header on a query result reorders the page already in hand and
leaves the statement exactly as written. A third click puts the server's own
order back.

Numbers sort as numbers, so 9 comes before 10 rather than after it — money
included, which is kept as text all the way to the screen so it never picks up
a rounding error on the way. NULL sorts last ascending and first descending,
the way Postgres orders it.

Scrollbars

A container that scrolls used to draw nothing to say so, and a table taller
than its pane looked exactly like a table that ended there. The only way to
find out otherwise was to try the wheel.

Every pane that scrolls has a bar now — the grid both ways, the schema tree,
the row detail, the SQL editor, the palette, the connection picker, the staged
changes. Each says how much of the content is on screen and where in it you
are, and each can be dragged.

The SQL editor scrolls sideways

A statement wider than the pane ran off the right edge and stayed there: no
bar, no wheel, and typing carried on writing where it could not be read.

It pans now, and the caret stays in view — while typing, on a click, and when
autocomplete puts a name in.

⌘⇧E, for when the shape is the hard part

Twelve statements worth a starting point: a filtered SELECT, a page, a
COUNT, a GROUP BY with HAVING, both joins, an upsert spelled the way the
connected engine spells it, a CTE. When a table is open its name is filled in,
quoted for that engine.

They are shapes, not answers — every one names a column you have to replace,
because the point is which side of a LEFT JOIN keeps its rows and where
HAVING goes, not the identifiers.

UPDATE and DELETE arrive with their WHERE already written. A template
that hands you DELETE FROM t; and trusts you to add the clause before ⌘↵ is a
template that eventually empties a table.

Installing

This release is not signed or notarized, so Gatekeeper blocks it on first
open. After dragging dbui to Applications:

xattr -dr com.apple.quarantine /Applications/dbui.app

Then open it normally. Alternatively, try to open it once, then go to System
Settings → Privacy & Security and click Open Anyway.

Signed and notarized builds will return in a later release. Until then the
in-app updater will not offer this version — it requires a notarized build
carrying the same Team Identifier as the copy you are running, and it refuses
anything that fails that check.

Verify your download against SHA256SUMS:

shasum -a 256 -c SHA256SUMS

dbui v0.2.5

dbui v0.2.5 Pre-release
Pre-release

Choose a tag to compare

@JosueRhea JosueRhea released this 10 Sep 03:26

This build is unsigned. It is not notarized by Apple, so macOS will
refuse to open it until you clear the quarantine flag. See
Installing below. The in-app updater will not offer this
release — install it by hand.

One theme, followed all the way down: taking a value out of a row, and being
told that it worked.

⌘C copies the cell you clicked

Clicking a cell is asking about that cell, so copying after it now hands back
that cell — not the forty columns around it. The value goes out whole, never
truncated, with a staged edit winning over what the server last said, and
NULL as the empty string every other export here uses.

A selected range is a different question and still copies as rows. So does
⌘⇧C, at any time, which is the way back to the whole row while a cell is
focused.

Right-clicking a cell now carries the column with it, so the menu has a Copy
Cell
entry that knows which cell it is about. Inside a multi-row selection it
moves only the cell cursor, so the menu still acts on the range you picked.

JSON columns and keys stopped being unreachable

Two cells could not be opened in place: a JSON document too tall for a one-line
box, and a primary key. Both used to answer a double-click with a refusal and
nothing else — which is what made a JSON column feel out of reach. The document
was right there, and the only thing anyone wanted was to take it somewhere.

Both now copy themselves. The document also lands in the sidebar with its whole
value selected, ready for a second ⌘C.

The key's sidebar field is copyable too. It is drawn read-only, because the
row's identity is not editable, and a box that takes no caret is also a box
nothing can be selected out of — which left the key as the one value on the row
that could not be reached by hand. It copies on click, and its header carries a
button that does the same.

A copy answers where you asked for it

The status bar is one line at the far bottom of the window. A sidebar scrolled
to its twentieth field is nowhere near it, so a copy confirmed only down there
reads as nothing having happened.

The cell you copied is now tinted, and the field's button says ✓ Copied.
Both marks drop when the selection moves to another row, because they belong to
the row the value came from.

The sidebar goes to the field it names

Sending someone to "the sidebar" is only an instruction if the sidebar then
shows the field. It scrolls there now — on the hand-off from a JSON cell, and
on Tab, which used to walk the caret off the bottom of the panel.

Installing

This release is not signed or notarized, so Gatekeeper blocks it on first
open. After dragging dbui to Applications:

xattr -dr com.apple.quarantine /Applications/dbui.app

Then open it normally. Alternatively, try to open it once, then go to System
Settings → Privacy & Security and click Open Anyway.

Signed and notarized builds will return in a later release. Until then the
in-app updater will not offer this version — it requires a notarized build
carrying the same Team Identifier as the copy you are running, and it refuses
anything that fails that check.

Verify your download against SHA256SUMS:

shasum -a 256 -c SHA256SUMS

dbui v0.2.4

dbui v0.2.4 Pre-release
Pre-release

Choose a tag to compare

@JosueRhea JosueRhea released this 04 Sep 21:28

This build is unsigned. It is not notarized by Apple, so macOS will
refuse to open it until you clear the quarantine flag. See
Installing below. The in-app updater will not offer this
release — install it by hand.

Two reports from the same corner of the app: creating a table looked like
nothing had happened, and an error the engine took the trouble to explain was
gone by the time it was read.

CREATE TABLE says what it did

Every engine reports DDL as zero rows affected, and the status bar rendered
that as "0 rows affected" — true, and a verdict on nothing. dbui now reads the
leading keywords of a statement and says CREATE TABLE notes · OK in 3 ms
instead.

A count the engine actually put a number on is never thrown away. A DELETE
that matched nothing still reports zero rows, because there that is the
answer.

The schema tree catches up on its own, too. Nothing re-read the catalog after a
DDL statement, so a table you had just made was not in the sidebar until you
pressed ⌘R. It appears now, through a refresh that stays quiet — the DDL's own
verdict is what you are reading, and "Catalog refreshed" landing on top of it a
moment later is how that feedback went missing in the first place.

SQL errors stay where you can read them

The status bar is one line, and the next message owns it. The reason a query
failed survived until the next thing happened — sorting a column, clicking a
cell, a background tab finishing its load — and then it was simply gone.

An error now belongs to the tab that earned it, drawn in a panel between the
editor and the grid: the engine's own message, its SQLSTATE, the statement it
is about, and buttons to copy or dismiss it. It goes when the next run replaces
it, and not before.

A batch that fails halfway keeps what ran

Running five statements and failing on the third used to discard the results of
the first two along with the error, leaving an empty grid and a one-line
footer. The failure now travels inside the batch: the statements that ran stay
in the strip above the grid, their rows are still there, and the panel says how
far it got — "2 statements ran before this one · 1 was not attempted".

Errors on background tabs are no longer swallowed

Both the query and the table-load paths only reported a failure if its tab was
still in front. Switching tabs while something was in flight made its error
disappear entirely. It lands on the tab it belongs to now, whether or not you
are looking at it.

Installing

This release is not signed or notarized, so Gatekeeper blocks it on first
open. After dragging dbui to Applications:

xattr -dr com.apple.quarantine /Applications/dbui.app

Then open it normally. Alternatively, try to open it once, then go to System
Settings → Privacy & Security and click Open Anyway.

Signed and notarized builds will return in a later release. Until then the
in-app updater will not offer this version — it requires a notarized build
carrying the same Team Identifier as the copy you are running, and it refuses
anything that fails that check.

Verify your download against SHA256SUMS:

shasum -a 256 -c SHA256SUMS