Free multi-platform database tool for developers, SQL programmers, database administrators, and analysts. Supports any database which has JDBC driver (which basically means – ANY database). EE version also supports non-JDBC datasources (WMI, MongoDB, Cassandra, Redis).
- Has a lot of features including metadata editor, SQL editor, rich data editor, ERD, data export/import/migration, SQL execution plans, etc.
- Based on Eclipse platform.
- Uses plugins architecture and provides additional functionality for the following databases: MySQL/MariaDB, PostgreSQL, Oracle, DB2 LUW, Exasol, SQL Server, SQLite, Firebird, H2, HSQLDB, Derby, Teradata, Vertica, Netezza, Informix.
DBeaver requires Java (JRE) 1.8+ to run.
- Windows installer includes JRE so just use it and doesn’t think about internals.
- On Linux, you may need to install Java manually (usually by running sudo apt-get install default-jre or something similar).
- On MacOS X you may need to download Java (JDK) from Oracle web site. Or use these instructions.
DBeaver 5.0.2 releases.
- SQL editor:
- Empty script close behavior config was enhanced
- Resources leak (thread + memory) was fixed
- Results viewer: plaintext + record mode error was fixed
- Permission grants in table DDL
- Constraints comments support was added
- Foreign keys comments support was added
- Sequences support (v10) was fixed
- Sequences comments support was added
- Functions permissions UI was added
- Triggers DDL was added
- Inherited tables DDL was fixed
- Foreign servers DDL was added
- Foreign wrappers DDL was added
- Database rename support was added
- DBA views resolve was fixed
- Standard function names highlight was fixed
- Exasol: table row count support was added
- SQL Server: URL generation (explicit port value) was fixed
- Greenplum driver configuration was added
- Data export: XLS format (NULL cell values, column comments) was fixed
- Minor UI bugfixes