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.
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!
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."
Very emblematic of it's Java GUI roots.
And some tools dont...
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.
https://www.jetbrains.com/help/idea/database-tool-window.htm...