DBeaver Changelog

What's new in DBeaver 7.2.1

Sep 21, 2020
  • Preference pages structure was reorganized (in the standalone and plugin versions)
  • SQL Editor: editor tab title now can include active database/schema name
  • MySQL: driver "MySQL 8" is now the default driver. "MySQL 5" driver can be used for older server versions.
  • Oracle: tables/views load performance was improved on some systems
  • CockroarchDB: role manager was fixed
  • DB2: runstats utility support was fixed (wrong syntax)
  • SQL Server: extra T-SQL dialect keywords were added
  • CUBRID driver configuration was fixed
  • Several UI freeze issues were fixed (deadlocks)
  • Several minor bugs were fixed (NPE and UI glitches)
  • Database navigator:
  • Filters now support masks escape (_ and % characters)
  • Connection state icons were replaced and adapted to dark themes
  • PostgreSQL:
  • Latest PostGIS driver mapping was added
  • Geometry data types export was improved (proper SQL format + SRID)
  • Hidden databases can be loaded in the database navigater
  • Import from CSV/XLSX:
  • Wrong rows can be skipped (with disabled "Batch import" option)
  • Import parameters documentation was updated

New in DBeaver 6.3.3 (Jan 20, 2020)

  • Tasks:
  • SQL script execute task was added
  • Variables support was added
  • Grouping of tasks by project/type was added
  • Active database/schema now saved for custom SQL queries
  • Target table mapping was fixed for database-to-database data transfer
  • Data viewer:
  • Column filter UI was improved (multi-value select, value search)
  • Null XML columns support was fixed
  • Column value transformations and coloring was fixed
  • Context menu was improved (layout was change, missing commands were added)
  • Problem with missing toolbar actions was fixed
  • Hex editor coloring was improved, dark theme support was added
  • SQL editor:
  • Auto-complete now respects active schema
  • Database output read was fixed (async mode)
  • Hyperlinks and object navigation were fixed
  • Aliases generation algorithm was improved
  • PostgreSQL:
  • Database restore task was fixed (target database)
  • SQL parser was fixed (BEGIN/END keywords)
  • Oracle: procedures/views source code editor was fixed
  • MySQL: database restore log level config was fixed
  • Netezza: views and procedures source extraction was fixed
  • Hive: view editor was fixed
  • Neo4j: arrays support was fixed, SQL parser was fixed
  • Metadata editor: current database detection was fixed
  • Tooltips for database navigator were improved
  • Variables in connection parameters now enabled by default
  • Connection type permissions save was fixed
  • Dark theme support was improved in the main toolbar and in different dialogs
  • SSH agents support was fixed (now we use ssh-agent on Linux)
  • SSH + private key + password: configuration dialog was fixed
  • A lot of minor bugfixes

New in DBeaver 6.3.2 (Jan 6, 2020)

  • Database backup/restore/sql tools (PostgreSQL, MySQL, Oracle) now can be saved as tasks
  • Smart auto-commit mode was introduced (enable transactions vefore data modifying query execute)
  • SQL editor:
  • Alias generation was improved
  • Output log flush eas fixed
  • Default database assign (for SQL script) was fixed
  • Data editor: advances paste now respects NULLs for dates and numbers
  • PostgreSQL:
  • $$ strings parser was fixed
  • Domain type arrays support was fixed
  • DB2 (iSeries, z/OS): new connection issue was fixed
  • Oracle: session manager now shows servr-side execution plans (thanks to @SergDzh)
  • MySQL: database backup/restore was fixed
  • Firebird: unique key DDL was fixed
  • Number of fixes and improvements in backup/restore tools
  • Workspace switch: last chosen workspace is now saved between app restarts
  • Dark theme support was improved (toolbars, dark colors customization)
  • Eclipse 4.6 support was fixed
  • Problem with missing toolbar buttons was fixed (Linux)
  • A lot of minor bugfixes

