DBeaver

Free multi-platform database tool for developers, SQL programmers, database administrators, and analysts. Supports any database which has a 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 the 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  DBeaver v7.1.4

• – Database navigator:
  • – Connection status icons and tooltips were redesigned
  • – Icon decorations added for Git-integrated projects
  • – Navigator view options were added in the context menu
  • – Simple view support was improved (redundant objects removed from the navigator tree)
  • – Icons for “Create new objects” action were fixed
• – Data editor:
  • – Unique key detection was fixed (for data editor)
  • – Advanced paste of multiple rows was fixed (redundant rows create was removed)
  • – Column filter dialog move/resize was fixed on Linux
  • – Grid data rendering performance was improved
  • – Auto-complete of column names was fixed in the filter panel
• – SQL editor:
  • – Search/replace/undio/redo shortcuts were fixed in embedded editors (view/procedure sources)
  • – Parameter binding was fixed for multiple occurrences of the same parameter
  • – Smart commit mode behavior was fixed for PostgreSQL (post-error transaction recovery)
  • – Delete indent with single backspace was enabled by default
  • – Server log panel now works for data modification triggers
  • – Extract query from source code now shows notification popup
  • – Multiple queries execution is now allowed (in separate tabs)
• – ERD editor: extra coloring was added for multi-schema diagrams
• – Oracle:
  • – Metadata read performance was increased (Tables, materialized views)
  • – Columns and constraints were added in materialized view editor
  • – Numeric data type precision read was fixed
  • – Support of implicit cursors in query results was added
  • – View DDL reading was improved (view comments are included in DDL)
• – PostgreSQL:
  • – Default schema detection and search_path overwrite was fixed
  • – Multi-dimension arrays support was added
  • – Table DDL for inherited tables was fixed
• – MySQL:
  • – Active database change in read-only connections was fixed
  • – CHECK constraints support was added
  • – Table copy operation was fixed
  • – User password management was improved (to avoid FLUSH PRIVILEGES)
• – Sybase:
  • – Support of text editing in views was added
  • – Schema indexes reading was fixed
  • – New table columns create was fixed
• – CockroachDB: direct table data edit support was fixed
• – HSQLDB: UUID data type support was added
• – Query cancelling was improved (force cancel for hanging connections)
• – Transaction isolation level settings save was fixed
• – Error and debug logging was fixed
• – A large number of minor UI improvements and bugfixes

Download