Support show outline for Apache Derby, MySQL, MariaDB, Microsoft SQL Server, and SQLite in Sql Editor.
When clicking an item in the outline, move the editor's scrollbar to display the item at the top line.
Support shortcut for Sidebar. default is (Ctrl/Cmd + 1/2/3).
Fixed Issues
Fixed an issue with context menu on database object.
Other Changes
Improve user experience in find&replace in Sql Editor.
2025-12-28
New Features
Support show outline of PL/SQL package in Sql Editor for Oracle.
Other Changes
Pull back changes of 2025-12-27 to fix an issue with restarting application after upgrading.
2025-12-27
Fixed Issues
Fixed an issue with executing Oracle package.
Other Changes
Support Restarting application after upgrading on Windows and Linux.
2025-12-21
Fixed Issues
Fixed an issue with write and read problem when there are duplicate column names in Data View when query contain join statement.
Other Changes
Show proper icon for different type of message.
2025-12-12
Fixed Issues
Fixed an issue with column sorting in Data View for empty cell.
Use raw numeric values during copying data in Data View.
Other Changes
Save log files to user home directory.
Ignore ROWID column during copying data for various formats in Data View.
Submit issues to tracker site(need permission from user first)
Cancel long-running sql execution gracefully.
2025-12-07
New Features
Support editing data in DataView for Sqlite
Support copy message on bottom bar.
Support change encoding in Sql Editor.
Fixed Issues
Fixed an issue with open definition of view in Sql Editor for Oracle 11g and lower version.
Fixed an issue with font height in Sql Editor.
2025-11-29
New Features
Support show dbms_output in Sql Editor for Oracle.
Fixed Issues
Fixed an issue with navigating in Sql Editor by Find & Replace.
Other Changes
Improved editing experience in Sql Editor.
Fix color of Script Explorer under Dark Mode.
2025-11-22
New Features
Support geography type for PostgreSQL in Data View.
Add camelCase text conversion to Edit menu with dictionary-based word splitting.
User can get "add comment of column statement" in Table Property.
Document of tables can search any word.
Fixed Issues
Selection/Highlight Rendering Fix.
Improvements
Sql Editor show text and selection more stable.
Saving state only work when application is in front of user.
2025-11-19
New Features
Object Browser, Object Exporter, Data Exporter, Data Importer, Table Property, Oracle Scheduler and Sql Executor support recovery state.
Support preview change statements before saving in Data View.
Improvements
Use disk drive as cache. reduce memory usage.
2025-11-18
New Features
Support search table in DocViewer.
Improvements
Warn user before closing tab when DataView have no unsaved changes.
2025-11-17
New Features
Support highlight square, curly, and angle brackets in SQL Editor.
Fixed Issues
Fix an issue with pasting SQL statement from MyBatis XML
Fix an issue with saving state when editing tab name of Database/Editor
Fix an issue with highlighting brackets in SQL Editor
Improvements
Save more states for restore Database.
Add a clear button in filter text field of Object View/History Window.
Use object name of first sql statement as tab name when create new Editor from sql file.
Ignore ROWID column in Data View for Oracle. ctid for PostgreSQL.
2025-11-11
Fixed Issues
Fix an issue with editing number in Data View for null value.
Fix an issue with saving database connection.
Fix an issue with recovering unsaved state after Editor created.
2025-11-08
Other Changes
Improve internalization of UI components.
Improve performance of loading comments in Sql Editor.
Improve performance of loading objects in Sql Editor suggestion box.
Fixed Issues
Fix an issue with exporting view DDL for Oracle.
2025-11-07
Other Changes
Refactor schema handling in AbstractBench, Database, ExplainBench, MainWindow, and WorkBench classes to streamline method signatures and improve state management.
Refactor ObjectBrowser to simplify schema selection handling and remove unused reset method.
Optimize OracleWorker for improved query performance and exclude specific schema owners.
Fixed Issues
Fix: add access check for DBA_RSRC_PLANS before querying resource plans.
Fix TableProperty tab styling when updateSql generates no changes.
2025-11-04
New Features
Support showing comment of table and column in Sql Editor.
Support Microsoft SQL Server(Preview).
Support for MariaDB is in production.
Improvements
Improved selecting schema experience in several components.
Show icon for different object types in Suggestion Box of Sql Editor.
Save current schema in state for restoring after restart.
Improved performance of loading objects in Object Explorer.
Fixed Issues
Fixed an issue with status bar when no editor opened.
Fixed an issue with init default schema in Sql Editor.
Fixed an issue with date type conversion in Data Importer.
Fixed an issue with type of data queried from H2 database.
Fixed an issue with concurrent modification in local session.
Fixed an issue with loading objects in Object View after changing table.
2025-10-29
New Features
Add Object Window to search database objects.
Sql Editor support showing line under identifier by mouse hover with shortcut(Win/Cmd key).
Sql Editor support showing table context menu by mouse primary click with shortcut(Win/Cmd key).
Data View support showing data in Markdown format.
Data View support exporting data in Markdown format.
Show current schema in status bar, and support changing schema.
Other Changes
Text Filter in Object View now search objects locally first.
Improve Mode Toggle in Data View
2025-10-25
New Features
Support MariaDB(Preview version)
Support restoring state of pin tab after restart.
Support restoring state of tab after crash or unexpected exit.
Detect changes of file after Workbench is active.
Paste string from XML and JAVA code.
Fixed Issues
Fixed an issue with Explain Plan.
Fixed an issue on preview data from sheet table.
Fixed an issue with end symbol in Oracle explain plan.
Filter sequences which is owned by serial column in Object Exporter for PostgreSQL.
Fixed an error on trigger definition for postgreSQL.
Fixed an error on detecting changes of file.
Other Changes
Improved the user experience during selecting schema.
Support reconnect to database in SQL Editor(context menu on tab)
Show file absolute path in tab tooltips
All columns alignment to left, make UI more consistent.
Use Material Design Icons.
Speed up loading of application.
Improved charset detection when open file.
Improved loading animation when loading object in Tree View.
Export Triggers associated with table in Object Exporter for PostgreSQL and Oracle.
2025-09-19
Fixed Issues
Fixed an issue with color of prompts in TextArea and TextField under Dark Mode.
Fixed an issue with accident recovery during the second instance started.
Fixed an issue with executing SQL in SQL Editor.
Other Changes
Removed Ctrl+H(deletePreviousChar) shortcut for SQL Editor on non-mac platform.
2025-09-17
Fixed Issues
Fixed an issue with executing comment statement in SQL Editor.
Fixed an issue with number configuration in Database Manager.
Fixed an issue with capturing of table name in context menu in SQL Editor.
Fixed an issue with global menu accelerators in macOS.
Other Changes
Update default configuration for Oracle/PostgreSQL/MySQL.
More precise configuration for Oracle/PostgreSQL/MySQL in Database Manager.
Use CheckComboBox to improve UI of Table Property.
Add Validation to TextField in Database Manager.
2025-09-11
New Features
Support add schema to favourite collections in Object View.
Add column type and comment in column mode of Data View.
Fixed Issues
Fixed an issue with editing data in Data View for table with complex name.
Other Changes
Improved the performance of loading data in Data View.
2025-09-05
Fixed Issues
Fixed an issue with Clob type in Data View.
Other Changes
Improved UI of Database Documentation.
2025-09-04
New Features
Support view documentation of tables.
Fixed Issues
Fixed an issue with creating new editor by clicking blank area of tab bar.
2025-08-26
New Features
Support inheritance table for PostgreSQL.
Fixed Issues
Fixed an issue with cell description in bottom bar. replace line break with space.
Fixed an issue with comment syntax highlighting in SQL Editor.
Fixed an issue with disable/enable partition tab in Table Property.
Other Changes
Accelerate loading of results.
Get index types according to storage engine for MySQL.
2025-08-19
New Features
Support canceling long-running generating in Share Window.
Support interval refresh in Data View.(by context menu on refresh button)
Fixed Issues
Remove duplicate error dialogs in exporting.
Fixed an issue with reload data in Data View.
2025-08-14
Fixed Issues
Fixed an issue with sharing HTML/PNG.
2025-08-13
New Features
Support exporting data to ZIP format in Data Exporter.
Support sharing HTML/PNG over the local network in Data View.
Support sharing HTML/PNG over the Internet in Data View(need an account).
Support Querying share history and delete history.
Fixed Issues
Fixed an issue with insert data in the Data View, if a column value is null, ignore it.
Fixed an issue with concurrent operation in Object View.
Only Oracle supports disable and enable index/constraint in Data Exporter.
Fixed an issue with duplicate items in Data Exporter.
Do not use property which is empty or null in connection.
Other Changes
Improved the performance in Querying Objects.
Improved the mechanism of the SQL Editor. it will initialize first before statement loaded. and show busy status while loading.
Open folder after exporting file in Data View.
2025-07-29
Fixed Issues
Fixed an issue with Add Column Statement in Table Property for Oracle.
Fixed some issues with SQL generation for Oracle.
Other Changes
Add confirm dialog before deleting a partition in Table Property.
2025-07-22
New Features
Added partition support for Oracle.
Property
Definition
Exporting
Change name
Add/Drop partition
Get create statement of partitioned table
Added partition support for MySQL.
Property
Definition
Exporting
Get create statement of partitioned table
Added partition support for PostgreSQL.
Property
Definition
Exporting
Change name
Add/Drop partition
Get create statement of partitioned table
Fixed Issues
Fixed an issue with sorting in the Data View.
Fixed an issue with executing PL/SQL command in the SQL Editor.
Fixed an issue with DateTimePicker in the Data View.
Other Changes
Enhanced dark themes. Correct some controls' color in dark mode.
Enhanced dark themes, Upgrade window, and it's webpage information have dark mode.
Optimized DDL of MySQL table.
2025-07-19
Fixed Issues
Fixed an issue with the sql splitter in the SQL Editor.
Other Changes
Enhanced dark themes. correct some controls' color in dark mode.
2025-07-18
New Features
Add clear button in Object Exporter/Data Exporter.
Enhanced the Connection Properties in Database Manager. specific different controls for different property type. User can select file for some properties.
Fixed Issues
Fixed an issue with shortcut capture in Preferences.
Other Changes
More friendly pagination in Sql History Window.
Enhance dark themes for selected tree cell in Object View.
2025-07-16
New Features
Support HTML export in the Data View.
Support PNG export in the Data View.
Support highlight range in SQL Editor.
Support associating Data View and sql statement in the SQL Editor.
Fixed Issues
Fixed an issue with pasting date and real value in the Data View.
Fixed an issue with displaying of new row and disabled row in Table Property under Dark Mode.
Fixed an issue with char/byte column type in Table Property for Oracle.
Fixed an issue with login failed when connecting to database.
Other Changes
Improve tab icon color in dark mode.
Create a new explain editor from database toolbar.
2025-07-11
New Features
Added foreign key support for PostgreSQL.
Enabled pasting from the clipboard in Table Property cells.
Added SQL generation for adding or altering columns, constraints, or indexes in Table Property, useful for table upgrades.
Introduced a text dialog to support multiline column comments in Table Property.
Fixed Issues
Fixed a color issue with SQL generation in Table Property.
Fixed an issue with function indexes for PostgreSQL.
Other Changes
Improved SQL keyword highlighting in the SQL Editor.
Updated options for different database dialects in Object Exporter.
2025-07-08
New Features
Added support for highlighting identifiers in the SQL Editor.
Fixed Issues
Fixed an issue with dark mode.
Other Changes
Improved the upgrade process.
2025-07-06
New Features
Added support for the dark theme.
Fixed Issues
Fixed an issue with the char/byte column type in Table Property for Oracle.
Fixed an issue with XML/JSON export in Data View.
Fixed an issue with SQL generation in the Table Property dialog.
Other Changes
Improved the performance of Explain Plan.
Improved the UI of Database Manager.
Enhanced interaction with Table Property.
Added support for IME position in the SQL Editor on Windows.
2025-06-28
New Features
Added support for MySQL 5.5+.
Supported Objects:
Tables
Views
Procedures
Functions
Triggers
Events
Table Property
Executing Plan
Data View
Export/Import
Added an option to remember SQL history in SQL Executor.
Added a Keep Alive option in JDBC connections.
Fixed Issues
Fixed missing details in the executing plan view.
Fixed mixed tabs and spaces in the unindent operation.
Fixed issues with constraint columns in PostgreSQL Table Property.
Fixed an issue with the generated ALTER COLUMN default value statement in the Table Property dialog for Oracle.
Other Changes
Improved indentation regulation in the SQL Editor.
Set prefWidth according to the label width of the column if there is no data in the table.
Used the connection identifier of the database link as comments.
2025-06-20
New Features
Added support for key mapping.
Other Changes
Improved comment/uncomment operations in the SQL Editor.
Improved indent/unindent operations in the SQL Editor.
Changed the default key mappings for indent/unindent.
Sorted connections by type, host, and name in Database Manager.
Redesigned the Database Manager UI.
2025-06-17
New Features
Added support for Oracle Scheduler.
Fixed Issues
Fixed an issue with the extension menu for PostgreSQL in the Object View.
Prevented pasting actions in the Data View when the table is not editable.
2025-06-13
New Features
Displayed PostgreSQL extensions in the Object View.
Fixed Issues
Fixed an issue with SQL generation in the Table Property dialog.
Other Changes
Used a background task to restore SQL history during upgrades, reducing waiting time for the first start after an upgrade.
Removed disable/enable menus in the Object View for PostgreSQL, as they are not supported by the database.
2025-06-08
Fixed Issues
Fixed an issue with the exit check.
Fixed an issue with displaying the ResultSet view when there is no ResultSet in Data View.
2025-06-06
New Features
Added tooltips to the database tab for user and identifier information.
Displayed data types in the column candidate list in the SQL Editor.
Added support for fractional seconds in timestamps.
Automatically sorted connections by host and name.
Fixed Issues
Fixed an issue with the object list in the SQL Editor.
Fixed an issue with refreshing in Database Manager.
Fixed an issue with editing in the Data View.
Fixed issues with XML and TSV export.
Other Changes
Normalized SQL keywords to lowercase.
Set the default value of ReadTimeout or SocketTimeout to 0 to disable timeouts in JDBC connections.
2025-06-02
New Features
Cleared recent files when unchecking the "Save Recent Files" option.
2025-06-01
New Features
Added support for copy/paste in the Data View using the HTML table format.
Fixed Issues
Fixed an issue in the Object View when loading children.
2025-05-28
New Features
Added auto-indent support for the SQL Editor.
Added support for Oracle TIMESTAMP WITH (LOCAL) TIME ZONE.
Brought the Database/Editor to the front when closing the database or application.
Added support for cloning rows in the Data View.
Fixed Issues
Fixed selection issues in the SQL Editor.
Fixed an issue with the preferences dialog.
Fixed an upgrade issue on Windows.
Fixed issues with index/constraint creation in the Database Editor.
Fixed an issue with opening links on Linux.
Fixed an issue with sequence DDL errors.
Fixed an issue with no input method on the text field in Table Property.
Fixed an issue with missing materialized views in the Export Objects View.
Other Changes
Improved DDL generation for PostgreSQL.
2025-05-21
New Features
The Object View now remembers the last expanded folder and reloads children after schema changes.