New in DBeaver 6.3.1 (Dec 27, 2019)

  • SQL editor:
  • Active database/schema change now affects current editor only
  • Server-side output now works with huge outputs
  • New command @unset was introduced
  • Table alias generation was fixed (conflicts with SQL keywords were fixed)
  • Query parameters dialog now doesn't appear on scrolling/refresh
  • Code templates now saved in utf-8
  • Data editor:
  • Smart option "Use all columns" for virtual identifier
  • Inline cell editor now uses the same font as in grid
  • Decimal values formatting was fixed
  • Data transfer:
  • Selected rows/columns option support was fixed
  • CSV import was fixed
  • Export to single file was fixed (timestamp pattern)
  • Export from query now works with variables
  • Transaction log/query manager: dark theme support was fixed
  • Dashboards + timeseries + minute interval support was fixed
  • SSH with private key + password support was fixed
  • Extra locales (pt and ru) support was added in bundled JDK
  • SAP HANA: GIS/spatial data type viewer support was added (thanks to @stefanuhrig)
  • Presto: metadata reading was improved (dummy errors suppressed)
  • AWS Athena: URL template now respected in new connections
  • MySQL:
  • Database backup can be saved as task now
  • Events editor (DDL) was fixed
  • PostgreSQL:
  • Connection dialog was improved (new tab was added)
  • $$ and $tag$ parser was improved (new config options were added)
  • JSON and struct data types support was fixed
  • DB2: table truncate command was fixed
  • Oracle: new function DDL was fixed
  • Snap repository dbeaver-ce is now official. We will update it on every version release
  • A lot of minor bugs were fixed

New in DBeaver 6.3.0 (Dec 2, 2019)

  • SSH Agent support was added (pageant and ssh-agent)
  • Disconnect project/folder/all actions were reworked
  • Problem with connection properties save was fixed
  • Connection properties dialogs UI was improved (test connection, password save, pref page search)
  • Task management UI was improved (task create/save actions in data transfer wizard)
  • ER diagrams: dummy errors are now suppressed (now they present in log file only)
  • Legacy Eclipse plugins installation support was added (with hold update site format)
  • Dark theme support was significantly improved
  • Auto-commit mode behavior change:
  • Toolbar toggle now affects current connection only
  • Mode change affects active DBeaver session only
  • Data export:
  • Export from SQL script now supports commands (@set and others)
  • Saved settings loading was fixed
  • XLSX exporter now respects export configuration
  • Data editor:
  • Fetch size can be changed before query execute
  • Spatial viewer now supports different pluggable tiles (mapbox, osm, etc)
  • Wrong date/time format now treated as error
  • SQL Editor: editor layout now saved between DBeaver sessions
  • Object editor (tables, views, etc) now checks for object name duplicates
  • Oracle: now we use full type name presentation by default
  • PostgreSQL: support of extra type aliases and array data types was added
  • CockroachDB: native CDB data types were added
  • Impala: active schema change support was added
  • A lot of minor UI/DB-specific bug fixes

New in DBeaver 6.2.5 (Nov 18, 2019)

  • Problem with context menu was fixed (on Linux)
  • Problem with mixed global/connection settings was fixed
  • SSH: "jump" server support was added (thanks to bsv798)
  • Data editor:
  • Vertical and horizontal scroll position is now saved between data refresh/filter
  • Smooth scroll mode is now the default mode (and configurable)
  • Large json loading performance was improved
  • Ordering by unnamed columns was fixed
  • Grouping panel refresh was fixed
  • Data export/copy as: use the same connection by default
  • Object editor: property change and object rename was fixed (right order of DDL queries)
  • SQL editor: CASE/WHEN formatting was fixed
  • Oracle: data type editor UI was fixed
  • MySQL: events DDL was fixed (interval)
  • PostgreSQL: array-based domain data types handle was fixed
  • SQL Server: synonyms search was added
  • HANA: table column create was fixed
  • Greenplum 6+: table DDL (distribution) was fixed
  • Full-text search dialog render was fixed
  • Application startup speed was improved
  • Several rendering glitches on HighDPI screens were fixed
  • Many other minor UI fixes

New in DBeaver 6.2.4 (Nov 4, 2019)

  • SQL editor:
  • Select row count from custom query was fixed (ORDER BY now allowed)
  • Parameters/variable binding was fixed
  • Export from query with parameters was fixed
  • Number of improvements in intellisense algorithms
  • Data viewer:
  • Smooth scrolling mode was added
  • Number of fixes in floating point numbers handling
  • Option for short/fully qualified table names in SQL script was added
  • Grid state save/restore (after ordering/filter apply) was fixed
  • Tabs pin + drag-n-drop behavior was fixed
  • Tables navigation was fixed (filter value refresh)
  • Query manager: query ordering/refresh was fixed
  • ERD: problem with broken layout after config change was fixed
  • CSV export: row separator config was added
  • PostgreSQL:
  • $$ delimiters handle was fixed
  • Function parameters default value reading was fixed
  • Oracle: table column comments save was fixed
  • SQL Server: functions and synonyms support was added in object search
  • Java version in Windows ad MacOS installers was upgraded to OpenJDK 11.0.5
  • A lot of other minor UI fixes

