We are using DataGrip and DBeaver to develop any non trivial SQL and investigations.

Metabase we use for building dashboards, and we taught non technical people to use it so they can answer ~70% of questions they have about the data themselves.

If you use DataGrip, make sure you try out the new (to me as an IDEA user, anyway) "Show output results in editor" function.

It's disabled in IDEA by default, so go switch it on and try it.

It's my most recent example of a feature I didn't even know I wanted and now can't imagine not having.

I've been using Mode Analytics for almost 5 years, and use Metabase or Redash for self hosted solution.

As an added question does any of those free systems support crossfiltering or drill down? Tested them and they seem severely lacking in basic 2020 features their big costly brothers got years years ago.

How does this work?

Of the commercial options, I used to use Navicat. Then moved on to DataGrip by Jetbrains.

Of the open/free options, I like DBeaver.

Curious - why DBeaver?

Not the GP, but while the UI leaves something to be desired (it’s Eclipse-based), I’ve found it’s a very productive tool once you figure things out. ER diagrams, graphical ways to update data, extensive ways to export/import data, DB metrics dashboards, lots of useful tools and features.