Releases

What changed, release by release.

Every version of DBClient, newest first: what is new, what got better and what was fixed. The app keeps itself current, so this page is for looking back.

0.4.4 Latest

· 25 MB

Browse PostgreSQL and SQL Server databases or Databricks catalogs from one connection

  • New Create or delete PostgreSQL and SQL Server databases or Databricks catalogs from the sidebar.
  • New Choose Count rows when a result has no total. Automatic counts and retries now avoid running changes twice.
  • Improved Touch ID or your Mac password can now protect connections without saved passwords, including files and SSH hosts.
  • Improved Wide tables open faster and long scripts start sooner. ClickHouse Cloud can load larger tables with read-only sign-in.
  • Improved Updated the built-in terminal, MongoDB driver and supporting libraries.
  • Fixed The sidebar showed only your starting PostgreSQL database (often named after your username), the active SQL Server database or the selected Databricks catalog. It now lists the others your account can access. CockroachDB, Neon, Supabase, TimescaleDB and YugabyteDB use the same PostgreSQL sidebar.
  • Fixed Closing a tab lets you save or discard pending database changes. Saving a cell refreshes only that result in its original database.
  • Fixed Scripts from SQL Server Management Studio and Oracle scripts saved on Windows now run correctly. Formatting keeps SQL from becoming part of a comment.
  • Fixed The AI assistant blocks more queries that could change data in PostgreSQL, MySQL and MariaDB.
  • Fixed Table copies keep similar column names separate. Imports and exports preserve spaces, line breaks and text that looks like a number.
  • Fixed SSH file transfers now ask before replacing files with names like "Report" and "report". Moving a file onto itself leaves it in place.

0.4.3

· 25 MB

Safer editing and more reliable imports

  • Improved Updated the built-in terminal and SQL Server driver.
  • Fixed Running a query again now starts at the first row and column. Watch still keeps your place.
  • Fixed Similar-looking table or column names no longer cause mixed-up edits, copies or comparisons, or crashes in the table designer. Copies also warn if a linked table is missing.
  • Fixed SQL Server: edits stay with the correct table when you switch database tabs or refresh the connection.
  • Fixed Excel exports now warn when text is too long for a cell and show how many values are shortened.
  • Fixed Special characters no longer split imported CSV, JSON Lines or Markdown values into the wrong rows or columns.

0.4.2

· 25 MB

Safer data copies and smoother editing

  • New View saved AI API keys in Settings with Touch ID or your Mac password. Switching AI providers also keeps the right model list and your saved model.
  • Improved Updated the MySQL driver and libraries used for networking, encryption and logging.
  • Fixed Data table headers now stay aligned with their columns after scrolling sideways and running a query with different columns.
  • Fixed Fixed leftover text in editors. Results from queries with comments can be edited, and PostgreSQL edits use the correct row and column type.
  • Fixed Copying tables and other database objects preserves their text, settings and links to other objects. Copies check for table changes and unclear column matches, and Replace existing affects only the matching object.
  • Fixed SQL Server: imports, exports and table copies preserve automatic row IDs. Compare Schemas adds missing automatic ID columns and reports changes it cannot make.
  • Fixed Compare Schemas now handles table, column and schema names that differ only by letter case.
  • Fixed PostgreSQL: table copies, designers and schema comparisons now use the correct text sorting rules, including rules from another schema.
  • Fixed SQLite: changing a table protects columns, indexes and triggers added by other connections, and checks related tables before saving.
  • Fixed Markdown exports keep special characters intact. Damaged Excel files now show an error instead of silently importing missing values.
  • Fixed Cancelling an update and starting it again right away no longer causes the new download to fail.

0.4.1

· 25 MB

AI help in terminals, plus safer imports, exports and schema changes

  • New Ask the AI assistant for help in database consoles and terminals on your Mac or SSH servers. It can read recent output and suggest commands; you choose what to insert and press Return to run it.
  • Improved Copy to Database now shows database icons beside connection names, making the destination easier to find.
  • Fixed Stopping the AI assistant no longer interrupts a query you are running yourself.
  • Fixed Imports and SQL exports now keep existing row IDs and set the next automatic ID correctly, preventing duplicate IDs in new rows.
  • Fixed Imports warn about repeated columns before values can be lost. JSON and XML exports keep columns with the same name, and Excel files keep empty rows and very small numbers when exported and imported again.
  • Fixed Copy as INSERT now includes binary data, such as images and files, instead of replacing it with NULL.
  • Fixed Compare Schemas now detects key changes, keeps names such as value and Value separate, and runs changes in the right order. Failed updates are fully undone on PostgreSQL, SQL Server, SQLite and DuckDB.
  • Fixed If saved connections, queries, history or backup lists cannot be read, the app reports the problem and protects the original file from being overwritten.

0.4.0

· 24 MB

Smoother loading and editing, with safer table copies

  • Fixed The loading screen no longer shows "Ready" while work is running, and the bar between the editor and results responds on the first drag.
  • Fixed SQLite: changing a table no longer reuses automatic IDs from deleted rows.
  • Fixed PostgreSQL: copying tables or rows keeps automatic IDs and numbering settings, so new rows get the correct next ID.

0.3.9

· 24 MB

Fixes for editing, table copies and SQL exports; macOS 26 now required

  • Improved Requires macOS 26 Tahoe or newer. Version 0.3.8 is the last release for macOS 15 Sequoia.
  • Improved Updated the Oracle client to 23.26.3, the terminal, and other app libraries. Oracle users can update the client in Client Setup.
  • Fixed Saving edits now checks that every change reached its row. If a row is missing or the save cannot be checked, nothing is saved and your edits are kept.
  • Fixed SQLite: the grid now blocks edits and deletes for rows with unsupported binary keys, instead of reporting a save that changed nothing.
  • Fixed SQLite: changing a table in the designer now keeps its primary and foreign keys intact.
  • Fixed Copying tables between databases now keeps primary key columns in the right order and fixes failures caused by text columns in keys or indexes.
  • Fixed MySQL and MariaDB: SQL exports from joins and grouped queries now use the correct quotes, so the exported files run.

0.3.8

· 24 MB

Fixes for auto-commit, files on SSH hosts, Excel and JSON files, IPv6 addresses and infinite numbers in SQL exports

  • Fixed In a host's Files tab, moving a folder over the same-named folder it sat in deleted both, and a name with an accent, an arrow or a line break could make Delete or a move act on another file. Such a move is now refused, and every row acts on its own file.
  • Fixed A connection string with an IPv6 address in square brackets, such as [::1], did not connect: the brackets ended up in the Host field, and the string the app wrote for such a host was wrong. Both work now, and ClickHouse and MongoDB connect to IPv6 addresses too.
  • Fixed With auto-commit off, some scripts still saved a change right away: the app did not read them the way the server does, and on SQL Server a batch's own BEGIN or COMMIT could confuse it. Such a run now waits for your commit, or stops and says why.
  • Fixed Exporting as SQL Inserts, or Copy as INSERT, wrote an infinite number as "inf", which SQLite and DuckDB took for a column name, so the file would not run. Each engine now gets a spelling it reads back as the same number.
  • Fixed Text exported to Excel or XML lost its carriage returns and some special characters. It now comes back exactly as it was, and text imported from Excel reads as Excel shows it. A damaged Excel file naming a column past Excel's last one is now refused instead of freezing or closing the app.
  • Fixed Importing a JSON file holding one record with a list inside, such as an order with its items, imported only the list and dropped the rest of the record. Such a file now imports as one row.
  • Fixed Once the result log filled up, it could stop following new lines, leaving the latest out of sight below. It keeps following them now, and so does the copy log in a host's Files tab.

0.3.7

· 24 MB

Terminal and Files tabs named by their folder, and file dragging fixed on macOS 27.2

  • New Terminal and Files tabs are now named by their folder. A terminal tab's name follows you as you change folders, on this Mac and on most Linux servers.
  • Improved In a run's Summary, the check mark beside each statement that worked is now green, so you can see at a glance how a script went.
  • Fixed On macOS 27.2, dragging files in a host's Files tab often did nothing: a file you had clicked first would not move, and after one drag the next could fail. Both work now.
  • Fixed Exported connections no longer include empty SSH or proxy passwords, and an exported SSH host no longer includes a database server, port and user it never had. Older files still import.

