🛠️ DBeaver — Visual Database Manager

DBeaver — Visual Database Manager: Think of DBeaver as a file manager for your database. Connecting through `psql` in a terminal is like browsing folders with `dir`/`ls`: powerfu

Think of DBeaver as a file manager for your database. Connecting through `psql` in a terminal is like browsing folders with `dir`/`ls`: powerful, but it assumes you already know what you're looking for at every step. DBeaver opens a window instead — tables appear in a tree on the left, you double-click one, scan the data like a spreadsheet, right-click a column to sort. So if the command line can already do everything, why use a GUI at all — isn't that just laziness? The real difference isn't speed, it's **discovery**. Dropped into a database whose schema you don't know, `psql` requires you to know the table names, columns and foreign keys before you can ask the right question — you must already know the answer to find the answer. DBeaver's ER diagram breaks that loop: you see at a glance what links to what. While learning, that difference is the difference between hours and minutes. From the Java side its place is clear: it does the same job as IntelliJ's Database tab, but it isn't tied to one IDE or one project — SQLite, PostgreSQL, MySQL and Oracle all connect through the same interface. The JDBC driver concept carries over unchanged; DBeaver downloads that driver for you on first connection. For QA the critical use is this: when a test fails, you answer "was the record actually written, and with what status?" in seconds, without touching the automation code. But precisely because it is that easy, set yourself a rule: add production connections through a read-only user wherever possible. A WHERE-less UPDATE run by accident in a GUI does exactly the same damage as in a terminal — it is just easier to click.

DBeaver is a **100% free, open-source** database management tool supporting **80+ databases** including MySQL, PostgreSQL, SQLite, Oracle, and SQL Server. Think of it as the free alternative to the paid DataGrip or MySQL Workbench. In Java you ran queries from the command line via JDBC — DBeaver does the same visually: click table structures, see FK relationships, view results in a spreadsheet.

Visual Schema Editor

SQL Editor + Autocomplete

Kurulum / Installation

What Does the DBeaver Install Command Actually Do?

EACH of winget/brew/apt…

EACH of winget/brew/apt uses the operating system's OWN package manager — it's the automated version of manually downloading the .exe/.dmg from dbeaver.io, the end result is IDENTICAL.

The --cask flag on macOS…

The --cask flag on macOS tells Homebrew this is a GUI app (not a command-line tool) — the DBeaver.app bundle gets COPIED into Applications.

On Ubuntu/Debian, the GPG key…

On Ubuntu/Debian, the GPG key gets added first (apt-key add) — this CRYPTOGRAPHICALLY verifies the package really comes from DBeaver's official server, PREVENTING a spoofed package install.

On first launch, DBeaver downloads…

On first launch, DBeaver DOWNLOADS a bundled Java runtime (JRE) — this is why the first launch REQUIRES an internet connection, later launches can work offline.