SQLPro Studio
SQL Database Client & GUI
Only for Mac
Free · In-App Purchases
New: sign in to Azure SQL with Microsoft Entra ID (Azure AD), including MFA. Connect with your work account, no SQL login needed.
SQLPro Studio is the premium database management tool for Postgres, MySQL, Microsoft SQL Server and Oracle 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.
+ Context aware database tree navigation, including quick access to tables, views, columns, indexes and much more!
+ SQL Beautifier/formatter.
+ Database wide searching.
+ NTLMv2 supported (but not required).
+ Netbios support.
+ Master password support for additional security.
+ Supports Handoff from iOS to macOS.
+ 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)
+ SnowflakeDB
+ SQLite
+ MongoDB
+ Oracle (11g and above)
Privacy Policy:
https://sqlprostudio.com/privacypolicy.html
Terms of Use:
https://sqlprostudio.com/termsofuse.html
Price:
SQLPro offers Premium subscriptions (or a single Lifetime purchase) in order to interact with database result sets. Premium subscriptions are available as either a Monthly, or a Yearly duration. Subscriptions auto-renew within 24 hours of the expiration date unless auto-renewal is turned off in the iTunes account settings. 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.
more Fixed
- Opening a SQLite file that is slow to load no longer freezes the app, including when a session is restored at launch.
- MySQL / MariaDB: reconnects and retries after "MySQL server has gone away".
- Copying date cells now copies them the way the grid shows them (#1179).
- Deleting result rows keeps pending changes and sorted grids correct.
- Microsoft Fabric: fixes SQL Server logins to Fabric warehouses.
- SQL Server: a failed connection no longer retries in a rapid burst.
- SQLite: closing a file that is not a SQLite database no longer reports a save error.
Changed
- Large result sets use far less memory, and exports stream to disk.
- Splitting long scripts into statements is faster.
2026.295 22 Oct
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.
2026.275 3 Oct
- 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
2026.259 16 Sept
- 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
2026.208 28 Jul
+ Fixed a crash users on older macOS versions were seeing when connecting to postgres databases.
2026.175 23 Jun
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.
2026.171 17 Jun
+ 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
2026.114 29 May
- 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.
2026.90 30 Apr
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.
2026.87 29 Apr
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
2026.50 27 Mar
+ Fixed an issue when export Postgres tables. [https://github.com/hankinsoft/SQLPro/issues/1103](#1103)
+ Updated connection window UI to better suit macOS 26.
2026.07 12 Feb
+ Improvements with macOS 26.
2026.05 28 Jan
+ Fixed an issue where formatting queries would result in pipe concatenations having extra spaces. [#1093](https://github.com/hankinsoft/SQLPro/issues/1093)
2026.03 9 Jan
+ macOS 26 improvements.
+ Added an option to specify batch size when importing. [#1098](https://github.com/hankinsoft/SQLPro/issues/1098)
2026.02 8 Jan
+ Additional improvements for macOS 26.
+ Cmd+C now copies entire line when no text selected. [#1085](https://github.com/hankinsoft/SQLPro/issues/1085)
2025.76 05/11/2025
+ Fixed an issue with searching when using MSSQL connections.
2025.71 10/10/2025
+ 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.
2025.57 24/09/2025
+ Fixed an issue with formatting queries.
2025.10 28/04/2025
+ Fixed a crash some users were seeing at startup.
2025.9 25/03/2025
+ Fixed a crash users could see when deleting records.
2025.7 19/03/2025
+ 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)
2025.01 11/01/2025
+ Fixed an issue with column sizing.
2024.60 23/07/2024
+ 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)
2024.38 25/06/2024
+ Removed some un-used files. [#985](https://github.com/hankinsoft/SQLPro/issues/985)
2024.32 03/06/2024
+ 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.
2024.31 29/05/2024
Fixed
- Opening a SQLite file that is slow to load no longer freezes the app, including when a session is restored at launch.
- MySQL / MariaDB: reconnects and retries after "MySQL server has gone away".
- Copying date cells now copies them the way the grid shows them (#1179).
- Deleting result rows keeps pending changes and sorted grids correct.
- Microsoft Fabric: fixes SQL Server logins to Fabric warehouses.
- SQL Server: a failed connection no longer retries in a rapid burst.
- SQLite: closing a file that is not a SQLite database no longer reports a save error.
Changed
- Large result sets use far less memory, and exports stream to disk.
- Splitting long scripts into statements is faster.
more Version 2026.295 22 Oct
Data Not Linked to You The following data may be collected but it is not linked to your identity: