Changelog
What’s new in CubbyDB
Every update is free for everyone with a license. CubbyDB tells you when a new version is ready and installs it in one click.
0.1.23
Results grid
- Hide columns you don't need: open the ⋯ menu above a table and choose Columns…, then uncheck any column. Hidden columns come back when you close and reopen the table, and the header shows how many are hidden.
- Expand cell has a new Structured view for JSON. Instead of formatted text, it lays the value out as a readable document, with plain-language labels, grouped sections, tables for lists, and Yes/No for true and false.
Appearance
- New setting, Button size (Settings → Appearance → Interface): make the top bar's buttons, the connection tabs, and the WHERE bar medium or large.
Windows
- No more white title bar. CubbyDB's own top bar now reaches the top of the window, with minimize, maximize, and close buttons at its right end.
0.1.22
Deleting rows
- The delete confirmation opens the moment you click, instead of after a pause while CubbyDB looks for related rows. If that check takes a moment, the dialog says so and fills in when it's done.
- The rows you're deleting stay selected while you confirm, and stay selected if you cancel.
- Right-click a row number to insert a new row or delete that row, or every selected row at once.
Results grid
- Show column types now works on tables that are already open, without re-running them.
- Selection in connection color is now on by default.
- On a connection with a color fill, the right-click menu, find bar, and other popups in the grid keep the normal theme color.
- Fixed the scrollbar hiding behind every other row, and the grid covering the sidebar's resize handle.
0.1.21
Help & Feedback
- Settings has a new Help & Feedback section. Email support opens a message with your CubbyDB version and system already filled in, for questions, ideas, and bug reports alike.
Results grid
- Remove deletes the row of the cell you've selected, with no need to click its row number first.
- The foreign-key jump menu marks its selected row the same way the command palette does, and moving the mouse over a row selects it.
- Row numbers no longer show through the grid's top-left corner when you scroll.
- Switching to another tab and back keeps the grid where you left it: the same scroll position and the same selected cell, rows, or range.
- New setting, Selection in connection color (Settings → Appearance → Table): on a color-tagged connection, the selection is drawn in that connection's color instead of the accent color.
- On a connection with a color fill, the WHERE bar and the bottom bar with paging and Add row/Remove row keep the normal theme color.
- New setting, Show column types (Settings → Appearance → Table): each column header shows its data type, like int4 or timestamptz, next to its name.
- Booleans read true and false everywhere, including when you edit a cell, copy, or export, instead of t and f.
Connections
- With many connections open, their tabs in the top bar shrink to fit instead of wrapping onto a second line.
- A color-tagged connection's tab in the top bar is highlighted in that connection's color when selected.
Ask AI
- When an answer counts or describes rows, like "there are 4 recipes with beef", it now ends with a query that lists those rows, ready to open in the editor.
Trial
- The free trial is now 7 days.
Fixes
- On Windows, links CubbyDB opens in your browser, like the ChatGPT sign-in page, no longer get cut off partway.
0.1.20
CubbyDB is now a paid app
- CubbyDB now costs a one-time price, with every future update included. Everyone gets a 14-day free trial, counted from their first launch of this version, and the top bar shows how many days are left.
- Buy from cubbydb.com/pricing, then paste your license key into Settings → License. One key works on up to 3 of your computers.
- Nothing is lost if your trial runs out: your connections, saved queries, cubbies and history are all still there once you activate.
Connections
- Every connection you had open comes back when you relaunch, not just the last one.
- Settings has a new Connections section: connect, edit, disconnect or delete any connection in one place.
Tables
- Right-click a table tab to open its structure or ER diagram.
- The Table Structure pane explains each index in plain English.
- Dragging a column past the edge of the results grid scrolls the grid along with it.
0.1.19
Ask AI
- Attach your app's code repositories to a connection, and the assistant can read them — to explain how your code actually uses a table, or to answer questions about the code itself. It can read your code but never change it, and a repo stays attached to that connection for every later chat.
- Watch the assistant work: each step — querying, searching code, reading a file — appears as it happens. Steps start collapsed; open one to see what it found.
- The assistant can take many more steps before answering, so longer investigations finish instead of stopping early. Press Escape to stop a reply at any time.
- Ask for an UPDATE, DELETE or schema change and the assistant writes the statement out for you to review and run yourself. It still can't run changes on its own, and SQL it didn't run is labelled "Not run".
- The message box is roomier, and shows exactly what's sent with your question: the table you're viewing, tables you've attached, and your repos.
- The chat follows along as a reply comes in, and stops if you scroll up to read. Saved chats open at their newest message.
Running SQL
- Running a statement that deletes rows or drops a table now asks first, and shows you the statements it found. Turn this off in Settings → General → Confirm destructive statements.
Results grid
- The grid uses your system's overlay scrollbars again, the same as every other pane.
- Escape closes the find bar (Cmd/Ctrl+F), even after you've clicked into the results.
- Add row, Import CSV and Remove row no longer get cut off when the window is narrow — the toolbar wraps onto a second line instead.
Connections
- Browsing for an SSH private key file on the connection screen works again.
Look & feel
- The top bar shows the new CubbyDB logo, and the app icon has been refreshed to match.
- The first tab now sits flush against the sidebar.
0.1.18
Connections
- A query or Refresh that follows a few minutes of inactivity now checks the connection first and replaces it if it has gone stale — so a suspended serverless compute (Neon and friends) comes back promptly instead of hanging on the operating system's long socket timeout. Nothing polls in the background, so idle computes can still scale to zero.
Results grid
- Large pages scroll noticeably better: rows and columns are windowed to the viewport, and a fast scroll no longer flashes blank on tall external monitors.
- The scrollbar has its own gutter, so the sticky header and rows never paint underneath it.
Command palette
- The highlighted row in Cmd/Ctrl+K keeps its connection color instead of being flooded with the app accent — so you can still tell which environment a result belongs to before you open it. Previously a selected production row could look like whatever your accent color happened to be.
- New Appearance setting to pick how that row is marked: an outline (the new default) or a solid fill.
Top bar & tabs
- The right-hand cluster is quieter: Saved, History and Refresh are icons now, grouped together, with hover labels that name each one and spell out its keyboard shortcut. Ask AI keeps its name, and the Cubby button shows the open cubby's name when there is one.
- Disconnect is gone from the top bar — each connection pill already has its own close button.
- Opening a SQL tab gives the editor a share of the window's real height instead of a fixed 280px, so the results pane no longer starts a third of the way down a large display.
- The tab strip no longer shows a horizontal scrollbar when many tabs are open; it still scrolls by wheel, trackpad or drag.
0.1.17
Branch tabs
- Open a second, independent view of a table: right-click a table tab for "Duplicate as Branch", or right-click a row for "Open Row in New Branch" (pre-filtered to just that row). A branch keeps its own filter and sort — clicking into that table from anywhere else always lands on its one main tab, never a branch.
Query history
- Cmd/Ctrl+[ and +] now step through the actual queries you've run — the table and WHERE clause — jumping to whichever table a past query was against and re-applying its filter, instead of just switching between tabs.
0.1.16
AI assistant
- "Ask AI" now shows exactly which tables it's using as context — a chip for whichever table you're currently viewing, plus a "+" to attach more tables explicitly, regardless of which tab is open.
- More reliable under load: requests now retry automatically on a rate limit or a provider hiccup, Stop actually stops the in-flight request, and a long conversation no longer risks overflowing the model's context window.
- Schema search inside the AI now understands multi-word and abbreviated queries ("customer orders" can find a table named cust_ord_hdr), not just exact substrings.
- New opt-in AI audit log — a full record of what was sent to the model and what it did, viewable as a second tab in History. Off by default.
Schema Compare & ER diagrams
- Schema Compare: diff two schemas — even across two different connections — and generate a migration script. CubbyDB never runs it for you; it's something to review and run yourself.
- ER diagrams: right-click a table for a visual map of it and everything directly connected to it, with draggable, collapsible table cards.
- Triggers and Row-Level Security policies now show up in a table's structure panel instead of being invisible.
Connections
- Read-only connection mode blocks every write on a connection at the app level, independent of what the database role itself allows.
- SSH tunneling: connect to a database behind a bastion host, with host-key verification the first time you connect.
Fixes
- Generate random UUID now works on text/varchar columns storing UUIDs as strings, not just native uuid columns.
- Set to NULL on a multi-cell selection now clears every selected column, not just one.
- Right-clicking a multi-cell range on a read-only connection no longer shows an empty menu.
- Viewing a function's definition could fail to load; fixed.
- New setting to turn off the small kind icon (table/query/function/…) shown on each tab.
0.1.13
Selecting & editing multiple rows
- Drag across cells (or Shift-click a second cell) to select a block spanning several rows — the same accent outline a single click gets, just around the whole selection.
- With a range selected: Remove deletes every row it touches, Cmd/Ctrl+V pastes one value into every cell it spans, and right-click offers Generate random UUIDs / Set to NULL for all of them at once instead of one cell at a time.
- Right-click a foreign-key or primary-key cell in a selected range to jump to related rows using every id in the selection ("IN (...)"), not just the one cell you clicked.
- The foreign-key jump menu is keyboard-navigable — arrow keys move through the table list (even while typing a filter), Enter jumps.
- Right-click a UUID cell — existing row, new row, or a whole selected range — for Generate random UUID.
Cubbies
- Save named groups of tables, saved queries, and AI chats scoped to a connection, pin them in the schema tree, and reopen every tab in one click.
- Available from the schema tree, the tab bar, Cmd/Ctrl+K, and two dedicated keyboard shortcuts.
Tabs & browsing
- Tabs are fixed-width with a hover tooltip for long titles, and an active tab picks up its connection's own accent color when one is set.
- Double-click a column's resize handle to fit it to its contents; first-load column widths now measure real rendered text instead of an approximation.
- The app no longer opens a blank query tab on connect — an empty state points you at the sidebar or Cmd/Ctrl+K instead.
Fixes
- The "Edit connection" modal was rendering behind the results grid.
- A few icon buttons — including the tab bar itself — were missing a pointer cursor on hover.
0.1.12
Cubbies
- Introducing Cubbies — a first pass at named, saveable collections of database objects.
Results grid
- Long cell values can now be expanded into a full, read-only view instead of just truncating.
- Rows referencing a foreign key are now listed alphabetically by table.
Tabs
- The app opens to a calmer empty state instead of an unused blank query tab.