Always improving

Querious keeps getting better

Querious has been updated again and again since it was first released, with new features, new views, and a steady stream of refinements. Here's what the latest versions bring.

27 updates since June 2023

Renewing gets you the latest version and another year of updates. It isn't a subscription, and you can keep using the version you already have either way.

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
Full Release Notes

Summary of Changes:

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

Summary of Changes:

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

Summary of Changes:

Primary Sidebar Filter databases and tables, group them automatically by name prefix, and expand whole branches with a click.
  • New A Filter field to search for databases and tables.
  • New Automatic grouping of databases and tables by similar name prefixes, using underscores or camel case. It can instantly organize servers with very many tables.
  • New 4.1.3 Items you expanded stay expanded while the filter changes.
  • New 4.1.3 Command-click a disclosure triangle to expand all of its siblings, and add Option to expand their descendants too.
  • New 4.1.3 A Total Size column in the database content table list.
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
42 new features
8 fixes

Summary of Changes:

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.

Want all of this?

Renew in your account