DBeaver

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, Sybase/SAP ASE, SQLite, Firebird, H2, HSQLDB, Derby, Teradata, Vertica, Netezza, Informix, etc.

Changelog v5.3.2

• Data editor:
  • Open With menu was added (web browser and Excel)
  • Next page auto-fetch was fixed
• UUID/GUID generate function was added
• ERD:
  • Save as picture function was fixed (case-insensitive file path)
  • Attributes visibility configuration was improved
• Data transfer: “truncate target table before load” function was fixed
• SQL editor:
  • Parameters biding dialog + results scrolling glitch was fixed
  • Glitch with first time reading of proposal was fixed
  • Stored procedure auto-completion was fixed
  • Syntax coloring: Color Themes support was fixed
• SQL Server:
  • Default schema detection was fixed
  • Column data type resolution was fixed
  • Identifiers auto-completion was fixed
  • NVarchar(MAX) data type resolution was fixed
• Exasol:
  • Exasol V6.1 support was added
  • Metadata reading performance was significantly improved
  • Partitions information was added
  • Security management was improved (roles, priority groups, policies, etc)
• PostgreSQL:
  • Rules support was added (read-only)
  • Stored procedures (PostgreSQL 11) support was added
  • Aggregate functions meta information support was added
  • Database tablespace edit support was added
  • Reserved keywords update was added
• Greenplum:
  • External table DDL generation fixes were added
• Redshift: column encoding information was added
• Oracle: PS/SQL blocks parser was fixed
• Huge code refactoring was made (separation of model and UI plugins)
• Many minor UI bugfixes

Download