0.3.6

· 24 MB

SSH hosts with a terminal and a Files tab, a terminal on this Mac, and a simpler New Connection picker

  • New SSH hosts and a terminal on this Mac. Add a server as a connection and it opens a terminal on it, in a tab beside your databases, with your ~/.ssh/config and keys read as in Terminal. The toolbar's Terminal button, or ⌃⌘T, opens your own shell on this Mac.
  • New Files on an SSH host. The host's Files tab shows its folders. Drag files in from the Finder or out to it, and move, copy, paste or delete them on the host. Every copy runs with rsync and shows its progress in the tab's log, and it asks before writing over a file.
  • New A simpler New Connection picker. Paste a connection string, an ssh command or a file path into the box at the top, and the form opens filled in. Databases, hosted services and hosts each have a card of their own.
  • Improved A spinner shows while a statement runs for you: in the Drop, Truncate, Rename, Duplicate and Import sheets, and on the connection's row in the sidebar for work with no sheet, such as Show DDL.
  • Improved The cursor in a console or terminal tab now wears the connection's color. Without one it follows your Mac's accent color, and is gray for the default accent, as in Terminal.
  • Improved SQL Server: the driver moved to FreeTDS 1.5.20, and the OpenSSL that encrypts those connections to 4.1.0.
  • Fixed A program in a console or terminal tab, such as htop, was not told when the window was resized, and Control-C did not reach it. Both work now.
  • Fixed ⌥⌘S did not hide the sidebar. It does now, like the toolbar button.
  • Fixed Copying a table between two saved connections that open the same database, such as one SQLite file, with Replace existing on, emptied the table. The sheet now sees the two as one place and refuses.
  • Fixed Redis: a key or value with a line break in it was sent as two commands, and a change the key browser could not write, such as a TTL that is not a number, was reported as saved. Both are fixed, and the commit sheet says why.
  • Fixed DuckDB and ClickHouse: timestamps were shown and compared to the millisecond, so rows a few microseconds apart read the same and an edit could land on the wrong row. They now show, save and copy to the microsecond, and ClickHouse DateTime64 to the nanosecond.
  • Fixed Two exports, or two dumps, saving to the same file at once shared one temporary file, so one could move the other's half-written rows into place. Each now writes to a temporary file of its own.
  • Fixed DuckDB: a database attached with ATTACH put its tables under the file's own, so a table could show twice in the sidebar. The tree now lists the current database alone.
  • Fixed Canceling a download of an update, or of the Oracle or Db2 client, showed it as failed instead of going back to the offer. A cancel is a cancel again.

0.3.5

· 24 MB

Drop a table on a list to copy it, and a notice before your license ends

  • New Drag a table, view or routine from the sidebar and drop it on another database's list on the right, such as its Tables list, to copy it there. The list lights up while the object is over it.
  • New From 30 days before your license ends, the toolbar shows how many days are left, as it does for the free trial, and says "License ended" once it has. Clicking it opens Settings ▸ License, where you see the end date and can renew.
  • Fixed After a lost connection, the app ran a statement again if it looked like a read, so a SELECT that writes through one of your own functions ran twice. The second run can no longer write: if it would, the server refuses it and the message says so.
  • Fixed MySQL and MariaDB: the special comment lines in a mysqldump file, like /*!40101 SET … */;, were skipped, so a pasted dump ran without the settings they carry, such as turning off foreign key checks. They now run.
  • Fixed MySQL and MariaDB: when a connection was saved as one but the server is really the other, Users & Roles could not list the accounts and said you were not allowed to see them. The app now goes by the server that answered, there and when it reads your SQL.
  • Fixed Watch, which runs only reads, let through a MySQL or MariaDB SHOW whose WHERE called a function with side effects, such as GET_LOCK. It is refused now, as the same call in a SELECT always was.
  • Fixed Exporting as SQL Inserts, Copy as INSERT and Import Data all included a table's generated columns, which the table computes itself, so the server refused the inserts. Those columns are now left out on every engine.
  • Fixed Import Data matched file columns to table columns without regard to case, so a file's "id" could land in a column named "ID" when the table had both. An exact match now wins, and a name that fits two columns is left for you to pick.
  • Fixed SQL Server: creating a persisted computed column, an indexed view or a filtered index from a query tab failed with "SET options have incorrect settings". Every connection now turns on the same session options SQL Server's own tools use, so these work.
  • Fixed Importing a damaged Excel file, such as one cut short, quietly brought in only the rows before the damage. Such a file is now refused with a message, so you never get part of a file without knowing it.

0.3.4

· 24 MB

Exports and table copies now keep every value and every row

  • Fixed A stopped or failed Export Data… deleted the file it was replacing and left nothing in its place. The export now writes to a temporary file beside it, which takes the old file's place only after the last row is in.
  • Fixed Binary values, such as images or files stored in a table, were lost when a table was exported or copied to another database: they came out as NULL or as just their size. They now export, import and copy whole on every engine, Oracle and Db2 included. A query result's export still cannot include them, and its sheet says so.
  • Fixed Export Data… on a table whose primary key is binary could read the first page over and over and never finish, or stop after the first page. Every row is now read once.
  • Fixed SQLite: a value stored in a column declared with another type, such as a blob in a text column, could export as NULL or be dropped by a copy. Every value now exports and copies as SQLite holds it.
  • Fixed An Excel export with more rows than a sheet holds, 1,048,575, dropped the rest and still reported every row as saved. The extra rows now continue on a second sheet, and importing such a workbook reads every sheet as one table.
  • Fixed Databricks: when the server cut a page of rows short at its size limit, Next went off or skipped the rows between that page and the next. Next now stays on and continues from the row where the cut stopped, so no row is skipped.

0.3.3

· 25 MB

Change the assistant's model from its panel, install updates from Settings, and fixes for generated columns on five engines

  • New The AI Assistant panel now shows the provider, the model and the thinking level under its title. Click any of them to change it there, and the next question uses the new choice. The provider menu also opens Settings to set up more providers.
  • Improved Settings ▸ General now installs the update it finds. Update & Relaunch sits in the same row, which shows the download as it runs and says why if the update cannot be installed. The pane used to send you to the toolbar's Update button.
  • Improved PostgreSQL: a column's type now shows with its length or precision, such as character varying(120) or numeric(10,2), in the table designer, the sidebar, the schema diagram and Compare Schemas. Before, a change in the designer or a compare script could leave the length out.
  • Improved The table designer sends only what you changed, in an order every engine accepts, so one edit can drop, rename, retype, add and reorder columns, generated columns included. A placement the server would refuse, such as a generated column above one it reads, is explained in words, and a refused change shows the server's own message and changes nothing.
  • Improved Copying a table to a different kind of database now says in the sheet which generated columns will land as plain columns holding today's values, since their expression is written in the source database's own SQL.
  • Fixed Databricks: copying or exporting a table could leave rows out when the warehouse cut a page of rows short at its size limit, which the copy took for the last page. Both now read on until every row is in.
  • Fixed Copying a table with two columns whose names differ only by case, such as Flag and flag, mixed the two up: both could be treated as booleans, or a generated column could be written like the plain one and the target refused the rows. Each column now goes by its exact name.
  • Fixed PostgreSQL: a table with a generated column could not be copied to another PostgreSQL database, because the copy wrote the column's expression as a DEFAULT, which the server refuses, and Show DDL showed the same. The column is now written as GENERATED ALWAYS AS and the target computes it.
  • Fixed Copying a table with generated columns could fail on DuckDB, since the copy tried to insert into those columns, and a table whose every column is generated reported rows copied while none were written. Generated columns now stay out of the INSERTs, and a table of only generated columns is created empty and says so.
  • Fixed Copying rows into a table that already exists (Data only) now goes by the target's columns, not the source's: a generated column gets no value, a plain column takes the values, and a name spelled in another letter case, such as Orders for orders, is found. Such rows used to be dropped or refused.
  • Fixed PostgreSQL: in the table designer, a generated column can now have its expression changed in place (PostgreSQL 17 or later), its type changed while it stays generated, or be made a plain column with a default, all in one edit. Setting it to None used to do nothing, and a type change failed.
  • Fixed SQLite and DuckDB: a generated column showed as a plain column, or not at all, and the table designer could not change a table that had one. Generated columns now show with their expression, survive a SQLite rebuild, and can be added and dropped as each engine allows.
  • Fixed MySQL and MariaDB: a generated column showed as a plain column the table designer could not change. The designer now shows its expression exactly, accents and emoji included, and can change it, retype the column, make a stored one plain, or drop it. Compare Schemas no longer reports a difference for the same expression spelled two ways.
  • Fixed SQLite: the table designer refused every change to a table with a column declared without a type, which SQLite allows, and a rebuild lost the collation of a column named in square brackets, such as [label text]. Both work now: an existing column may stay untyped, and the collation is kept.
  • Fixed SQLite: text holding a NUL character was cut off at the NUL when read, and could not be written back whole. Such text is now read in full and written back in full, so edits, copies and page reads find the right row.
  • Fixed PostgreSQL: a schema, table or column with a dot in its name could show another object's type, key or comment in the sidebar, because the sidebar told objects apart by their dotted names. Each part of a name is now kept separate.
  • Fixed SQL Server: an exported saved query lost the database it was saved against, so after an import it opened on the connection's default database. The export file now carries that database, and older files still open.
  • Fixed SQL editor: a name with letters outside ASCII, such as 基数, or with a dollar sign in it was treated as symbols, so Format put spaces between its characters. Such a name is now one word, colored and formatted as one.
  • Fixed Sidebar: after the last tab of the connection on screen closed, the sidebar could move its selection to the next connection's row a moment later, replacing rows you had ⌘-clicked meanwhile and opening that connection's page. The move now stops once you click or arrow in the sidebar, and a ⌘-, ⇧- or ⌃-click never opens a connection's page.

