Fixed - Opening a very large .sql file no longer freezes the app. A 110 MB script now opens in a few seconds instead of locking up, and reopening it after a crash is fast too. - Scripts with hundreds of statements no longer leave the app unresponsive while the results come in, and the result messages keep up with long scripts. - Right-clicking in the Messages pane after closing a tab could freeze the app for good. Fixed. - Data > Filter > Result set no longer hangs when the first statement returned no rows. - Favorites > "Add current query as favorite" works on a tab that is not connected, instead of hanging. - Importing connections from a large file no longer hangs; the file is read in the background with a progress message. - Formatting a very large query no longer hangs the app. - MySQL / MariaDB: connecting to a server that requires secure transport shows the real TLS error instead of "insecure transport" (#3159), and the Enforce SSL setting is honoured. - MySQL / MariaDB: new "Verify server host name" option for TLS connections made through a DNS alias or IP address. - Exports to CSV, JSON and XML write SQL Server date columns as dates, without a time and time zone. - SQL Server: scripting a procedure or function with no database selected no longer crashes. - SQL Server: Microsoft Entra ID sign-in works for login domains the directory does not recognise. - Fixed a crash when drawing the line numbers after pasting over a selection or undoing. - Fixed two crashes when removing a tree entry and when a results grid shrinks. - Fixed the app being quit by its own hang detector while a dialog was open or while it sat idle in the background. Changed - The Messages pane's right-click menu no longer offers the editor's commands. - The database dropdown in the MySQL, MongoDB and Snowflake connection editors no longer shows a double arrow.

- SQL Server: sign in with Microsoft Entra ID (MFA) - SQL Server: queries retry automatically after an Azure idle disconnect, plus Azure Synapse dedicated SQL pool support - SQL Server: fixed exports damaging non-Latin1 text, duplicated tables losing their triggers and data, and PERSISTED being dropped from computed columns - MySQL / MariaDB: redesigned connection editor with inline SSL/TLS settings, and connections are tested before saving - Results grid: new selection summary showing count, sum, average, min, max, median and mode (toggle with the sigma button) - Results grid: "Select column" in the header menu (or Cmd-click a header), a choice of copy separator and header format, and "Copy nulls as blank string" - Results grid: dividers between stacked result sets now stay where you drag them - Sidebar: text size preference, a new icon set, Delete to drop and Return to rename - Sidebar search: limit results by object type, and matched tables can be expanded again - SQLite: add, edit and remove CHECK constraints in the table designer, plus an "All rows" option on the Data tab - SQLite: fixed table renames failing partway, and TEXT columns now read as text - Oracle: stored procedure menus with an INVALID badge and a Compile action; fixed new connections failing with ORA-12514 - MongoDB: fixed a crash when editing a document - Connections list no longer probes every saved server on each refresh, which could trigger MySQL's max_connect_errors - Restoring a purchase now unlocks the app immediately, and renewed subscriptions no longer show as expired - Fixed autocomplete missing bare column names, plus layout and spelling fixes across many dialogs

- Snowflake: SSO sessions auto re-authenticate, concurrent logins share one session instead of a browser popup each - MySQL: export window no longer comes up empty; view/FK ordering fixed - SQLite: Data tab pages large tables instead of loading everything - Oracle: no longer forces UTF8, so non-UTF8 databases decode correctly - Query history: delete individual entries or clear all; credentials excluded from recording - Postgres/Redshift, MSSQL: several crash fixes - Query formatting preferences gained a live preview - Stability: crash fixes across SQLite columns, trigger renames, grid backtab, window restore, query cancel

+ Fixed a crash users on older macOS versions were seeing when connecting to postgres databases.

This release focuses on reliability and refinements: - Improved licensing and activation handling - Performance and stability improvements - Various bug fixes If your purchase isn't detected, tap "Restore Purchase" to reactivate it. Thanks for using SQLPro! If you're enjoying the app, a rating or review is always appreciated.

+ Fixed an issue with favourites not always loading properly. + Fixed issue with redshift connections. + Fixed redshift drop materialized view created invalid sql. + Fixed separate stored procedures for redshift connection

- Window & Session behavior preferences redesigned. Separate controls for "save state and restore on next launch" vs. "clean shutdown", and independent prompts for "on tab close" and "on window/app close". Save-state users no longer see a misleading "unsaved changes will be lost" warning, and clean-shutdown users can opt out of the prompt entirely. File-backed query tabs are now always autosaved using macOS-native autosave. - Cmd+Q now correctly dismisses the connection picker and quits the app cleanly. Previously the modal sheet consumed the shortcut and required clicking Cancel first. - Tab dirty-state tracking moved to a model flag, so the unsaved indicator no longer flickers between titles. - Database tree state restore on connections with very large schemas is dramatically faster. - Fixed a hang when opening very large SQL files. The editor's scroller workaround used to force full-document layout and could trip the watchdog on multi-MB files. - Fixed a crash when "Copy as SQL update" was triggered on certain result sets (column metadata is now fetched off the main thread). - Fixed a crash when expanding an Oracle table whose parent entry had no schema component. - Fixed alias-aware syntax highlighting after restoring a query from History (and inside the History preview). - Fixed a SQLite crash on the auto-refresh path that could fire when external processes (Python, etc.) were inserting data into the database while the app had it open.

Query Formatter: - Celko-style "river" alignment for cleaner left-aligned keyword columns. - Break JOIN...ON onto its own line. - Expand BETWEEN...AND onto a deeper indent. - Expand long IN(...) lists onto separate lines. - Configurable max line width, blank lines between statements, and space after commas. - Nested CASE statements break onto their own line. - All formatter layout and spacing options exposed in Query Formatting preferences. - Fixed incorrect spacing around the || concatenation operator. Query Editor: - Cmd+C now copies the entire line when no text is selected. - Configurable "Select top" limit. Database Tree: - Added Duplicate Database with an optional "Include data" mode. - Added custom per-connection icons with iCloud sync and an in-app crop editor. - Added "Show in Finder" for favorites. - Every connection-list context menu item now has an SF Symbol. - Tree icons dim when the host window isn't main. - Fixed disclosure triangles requiring a double-click on recent macOS. Favorites: - Modernized designer window: larger, cleaner, SF Symbol +/- controls, autocomplete wired to the query field. - Added token support when running a favorite. Performance & Stability: - Post-connect autocomplete initialization moved off the main thread -- windows open faster. - Tokenizer now handles backslashes inside strings per dialect. - Hardened error and array handling across connectors. - Fixed a crash when exporting to CSV. - Fixed a crash during CSV import. - Improved CSV import handling for non-numeric strings in numeric columns. - Fixed an issue where editing multiple rows could generate incorrect UPDATE queries. - Fixed a rare crash related to key-repeat. - macOS 26 compatibility updates.

MongoDb: - Improved reliability and performance - New visual filter builder: build MongoDB queries with a point-and-click interface instead of writing JSON by hand (column picker, 16 operators including contains, regex, exists, null checks, with AND/OR logic) - New visual sort editor: add/remove sort fields with column picker and ASC/DESC toggle - New projection editor: checkbox grid to include/exclude fields with Select All/None General: - Fixed a crash that could occur when exporting to CSV - Fixed SQL Formatter incorrectly adding spaces to the || (concatenation) operator - Improved CSV import handling for non-numeric strings in numeric columns - Fixed an issue where editing multiple rows could generate incorrect UPDATE queries due to stale column state - Fixed duplicate database dialog now includes an "Include data" option - Added Duplicate Database context menu for MSSQL, MySQL, and Postgres - Fixed database tree disclosure triangles requiring double-click on modern macOS

+ Fixed an issue when export Postgres tables. [https://github.com/hankinsoft/SQLPro/issues/1103](#1103) + Updated connection window UI to better suit macOS 26.

+ Improvements with macOS 26.

+ Fixed an issue where formatting queries would result in pipe concatenations having extra spaces. [#1093](https://github.com/hankinsoft/SQLPro/issues/1093)

+ macOS 26 improvements. + Added an option to specify batch size when importing. [#1098](https://github.com/hankinsoft/SQLPro/issues/1098)

+ Additional improvements for macOS 26. + Cmd+C now copies entire line when no text selected. [#1085](https://github.com/hankinsoft/SQLPro/issues/1085)

+ Fixed an issue with searching when using MSSQL connections.

+ Improvement to 'Run current query'. [#1057](https://github.com/hankinsoft/SQLPro/issues/1057) + Improvement to MySQL comments. [#1055](https://github.com/hankinsoft/SQLPro/issues/1055) + Improvements to scripts Postgres tables with multiple primary keys. [#1056](https://github.com/hankinsoft/SQLPro/issues/1056) + Fixed a crash some users could see when importing csv files.

+ Fixed an issue with formatting queries.

+ Fixed a crash some users were seeing at startup.

+ Fixed a crash users could see when deleting records.

+ Fixed an issue where copy as markdown and copy as formatted text monospaced could have empty fields. [#1020](https://github.com/hankinsoft/SQLPro/issues/1020) + Added an export keyboard shortcut for 'execute secondary query style'. [#1017](https://github.com/hankinsoft/SQLPro/issues/1017)

+ Fixed an issue with column sizing.

+ Added options for autosize columns. [#966](https://github.com/hankinsoft/SQLPro/issues/966) + Fixed an issue with SSH tunnels. [#989](https://github.com/hankinsoft/SQLPro/issues/989)

+ Removed some un-used files. [#985](https://github.com/hankinsoft/SQLPro/issues/985)

+ Fixed an issue where when modifying results inline, after applying or discarding changes there woulds still be a partial visible changes UI. + Fixed an issue that could cause crashes for some users when viewing preferences.

+ Fixed a crash that could occur when modifying MySQL table structures.