Our great sponsors
-
beekeeper-studio
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
-
dbgate
Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
Beekeeper Studio studio is popular and modern GUI client. It offers only basic functionality (focused on writing SQL queries), but looks very nice and has very good basic workflow. The key design concept is that one opened window contains only tables and queries from one database. If you need to work with more databases simultaneously, you need to open more app windows. If has two editions - community and commercial. Community is free and open-source, paid commercial license offers a few additional features (eg. support for Oracle database). Beekeeper Studio is developed and maintained by Matthew Rathbone. But has also quite active contributor community on GitHub.
DbGate is the most feature rich client from this list. It uses multi-connection and multi-database in one window paradigm, with tabs labeled with asociated database. It has interesting data-navigating features, like master/detail and form views, and excel-like data editing. Also you could use features which you may know from classical clients, like query designer or ER diagram viwer. It is the only client from this list, which offers also web version (you could play with it in demo app). But if you need only to write simple SQL query into one database, you could use simpler solutions. Otherwise, when you don't like to write repeating simple queries, this tool is right choice for you. DbGate is developed by Jan Prochazka (author of this article).
Antares is probably the youngest client from this list. It has distinctive visual style. It uses multiple databases, but one connection per window paradigm. You could switch between connections using left panel, which is in other tools (including VS Code) used for widget switching. It has quite good SQL dumping abilities for PostgreSQL and MySQL (ability to make SQL backup of database/selected tables), which is a bit problem for other tools. Also it utilizes (in)famous library faker.js, you could insert new rows with testing data. Antares is developed by Fabio Di Stasio.