0.3.2

· 24 MB

Drag to select in the results grid, console tabs on a newer Ghostty build, and safer edits, exports and saves

  • New Drag across the results grid to select the rectangle of cells you sweep, or down the row numbers to select those rows, and ⇧-click a cell to select the rectangle from the selected cell to it. ⌘C copies the selection as tab-separated lines, and the copied cells flash so you can see what went to the clipboard.
  • Improved Console tabs run on Ghostty's terminal library build of October 15. A console you are not typing in no longer redraws itself every 600 ms for its blinking cursor, which had kept about 225 MB of graphics memory in use per console.
  • Fixed Closing the last tab of the connection in front showed "No Open Tabs" while the other connections' tabs still stood on the strip. The window now moves to the tab beside the closed one.
  • Fixed Clicking another connection in the sidebar or in the Commands palette carried the query tab in front along to that connection. Those now bring the connection forward and leave the tab where it is. Only the toolbar's connection menu moves a tab.
  • Fixed The Mac's automatic corrections, curly quotes, long dashes and spelling fixes, could change what you typed in the app's text boxes, and JSON typed into the pop-out value editor came out invalid. The value editor now keeps every character as typed, and the app turns the corrections off for itself the first time it runs. Edit ▸ Substitutions turns any of them back on.
  • Fixed A change to connections, saved queries, query history or the backup list that could not be written to disk looked saved and was gone at the next launch. An alert now says which file could not be written.
  • Fixed Export Data… and Copy to Database… read their pages by position, so a row deleted while they ran shifted the rows behind it and one was skipped. Every page after the first now starts after the last row's key.
  • Fixed MySQL, MariaDB, ClickHouse and Db2 refused a new grid row saved with nothing typed into it. The row now goes in with every column at its default.
  • Fixed ClickHouse: a grid edit or delete on a row whose key other rows share changed all of them, and on a replicated table a row that arrived or left during the save could be changed in its place. The save now refuses unless one row matches, names the row by its content and place in the table, and checks afterwards that each change landed.
  • Fixed ClickHouse: a map or a tuple could not be edited in the grid, and an array, map or tuple typed as a value the column cannot hold, such as 256 in an array of UInt8, was stored as an empty or default value and reported saved. Such a cell now edits as JSON, and the server refuses what the type cannot hold, naming the field.
  • Fixed ClickHouse: a change the server could not apply stayed queued and held every later change to the table, and a failed save could say nothing had changed or withdraw a change someone else had queued. The save now withdraws only its own failed change and says why, names the rows whose changes did land, and asks for a reload when it cannot tell.
  • Fixed ClickHouse: a NaN or infinite float, alone or inside an array, map or tuple, showed as NULL. It now shows by name as nan, inf or -inf.
  • Fixed ClickHouse: a query naming the default database, such as SELECT * FROM default.events, came up read-only in the grid, since default is also a SQL keyword. It now edits like any other result, and completion knows the table.
  • Fixed SQLite: editing or deleting a row whose primary key is NULL changed every row with a NULL key. Such a row now takes no edit or delete, and the status bar says why.
  • Fixed MongoDB: Export Data… on a collection of more than 1,000 documents stopped at 1,000 and called that the whole collection. The export now reads the whole collection in pages, with every document's values under their own field names.

0.3.1

· 24 MB

Export and import in nine formats, whole tables out, data files dropped onto tables, and new tables made from files

  • New The Export sheet offers nine formats: CSV, TSV, JSON, JSON Lines, SQL Inserts, Excel, Markdown, HTML and XML. CSV can be split by a comma, a semicolon or a pipe. HTML and XML are coloured as markup, and Preview in Browser opens the HTML page in your browser.
  • New Export Data… in a table's menu writes every row of the table in any of those formats, read from the server in pages. The sheet counts the rows as they go, and Stop ends it.
  • New Import Data… in a table's menu replaces Import CSV… and takes any format the export writes. The delimiter is detected and can be changed, and numbers and booleans go in as such.
  • New Drag a data file from Finder onto a table in the sidebar or in the Tables listing to import it into that table. The row lights up under the file. Dropped on a database, on its Tables folder or anywhere else on the window, the file asks which table takes it.
  • New New Table… in that sheet makes the table from the file: the table designer opens with one column per column of the file, each typed by its values. Press Create Table, and the import sheet comes up for the new table.
  • Improved Save as Excel… is gone from the Export sheet: Excel is a format in the menu, and Copy with Excel picked puts the rows on the clipboard tab-separated, ready for a spreadsheet.
  • Improved A button that only closes a sheet, such as Close, Done or OK, no longer wears the accent color; only a button that changes something does. The DDL sheet's Done is now Close.
  • Fixed A file dropped on the SQL editor could do nothing while a table designer was open in another tab, because the hidden designer took the drop. Files dropped on the editor or on the results under it now open as they do anywhere else on the window.

0.3.0

· 24 MB

Sort by double-click, row estimates and connect times in the sidebar, and the trial key by email

  • New Double-click a column header in the results grid to sort by that column: once for ascending, again for descending, a third time to clear it. Another header's double-click sorts by that column alone, and the sort shows as a bold mark in the connection's color beside the name.
  • New The sidebar shows how long a connection took to connect, at the right of its row when there is room and in its tooltip.
  • New Tables show about how many rows they hold, such as ~48K, in the sidebar tree and in the Tables listing. The figure is the server's own estimate, never a count, so even a huge table costs nothing to show.
  • Improved The free trial key now comes by email, which confirms your email address: press Start Free Trial, then enter the key from the email under License Key and press Register. A mistyped address costs nothing: ask again with the right one.
  • Improved Sort Ascending and Sort Descending in the column menu now sort by that column alone. To sort by several columns, choose Add to Sort Ascending or Add to Sort Descending on the next column, and Remove from Sort to take one back out.

0.2.9

· 24 MB

A free month's trial

  • New A free month's trial, asked for in Settings ▸ License with your name and email address. The toolbar shows how many days of the trial are left.

0.2.8

· 24 MB

