SQLPro Studio database client2026.271

SQLPro Studio is the premium database client and management tool for Postgres, MySQL, Microsoft SQL Server and Snowflake databases.

Some of the great features include:
+ Intellisense/SQL autocompletion.
+ Syntax highlighting with customizable themes (including dark).
+ Tabbed based interface for an optimal user experience (iPad).
+ Context aware database tree navigation, including quick access to tables, views, columns, indexes and much more!
+ NTLMv2 supported (but not required).
+ Netbios support.
+ SSH Tunnelling (password and private key authentication).
+ Microsoft Entra ID (Azure AD) sign-in, including MFA, for Azure SQL.

SQLPro Studio supports the following database servers:
+ MySQL & MariaDB
+ PostgreSQL
+ Microsoft SQL Server (2005 and above)
+ Snowflake

Privacy Policy:
https://hankinsoft.com/privacypolicy.html

Terms of Use:
https://hankinsoft.com/termsofuse.html

Price:
SQLPro requires a Premium upgrade in order to interact with database result sets. Premium is available as either a Lifetime Purchase or through a Subscription with Monthly and Yearly options. Subscriptions auto-renew within 24 hours of the expiration date unless auto-renewal is turned off in the iTunes account settings. Your Account will be charged for renewal (based on your selected plan) within 24-hours prior to the end of the current period. Any unused portion of a free trial period, if offered, will be forfeited when the user purchases a subscription to that publication, where applicable. Payment will be charged to your iTunes Account at confirmation of purchase.

