DBeaver Community

What it is

DBeaver Community is a free, open source (Apache 2.0) desktop client for relational databases. It runs on Windows, macOS and Linux and connects through JDBC drivers to PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, Oracle and many others. As of 2026-09 the current Community release is 26.2.1 (source: dbeaver.io).

Its main features are a SQL editor with autocomplete and formatting, a spreadsheet-like data editor, a schema browser, generated ER diagrams, visual EXPLAIN for supported databases, and data import and export in formats such as CSV.

Is it worth your time?

Yes, if you work with more than one database or want one tool on every operating system. It is especially handy on macOS and Linux for SQL Server, where SSMS does not run. The official tools (pgAdmin, MySQL Workbench, SSMS) still go deeper into their own database's administration, so many engineers use both: DBeaver for everyday querying across systems, the vendor tool for server-specific work.

Free vs paid

Community is free for any use. DBeaver also sells PRO editions with extra features such as NoSQL and cloud database support, advanced security and technical support; prices are on the DBeaver PRO site, and you do not need them to learn SQL.

How to use it well

• Create one connection per database and name them clearly, such as "local-postgres" and "staging-readonly", so you never run a query against the wrong server.
• Mark production connections as production in the connection settings, which adds confirmations for data changes.
• Turn off auto-commit for connections where you practise transactions, and commit or roll back yourself.
• Use the generated ER diagram of a sample database to learn its relationships.

Watch out for

The first connection to a database downloads its driver, which needs internet access. A GUI makes it easy to edit data by clicking; on shared or production databases, prefer written, reviewed SQL.

Common questions

Does it replace the command-line client? No. Learn psql, mysql or sqlcmd too, for servers and scripts.

Is it heavy? It is a Java desktop application, so it uses more memory than a simple editor, but it runs fine on a typical student laptop.