I also use Postico for Postgres https://eggerapps.at/postico/ the UI there is nice as well. It’s the closest I could find to Sequel Pro.
# Mysql Only:
- Sequel Pro (Free, Pretty, Mac only. Has issues with MySQL v8)
- Workbench - https://www.mysql.com/products/workbench (Free, Pretty)
- DBForge - https://www.devart.com/dbforge/mysql/studio/editions.html (Freemium)
- Querious - https://www.araelium.com/querious ($50 one time, Mac only)
- Sequel Ace - https://github.com/Sequel-Ace/Sequel-Ace (Free)
# Postgres Only:
- Postico ($40, Pretty, Mac only)
- PgAdmin - https://www.pgadmin.org (Free, Clunky)
# SQL Server:
- Azure Data Studio - https://docs.microsoft.com/en-us/sql/azure-data-studio (Free, Pretty)
# Multi DB:
- DataGrip ($89 first year, $71 second year, $53/year after that, Clunky, Powerful)
- TablePlus ($50, Pretty, Useful)
- DBeaver (Free version, Clunky, Powerful)
- Heidi (Free, Clunky, Usable)
- SQuirrel (Free, Clunky, Usable)
- http://sequeljoe.ohwg.net (Free, beta)
- Valentina Studio - https://www.valentina-db.com/en/valentina-studio-overview (Freemium, Pretty)
- Aqua Studio - https://www.aquafold.com ($500, Clunky)
- Navicat Premium ($599, Pretty, has good reputation)
- POPSql - https://popsql.com (free for 2 saved DB connections,12/Mo., Pretty)
- Beekeeper Studio (Free, Electron)
- DBGate (Free, Electron)
- VSCode Extensions (Free, Electron)
EDITED based on other comments
If I was getting new, I would definitely check out popsql, tableplus, and datagrip first.
If I was looking for something new right now, I'd try DataGrip first. I'm a huge fan of Jetbrains' products so I'd be happy to pay them for another useful tool.
Just my 2c. I'm sure others have different experiences/likes/dislikes
I am in no way affiliated with the product or it's creators, but have seen many SQL clients and can recommend it.
TablePlus got good enough with its interface, though there are still some parts still feeling unintuitive like ordering of columns through numbering instead of drag/drop style but it's the best of workable solutions. (DataGrip is too heavy)
After many years Sequel Pro (MySQL only) started having problems so I tried every tool in this class for macOS and ended up standardizing on TablePlus.
It supports most common DBMSs, works on Mac and Windows, and apparently has a Linux alpha.
I still prefer Sequel Pro’s UI but TablePlus is ok. No critical bugs although import of massive or complex MySQL dumps still works more reliably on the official CLI client.