Version History + General fixes 2026.271 Sep 29 • Database connections now stay open while you switch to another app, so temporary tables, session settings and open transactions are no longer lost.
• The database tree shows which database is selected and that it can be changed.
• Toolbar buttons use symbols, and the table designer uses the system tab bar.
• Fixes and refinements throughout, including groundwork for iPhone Duo. 2026.266 Sep 25 + General improvements 2026.261 Sep 19 + Improvements to tabs 2026.260 Sep 18 - SQL Server: sign in with Microsoft Entra ID (MFA)
- SQL Server: new Encryption setting, automatic retry after an Azure idle disconnect, and Azure Synapse dedicated SQL pool support
- Tabs now work on iPhone: browse open tabs as preview cards, switch between them, and going Back keeps the tab open
- Better support for foldables and rotation: the layout switches between phone and tablet styles without losing your queries or results
- New setting to ask before closing a connection with unsaved tabs (on by default on iPad)
- Results grid: new selection action bar, add rows to a table, and fixed a crash when sorting or resizing columns on iOS 26
- MySQL: redesigned connection editor with read-only mode, authentication method, timezone and timeout options
- Oracle: read-only connection option
- Snowflake: SSO sessions sign back in automatically when they expire, and NULLs and column types display correctly
- Fixed mongodb+srv:// and other DNS SRV lookups
- Fixed query formatting indentation
- Enter a license key from the paywall or Settings. Restoring a purchase unlocks the app immediately, and renewed subscriptions no longer show as expired
- Crash fixes for SQL Server messages, Postgres "Copy as SQL update" and MongoDB document editing 2026.259 Sep 17 Updates and improvements. 2026.180 Jul 7 - Fixed an issue where Setapp activation was not always working.
- Snowflake: Login improvements, including additional login methods.
- MySQL: connecting to servers that do not use SSL now works again in the Disabled and Prefer SSL modes (fixes a case where the connection failed even though the server was reachable).
- Postgres: fixed a crash that could happen when connecting to certain hosts.
- Tables, schemas and objects that contain a dot in their name (for example a schema named "first.second") now resolve correctly in the database tree and in queries.
- Fixed several freezes/hangs at launch and while editing large queries.
- General crash and stability fixes. 2026.170 Jun 15 + Fixed an issue that could cause the app to lockup when opening some sqlite files. 2026.160 Jun 4 - Opening a SQLite file no longer freezes the UI while the schema is read, especially on large or iCloud-backed databases.
- Autocomplete: debounce on keystroke updates, plus O(1) allowed-tables lookup per entry. Large schemas no longer slow typing in the query editor.
- Connection-pool teardown no longer blocks the UI while a remote database closes its socket. Disconnect and tab-close return immediately even when the database is unreachable.
- Result-set sort treats signed numeric strings as NSDecimalNumber so "-100" sorts below "-50" instead of the other way around.
- Fixed a crash when copying a geometry cell value.
- Moved some logic that should have been on a background thread, from a foreground thread to a background thread. 2026.153 Jun 3 - Faster, more responsive query editor when typing. Autocomplete is now much quicker on large schemas and no longer stutters while you type at speed.
- Performance improvements while typing in the query editor.
- Fixed a crash when editing rows in a table with GIS geometry columns.
- MySQL: New per-connection option: "Use FOUND_ROWS". Available in the edit-connection screen under Advanced -> Row counts. 2026.104 May 13 + General performance and stability improvements. 2026.99 May 11 + Fixed a crash when loading larger files. 2096.97 May 7 - Sort order for negative numbers ([#1131](https://github.com/hankinsoft/SQLPro/issues/1131)). Sorting a column of numeric values now orders negative numbers correctly. Previously a column containing both positive and negative values could end up out of order when the database returned numeric values as strings (most commonly with Oracle).
- iPad schema sidebar crash. Fixed a table-view crash when removing the last table from a database in the schema sidebar.
- Large-cell tooltips. Faster scrolling and pointer-driven tooltips on result grids that contain very large string values (multi-megabyte JSON / log columns no longer cause UI hitches).
- Open from Files / Share sheet. Opening a `.sql` file from the Files app or a Share-sheet provider no longer freezes the app on slow sources (iCloud Drive, Google Drive, OneDrive). The file is now read on a background thread with a *Loading…* placeholder in the destination tab.
- Oracle autocomplete crash. Fixed a crash that could occur when refreshing autocomplete on a connection that lists many schemas.
- Postgres autocomplete. Faster typing in long queries when the connection has a large keyword set. The autocomplete refresh that runs on every keystroke is now O(1) per keyword check instead of scanning the full reserved-word list. 2026.92 May 4 - Fixed a rare launch hang on memory-constrained devices when first loading the autocomplete favorites cache. 2026.90 Apr 30 - MongoDB support improved, including a visual Find Builder tab (collection, filter, sort, skip, limit) so you can explore collections without hand-writing JSON.
- Geometry / spatial viewer: preview POINT, LINESTRING, POLYGON, and other shape data right inside the result grid, with "Open in Maps" for point data.
- Custom connection icons: choose any image from your photo library, adjust it with a built-in crop editor, and sync icons across your devices via iCloud.
- Tab colour picker on every connection so each database has its own colour in your tab bar.
- Improvements to Auto-reconnect when the server drops the connection (idle timeouts, brief network blips, server restarts).
- Various crash fixes and stability improvements. 2026.83 Apr 22 + MongoDB improvements.
+ Geometry viewer. [#688](https://github.com/hankinsoft/SQLPro/issues/688) 2026.73 Apr 15 + Fixed an issue that could cause a crash when removing Oracle connections.
+ Fixed an issue that could cause a crash when exporting data.
+ Fixed an issue where adding a SQLite database could cause no action to occur. 2026.53 Apr 6 + Added Oracle support. 2026.29 Mar 16 + Improved support for iOS 26. 2026.10 Feb 19 + Fixed an issue where logs would sometimes not be visible.
+ Fixed an issue with the Setapp framework. 2025.58 09/30/2025 + Fixed an issue with line numbers. 2025.57 09/19/2025 General:
+ Improvements with line number displays for queries.

SQLite:
+ Fixed a crash some users could have when modifying sqlite databases.
+ Improvements to modifying sqlite table ddl.
+ Fixed an issue where scripting views would not always work. 2025.56 09/17/2025 + Fixed an issue that could cause a crash when editing SQLite DDL. 2025.55 09/12/2025 + Autocomplete can now be disabled. 2025.53 09/11/2025 + Fixed a crash that could occur when adding or editing a trigger.
+ Fixes some color issues. 2025.16 02/24/2025