New in DBeaver 6.2.3 (Oct 23, 2019)

  • SQL Editor: parameters binding dialog improvements (value preview)
  • Data viewer:
  • Result tabs drag-n-drop support was added
  • Spatial data viewer was fixed (tooltips generator)
  • Task editor: add/remove tables for existing task was fixed
  • Virtual foreign keys support was fixed (table rename support)
  • Oracle: Q-style quoting support was added
  • PostgreSQL:
  • Foreign Data Wrappers configurator wizard was added
  • $$-quote support was fixed
  • Dependencies info reading was fixed (PG12)
  • Function signature generator was fixed (FQ type names)
  • MySQL: column autoincrement flag editor was fixed
  • Elasticsearch: driver version was updated
  • Windows: app crash problem was fixed
  • MacOS: app notarization added for all distributions
  • Eclipse plugin: create .dbeaver folder on demand
  • A lot of minor UI fixes

New in DBeaver 6.2.2 (Oct 7, 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

New in DBeaver 6.1.5 (Aug 19, 2019)

  • Data viewer:
  • Virtual primary/foreign keys editors were enhanced
  • Problem with filters on data refresh was fixed
  • Added confirmation dialog before opened result tabs closing
  • Problem with missing updated row count (in script mode) was fixed
  • References panel now remembers last FK/reference selection
  • Value view panel now supports Find/Replace
  • Float values rendering was fixed (numbers rounding is disabled by default)
  • Data transfer:
  • Save of previous target container selections was added
  • Export of tables/queries with complex data types (structs, objects) was improved
  • Connection management:
  • Connection permissions config was added (restrictions of data/metadata changes for a particular connection or connection type)
  • Problem with bootstrap queries and auto-commit state save/load was fixed
  • Multi-project support was improved (use selected project for new connections)
  • Support of empty database passwords was added
  • Copy/paste and drag-n-drop connections between different projects was fixed
  • Database navigator:
  • Default double-click behavior configuration was added (view properties/data/erd)
  • Object edit dialogs are properly sized now (problem with too small dialog window was fixed)
  • Connection type coloring in the main toolbar is back
  • DBeaver toolbars visibility was fixed (for Eclipse plugin version)
  • New DBeaver version automatic downloading (optional) was added
  • MySQL:
  • Datetime columns edit was fixed. Problems with timezone were fixed.
  • Legacy MySQL

New in DBeaver 6.1.4 (Aug 7, 2019)

  • Many problems with workspace migration were fixed
  • Data viewer:
  • UI look and feel was significantly improved
  • New interface for rows/columns coloring
  • Logical foreign key creation was simplified
  • Many bugs were fixed in References panel rendering
  • Column filters UI was fixed (dups, dictionary reading errors)
  • Unique key detection was fixed (use indexes with nullable columns if no other identifiers found)
  • Entiy diagrams: logical foreign keys can be created/deleted right in the diagram editor
  • Data transfer: auto-generated (identity) columns handler was added
  • DDL generation: now we generate tables DDL according to their foreign keys order
  • Geometry viewer: simple (flat) geometry support was added
  • Execution log: reading of row count for DML statements was fixed
  • SQL Editor:
  • SQL formatter was fixed (DECLARE statements)
  • Copy SQL to Java code was improved (thanks to loro2)
  • PostgreSQL:
  • Array data type handler was fixed
  • Indexes metadata reading was fixed
  • Execution plan visualization was fixed for CTE nodes
  • SQL Server:
  • Support of identity columns creation was added
  • Session manager was fixed
  • Oracle:
  • Scheduled jobs metadata reading was fixed
  • Session management was fixed for RAC mode
  • Firebird: views and indexes metadata reading was fixed
  • Apache Hive: many bugfixes related to complex (struct/array) data types handling
  • Apache Drill: driver was fixed (missing JDK modules were added)
  • Many other minor UI bugs were fixed

New in DBeaver 6.1.2 (Jul 12, 2019)

  • Git integration:
  • Create projects in remote repositories
  • Pull/commit/push automation from the DBeaver perspective
  • Integrate existing projectys with Git repositories
  • Problem with SSH and SSL connections was solved
  • Problem with missing legacy character encoding was fixed
  • Data editor:
  • "Delete cascade" feature was added
  • Problem with column order was fixed (when result contains multiple columns with the same name)
  • Problem with duplicated values in column filters was fixed
  • "Default" values were added for numbers, strings and booleans
  • Data transfer:
  • Export to a single file was fixed
  • TXT format: extra options were added
  • CSV import: timestamp columns parser was fixed
  • PostgeSQL:
  • Extensions management was added
  • Partitions DDL was added
  • Partitions create/drop support was added
  • Object description reading was fixed (+ problem with duplicated objects was solved)
  • Complex data types rendering was fixed
  • float4 data type support was fixed (wrong value render)
  • Greenplum: ERD renderer was fixed
  • Oracle:
  • Problem with read-only tables was fixed (for some Oracle versions)
  • View management: problem with semicolons was fixed
  • DB2 for iSeries:
  • Procedures DDL was added
  • Problem with schema list reading was fixed
  • Generic driver (SQLite and others): problem with view create command was fixed
  • Plenty of minor UI bugs were fixed

New in DBeaver 6.1.0 (Jun 19, 2019)

  • Data viewer:
  • Spreadsheet column-based coloring support was added
  • Copy as HTML now uses html clipboard format
  • Focus loss bug was fixed (MacOS)
  • Data transfer:
  • Export to XLSX format: performance was greatly improved
  • Table truncate confirmation was added
  • Plaintext export was fixed (datetime data types formatting)
  • SQL editor:
  • SQL execution plan save/load support was added
  • Bug with keywords in comments was fixed
  • Active connection/schema selectors were fixed in the main/context menus
  • Workbench/J formatter was fixed
  • ERD diagram: Dark theme support was improved
  • Database navigator:
  • New object create context menu redesigned
  • Duplicated nodes bug was fixed
  • Spatial viewer:
  • Coordinates inversion was fixed (MySQL)
  • Column SRID and coordinates flip settings are now saved between sessions
  • Oracle:
  • Constraints metadata reading was fixed (fixes table editor as well)
  • Indexes DDL reading was added
  • PostgreSQL:
  • Backup of "quoted" schemas and tables was fixed
  • Functions' dependencies information was added
  • Struct data types parser was fixed (boolean fields extraction)
  • MySQL:
  • BEGIN keyword handler was fixed
  • View DDL was fixed (extra delimiters)
  • SQL Server: drop index qury was fixed
  • Eclipse plugin installer was fixed (missed bundles)
  • Many minor UI bug fixes

New in DBeaver 6.0.5 (May 23, 2019)

  • Database navigator:
  • Create object menu was improved (no redundant sub-menu)
  • Connection folders creation was fixed
  • Elements coloring was improved (for different connection types)
  • Shortcuts processing was fixed (broken shortcuts after some actions)
  • Table editor tabs activation was fixed
  • Columns editor: auto-completion was fixed in drop-downs.
  • Data transfer: export from multiple queries was fixed (target file names)
  • SQL Editor: SQL formatter was fixed (exp numbers and other minor fixes)
  • Spatial data editor:
  • Geography/geometry value editor (plaintext, WKT)
  • Numerous fixes in different SRIDs support
  • Oracle: metadata (constraints, foreign keys) reading performance was significantly improved
  • PostgreSQL:
  • Multiple query result sets support was added
  • Table partitions information was extended
  • Native database backup was fixed
  • Database creation was fixed (special characters in db name)
  • Sequence rename was fixed
  • Full schema DDL generation was fixed
  • Greenplum, Redshift: execution plan explain now supports plaintext format
  • SQLite: sample database was updated
  • Sybase (12 and older): stored procedures source reading was fixed
  • Apache Ignite: identifiers quoting was fixed
  • DB2 iSeries: schema reading was fixed
  • Extra command line parameters (connection opening)
  • Connections import from SQL Developer was fixed
  • Windows installer: config files (dbeaver.ini) backup
  • Extensions (Office, SVG, etc) installer was fixed
  • Checking for multiple DBeaver instances was added
  • Many minor UI bug fixes

New in DBeaver 6.0.4 (May 8, 2019)

  • Data editor:
  • Value transformers for custom queries and pseudo columns
  • Advanced data coloring configuration
  • Logical entity structure editor
  • Gradient colors for numerical/datetime columns
  • Navigate to FK/references: multiple rows support
  • Extra shortcuts were added
  • Spatial (GIS) viewer:
  • CRS (SRID) transformations support was added
  • Inverted coordinates support was added
  • Support of geography data type was added
  • Support of curved geometries was added
  • Open map in browser command
  • Maximum geometry objects limitation was added
  • Numerous bug fixes (tooltips, actions)
  • SQL editor:
  • Indentation was fixed (keyword-based indents were disabled)
  • Process @set commands in data export
  • "Format" context menu was fixed
  • Schema selector toolbar was fixed (missing database name)
  • Global native clients configuration was added
  • Shortcuts for connection/schema selectors were fixed
  • PostgreSQL:
  • Full schema DDL generation was added
  • Function create was fixed (function body)
  • Trigger create support was added
  • Columns DDL was added
  • MySQL: query metadata extraction was fixed (bug with wrong database name)
  • Oracle: metadata reading was fixed
  • SQL Server:
  • Procedures auto-completion was fixed
  • Support of older Azure versions was added
  • Redshift: external tables (spectrum) data reading was fixed
  • Clickhouse additional array data type support was added
  • Korean localization was added (thanks to Seongbae Chang)
  • Many minor UI bug fixes

New in DBeaver 6.0.3 (Apr 30, 2019)

  • Connection/schema selector toolbar was redesigned
  • Create object context menu was redesigned
  • Data viewer:
  • Panels UI was redesigned
  • "Copy As" command was added (CSV, HTML, JSON, etc)
  • IN filter UI was improved (previous selection save)
  • Statistics view was improved (proper view of multiline queries)
  • SQL editor: auto-indent was fixed
  • GIS spatial data viewer beta version (PostgreSQL, MySQL/MariaDB):
  • Viewer panel was redesigned, special results presentation was added
  • Multiple objects viewing support was added
  • Copy/save as picture, print, SRID selector
  • Data transfer:
  • Export progress monitoring was fixed
  • Export from custom SQL queries performance was improved (using fetch size)
  • Split output file feature was added
  • Reset UI settings menu item was added
  • Backup/restore wizards: native client configuration was added in the dialog
  • MacOS X installer was updated (JRE version update)
  • PostgreSQL:
  • Schema/tables backup wizard was fixed
  • Triggers enable/disable tool was added
  • Greenplum: tables reading for GP 4.x was fixed
  • SQL Server:
  • Use TOP to limit queries fetch size
  • Dynamic parameters binding bug was fixed
  • Table triggers enable/disable tool was added
  • Support of special characters in object names was added
  • Oracle:
  • New config option for metadata reading performance fix
  • Subpartitions browser was added
  • PL/SQL blocks parser was improved
  • Configuration of system views usage was added
  • DDL reading was fixed (problem with string truncate with some driver versions)
  • Many minor UI bug fixes

New in DBeaver 6.0.2 (Apr 10, 2019)

  • Eclipse 2019-03 is now the default platform
  • Embedded editor activation problem fixed (Linux)
  • SQL editor:
  • SQL errors now shown in results panel instead of modal dialog (configurable)
  • Certain long strings visibility problem was fixed
  • Auto completion was fixed for CALL/EXEC keywords
  • Tables/schemas were removed from columns proposals
  • Context menu was improved (redundant items were removed)
  • Numerous NPE errors were fixed
  • Multi-statements scripts formatter was improved (adding statement delimiters)
  • Database-specific named parameters prefix was added
  • SQL formatting was fixed
  • Morph delimited list formatter was fixed (spaces in tokens)
  • Data editor:
  • Unnecessary focus changing was fixed
  • Calc panel: strings/numbers aggregation toggle was added
  • Data transfer: fetch size was added in export settings (may significantly improve performance)
  • ERD (custom diagrams):
  • Additional styles were added for notes (colors, transparency, border, font settings)
  • Notes now can be connected with entities
  • Dashboards:
  • Timeseries dashboards rendering was fixed.
  • New dashboards extraction model was added (statistics reading by intervals)
  • Exasol dashboards were added
  • PostgreSQL:
  • Alpha version of GIS/spatial data viewer (maps) was added
  • Explain for queries with parameters was fixed
  • Database description reading was fixed (PG < 9.4)
  • Greenplum: tables reading for GP 4.x was fixed
  • Oracle:
  • Public synonyms in auto-completion
  • Session manager now shows instance ID (for clusters)
  • MySQL/MariaDB:
  • New database dialog now uses server charset/collation defaults
  • Native client was updated (problems with dump/restore compatibility)
  • MS SQL Server/Azure: driver version was updated, support of AD MSI authentication was added
  • Elasticsearch: metadata reading was fixed (schema/table names escaping)
  • Pervasive SQL driver configuration was added
  • MySQL NDB cluster driver configuration was added
  • Google BigQuery driver was updated
  • Numerous localization bugs were fixed
  • Many minor UI bug fixes

New in DBeaver 6.0 (Mar 19, 2019)

  • Added support for different cloud databases in AWS and Azure,
  • Significantly improved support for PostgreSQL and SQL Server
  • Increased number supported drivers to more than 70.
  • Renovated connection wizard and data migration tools.
  • Added analytical panels, customizable dashboards, mock data generators, SQL debugger.
  • Modernized UI, significantly improved dark theme support
  • Closed more than 1600 issues on GitHub.
  • And a lot of other things. Thank you for your support!

New in DBeaver 5.3.5 (Feb 19, 2019)

  • Database health monitoring dashboards were added (for PostgreSQL, MySQL and MariaDB)
  • Bookmarks: navigate to object action was added
  • Content editor (XML, JSON): contents formatting was added (Ctrl+Shift+F)
  • Charts: copy image to clipboard action was added
  • SQL editor:
  • Morph to delimited text action was fixed (spaces processing)
  • Delete file action was added in tab context menu
  • Intelligent bracket auto-close was improved
  • Variables resolution was fixed (mixed letters case)
  • Script Save As in non-UTF encoding was fixed
  • Files delete: keep local history by default
  • Statistics panel rendering was fixed
  • Data editor:
  • JSON auto-format was fixed (null values)
  • Standalone editor of NULL values was fixed
  • Date-time editor in native format was fixed
  • Plaintext renderer was fixed (extra spaces)
  • SSH tunnel: keyboard-interactive AND publickey auth support was added
  • Open resources in embedded text editor support was added
  • Dark theme support was improved
  • Tips of the day dialog font was fixed (HighDPI)
  • PostgreSQL:
  • Arrays editor was fixed (new array create)
  • Indexes statistics was fixed (rel size)
  • Table dependencies info was added
  • SQL Server:
  • SQL errors processing was fixed (error inside stored procedures)
  • Oracle:
  • Objects search was fixed (synonyms resolution)
  • Procedures/packages compile was fixed (trailing delimiter, log error position)
  • CockroachDB:
  • Database schema browser was fixed (aggregate functions, rules)
  • Permissions reading was fixed (CRDB style)
  • MySQL: database dump without DROP statement option was fixed
  • Firebird: sequences metadata reading was fixed
  • Sybase:
  • Stored procedure reading was fixed (multiple databases)
  • Query processing was fixed (trailing semicolon issue)
  • Synonyms tab removed
  • Many minor UI bugfixes

New in DBeaver 5.3.4 (Feb 5, 2019)

  • Data viewer:
  • New UI for view switching (grid/text, record)
  • Columns search was added in data filter settings
  • Numeric data types rendering was fixed
  • Plaintext mode renderer was fixed
  • SQL Editor:
  • Action toolbar design was improved
  • Context menu was simplified
  • "Find paired bracket" command was added
  • Databse navigator: double-click behavior config was fixed
  • Quick object search dialog UI redesign (object types selector)
  • Data transfer:
  • Export from multiple SQL queries was added
  • Export into single file from multiple tables was added
  • Target file name generation was improved
  • Transaction log: history loading was fixed
  • Dark theme support was improved
  • Optional extensions install was fixed (Eclipse 2018-09 support)
  • Stored procedures calling was fixed for most databases
  • Auto-completion was added to selector controls (comboboxes)
  • New databases:
  • Apache Ignote driver was added
  • MapD (OmniSci) driver was added
  • Dremio database driver was added
  • PostgreSQL: sequences DDL was fixed
  • Greenplum:
  • External tables create/edit support was added
  • GP functions DDL was improved
  • SQL Server: better support of SQL Server 2008 and earlier
  • Oracle: materialized view create/edit/refresh was added
  • DB2 iSeries: driver config was fixed (object descriptions read enabled)
  • SQLite: table DDL reading was fixed (indexes)
  • Eclipse plugin: older Eclipse versions (4.4-4.6) support was fixed
  • Interface localization was improved
  • Many minor UI bugfixes

New in DBeaver 5.3.2 (Jan 8, 2019)

  • 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

New in DBeaver 5.3.0 (Dec 13, 2018)

  • Data editor:
  • Dictionary tables lookup/search was added
  • Grouping panel now supports different presentations
  • Unpin all tabs command was added
  • SQL editor:
  • Auto-completion algorithm was improved
  • SQL formatter was improved (UPDATE, BEGIN/END)
  • Multi-tab context menu was fixed
  • Connection wizard: settings page UI was redesigned
  • Foreign key creation dialog: unique indexes usage was added
  • SQL processing: LIMIT usage was fixed
  • Connection ping (keep-alive) was improved (ping CALLED only during idle periods)
  • FireBird: SQL execution plan analyzer was added (thanks to tomas303)
  • SQL Server:
  • Database objects search was fixed
  • Metadata reading (unique keys) was fixed
  • Table comments editor was fixed
  • DateTimeOffset data type support was fixed
  • New extension requires Microsoft driver only
  • Oracle:
  • Timestamp handling was fixed (for some Oracle server versions)
  • PostgreSQL:
  • Non-default databases are disabled by default
  • Native psql invocation was fixed (for old PG versions)
  • CSV files: columns and foreign keys reading was fixed
  • H2: embedded database shutdown procedure was fixed
  • A lot of minor fixes in UI and metadata processing

New in DBeaver 5.2.5 (Nov 22, 2018)

  • SQL Server (MSSQL) database extension was added:
  • Native SQL Server metadata
  • Table/columns/indexes/constraints editor
  • View/edit objects' comments
  • Connection invalidate/reconnect action was redesigned (now forces reconnect always)
  • Data viewer:
  • Cell rendering was fixed in the plaintext view
  • Data save/reject key bindings were fixed
  • Support of right align for numbers and dates in plaintext view was added
  • SQL editor:
  • Tabs management was redesigned (now all tabs are pinnable and closeable)
  • SQL completion was significantly improved/fixed
  • Additional configuration for SQL formatter
  • Object editor:
  • Problem with "jumping" focus was fixed
  • Links rendering was fixed
  • Checkboxes are now grouped together
  • Data transfer: problem with multiple tables mappings was fixed
  • Read-only connections now restrict metadata edit
  • Driver properties editor UI was improved (password properties masking)
  • Project explorer UI was fixed (header column sizes)
  • PostgreSQL:
  • View and functions rename support was added
  • PostGIS support improved (now supports creation of new geometry values)
  • Data type DDL was added
  • Functions DDL was improved (comments)
  • JDBC driver default version changed to 42.2.5
  • MySQL:
  • Multiple/excluding schema filters were fixed
  • Presto: table elements reading was fixed (performance)
  • DB2 z/OS: driver config was fixed (foreign keys reading)
  • A lot of minor UI fixes

New in DBeaver 5.2.4 (Nov 12, 2018)

  • Results viewer:
  • Ordering confirmation config was fixed (issue with "unsortable" results fixed)
  • Toolbars layout was changed
  • Grid presentation: columns width stretching (fit screen/value) commands were added
  • Plaintext presentation: tabs support was fixed
  • SQL editor:
  • Associated connection info can be placed in the first line of script (can be shared between different users)
  • Unnecessary objects information reading was disabled (completion performance was greatly improved)
  • Auto-completion was fixed (identifier replacement)
  • Use different syntax for store functions and procedures invocation
  • Fix for the "Search inside names" option support
  • Object editor:
  • Property editor form was redesigned/fixed
  • Glitch with jumping cursor fixed
  • Grid visibility config was added
  • Read-only connections detection was fixed
  • Light theme is now default DBeaver theme (instead of Classic)
  • Preferences pages were reorganized. SQL scripts processing pref page was added.
  • Driver selection page: new design (optional)
  • Linked folder/file handling was fixed (do not delete broken links)
  • Data transfer wizard: progress monitor was fixed
  • Greenplum:
  • Functions header/footer was added to DDL
  • Table DDL generation was enhanced
  • SQL Server: procedure names fixed in auto-completion
  • AWS Athena: connection page was fixed
  • ORacle: do not use DBA_* views by default
  • Mock data generation wizard was improved:
  • Possibility to skip columns
  • Column generator settings save/load was fixed
  • Skip auto-generated columns by default
  • Darkest Dark theme support was fixed
  • German language localization update (thanks to Bullnados)
  • Chinese language localization update (thanks to fengchao)
  • Maven configuration was redesigned (now Maven project nature can be used in Eclipse)
  • A lot of minor UI fixes

New in DBeaver 5.2.1 (Sep 30, 2018)

  • SQL editor: highlighting all occurrences of selected word (configurable)
  • DBeaver extensions installer was improved: admin permissions are not required any more
  • Color Theme extension support was added including Solarized Dark/Light themes
  • Problem with upgrade from DBeaver 3.x was fixed
  • Server session manager was improved:
  • UI was redesigned
  • Session manager is now present in Tools menu
  • "Explain execution plan" tab was added
  • Long operations panel was added
  • Oracle: many additional session properties were added
  • RPM package was fixed (with newer RPM packager)
  • Data transfer: option "Selected columns/rows only" were fixed
  • "Read data in SQL console" behaviour was fixed (use SQL scripts instead of console)
  • Extra commands were added to Database navigator context menu: for data edit, ERD, etc
  • Grouping panel was improved: default ordering, duplicates finder, SQL Server syntax support
  • UI for the connection selection dialog was improved
  • Procedures editor was fixed (Generic driver)
  • Results viewer:
  • Columns widths resize issue was fixed
  • Row deletion for custom SQL without unique key was fixed
  • SQL Editor:
  • Paste from source code
  • formatting was improved (line feeds)
  • SQL indentation was fixed (DDL statements)
  • Formatter preferences page was redesigned
  • SQL Workbench formatter was added
  • ERD editor: note delete command was fixed
  • Generic connections (Impala and some others) create was fixed (buttons enablement)
  • Oracle: "Connections has timed out" error was fixed
  • SQL Server: IPv6 hosts support was added
  • Vertica: tables metadata reading performance was greatly increased
  • PostgreSQL: generic (Legacy) driver metadata reading was fixed
  • Redshift/PostgreSQL: array data types support was improved (NULL arrays)
  • Added localization for many UI strings
  • Many minor UI fixes

New in DBeaver 5.1.0 (Jun 11, 2018)

  • 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

New in DBeaver 5.0.5 (May 21, 2018)

  • PostgreSQL procedures debugger was added in CE
  • Search in query history feature was added
  • Query manager view was redesigned
  • DBUnit data export format support was added (thanks to Henrik Hansen)
  • Eclipse Mars (and earlier) support was fixed
  • Foreign key values browser was improved (progress visualizing, values ordering)
  • Results viewer/editor key bindings activation was fixed
  • Results viewer now respects database navigator filters (default column visibility)
  • Results viewer shortcuts (fetch page/fetch all) were changed to avoid conflicts with Linux def shortcuts
  • XLS data exporter was improved (column comments support)
  • SQL formatter was fixed (special characters processing)
  • SQL Editor: auto-completion was fixed for Generic driver (including SQL Server and Informix)
  • Connect, disconnect and invalidate timeouts were added
  • PostgreSQL: view comments and permissions support was added
  • PostgreSQL: asynchronous server output reading is now supported
  • PostgreSQL: schema create was fixed
  • MariaDB: packages support was added, procedures read was fixed
  • DB2: table columns create/edit supports was added
  • Oracle CASE statement parsing was fixed
  • Misc minor UI bugfixes

New in DBeaver 3.0.2 (Nov 19, 2014)

  • 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

New in DBeaver 2.3.7 (Feb 5, 2014)

  • 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

New in DBeaver 2.3.6 (Jan 23, 2014)

  • 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

New in DBeaver 2.3.4 (Dec 17, 2013)

  • 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

New in DBeaver 2.3.2 (Nov 19, 2013)

  • 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

New in DBeaver 2.3.1 (Oct 29, 2013)

  • 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

New in DBeaver 2.3.0 (Sep 27, 2013)

  • 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

New in DBeaver 2.2.5 (Aug 27, 2013)

  • 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

New in DBeaver 2.2.2 (Jun 18, 2013)

  • 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

New in DBeaver 2.2.1 (May 28, 2013)

  • Oracle, MySQL, Cassandra and WMI drivers are now included in standard DBeaver distribution. No need to download these drivers separately.
  • Oracle OCI driver is now obsolete. It is replaced by Thin driver.
  • Data export from query/SQL script fixed.
  • SSH keep-alive support added.
  • Windows installer fixed (extraction worked incorrectly on some systems)
  • Minor UI fixes

New in DBeaver 2.2.0 (May 14, 2013)

  • Multiple result sets are now supported by SQL editor
  • Result set filters has been improved (you may set filter criteria directly in SQL editor/table data viewer)
  • Find/replace support added result sets. Now you may search data right in result set using good old CTRL+F.
  • Metadata (tables/constraints/foreign keys) editor has been improved (you may create complex table structure in UI and then save it in one click)
  • JRE is now included in Windows installers. So there are no system prerequisites for DBeaver if you are on Windows.
  • MySQL TINYINT(1) data type problem fixed, Oracle date/time data type problems fixed, a few minor fixes for SQL Server and PostgreSQL added.
  • Many minor UI bugfixes and improvements

New in DBeaver 2.1.2 (Apr 25, 2013)

  • MS Access driver added (UCanAccess)
  • Drivers download fixed
  • Projects import/export fixed
  • Big Integer values handling fixed
  • Oracle TIMESTAMP formatting fixed (filters)
  • ResultSet UI improvements

New in DBeaver 2.1.1 (Apr 2, 2013)

  • Eclipse 4.2.2 is base platform for standalone version
  • UI freeze during MySQL long queries fix
  • Sort navigator tree alphabetically (configurable)
  • Expand navigator tree on connect (configurable)
  • MySQL enum/set data types handle fix
  • Oracle TNS names load fix (on Linux)
  • Autocomplete fix (SQLite)
  • Cell editor dialog UI fixed
  • Standard commands’ handlers fix
  • Minor UI and functional fixes