This is a selection of the most notable changes in each version, not the complete release notes. Each version also includes many smaller improvements and fixes that aren't listed here.
Querious 5.0
October 1, 2026
94
new features
6
improvements
30
fixes
PostgreSQL Support
A native, full-featured PostgreSQL client: tables, views, functions, import and export, pg_dump and pg_restore, and server views for activity, locks, statements, replication, and more.
-
PostgreSQL
Tables: content, columns, indexes, keys, constraints, sequences, and triggers.
-
PostgreSQL
Views and Materialized Views, and Functions and Procedures.
-
PostgreSQL
Import and export of CSV, Tab, JSON (export only), and SQL.
-
PostgreSQL
pg_dump and pg_restore: dedicated views with really great interfaces.
-
PostgreSQL
Server Activity: view and kill running processes.
-
PostgreSQL
Server Locks: monitor every open lock on the server.
-
PostgreSQL
Server Statements: find costly queries to optimize.
-
PostgreSQL
Server Replication: confirm replicas are keeping up.
-
PostgreSQL
Server Index Usage: discover better indexing opportunities.
-
PostgreSQL
Server Status: overall health and status.
-
PostgreSQL
Server Users/Roles (view and edit), Variables (configure server settings), and Extensions (view, install, and uninstall).
-
PostgreSQL
Schema Diagnostics, Schema Types (view custom types), and Schema Sequences.
-
PostgreSQL
Connect over TCP/IP or a Unix socket, with SSL or an SSH tunnel.
-
PostgreSQL
Note that currently Duplicate and Compare are not supported for PostgreSQL.
Query Assistant
An AI chat in the Query view that writes, explains, and rewrites SQL from a description. It never runs anything and never sees your data, and it stays off until you turn it on.
-
New
Describe a query and get SQL. It writes queries, explains queries you paste in, rewrites them, and writes DDL.
-
New
It generates queries only. It never executes anything and never has access to the data in your tables.
-
New
Opt-in schema context. With "Provide Schema Definitions" on, the assistant can look up your table and column names and
CREATE statements.
-
New
Off by default. Choose Fast or Standard reasoning complexity.
-
New
Account-based sign-in. Register Querious with your Araelium Account, a license key, or an access key from a team leader. Using your account always applies your latest license, and enables the Query Assistant service. Team licenses let organizations hand out revokable access keys.
MySQL Server Views
New views for index usage, locks, query digest, and query analysis, plus refreshed InnoDB Status, Users, and Slow Queries views.
-
MySQL
Index Usage: discover better indexing opportunities.
-
MySQL
Locks: inspect blocked connections.
-
MySQL
Query Digest: find which query patterns cost the server the most time and I/O.
-
MySQL
Query Analyzer: analyze a single query's execution plan.
-
MySQL
InnoDB Status now has a structured layout and summary bar.
-
MySQL
Users overhauled, with a better layout, filtering, and better MySQL 8+ support.
-
MySQL
Slow Queries gained helpful tooltips.
-
MySQL
Server Access has a clear permission switch for letting Querious read local log files protected by elevated permissions, using the new Querious Privileged Helper tool.
Schema Structure Views
Diagnostics that find structural problems, index usage across a whole schema, and a new Schema Info view.
-
New
Schema Diagnostics: scan your schema to find structural problems that tend to cause trouble later.
-
New
Schema Index Usage: discover better indexing opportunities in a schema.
-
New
Schema Info: a new view showing data usage, numbers of objects, and schema settings.
Database Relationship View
Rebuilt with three layouts, draggable tables whose positions are saved, a minimap, and foreign keys that attach to the exact fields.
-
New
Three all-new layouts for arranging tables, with customizable spacing.
-
New
Drag and reposition tables. Your custom positions are saved. Rubberband selection moves several tables at once.
-
New
A new interactive minimap helps you stay oriented in a large graph.
-
New
Zoom by scrolling while holding Option. Pan by scrolling as before, or Command-drag.
-
New
Foreign key edges connect directly to the PK/FK fields, with visual tweaks for clarity.
Table Content View
A Relationships sidebar for jumping between related rows, a resizable vertical editor, unloaded columns, MySQL UUID display, and smoother scrolling.
-
New
Relationships sidebar. Shows tables related through PK/FK links, directly or as ancestors, for very fast jumping between them. Select an Order row and jump to that order's Account or LineItems.
-
New
The vertical form editor has resizable columns (remembered per table), and a quick "Go to Column…" button.
-
New
Leave JSON columns unloaded by default, or mark specific columns as Unloaded if you never care about their values.
-
MySQL
MySQL UUID support: interpret
binary(16) as a UUID and display it as a UUID string.
-
New
Much smoother scrolling in large lists, an option to show row numbers, and improved conditional row highlighting.
Structure View
Filter and sort columns, see keys at a glance, edit enum and set values in a proper list editor, and review changes with colored rows and Apply and Revert buttons.
-
New
Table Columns can be filtered by name and sorted by name or the table's natural order.
-
New
Columns show which are PK/FK, and clicking jumps to the related key.
-
New
A new value list editor for enums and sets, with Cut/Copy/Paste, drag reordering, and multi-line paste.
-
MySQL
Specify MySQL column default values as an SQL expression.
-
New
Added, removed, and modified columns are colored across the whole row, and the details area is resizable.
-
New
Modified indexes and foreign keys are highlighted and show Apply and Revert buttons.
-
New
New, better-organized layouts for Table Info and for Function and Procedure structure.
Import, Export & Duplicate
Copy and export as JSON, a smarter CSV/Tab import with date and number conversion, faster imports, better-ordered SQL exports, and larger progress windows.
-
New
JSON. Copy rows to the clipboard as JSON, and export table contents to JSON as an object array, values array, or table object, compact or pretty-printed.
-
New
CSV/Tab import "Values" view. Convert date formats (ISO, RFC, SQL, Unix timestamp, or custom) and number formats (dot or comma decimals), use SQL expressions as values, and choose how empty values are handled.
-
New
New import options to disable foreign keys (when INSERTs are in the wrong dependency order) and disable unique checks (to speed up imports). New tables created during import can choose from the types the server supports.
-
New
SQL export statements are better ordered by dependency, and MySQL exports release the global read lock after creating an InnoDB snapshot so other connections can keep writing.
-
New
SQL import no longer wraps the file in a transaction. Transactions are left entirely to the SQL file.
-
New
The progress and error windows are larger, more readable, and resizable. Double-click an operation to reveal the file in Finder.
Appearance & General
A refreshed macOS interface, many more ways to customize it, passwords synced through iCloud Keychain, and faster tab loading.
-
New
Requires macOS 13.2 or later.
-
New
Refreshed interface matching current macOS conventions: new window toolbar and sidebar appearances, new control sizing and spacing, and a native right-side inspector sidebar in several views.
-
New
Preferences are organized into groups, and there's an all-new update checker that can show previous versions and multiple newer versions.
-
New
Appearance customization: tint the titlebar with the connection color, choose what each connection tab displays, change control sizes and list font sizes app-wide, and pick Compact, Regular, or new Large result row spacing.
-
New
Saved passwords are stored as synchronizable Keychain items, so they're available in iCloud Keychain as well.
-
New
Previous/Next Editor now defaults to Cmd-Shift-comma/period for quick keyboard navigation between subviews.
-
New
Faster tab loading and view switching.
Removed
Artificial Foreign Keys and the Schema / Structure / SQL Structure view are gone.
-
New
Artificial Foreign Keys were removed. They were designed for MyISAM tables, which have no real foreign keys, and nearly all production databases now use InnoDB. Removing them makes features that rely on real foreign keys much easier to build.
-
New
The Schema / Structure / SQL Structure view was removed as redundant. Use File → Export instead.
4.2.1 – 4.2.5
5 updates — 2 new features, 10 improvements, 9 fixes
May 28, 2025 – Oct 5, 2026
Querious 4.2
May 20, 2025
17
new features
3
improvements
15
fixes
Queries View
Saved and Recent Queries now belong to each server, with a Shared section for the rest, and the vertical editor comes to the Query view.
-
New
Saved and Recent Queries are kept per server. You only see the queries for the server you're connected to. Your earlier saved queries moved into a new Shared section, whose queries are available on every server.
-
New
A vertical editor for viewing and editing values in the Query view, just like Table Content.
-
New
Editor menu items to go to the Previous and Next query, and to open the Select Database popover.
Table Content
Paste CSV, Tab, or SQL straight into a table, keep your column order, and jump to related rows with a shortcut.
-
New
Paste CSV, Tab, or SQL text directly into the Table Content view without importing from a file.
-
New
The view remembers the order of columns if you move them. This is also available in Table View Options.
-
New
Filtering in the search locations popup highlights the first matching field name for convenience.
-
New
4.2.2
Command-Control-R shows "Show Related Rows", now a visible list of tables instead of a popup.
-
Improved
4.2.2
Clicking the (x) in the WHERE field turns the search back into Show All.
Key Bindings and Editing
More key bindings, Tab and Shift-Tab indenting, and clearer reporting of conflicts.
-
New
New key bindings for Focus on Sidebar Filter, Previous Query, Next Query, and Select Database.
-
New
Tab and Shift-Tab indent and outdent the selected text.
-
New
Key binding conflicts are displayed more accurately.
Other Additions
Duplicate several columns at once, sort saved connections, safer duplication of schema objects, a clearer import panel, and reinstalling older builds.
-
New
Multiple columns can be duplicated at once in the Table Columns editor.
-
New
A contextual menu item in the Saved Connections sidebar sorts the selection alphabetically.
-
New
Duplicating a schema object now confirms before it overwrites an existing object.
-
New
4.2.2
The Import panel has a third stage with a bigger, more distinct Options section, so it's easier to see INSERT vs UPDATE and whether TRUNCATE is on.
-
New
4.2.4
The updates window can display every past build, so Querious can reinstall an older version.
Speed and Refinements
A much faster sidebar for databases with tens of thousands of tables, and smoother handling of dropped connections.
-
Improved
Significant optimization of the primary sidebar when a database has tens of thousands of tables.
-
Improved
The Table Reference toggle moved up next to the Selected Database and Run Query button.
-
Improved
View syntax in the View Structure view is no longer formatted by default.
-
Improved
4.2.1
Avoids two cases of a spinning cursor and brief freeze when the connection to the server is silently lost.
4.1.1 – 4.1.3
3 updates — 8 new features, 12 fixes
January 2, 2025 – January 17, 2025
Querious 4.1
January 1, 2025
13
new features
2
improvements
1
fix
Connections
An Exclusive database option for big servers, server-wide reindexing, a per-database refresh, and more SSH key types.
-
New
"Exclusive" database option. No other databases will show as existing or be used, which makes connections to servers with very many databases more efficient.
-
New
An option to reindex the entire server immediately.
-
New
A Refresh Database menu item refreshes only the selected database, not the entire server.
-
Improved
Server Access supports
sk-ecdsa-sha2-nistp256 and sk-ssh-ed25519 keys, and newer Diffie-Hellman key exchanges.
Query View
A friendlier Table Reference sidebar and customizable Format and Minify shortcuts.
-
New
A more usable Table Reference sidebar: fuzzy-filterable database and table popups, a filter field, tables and fields you can drag and drop as text, and double-click insertion that adds a comma when appropriate.
-
New
4.1.3
Format and Minify have customizable key bindings.
Import, Export, and More
A bigger import/export progress panel, copy and paste for highlights, and an updates window that shows every newer version.
-
New
The import/export progress panel is larger and more readable, and export progress shows the exported file size when finished.
-
New
An action menu in Conditional Highlighting copies and pastes highlights between tables.
-
New
4.1.3
The updates window shows all newer versions, with their release notes, which require a renewal or upgrade, and a choice of which one to install.
-
New
4.1.3
The field value panel can use the Find Panel when shown modally.
4.0.1 – 4.0.15
15 updates — 10 new features, 41 improvements, 69 fixes
June 20, 2023 – October 31, 2024
Querious 4.0
June 11, 2023
Appearance and Preferences
A refreshed look, an all-new Preferences window, and customizable key bindings.
-
New
Refreshed interface matching current macOS conventions: new window toolbar and sidebar appearance, with many little refinements.
-
New
An all-new Preferences window with settings organized for easier discovery.
-
New
Customizable key bindings for menu items in the menu bar. Key binding sets can be moved between devices.
-
New
New preferences for sidebar icon and row sizes, light and dark mode behavior, and hiding the internal MySQL databases.
-
New
Previous/Next Editor menu items switch between subviews like Columns, Keys, and Info, and between query tabs.
Table Content
Conditional Highlighting, per-condition toggles, column-aware copying, much faster multi-row edits, and more.
-
New
Conditional Highlighting colors a field, or an entire row, based on the values of the data.
-
New
Each search condition has a checkbox to temporarily disable it, and the search popup fuzzy-filters fields.
-
New
Choose which columns will be copied when copying rows, and a new Copy Value menu item.
-
New
Much faster setting of one column's value across many selected rows.
-
New
A Row Spacing preference for Compact or Expanded result lists.
-
New
The JSON field value panel can use single-line or multiline formatting.
-
New
4.0.10
IN and NOT IN search operators.
-
New
4.0.7
Jump to Column is available when right-clicking row lists, and flashes the column it jumps to.
-
New
4.0.14
Preferences for the default row sort order and for remembering sorting between launches.
-
New
4.0.14
The Field Value panel remembers its size and saves with Command-S.
Query View
Much smarter, fully asynchronous autocomplete, a fuzzy database selector, and better searching of saved queries.
-
New
Much smarter context-sensitive autocomplete, fully asynchronous so it never slows your typing, with fuzzy completion.
-
New
A new autocomplete window shows more information such as routine parameters and return types, with a preference to turn it off inside comments.
-
New
A fuzzy-filterable Select Database popup.
-
New
The result list shows how many queries remain to be executed.
-
New
Sidebar filtering searches inside the queries themselves, and recent queries use a longer part of the query as their name.
-
New
Option-Arrow text navigation stops at more logical boundaries between SQL syntax elements.
-
Improved
4.0.6
The Table Reference sidebar also shows views.
-
Improved
4.0.5
Better formatting for joins, such as LEFT OUTER JOIN.
Structure View
Change character sets and collations in bulk, with an improved index editor and routine layout.
-
New
Change the character set and collation of multiple columns at once, or switch them to the table default.
-
New
Changing a table's collation lets you change only its default, or also convert all existing fields.
-
New
The index columns popover has syntax coloring and autocomplete for column names.
-
New
A new Routine Structure layout makes parameters much easier to show and edit, and the Procedure Content view has more room for parameters.
-
New
4.0.10
The Enum/Set value editor lets you set the values as an SQL value list.
Database Comparison and Relationships
Saved comparison presets and an all-new relationship view focused on keys.
-
New
Save and reload comparison presets, so repeating a comparison between development and production is fast.
-
New
A Swap button swaps the Target and Reference, and Compare Database… preselects the chosen database.
-
New
An all-new Database Relationship view that defaults to showing only tables with primary/foreign-key relationships and only their key fields.
-
New
Double-click a table to focus on the tables directly related to it. A contextual "Go to…" menu jumps to that table's content.
SQLite
Experimental SQLite support, so Querious can open and work with SQLite databases.
-
New
Experimental SQLite support: open and work with SQLite databases, with SQL documents that can switch between the MySQL and SQLite variants.
-
New
4.0.7
Create a new SQLite file from the File menu.
Import, Export, and Connections
SQL_MODE options for exports, opening many objects at once, passwords from an external command, and slow-query timestamps.
-
New
An option to preserve the SQL_MODE in exported CREATE statements for triggers, routines, and events.
-
New
Right-click a selection of several schema objects in the sidebar to open them in new tabs or windows, plus a Copy Name menu item.
-
New
4.0.7
Supply a MySQL password from an external command or script, useful for time-limited passwords from services such as AWS IAM.
-
New
4.0.10
Slow Queries show timestamps and sort by them, and local Slow Queries and Error logs can be chosen with the standard Open panel.
-
Improved
4.0.14
Importing CSV/Tab with UPDATE statements supports "Use Default Value for empty values" as INSERT does.
Stability
Fixes for the large majority of crashes, and for invalid UTF-8 from older MySQL servers.
-
Improved
4.0.13
Stability improvements that fix over 85% of all crashes that occurred in Querious.
-
Improved
4.0.13
Works around invalid UTF-8 sequences stored by older MySQL versions, which could otherwise force Querious to quit.
-
Improved
4.0.13
More efficient sharing of server connections between tabs, reducing total connections and memory use.