DBeaver is a software solution for developers, analysts and database administrators that have to manage different types of databases. It provides support for lots of popular databases such as MS Access, Oracle, DB2, SQL Server, MySQL, PostgreSQL, Teradata, or Firebird.
The app has a standard interface, comprised of a main menu tab, a toolbar with various options, a side panel, and the main display area. There aren't many visual customizations, but the navigation through the menu is straightforward. At times, the buttons feel unresponsive and the toolbar icons could've been more intuitive.
DBeaver supports any database that has a JDBC driver, but it's also capable of handling external datasource that doesn't have a JDBC driver.
It has a built-in Database Object Editor that can be used in multiple databases, to various jobs, like editing tables, views and schemas.
Moreover, it comes with Entity Relation Diagrams that allows users to view the diagrams of existing tables and whole database schemas.
To summarize, DBeaver is a friendly application to use, either you're a proffessional or a beginner. It's free, it supports multiple platforms, so it can be used in various projects.
v6.2 [Sep 12, 2019]
- Task management: now all data transfer operations (export/import) can be saved as tasks:
- New task management view.
- Running saved tasks in two clicks.
- Task execution logs.
- Data transfer:
- Output file names were fixed.
- Previous wizard settings save was fixed.
- Many minor improvements.
- Virtual table columns:
- Supported for all tables and views.
- Supports expressions, math functions and geometry transformation functions.
- Virtual foreign keys config save/copy was fixed.
- Data viewer:
- Hex viewer was added for string content.
- Long CLOB text viewer was fixed.
- Filter dialog was fixed (orderings, distinct value reading).
- SQL editor: parameters binding was improved:
- Show dialog before script execution.
- Show current query text.
- Object editor: new command for expensive properties (row count) reading.
- SAP HANA.
- New extension developed (thanks to @kai-morich):
- Driver auto-download.
- Sequences, synonyms, triggers.
- SQL execution plan.
- Object searcher.
- H2GIS: spatial data viewer was added.
- Redshift: stored procedures support was added.
- Yellowbrick: driver config was fixed for better performance.
- Oracle: view column comments edit support was added.
- A lot of minor UI fixes.
Feature-rich relational database known for its high performance and excellent concurrency
