DBeaver

DBeaver is an open source, multiplatform and totally free graphical software implemented in Java/Eclipse and designed from the ground up to act as a SQL client and universal database manager for GNU/Linux operating systems. The project’s main goal is usability.

Features at a glance

Among its highlights, we can mention a metadata editor, SQL statements/scripts execution, transactions management, scrollable resultsets, SQL scripts management, ER diagrams, as well as a modern and carefully designed user interface.

In addition, DBeaver can handle external data sources whether they have a JDBC driver or not, various database management tools, such as ERD, and a collection of plugins for the MySQL and Oracle database servers.

The application is based on an open source framework and features a powerful plugin architecture, allowing the user to easily extend its default functionality by creating extensions/plugins.

MySQL and Oracle features

The software comes with separate functionality for the MySQL and Oracle database servers, among which we can mention support for Enum/Set datatypes, an advanced metadata editor, catalogs, users and session management, metadata DDL, triggers and procedures views, support for XML and Cursor data types, as well as support for browsing and editing various metadata objects, including tablespaces, indexes and packages.

Supported databases

The application supports a wide range of database servers/engine, including MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Sybase, ODBC, Java DB (Derby), Firebird (Interbase), HSQLDB, SQLite, Mimer, H2, IBM Informix, SAP MAX DB, Cache, Ingres, Linter, Teradata, Vertica, as well as any JDBC compliant data source.

Under the hood and supported operating systems

The software is written entirely in the Java programming language, DBeaver is a platform-independent application that supports Linux, Solaris, HPUX, AIX, Mac OS X and Microsoft Windows (2000/XP/2003/Vista/7) operating systems. It has been successfully tested with both 32-bit and 64-bit instruction set architectures.

What is new in this release:

• Results viewer: Groupings panel was added (GROUP BY generator)
• Results viewer: Aggregate panel was renamed to Calc
• Results viewer: links navigation was fixed (references rendering)
• Results viewer: show confirmation if panel data was modified
• Results viewer: improved drag-n-drop support for all controls
• Results viewer: icons were fixed
• Mockdata: template generator was added
• SQL editor: show stored procedures/functions in SQL completion
• SQL formatting was fixed (single line comments)
• XLS export: empty tables export was fixed
• Update site management preference page was added
• Columns visibility/order configuration dialog was improved
• Date/time formatted was fixed (nanoseconds format pattern)
• HANA: functions source code reading
• Clickhouse: array data types support was added
• Oracle: session elapsed time was added
• Oracle: timestamp with timezone handler was fixed (check driver version)
• PostgreSQL: drop sequence query was fixed
• RedShift: driver configuration was fixed
• Many minor UI bugfixes

What is new in version :

• We rolled back to Java 6
• Custom queries results are now editable
• SQL parser/formatter was improved
• SSH tunnel connection timeout was added
• Many minor bugfixes and improvements

What is new in version 2.3.7:

• MySQL maintenance tools (check, analyse, etc) was added
• Oracle table tools (analyse, gather statistics) was added
• DB2 table truncate tool was added
• SQLite driver was updated, metadata read has been fixed
• SQL autocomplete fixed
• Server output window added in SQL editor
• ResultSet viewer UI was fixed
• Minor UI fixes

What is new in version 2.3.6:

• Resultset viewer/editor was redesigned
• SOCKS (4/5) proxy support was added
• Connection network configuration UI was redesigned
• MS Access driver was updated
• SQLite SQL statements processing was fixed
• DB2 metadata browser has been fixed
• Oracle sequences search was added
• Many additional UI preferences was added
• Minor UI fixes

What is new in version 2.3.4:

• Database objects quick search dialog has been added
• Query execution progress/cancel UI was redesign
• SQL auto-completion was improved
• Results find/replace has been fixed
• Multiple result sets support (SQL Server & Sybase) added
• DB2, Oracle extensions was improved. Legacy DB2 LUW driver added
• MySQL driver updated
• Many UI fixes and improvements

What is new in version 2.3.2:

• Open editors are now restored after restart
• Connections' folders support has been added
• SQL auto-completion was improved
• Auto-completion and hyperlinks for procedures/packages has been added
• Database search results are now structured
• Disconnect detection by error code has been added
• Driver management UI was redesigned
• DB2 for AS 400 driver has been added
• H2, Derby and HSQLDB drivers were updated
• Minor fixes in Oracle, MySQL and DB2 plugins
• Data transfer columns mapping fixed
• SQL processing UI fixed
• Minor UI bugfixes

What is new in version 2.3.1:

• DB2 extension replaces generic DB2 driver (note: this applies only to DB2 LUW, DB2 for z/OS still use old generic driver)
• Separate database connection used for metadata reading (configurable)
• Pseudo columns (ROWID) support added for Oracle and DB2. Data editor now uses ROWID as primary table identifier (instead of PK).
• Local/server-side result set ordering is now configurable
• SQL templates additions ($schema and $catalog variables has been added)
• Metadata editor UI improved
• Minor UI bugfixes

What is new in version 2.3.0:

• DB2 extension (metadata browser, execution plan view, etc)
• Eclipse 4.3 is now base platform (improves UI and editors performance)
• Fixes of MS SQL, MySQL, Oracle ad CSV extensions
• Metadata editor fixed
• Execution plan visualization improved
• Auto-increment columns edit fixed
• Many minor fixes in UI and model

What is new in version 2.2.5:

• Data transfer performance improved
• Query/script execution statistics improved
• SQL autocomplete improved
• Results view copy/advanced copy improved
• Results view rendering fixed
• Unique keys management simplified
• A few minor UI problems fixed

What is new in version 2.2.2:

• Connection properties UI completely rewritten and improved
• DB2 for z/OS driver added
• Binary (LOB) editor improved, Hex and Base64 formats added
• Autocommit and transaction isolation per-connection configuration added
• Cross-database data export fixed
• Results viewer fixed (additional segments fetch)
• Checking of multiple running DBeaver instances added
• Context menu fixed in Eclipse plugin mode
• Foreign keys added in generic DDL
• UI freeze on disconnect with socket timeout fixed
• Many minor UI fixes

Requirements:

• Java 2 Standard Edition Runtime Environment