In this post, we are going to quickly review three database tools DBeaver, HeidiSQL, and TablePlus; as well as to compare pros and cons of each tool and choose the one that matches your needs.

1. DBeaver

DBeaver provides a powerful database client for multiple drivers, but it’s a little bit overwhelming.

  • Supported Platforms: DBeaver used to work on all platforms supported by Eclipse framework (Windows, Linux, MacOS, Solaris, AIX, HP-UX). Starting from version 4.2, it limited its support to Windows, MacOS and Linux only.

  • Supported Drivers: DBeaver community version supports any databases that use JDBC driver (which means a lot of databases): MySQL, PostgreSQL, MariaDB, SQLite, Oracle, to DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc. The enterprise adds support for non-JDBC datasources (WMI, MongoDB, Cassandra, Redis).

  • Pricing: DBeaver has a free and open source community version (DBeaver CE). It has an enterprise edition (DBeaver EE) with more driver support, more advanced features and dedicated customer support for enterprises.

DBeaver

Pros:

  • It’s cross-platform. If you work on multiple operating systems, you can have a consistent experience across all systems.
  • It supports a lot of databases.
  • Entity-relationship diagrams are supported.
  • Good built-in reformat SQL

Cons:

  • It runs on a Java virtual machine, it consumes a lot of memory usage while running.
  • Confusing and unintuitive icon design. You might not know where to look for the function you need.
  • The autocomplete feature in query editor is slow and not so smart.

2. HeidiSQL

HeidiSQL provides a powerful graphical interface for managing tables, logs, and users of a MySQL database, as well as Microsoft SQL Server and PostgreSQL.

  • Supported Platforms: HeidiSQL was built for the Windows platform, and it only works on Windows.

  • Supported Drivers: Initially, HeidiSQL offered support for MySQL, then extended to MS SQL Server, and now it also includes PostgreSQL support.

  • Pricing: HeidiSQL is a free and open-source client. Its codebase was originally taken from Ansgar Becker’s own MySQL-Front 2.5 software. Anyone can download and use the app for free with no limitation, but it also accepts the donation.

HeidiSQL

Pros:

  • It’s lightweight.
  • Connect to multiple servers in one window
  • Free to use – Licensed under GNU GPL.
  • Portable. Alongside the possibility of downloading the installer and source code, a portable version of the software is available.
  • Full database user management and privileges management options.
  • Write queries with customizable syntax-highlighting and code-completion
  • Data synchronization. HeidiSQL can compare and synchronize your data and structure between local and remote databases.
  • SSH tunneling support

Cons:

  • Low stability. HeidiSQL is known to have a lot of bugs that result in frequent crashes
  • It’s only available for Windows and it doesn’t look like a cross-platform is coming anytime soon
  • No built-in debugger included
  • Low DPI display. The author attempted to add the high DPI but dropped it eventually.

3. TablePlus

With a native build and a lightweight size, TablePlus is a very handy tool for managing multiple databases.

  • Supported platforms: TablePlus is built native for each platform. It started out with a native version for Mac, then another version for Windows, and a version for Linux was introduced recently as an alpha release. It also has an iOS version.

  • Supported Drivers: TablePlus supports a handful of relational databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, Oracle; and two popular NoSQL databases: Cassandra and Redis.

  • Pricing: TablePlus has a free version with full set of features which you can download and use forever, but there are some usage limitations. If you use it heavily, the license costs $59 to remove all those limitations.

TablePlus

Pros:

  • Native build for each platform so it’s fast, lightweight, and stable.
  • Clean and simple interface.
  • Multiple drivers support
  • Multiple conditions data filter
  • Queries history and keyword binding favorite.
  • Streaming results and async loading to show queries results faster and doesn’t block the UI.
  • Very quick inline editing for table data and structure, you also can edit query results directly.
  • Smart query editor with highlight syntax, instant autocomplete, SQL reformat.
  • A plugin system to extend the app.
  • Quick support. TablePlus releases new updates regularly and responds to users’ requests almost immediately.

Cons:

It currently lacks of some advanced features such as ER Diagram, database compare tool to Diff and Sync, etc.

4. Conclusion

Go with DBeaver if you:

  • Work with all kinds of databases and switch regularly
  • Don’t mind the slugginess

Go with HeidiSQL if you:

  • Prefer the old-fashioned design with loads of buttons in the UI.
  • Work on Windows only
  • Need a tool that is feature rich.

Go with TablePlus if you:

  • Are a fan of native experience
  • Work with multiple databases
  • Want a modern design with better usability
  • Want quick support & development cycle.