

The selection aggregates strip is the headline change in SQLPro Studio 2026.238. Highlight a column of numbers and the app gives you count, sum, average, minimum, maximum, median, and mode without writing a single function. It is the kind of small addition that saves real time when you are poking around a table and just want a quick sense of the data. Here is what else you get in the current version:
- Native macOS client for SQL servers — no Java required, runs on macOS 13.5 or later.
- Query and manage multiple database types from one window, including Heroku, Amazon RDS, and Microsoft Azure.
- Syntax highlighting with customizable themes, plus autocomplete for SQL statements.
- Update table contents and compare query results side by side.
- NTLMv2 support for networks that still need it.
The core workflow has not changed, and that is a good thing. You still get the same direct handling of views, saved queries, and data retrieval that made SQLPro Studio a dependable choice for people who work with databases every day. The new aggregates strip simply removes a little friction from the everyday chore of sizing up a result set.
180 MB idle, even with three tabs open
I have been running SQLPro Studio across a handful of PostgreSQL and SQLite databases this week, and the app stays lean. On an M1 Mac it idles around 180 MB of RAM with three tabs open; hammer it with a poorly-indexed join returning sixty thousand rows and memory climbs maybe another hundred megs before settling back down. Queries cancel cleanly — no beachball, no force-quit dance. The native build shows its teeth here: tab switching is instant, scrolling through results is smooth, and I have not seen a crash since the update. If you are searching for a SQLPro Studio crack Mac, the real thing runs quiet and stable enough to forget it is open.
Quick task: clean up a mailing list
Here is a real workflow from this morning. I had a customer table with duplicate email addresses and a last-login column that was half NULL. In under five minutes I did this:
- Opened the PostgreSQL connection and selected the
customerstable. - Ran a simple
SELECT email, COUNT(*)query grouped by email, then highlighted the count column and glanced at the new aggregates strip — median count was 1, max was 7. - Wrote a
DELETEwith a CTE that kept the most recent login per email. Autocomplete filled in column names as I typed. - Compared the row counts before and after by holding the results in separate tabs.
No export, no spreadsheet, no switching tools. The whole thing felt like working at a well-organized prep station.
The current update adds one practical tool: a selection aggregates strip. Highlight a range of values in a result set and it shows count, sum, average, minimum, maximum, median, and mode.
- macOS 13.5 or later
- Apple Silicon or Intel 64-bit
Questions I actually get
Which database types can SQLPro Studio connect to?
SQLPro Studio lets you query and manage multiple SQL database types from a single app, including major cloud providers like Heroku, Amazon RDS, and Microsoft Azure.
Does SQLPro Studio require Java?
No. It is a native macOS application and does not require Java to run.
Notes from the tables 0
Sign in or pull up a chair to leave a note.
No notes on this one yet. They go up after I read them.