Keyboard moves on the results grid: arrows, ⌘ arrows, Home, End, the Page keys, Return and Escape

  • New The arrow keys move the selected cell around the results grid, and the grid scrolls to keep it in view. ⇧↑ and ⇧↓ select rows from that cell outward, ⇧← and ⇧→ select cells along its row, one more with each press, the way a text editor selects.
  • New ⌘↑, ⌘↓, ⌘← and ⌘→ jump the selected cell to the first or last row or column, the way they reach a document's ends in a text editor.
  • New Home and End move the selected cell to the row's first and last column, ⌘Home and ⌘End to the first and last row, and Page Up and Page Down move it a page of rows.
  • New ⇧ with any of those selects from the cell all the way to there: ⇧⌘→ takes the cells to the end of the row, ⇧⌘↓ the rows to the last, ⇧Page Down a page of rows. The keyboard goes with the selection, so an arrow afterwards starts from its far end.
  • New ⌘C, and Copy Cells in the right-click menu, copy a run of cells tab-separated, ready to paste into a spreadsheet's row.
  • New Return edits the selected cell. When the edit ends, with Return, Escape or a click elsewhere, the cell is selected again, so the arrow keys move on from it. Escape clears whatever is selected: a cell, rows or columns.

0.2.7

· 24 MB

Thinking levels for every AI provider, ⇧⌘↩ on a selection, and side panels sized one at a time

  • New The Thinking level in Settings ▸ AI now works with OpenAI, Gemini, Grok, DeepSeek, Mistral and a local Ollama server, not only Claude. Each provider's own levels are offered, and a level a model refuses is taken off its list.
  • Improved ⇧⌘↩ runs only the selected statements when text is selected. With nothing selected it runs everything in the tab, as before.
  • Improved The inspector and the AI assistant panels can be dragged as wide as the window allows. Before, each stopped at a fixed width, about a third of a normal window.
  • Improved The SELECT statements of a script are paged like a SELECT run on its own: 1,000 rows at a time, each result with its own pager and total. Before, a script ran each statement whole, so a big table in a script fetched every row.
  • Fixed With the inspector and the AI assistant both open, dragging one panel's edge also resized the other. Each now keeps its width while the other is dragged.
  • Fixed A connection that died without a word, after the Mac slept or the network changed, could leave a statement waiting for minutes. Connections to PostgreSQL, MySQL, MariaDB, Redis and a proxy now carry a keepalive, so the loss is noticed within about half a minute and the app reconnects.

0.2.6

· 24 MB

A thinking level for the AI assistant, ⌘A on the results grid, and opened files named in full and found inside their sidebar folders

  • New Settings ▸ AI has a Thinking level under Model. The levels are the ones the provider lists for the chosen model, such as Claude's low to max, and "Model default" leaves it to the model. Every question and completion carries the level you pick.
  • New Press ⌘A on the results grid to select every row, the same as clicking the blank corner above the row numbers. ⌘C then copies them all, tab-separated.
  • Improved Next to the AI API key, the Remove button now stays on the row, disabled, until a key is saved. Before, it was hidden, which left Save floating in the middle of the row.
  • Improved A SQLite or DuckDB file you open is now named after its whole file name, extension included, such as "shop.sqlite". Before, the last extension was dropped, so "database.sqlite.sqlite" became "database.sqlite". A connection already saved keeps its name.
  • Fixed Opening a database file whose connection was filed in a closed sidebar folder showed its page with no row highlighted. The folder now opens, and the connection is highlighted.
  • Fixed Pressing ⌘C on the results grid copies what is highlighted: a cell's value, the selected rows, or the selected columns, tab-separated. Before, it only made the system's sound.
  • Fixed After a click on the blank corner above the row numbers, ⌘C now copies the rows it selected. Before, the copy still went to the editor.
  • Fixed Clicking the blank space under the text in the SQL editor now puts the cursor on the last line. Before, it stopped one line short when the text ended with an empty line.
  • Fixed A row copied from the results grid and pasted into the SQL editor now stays on one line. Before, the editor broke the line at the tabs between its values.

0.2.5

· 24 MB

A menu on every column header, opened files that unfold in the sidebar, and Homebrew upgrades that reopen the app

  • New Every column header in a result now ends in an up-and-down chevron. Click it for the column's menu: sort ascending or descending, clear the sort, fit the column's width or every column's, copy the column or its name. The same menu still opens on a right-click.
  • Improved Sorting a column no longer widens it. Every header keeps room for its sort mark, so the columns stay put as sorts come and go.
  • Improved Installing a release with brew upgrade now quits the running app first and reopens the new version once it is in place. Before, the old copy kept running until it was quit by hand, and the new version only opened at the next launch.
  • Improved A SQLite or DuckDB file you open, by double-click, drop or File ▸ Open…, now comes up open in the sidebar: the connection, its database and its tables, with the connection highlighted. Before, only the connection row opened, on a closed database row.
  • Fixed Double-clicking a NULL cell and then clicking away turned it into an empty text and counted it as a change. A cell left as it opened now changes nothing, and the NULL stays.

0.2.4

· 24 MB

Columns that fit Chinese and emoji text, a reason when a cell cannot be edited, and editable Databricks timestamps

  • Improved When a cell in an editable result cannot be edited, such as a generated column, the status bar now says why while the cell is selected. Before, a double-click on it did nothing.
  • Improved The "Review Changes" sheet shows a spinner while a save runs, and closes as soon as the save is done. The grid reloads behind it. Before, the sheet stayed open through the reload, showing zero changes.
  • Improved Databricks: timestamp cells can now be edited in the grid. They used to be read-only because the server returns timestamps rounded to milliseconds, and the save now allows for that.
  • Improved The editor for a long or JSON cell now shows its text in a rounded box with a margin around it, like every other sheet. Before, the text ran to the sheet's edges.
  • Fixed A column holding Chinese, Japanese, Korean or emoji text came out too narrow, so its values were cut short with an ellipsis. Such text is now measured, and the column fits it.

0.2.3

· 24 MB

