If you have the license for it, it is hard to beat Datagrip from Jetbrains. Support for just about any database and also integrated support for AI/Copilot making it much easier to write exploratory queries.
I used Datagrip like 10 years ago and it was amazing, back then I used some pre-release evaluation thingy, loved it, was only working with mysql though.
last year i looked at it again, in a project where mongodb is used, it did not perform so well, sure the features where there, but still mongodb is document orientated so i had to come up with workarounds and so ... yeah back to cli unfortunately
but for any relational database, I'd rather use datagrip!
For simpler use-cases I've used both https://dataflare.app/ and https://tableplus.com/ with success. They are much quicker and lighter to start-up, browse some tables and run some queries.
Free versions are generous enough for daily use as well. For example for TablePlus "The free trial is limited to 2 opened tabs, 2 opened windows, 2 advanced filters (filters are not available on the free TablePlus Windows) at a time."
I suppose it has more advanced features than IntelliJ?
Because when I switched to MacOS I had to find a replacement for HeidiSQL and, to my surprise, I was able to do everything I wanted to directly from IntelliJ, which was already my main IDE.
last year i looked at it again, in a project where mongodb is used, it did not perform so well, sure the features where there, but still mongodb is document orientated so i had to come up with workarounds and so ... yeah back to cli unfortunately
but for any relational database, I'd rather use datagrip!