Aside from that, it's usually just been a mix of using specialized tools like MySQL Workbench, SQL Developer, pgAdmin and others, or something that tries to do it all like DataGrip.
Didn't actually find anything particularly amazing about DataGrip, but if I'm paying for the JetBrains Ultimate subscription, might as well use it because it's pretty okay.
DBVisualizer: https://www.dbvis.com/ (for exploring the schema)
Jailer: https://wisser.github.io/Jailer/ (for data browsing)
Aside from that, it's usually just been a mix of using specialized tools like MySQL Workbench, SQL Developer, pgAdmin and others, or something that tries to do it all like DataGrip.
Didn't actually find anything particularly amazing about DataGrip, but if I'm paying for the JetBrains Ultimate subscription, might as well use it because it's pretty okay.