Writes that run once, MongoDB edits that land on the right document, and SQL read the way each engine reads it

  • Fixed A statement that changes rows and shows them, such as an UPDATE … RETURNING inside a WITH, ran its update again on every page turn and header sort. A WITH ending in a DELETE or an UPDATE was paged, and changed only the first page of rows. Both now run once, exactly as typed; a header sort orders the rows already loaded.
  • Fixed A SELECT that calls nextval() or takes an advisory lock stepped the sequence again on every page turn, count and header sort. It now runs once too, and its rows sort on screen.
  • Fixed Watch re-ran whatever the tab ran last, so turning it on after an INSERT or an UPDATE repeated the write on every tick. Watch is now offered only for a statement that reads: after a write the button is off and says why, and a write run in a watched tab ends the watch.
  • Fixed Sorting the result of SHOW, CALL, EXPLAIN or a similar statement by a column header re-ran it with an ORDER BY it cannot take, and the re-run failed. Such a result now sorts on screen, and the statement stays as typed.
  • Fixed A statement that ends in a comment, such as SELECT * FROM orders -- newest first, had its page limit, its count and a sort's ORDER BY added on the comment's line, where the server read them as part of the comment. Every row came back and the count failed. They now go on a line of their own after the comment.
  • Fixed When the connection dropped inside a transaction, the app reconnected and carried on with the rest of the script, although the server had rolled the first part back. The run now stops at that statement, says the transaction was rolled back, and runs nothing after it.
  • Fixed MySQL: a TLS connection killed during a statement, or whose server went away, showed the single word uncleanShutdown and never reconnected. It is now a lost connection like any other: the app reconnects, and a statement that only reads is run again.
  • Fixed MySQL and MariaDB: with auto-commit off, a tab's script could be cut into statements by another tab's SQL mode. Under NO_BACKSLASH_ESCAPES, SELECT 'C:\'; DELETE FROM t then read as one SELECT, so no transaction was opened and the DELETE was committed. Each tab's connection now reports its own mode as it opens, and the script is read that way first.
  • Fixed MySQL and MariaDB: ⌘↩ and Explain run the statement under the cursor as the connection reads it, and nothing beside it. Explain used to wrap the text as the other reading cut it, and the connection could run a DELETE hidden in that text.
  • Fixed MySQL and MariaDB: after a lost connection, a read that holds a backslash is not run again when the fresh connection reads backslashes the other way, because the lost one had been switched by hand. The run stops there and says so.
  • Fixed MongoDB: editing or deleting a document whose _id is text that looks like an ObjectId changed another document, or none, and was reported as saved. A row now carries its document's own _id, whatever its type, so a change lands on that document.
  • Fixed MongoDB: a change the server refused, such as a value that breaks a unique index, was reported as saved. The "Review Changes" sheet now stays open with the server's own message, and the edit stays pending. The same goes for a document someone else deleted first. The sheet also no longer promises a single transaction, which MongoDB does not do.
  • Fixed MongoDB: an edit in the grid could change a field's type: an ObjectId became text, a 32-bit integer became a 64-bit one, and 01235 would not save at all. A value is now saved as the type its field holds, and text that type cannot hold is refused. Embedded documents and arrays are read-only in the grid now.
  • Fixed MongoDB: a typed command could reach the server with its keys in a different order, so a sort by last name and then first name sometimes sorted by first name first. Keys now go out in the order you typed them, and a whole number keeps every digit.
  • Fixed A valid MySQL or MariaDB script could fail with a syntax error because it was cut into statements in the wrong place: inside a string with a backslash-escaped quote, a name in backticks or a # comment. Scripts are now cut the way each engine reads them, including E'…' strings on PostgreSQL, backslash escapes on ClickHouse and square brackets on SQL Server and SQLite.
  • Fixed Databricks: a raw string that ends in a backslash, such as r'C:\tmp\', swallowed the statement after it. A raw string now ends at its closing quote.
  • Fixed In a MySQL, MariaDB or ClickHouse tab, a string with a backslash-escaped quote was colored as a string followed by code, completion would not open after it, and Format changed the case of words inside it. The editor, the SQL previews, the result log and the assistant's replies now read text the way the tab's engine does.
  • Fixed The assistant's read-only check could pass a MySQL statement that hid a DELETE behind a double-quoted string with a backslash in it. The read-only connection still refused the write; the check now refuses such a statement itself.
  • Fixed MySQL and MariaDB read -- as a comment only when a space follows it. The editor colored --asdf as a comment anyway, so SELECT * FROM t --asdf looked right and the server refused it. Such dashes are now colored as code with an orange mark that explains the missing space, and Format leaves them as typed.
  • Fixed Importing a one-column CSV file skipped every row whose value was empty. Those rows are now imported, and a one-column export writes an empty value as two quotation marks, so it is still a row when the file is read back.
  • Fixed Copying a table to another engine could drop or change a text default: from ClickHouse or MariaDB a default with a quote was left out and a backslash arrived doubled, and from MySQL every text, date and time default was left out. These defaults now arrive as the values they are.

0.2.2

· 24 MB

Fewer tabs on the way to a table, Back and Forward through pages, and a console for each database

  • Improved Getting from a connection to a table used to leave four tabs open; now it leaves two. What you open from an overview replaces it in the same tab while the tab's title is in italics. Click the page beside its cards, or its tab, and the title turns upright: the tab is kept, and what you open next gets a tab of its own.
  • Improved Back and Forward on the tab strip step through pages as well as tabs. A page you only glanced at comes back with its filter, selection or zoom. A tab holding something you would lose, such as uncommitted edits, an open transaction, changed SQL or a console, is never replaced: the next page opens beside it.
  • Improved A database's overview has a Console card again. It opens the engine's own command-line client with that database as the current one, or that schema on PostgreSQL. Clicking it again brings the console forward, and another database's card opens a console of its own.
  • Improved A single statement with no rows to show, such as an ALTER or an UPDATE, now reads the way it does in a script: a Summary line with the statement, a check mark, how it ended and how long it took. It used to be a lone gray check mark in an empty pane.
  • Improved The foreign-key picker names the table its rows come from, beside the filter box. A long key such as a UUID now shows whole, and the picker opens wider to make room for it.
  • Fixed A suggestion from the assistant while typing SQL sometimes did not appear. A model that thinks before it answers could spend the reply's whole size limit on its thinking; the limit now leaves room for it. And a suggestion requested while the completion list was open was thrown away; one is now requested as the list closes.
  • Fixed Reopening a closed tab with ⇧⌘T or the Back arrow brought the Backups list back as an empty query tab, a saved query as plain text without its name, and the connection's own page, or a list of extensions, casts, tablespaces or partition functions, not at all. Each now comes back as what it was.
  • Fixed Each table glanced at from the sidebar left one connection to the server open until the whole connection was closed. The connection is now handed back when the next table takes the tab's place.
  • Fixed Whether a click kept a tab, its title turning upright, could differ from one run of the app to the next. Now it is the same every time: what a list opens stays in italics until you click in it, a right-click under a list keeps the list, and a click under a sheet or the ⌘K palette keeps nothing.
  • Fixed After a script, the strip of result chips stayed above the Disconnected pane, where its chips opened nothing. The strip is now hidden while there is no connection.

0.2.1

· 24 MB

The foreign-key picker shows the rows a key points at, a newer terminal in console tabs, and a narrow status bar that keeps Commit and Discard

  • Improved The foreign-key picker used to list only the keys of the table a column points at. It now shows that table's first 500 rows, with the row the cell points at marked and in view. The filter searches every column, and a click on a row writes its key. The row inspector gets the same picker.
  • Improved Console tabs run on Ghostty's terminal library 2.2, up from 1.6, which fixes a terminal that stayed blurry and oversized after a display was reconnected or changed its resolution.
  • Fixed In a narrow window with the row inspector open, the status bar ran out of room: the Commit… button got no space at all, and Discard was cut to one letter. The bar's words now step aside first, and Discard, Commit… and the page buttons always stay.

0.2.0

· 23 MB

Reconnecting by itself after a server goes quiet, ClickHouse redirects refused, and SQLite foreign keys checked before a change is saved

  • Improved ClickHouse Cloud: the page your browser shows at the end of a Cloud SSO (Read-Only) sign-in is now a proper page with the app's icon and name, in a light and a dark look. It used to be a bare heading and one line of text.
  • Fixed PostgreSQL, MySQL, MariaDB, Redis and ClickHouse: a connection attempt that was accepted but never answered, as a forwarded port does while its server is away, waited for good, so the app could not reconnect by itself. It now gives up after 10 seconds and tries again every 15 seconds. A paused ClickHouse Cloud service gets 2 minutes to wake.
  • Fixed Redis: when the server closed the connection, for example after a restart, the app did not notice, and every command failed until you reconnected by hand. The app now sees the loss and reconnects by itself.
  • Fixed PostgreSQL, MySQL, MariaDB and Redis: connecting to a port where nothing listens showed a message that read like an error code, and on PostgreSQL it took 10 seconds to appear. The attempt now fails at once and says the server could not be reached. Reconnecting to PostgreSQL after a restart is 10 seconds quicker for the same reason.
  • Fixed Stopping a statement the server never answered left its connection waiting for good, so everything run on it afterwards queued behind the stopped statement. A stopped statement now gets 5 seconds to end; then its connection is closed, and the next statement opens a fresh one.
  • Fixed ClickHouse: a server, or a proxy in front of it, that answered a query with a redirect had your user name and password sent on to the other address. The app now refuses every redirect and says where it pointed.
  • Fixed SQLite: a foreign key added in the table designer over rows that point at nothing was saved anyway, and so was a change that left other tables' references pointing at nothing. The designer now checks every row against the foreign keys first and refuses such a change, naming the table and how many rows. Nothing is changed then.
  • Fixed A CSV export wrote a value holding a Windows line break without quotes, so the row split in two when the file was read back. Such a value is now quoted like any other line break.
  • Fixed Importing a connections file that listed the same connection twice, with saved queries, made the app quit unexpectedly as the import sheet opened. Such a file is now refused with a message naming the connection.

0.1.9

· 23 MB

