DBeaver – open-source database client

Original Article ↗ Hacker News Discussion ↗

Overall sentiment and use cases

  • Widely praised as a powerful, free, cross‑platform “Swiss army knife” for databases.
  • Commonly used for PostgreSQL, MySQL/MariaDB, SQL Server, Redshift, SQLite, Babelfish, and more.
  • Especially valued for ad‑hoc querying, exploring schemas/DDL, light data editing, ER diagrams, and geospatial data viewing.

Strengths and notable features

  • Single tool for many DBs via JDBC; can customize drivers and works better than some tools with non‑standard backends (e.g., Babelfish).
  • Visual row editing with transactional “save” flow is appreciated for safe, small updates.
  • ER diagram viewer and schema introspection are frequently cited as standout features.
  • Good format options for data export, including SQL; Parquet access works well via DuckDB.
  • Geospatial support (e.g., PostGIS types) renders directly in an embedded map.
  • CloudBeaver (browser version) seen as a better shared/web alternative than pgAdmin in some environments.

Weaknesses, bugs, and UX complaints

  • Connection handling can be fragile, especially after network loss or laptop suspend; sometimes requires manual reconnect or full restart.
  • Some report buggy behavior with PostgreSQL errors and stored procedures, vague error messages (Java stack traces), and occasional drawing/editor glitches.
  • Perceived as heavy, memory‑hungry, and “clunky” on macOS; slower or less responsive than lighter native tools.
  • Dark mode and SWT/Java UI criticized as ugly, non‑native, or ergonomically off, especially on Linux/HiDPI; others find it utilitarian and fine.
  • Update prompts and some dialogs are considered noisy or oddly worded.
  • Plugins may need reinstallation after updates.

Comparison to other tools

  • Seen as less DB‑specific than pgAdmin, MySQL Workbench, or Navicat (e.g., missing deep server stats, planner visualizations, schema diff in community edition).
  • Many prefer native/mac tools (TablePlus, Postico, Sequel Ace, Sequel Pro) or lighter Windows tools (HeidiSQL), but still fall back to DBeaver for multi‑DB support.
  • Some alternatives mentioned: DataGrip/IDEA DB plugin, Azure Data Studio, SQuirreL, DBGate, Adminer, DBVisualizer, Jailer, Harlequin (TUI), pgcli/mycli.

Business model and contributions

  • Core is open source; advanced features and broader connectors require paid editions.
  • Some users want a simple donation option for the community edition; others argue donations are negligible compared to commercial revenue.