2026-01-01

Happy New Year!

New Features

• 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.

Fixed Issues

• Properly displayed NClob types.

Other Changes

• Improved the performance of large text selection.