I’ve been dealing with Postgres and MySQL and some others on a regular basis, so finding a good GUI is like making a good friend for life. There’s so many tools out there but let me note down some points from my own experience about this tool TablePlus that I considered the best GUI for relational databases.
tl;dr: native build, supports multiple drivers, elegant UI, handy query editor, secure connection, multi-tabs/windows, code review, active development
First, if you’re working with MySQL only, Sequel Pro might be good enough for you. But if you’re working with more than one? TablePlus supports a lot of relational databases such as MySQL, Postgres, SQL Server, SQLite, Microsoft SQL Server…
Second, some other tools like Dbeaver also support mulitple databases but for me, the design is so complicated. TablePlus has a nice UI (it has dark theme) and its query editor is really handy, really convenient.
Third, considering some bigger tools that are feature-rich like Navicat, I click open the app and need to go for a walk while it gets up and running. It too heavy and memory consuming. TablePlus, with a native build, can start in less than a second.
Some other notable points: connection encryption to keep database secured, multi-tabs/windows, code review, plugin system, active development and quick support.
It’s currently only available on Mac, GitHub repo here