The AI assistant on a model on your own Mac, tabs in the order you open them, and a pager even on a one-page result

  • New Settings ▸ General links to the website, the documentation, the release notes, the support desk at azcode.dev and the privacy page, each opening in your browser.
  • New The AI assistant can run on a model on your own Mac. Choose Local server in Settings ▸ AI, keep Ollama's address or type another, such as LM Studio's, and pick a model; no key is needed. Your questions, schema names and sampled rows then go to that address and nowhere else.
  • Improved Oracle's connection page fits its sheet again, with no scroll bar. Its Options page now holds what a connection can do without: the Oracle Client row, the certificate DN and the call timeout. Db2's client row moved there too, and Service Name or SID is chosen on the name's own row.
  • Improved Settings ▸ Security shows a notice only when there is one, instead of keeping two empty lines for it.
  • Improved Tabs sit on the strip in the order you opened them: a new tab is always the last one, whatever its connection. Drag a tab to arrange the strip; a line between two tabs shows where it will land.
  • Improved The pager stays in the status bar for every single SELECT and every table opened from the sidebar, even one that fits on a page, where it reads the whole result, such as 1–31 of 31. A small table used to show neither a pager nor a row count.
  • Improved Settings ▸ License asks the license server for the registration each time the pane opens, so a renewal or a corrected name shows at once. If the server cannot be reached, the pane shows what it last knew.
  • Improved How many Macs a key registers, as the license sheet says before you register, is read from the store's public product list, the same list the pricing page reads. That request carries nothing about this Mac.
  • Improved Settings ▸ Browsing no longer offers a switch to stop remembering the statements you run: every statement you run yourself is remembered, and Clear History still forgets them all.
  • Improved The OpenSSL that encrypts SQL Server connections moved from 3.6.4 to 3.6.5.
  • Fixed Dragging a tab onto another connection's tab moved the tab to that connection. A drag now only moves the tab along the strip; its connection never changes.
  • Fixed A tab of a connection without a color theme wore the engine's brand color on the strip, and a themed tab lost its color while it was the only connection with tabs open. A tab now wears its connection's theme color alone, or none.
  • Fixed The database menu in the title bar highlighted its rows in the system's blue whatever the connection's color theme, and in light mode the blue database icon vanished on the highlighted row. The highlight now wears the connection's color, with the icon, the check mark and the name in white.
  • Fixed Picking another connection in the title bar while a console tab was in front carried the console there and restarted its program, which failed. The connection menu and the database picker now move a query tab only; a console, a designer, a listing, the overview or a diagram stays put. The sidebar, the ⌘K palette and Compare Schemas do the same.
  • Fixed With VoiceOver or another accessibility reader running, returning to a query tab from the overview could freeze the app: the pager's row reading in the status bar read itself in a loop. The reading, the page number and the match count in the grid search are no longer selectable text, which ends the loop.

0.1.8

· 23 MB

PostgreSQL values exactly as psql prints them, and SSH tunnels that read your ~/.ssh/config

  • New SSH tunnels read ~/.ssh/config and /etc/ssh/ssh_config the way ssh does in Terminal. SSH Host can be the name of a Host entry, and SSH Port, SSH User and the key can stay blank: the placeholders show what ssh will use, and a field you fill in wins. HostName, Port, User, IdentityFile, Include, ProxyJump, ProxyCommand and the rest all apply.
  • Improved PostgreSQL: every value now arrives as the text psql prints for it, whatever its type. Intervals, arrays, ranges, network addresses, money and extension types used to show only their type name in angle brackets, and a long numeric was rounded. An edit, Copy as INSERT, an export or a copy to another database writes that same text back.
  • Improved PostgreSQL: a timestamptz shows with its zone offset, as psql prints it, and its date picker opens on the time the text shows. Copied to another database, it travels as the same moment in UTC.
  • Improved The AI Assist button is in the toolbar from the start. Until a key and a model are set, clicking it or pressing ⌥⌘A opens the AI page of Settings, and its sparkles stay gray.
  • Improved PostgreSQL: COPY … FROM STDIN in a query tab now says plainly that it needs a file to read, and points to a console tab or COPY … FROM '/path' instead.
  • Fixed A designer with a wide row, such as Compare Schemas, could push the AI assistant panel past the edge of the window. The tab's content now stays inside its own column, and Compare Schemas puts Source above Target when the two do not fit side by side.
  • Fixed An array column, such as PostgreSQL's integer[] or ClickHouse's Array(Int32), was edited as a number. It now edits as its text, such as {1,2,3}.

0.1.7

· 23 MB

Column and table comments, a connection for every tab, and tab switches that answer at once

  • New Column and table comments in the table designers. Select a column for its Comment; the table's own comment is in the structure editor's header and in New Table. Comments are written the way each engine keeps them, Compare Schemas reports one that differs, and a copied table keeps its comments where the target has them. SQLite keeps none.
  • New Every tab that runs SQL has a connection of its own, and a transaction belongs to the tab that opened it. The sidebar, Show DDL and the other tabs keep working while a tab waits on a long query; before, everything queued behind one connection. A tab with an open transaction cannot be closed until it is committed or rolled back.
  • Improved Clicking a tab highlights it at once, and its editor and results follow a moment later. Switching to a connection with many large results open used to hold the click back until everything was laid out; the same goes for ⌃⇥, ⌘1 to ⌘9 and the tab overview.
  • Improved Switching back to a connection is as quick as switching tabs: the workspaces of the last ten connections you used stay ready behind the one on screen, editors, results and consoles included. The toolbar, the window title and the row inspector belong to the window now and follow the connection in front.
  • Improved A selected cell lights its row: the rest of the row wears a lighter wash of the cell's color, so it is easy to follow across a wide result.
  • Improved Nothing in the results grid is rounded any more: a selected cell, a selected row or column, and a search match all fill their cells to the corners.
  • Improved The results grid stops at its edges. A trackpad scroll that reaches the first or the last row, or either side, no longer slides past the edge and springs back.
  • Improved Scroll a wide result sideways and the row numbers stay put at the left edge; the columns slide under them. A row number still selects its row there, and its right-click menu is the row menu.
  • Improved The app looks for a newer release a minute after it starts, and then about once a day. It used to wait five minutes.
  • Fixed The red warning "The connection is closed. Reconnect and try again." stayed on screen after the connection was back, until the tab ran something again. It now goes away with the reconnect. Warnings about a statement the server may have applied stay.
  • Fixed Showing the result log in one tab made it open by itself in another tab, the next time that tab ran a query. Each tab keeps its own now: the log opens and closes only in the tab where you press ⌘L or its button, and a run never moves it. A new tab starts the way you last chose.
  • Fixed DuckDB: a change committed in one tab could be missing from another tab, from the tree or from an export, and gone from the file once the connection closed, because each tab opened the file in an instance of its own. The app now opens a DuckDB file once and gives every tab a connection to that one instance.
  • Fixed Assistive tools such as VoiceOver were still offered the buttons of designers, listings, consoles and pages in tabs behind the one on screen — three "Manage Filegroups…" buttons for the one you could see, for instance. A tab behind another now leaves the accessibility tree whole.
  • Fixed With no connection selected, a schema refresh could bring a connection's workspace back on its own: the sidebar's highlight returned to a row a closed tab had left lit, and the window followed it as if the row had been clicked. The window now follows only a row you click or move to with the keyboard.
  • Fixed A statement that kept the connection busy for more than about ten seconds, such as a long SELECT, an ALTER or an import, could have the connection torn down under it: the keepalive's ping queued behind the statement, timed out, and dropped a healthy connection. The ping now goes to the sidebar's own connection alone, and only while it is idle.
  • Fixed On MySQL and MariaDB, changing a column in the designer dropped the column's comment, because the column was restated without one.
  • Fixed In the editor, the column list of a MERGE statement's INSERT branch was read as a list of tables, so its columns wore the orange underline of a table the tree does not have.

0.1.6

· 23 MB

An editor that marks problems and completes joins, query history, Excel export, dump and restore, schema compare, and AWS IAM sign-in

  • New The editor marks problems as you type: a dotted red underline under a string, quoted name, comment or bracket that is never closed, or a clause with nothing after it, and an orange one under a table, column or qualifier the tree does not have. Hover for the reason.
  • New Completion reads an outline of the statement: after an alias's dot it offers that source's columns, in WHERE, ON, GROUP BY and ORDER BY it offers columns and never a table, and after JOIN it offers the tables a foreign key ties to the ones already in the query, each with its ON condition written.
  • New Query history: every statement you run is remembered per connection, newest first, and offered in the ⌘K palette under History. Settings ▸ Browsing turns it off or clears it.
  • New Save as Excel… in the Export Result sheet writes an .xlsx workbook with one sheet named for the table: a bold frozen header row, numbers and booleans as cells Excel can sum and filter, everything else as text.
  • New Dump Database… and Restore Database… on a connection's menu and in the palette run pg_dump and psql, mysqldump and mysql, or sqlite3 in a console tab, with the file, the scope and the connection's settings filled in, and Show in Finder when the file is done.
  • New Compare Schemas… lists every table that differs between two databases of one engine and writes the script that brings the target up, from the designers' own planners, ready to open in a query tab on the target.
  • New Sign in with AWS IAM on RDS and Aurora PostgreSQL: the token is signed at every connect from the credentials in ~/.aws, and the console's psql and pg_dump get it too.
  • Improved A dump or restore that is ended before it finishes says so in the tab, instead of reporting a finished file.
  • Improved A blank tab shows a quiet table glyph, like the app's other empty views, instead of a play button that looked like something to click.
  • Improved Refreshing the sidebar shows: the connection's icon turns into a spinner and the rows under it fade while they are read again, then come back as the fresh tree arrives.

0.1.5

· 23 MB

Working buttons on macOS 15, and Oracle and Db2 clients that set up on demand

  • Improved Connecting to a saved Oracle or Db2 connection whose client is not installed opens the client setup sheet first; once the download is in, the connection goes on by itself. Test Connection and Add do the same, and Cancel leaves the connection alone, without an error.
  • Improved A DBClient update that brings a newer Oracle or Db2 client offers it the next time such a connection is opened: Update installs it and removes the old one.
  • Improved A client download that fails keeps the sheet open to try again, and leaves the client already installed as it was.
  • Improved The Oracle Client and Db2 Client sheets no longer look up the vendors' downloads pages: Check Oracle for Updates and Check IBM for Updates are gone. Each sheet installs the client this build is made for; a newer one arrives with a DBClient update.
  • Improved Completion works inside quoted names: typing audit_ between backticks offers audit_log, and accepting it closes a quote you left open.
  • Improved After a table name, completion offers the keywords that can follow it — WHERE, JOIN, ORDER BY, LIMIT — instead of nothing.
  • Fixed On macOS 15 Sequoia every standard button — Add Connection, Save, Cancel, Test Connection — drew as a yellow box with a red no-sign, so a connection could not be added. They are real buttons again.
  • Fixed On macOS 15 the toolbar's actions piled up beside the connection menu instead of standing at the right end of the bar.
  • Fixed On macOS 15 the sidebar's disclosure carets were near-white; they are the same gray as on macOS 26.
  • Fixed On macOS 15 the tab strip was a bright band over the gray window. It now sits flat on the window ground on every macOS.

0.1.4

· 23 MB

Up to 3 Macs on one license key

  • New A license key registers up to 3 Macs at once. Each registers in Settings ▸ License with the same email address and key; the pane says how many Macs the key holds, and Deregister This Mac takes this Mac off it.
  • New A Mac that is gone can be released under My Licenses at azcode.dev. When the key is full, another Mac is refused until you make room.
  • Improved When a registration ends, the pane says why: this Mac was deregistered or released, another Mac took its place, the license ended, or it was withdrawn.
  • Fixed In the diagram, the click after dragging a table was lost — arrange a few tables, pick one, and nothing lit up.
  • Fixed The database picker's menu drew its blue cylinder icons in black.

0.1.3

· 24 MB

Free for databases on this Mac, a license for remote ones, and SSH tunnels that work the way ssh does in Terminal

  • New Connecting to another machine now needs a registered license. A copy without one says so in a sheet: Buy a License… opens the pricing page, and Enter License… opens Settings ▸ License. Databases on this Mac stay free, with every feature: files, and servers on localhost. A connection through an SSH tunnel or a proxy counts as another machine.
  • New Settings ▸ License registers this Mac: enter the email address the license was issued to and its key, and click Register. A key registers one Mac at a time. Deregister This Mac frees it, and registering on another Mac moves it there.
  • New A registered copy checks its registration about once a day. Being offline changes nothing, and a copy that is not registered never contacts the license server.
  • New SSH tunnels run on the Mac's own OpenSSH. RSA, Ed25519 and ECDSA keys work, encrypted ones too: there is a Key Passphrase field under the key. Before, only an unencrypted Ed25519 key did.
  • New The first time you connect to an SSH server, a sheet shows its key fingerprint and asks. Trust and Connect saves the key in ~/.ssh/known_hosts, the file ssh uses in Terminal, so a server trusted in one is trusted in the other.
  • Improved A server whose key has changed is always refused. The Host Key menu is gone, and its Accept Any setting with it. A server that an earlier version remembered in a file of its own is asked about once.
  • Fixed A crash on macOS 27 that could strike while the grid measured its text.
  • Fixed Return and Escape work in a sheet after you click its text to select or copy it.

0.1.2

· 23 MB

Passwords are saved only if you ask

  • New The connection editor has a Save Password switch, off for a new connection, so nothing goes to the Keychain unless you ask. The connections you already have keep their passwords.
  • New A connection that saves no password asks for it when you connect. The answer is held until you quit, and a wrong one asks again.
  • Improved The New Connection picker lists engines and services by how often they are used, the relational ones together.
  • Improved A blank tab shows the keys to start with: ⌘↩, ⇧⌘↩ and ⌘K.
  • Improved The Overview tab's tiles are compact one-line rows.
  • Improved The Connection String row has a copy button.
  • Fixed PostgreSQL enum columns show their values and their real type name, and editing one offers a list of the allowed values.
  • Fixed A cell only partly in view at the grid's right edge can be clicked and edited again.

0.1.1

· 23 MB

Consoles in a real terminal, and a much smaller download

  • New A console tab is a real terminal running the engine's own client: psql, mysql or mariadb, sqlite3, sqlcmd, redis-cli, mongosh, clickhouse-client, SQL*Plus or SQLcl, db2cli. It opens signed in to the connection, through its SSH tunnel or proxy too.
  • New When that client is not on the Mac, the app names it and shows the Homebrew line that installs it, with a copy button and Check Again.
  • New Oracle gets Users & Roles, a Tablespaces folder, Explain, New Schema and Drop Schema, collations and bitmap indexes, and the assistant can run read-only queries there.
  • Improved The download is a sixth of the size. Oracle's client library is no longer inside the app: the first Oracle connection downloads it from Oracle, and an Oracle Client Setup sheet updates or removes it.
  • Improved IBM's Db2 driver is downloaded and checked by the app too, from a Db2 Client Setup sheet. Before, you fetched and unpacked it by hand.
  • Fixed On macOS 27: dragging objects out of a listing, the right-click menu on empty sidebar space, the resize cursors on pane dividers, and the grid's column-resize handles all work again.
  • Fixed Redis lists every database in the sidebar, the empty ones too. ClickHouse no longer crashes the app when you disconnect just as a query starts.

0.1.0

· 140 MB

Three new engines: Oracle, IBM Db2 and Databricks

  • New Oracle: connect by service name or SID, with a wallet for verified TLS. Browse, run SQL and PL/SQL blocks, edit rows, and design tables, indexes, foreign keys, sequences, triggers, synonyms and types. Oracle's client library comes inside the app, which is why this download is the big one.
  • New IBM Db2: browse, query, edit rows, design tables, indexes, triggers and sequences, and manage roles and grants under Users, Groups & Roles. IBM's driver is not in the app; a setup sheet in the connection editor walks you through getting it.
  • New Databricks SQL warehouses, with an access token: browse one Unity Catalog, run SQL, edit tables that have a primary key, design Delta tables, and grant access under Principals & Permissions.
  • New ClickHouse Cloud can sign in through your browser instead of a database password.
  • New Running several statements shows a Summary: one line per statement, with how it ended and how long it took. Only a statement that returns rows gets a result of its own.
  • New Drag a table, view or routine straight out of the sidebar tree onto another connection to copy it. Copies work to and from Oracle, Db2 and Databricks.
  • Improved A script that reaches a statement which would commit your open transaction pauses and asks: Commit & Continue, or Roll Back & Stop.
  • Improved On SQL Server the toolbar's database menu lists the server's databases, and picking one moves that tab there.
  • Improved Zoom scales checkboxes, menus, pickers and buttons too, and a sheet shrinks to fit the screen.
  • Improved Showing a password in the connection editor always asks for Touch ID or your login password.
  • Fixed A query never runs in a database other than the one its tab shows. If the switch fails, the query is not run and the app says so.

0.0.9

· 36 MB

Collations in the table designer

  • New The table designer picks a collation from the server's own list, per column on PostgreSQL, MySQL, MariaDB, SQL Server and SQLite, and for the whole table on MySQL and MariaDB.
  • New Generated columns can be Stored as well as Virtual.
  • Improved The column editor has more room: a row keeps the name, type, key and NOT NULL, and a form under the rows edits the selected column's collation, default, auto-increment and generated settings.
  • Improved On MySQL and MariaDB, New Database fills in the server's default character set and collation, so the choice is in view.
  • Improved Query tabs are numbered across the whole window, so two connections no longer both show a Query 1.
  • Improved In Show all tabs, the arrow keys move between the cards, Return opens one and Escape closes the overview.
  • Fixed Changing a column, its type for example, no longer resets its collation. SQLite tables whose columns use COLLATE can be changed in the designer.
  • Fixed A right-click on a row of a listing tab selects that row before its menu opens.

0.0.8

· 35 MB

A saved-query list, TLS on more engines, safer edits

  • New A database's Queries folder opens a list of your saved queries: filter it, double-click to open one, right-click to duplicate or delete one.
  • New Redis and MongoDB connect over TLS, and SQL Server's Required mode encrypts the whole session. The SSL menu lists only the modes an engine can carry out, and Required is named for what it is: no certificate check.
  • Improved With auto-commit off on MySQL and MariaDB, a statement that would quietly commit your waiting changes, such as a CREATE, ALTER, DROP or TRUNCATE, is stopped with an explanation.
  • Improved The assistant runs its queries on a separate read-only connection, so it can never touch your open transaction. On SQL Server and DuckDB, which have no read-only mode, it writes SQL for you and runs none.
  • Improved SSH remembers a server's key when automatically trusting it for the first time and refuses the connection if the key later changes. A damaged connections or saved-queries file is set aside, not overwritten, and the app says so.
  • Fixed While you edit a cell, the picker, Restore and Set NULL buttons sit in a small bar beside it, so the whole cell is free for typing. Timestamps with microseconds get the calendar too.
  • Fixed Clicking another database in the sidebar no longer moves the tab you were working in, and a script keeps running in its own database if you switch tabs meanwhile.
  • Fixed Grid edits are written the right way for each engine: backslashes on MySQL, booleans and Unicode text on SQL Server. A result is editable only when its columns really come from the table.

0.0.7

· 35 MB

Each tab keeps its own database

  • Improved A tab belongs to one database. Picking another database moves only the tab you are on, a new tab opens in the database you were in, and a query waits for the switch before it runs. Before, the pick moved every tab of that connection.
  • Improved A statement that returns no rows, such as a CREATE, an INSERT or an UPDATE, shows the server's own completion line with a check mark instead of an empty grid.
  • Fixed A comment standing alone in a script is no longer sent to the server as a statement.
  • Fixed At large zoom levels the toolbar's buttons stay inside the title bar, and the Run button's menu grows with the zoom.
  • Fixed ⌘F in the results grid puts the cursor in Find in results.
  • Fixed A grid could come up with some columns blank right after a query ran.
  • Fixed PostgreSQL view and trigger definitions always spell table names with their schema, so a copy into another schema is created correctly.

0.0.6

· 35 MB

Quick with big schemas, and one Run button

  • New Run, Run All and Re-run are one toolbar button: Run ⌘↩, with an arrow that opens the other two. It turns into Stop while a query runs.
  • New Tables in the assistant's replies are drawn as real tables, and their text can still be selected.
  • Improved The sidebar and the listing tabs stay quick on servers with hundreds or thousands of tables. With about 900 tables open, a click or a filter keystroke used to freeze the app for up to a second.
  • Fixed Big databases load their whole schema. Tables late in the alphabet could come back with no columns or primary key, and the grid refused to edit them.
  • Fixed The assistant works with OpenAI's reasoning models, and a reply appears as it is written instead of all at once.
  • Fixed The ⌘K palette lists the right rows while you type.
  • Fixed With a filter typed in the sidebar, the folders it opened can be folded by hand again, and ⌘F on a listing tab goes to that list's filter.

0.0.5

· 35 MB

Move several connections at once

  • New Gather connections in the sidebar with ⌘-click or ⇧-click and drag them into a folder, out of one, or to a new place together.
  • New A right-click inside such a selection offers Move to Folder, Remove from Folder and Export… for all of them.
  • New Right-click the empty space of a listing tab for New Table…, New View… and the like, where the connection can create that kind.
  • Improved In the sequence designer, empty Range and Cache fields show the value the server will really use, or say to leave them blank for the server's default.

0.0.4

· 35 MB

A much faster results grid

  • Improved Scrolling through results is far smoother, most of all on wide ones: the grid is now a native table that draws only the rows and columns on screen.
  • Improved The pager reads the row range first, then first, previous, the page number, next, last and the page size sit together at the right, so the buttons stay put while the numbers grow.
  • Improved A click anywhere on the "2 of 1,260" phrase puts the cursor in the page number.
  • Improved The status bar no longer ends with the query's load time. Each statement's time is still in the result log.
  • Fixed The toolbar's buttons are all one height.

0.0.3

· 35 MB

The app opens on macOS 15, and an inspector you can edit in

  • New On an editable result, the inspector's Fields page is a form: change a value there and it joins the grid's pending changes.
  • New The command palette has a toolbar button, Commands, and a click outside the palette closes it.
  • Improved Toolbar actions are outlined icon buttons, and Watch wears an eye.
  • Improved The pager under the results is a few separate groups instead of one boxed capsule.
  • Improved The disk image itself is signed and notarized, like the app inside it.
  • Fixed The app opens on macOS 15 Sequoia. Version 0.0.2 shipped its SQL Server and TLS libraries built for macOS 26, which macOS 15 refuses to load.
  • Fixed The sidebar's selection highlight and its filter box sit centered.

0.0.2

· 35 MB

The app updates itself

  • New The app looks for a newer release about once a day and shows an Update button in the toolbar when there is one. Update & Relaunch downloads it, swaps the app and opens it again.
  • New Settings ▸ General shows the installed version and a Check for Updates button that always answers.
  • Improved An update is installed only when the download matches the published checksum and carries the same developer's signature. If anything fails, the old app stays and the reason is shown.
  • Improved Small icon buttons, such as add row, export, chart, the log and a tab's ✕, have a full-size click area and a hover highlight.

0.0.1

· 35 MB

The first release

  • New Nine engines in one app: PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, MongoDB, Redis, DuckDB and ClickHouse, plus CSV, TSV, Parquet and JSON files opened as tables. Tiles for Supabase, Neon, CockroachDB, TimescaleDB, YugabyteDB, Valkey and ClickHouse Cloud fill in the port and SSL mode.
  • New A SQL editor with completion, a formatter, Explain and Watch, along with saved queries, tabs and the ⌘K command palette.
  • New A results grid you edit in place, joins included, with the exact SQL shown for review before it runs. Around it: an inspector, paging, charts, export as CSV, JSON or SQL inserts, and CSV import.
  • New Designers for tables, triggers, events, sequences, types and synonyms, for PostgreSQL's server objects and for SQL Server's partition functions and schemes. Users & Roles, a schema diagram, and tables copied from one engine to another.
  • New An AI assistant that reads your schema and runs read-only queries, on your own key for Claude, OpenAI, Gemini, Grok, DeepSeek or Mistral.
  • New SSH tunnels, SOCKS5 and HTTP proxies, connection strings, folders and colors, passwords in the Keychain behind Touch ID, export and import of connections, a console tab for each engine, and twelve languages.