Add optional Apache Kafka plugin support with a custom Kafka dashboard for cluster overview, broker/topic browsing, live message tailing, producing messages, and consumer group inspection.
Overview
Brokers
Pulling Message
Topic
Group
SASL Support
Add optional RabbitMQ plugin support with RabbitMQ server connections, object browsing, and message tailing.
Overview
Nodes
Virtual Hosts
Queues
Exchanges
Pulling Message
Channels
Connections
Remember last file or directory path after using file dialog.
MongoDB plugin uses tree view to show complex property of document.
Support suggestions for functions of current database type in SQL editor.
Support showing built-in function comments in SQL editor tooltip when hovering over function names.
Add new tab for showing built-in functions of current database type with search and insert support.
Fixed Issues
Fixed a stuck issue with upgrading on Linux.
Fixed an issue with array processing.
Fixed an issue with loading data for DuckDB.
Fixed an issue with underline in SQL editor.
Resize width of preview table columns after loading data in data importer.
Other Changes
Improvement of internationalization support.
Improvement of menu icon and tab icon.
2026-06-13
New Features
Add optional Apache Kafka plugin support with a custom Kafka dashboard for cluster overview, broker/topic browsing, live message tailing, producing messages, and consumer group inspection.
Refactored MongoDB plugin
Support more editing buttons in toolbar for MongoDB scripts.
Support querying multiple collections in one workbench.
Support viewing collections in different mode(list/table/markdown/json)
Support exporting collection data in JSON/Excel/Markdown/XML.
Add MongoDB server info retrieval and enhance UI with connection details
Support view attributes of document by gathering first 100 documents of collection
Support cell copy with different condition in table mode.
A locks monitor for supported databases like Oracle, PostgreSQL, MySQL, MariaDB, DB2 and SQL Server, this is a preview feature, currently only support showing locks in Object View, and will add more features in the future.
Support Find & Replace in MongoDB editor and Redis editor.
Fixed Issues
Fix value update in connection properties .
Other Changes
Plugin updating includes check for required main version.
column sorting in suggestion list is aggregated by table name only (ignoring database identifier and schema).
2026-06-02
New Features
Add Locks View for PostgreSQL and other databases with lock information in Object View.
2026-06-01
New Features
Support DPI scaling on Linux(Although not perfect yet, tested on Ubuntu 24.04 X11).
Schema Comparison options are now scrollable, can normalize identifier case for YAML export, and generate DDL-based diff SQL for supported views, routines, triggers, and packages while skipping object types unsupported by the target database.
Other Changes
Plugin downloads now declare a minimum required SQLife version, show that requirement in Plugin Manager, and block installation when the running application version is too old.
Fixed Issues
Fixed an issue with deleting default catalogue in Database Manager.
Fixed Oracle Data View by appending real ROWID only after metadata confirms the target object is a physical table (not view/synonym).
2026-05-30
New Features
Add optional MongoDB key-value plugin support with MongoDB server connections, database/collection browsing, and document editing tabs.
Add optional ClickHouse plugin support with ClickHouse JDBC connections, JDBC URL import parsing, object browsing, DDL loading, and query execution.
Add optional Databricks plugin support with Databricks JDBC connections, JDBC URL import parsing, schema/object browsing, DDL loading, and query execution.
Add optional IBM Db2 plugin support with DB2 server connections, JDBC URL import parsing, DB2 object browsing/query helpers, and DB2 test fixtures for local validation.
Add optional Snowflake plugin support with Snowflake JDBC connections, JDBC URL import parsing, schema/object browsing, DDL loading, and query execution.
Add column selection priority memory in SQL Editor suggestions, with a Preferences toggle and per-table weighting that adapts to recent usage.
Compare database objects and show diffs in editor.
Check plugin update and show a notification when a new version is available.
Fixed Issues
Fixed an issue with loading definition of table with clob column for Oracle.
Fixed an issue with editing data in column mode in DataView.
Fixed DataView column header context menus so the clicked column stays correct after horizontal scrolling.
Fixed Table Property save SQL for DuckDB so table changes generate dialect-specific ALTER statements instead of empty diffs.
Other Changes
A real ROWID column is auto-added only for Oracle plain table selects with simple column or wildcard items, and bare * is rewritten with a table alias (without AS) for Oracle compatibility.
2026-05-23
New Features
Support for HiDPI displays on Windows.
Support for Redis by plugin. with features: Object View, Data View, and executing command.
Support DuckDB object browsing in Object View by listing extensions with installation metadata, plus functions, types, and secrets, with delete actions for DuckDB types and secrets.
Add a folder-based connection mode for Apache Derby and HyperSQL embedded databases, including creating a new database folder from the chooser flow.
Fixed Issues
suppress error message when fetching models lack of LLM provider key.
Fixed an issue where Windows DPI/display changes could leave the UI stale or missing after display power/state changes.
Fixed DuckDB SQL execution error handling by rolling back the current transaction when statement execution fails.
Fixed DuckDB object browsing and DDL loading for sequences, functions, types, indexes, and secrets.
Fixed DuckDB change detection so read-only statements like PIVOT no longer leave the session marked as having uncommitted changes.
Fixed DuckDB result conversion in Data View so BLOB values are wrapped as BlobClip instead of exposing raw JDBC driver objects.
Fixed an issue with empty schema name for Apache Derby.
Fixed an issue with test connection for plugin-based databases.
Other Changes
Improved the integration with AppStore In-App Purchase on macOS.
Support Microsoft Store in-app purchase for MSIX distribution on Windows.
Improved the performance when querying objects from Oracle.
PL/SQL block executing will be regarded as a uncommited transaction.
Use SaveFile Dialog to replace FileChooser for file mode database. support to create new database file if not exist.
2026-05-10
Love to mothers all around the world! Happy Mother's Day!
New Features
Support fixing error statement in Sql Editor with AI.
Add copy options for XML and Java code to context menu of Sql Editor.
Support copy location/column comment from status bar.
Other Changes
Only simple select statement will have virtual rowid column for databases except Oracle.
2026-05-03
Fixed Issues
Fixed an issue with freezing when opening preferences on Linux.
2026-05-02
New Features
Add Agent to do tasks. introduce OpenAI, DeepSeek and Ollama as provider.
State saving for AI conversations.
Fixed Issues
Fixed an issue with locking of table when executing query statement for PostgreSQL.
Fixed an issue with locking of table when executing query statement for MySQL and MariaDB.
Fixed an issue with changing table in Table Property for Apache Derby and HyperSQL.
Fixed an issue with saving changes of Table Property for SQLite.
Fixed an issue with object filtering in Object View for HyperSQL.
2026-04-26
Fixed Issues
Fixed an issue with mode toggle in Connection Manager.
Fixed an issue with editing row with complex column for Oracle.
Fixed an issue where hardware ID collection could hang indefinitely if an OS command got stuck.
Fixed an issue with getting definition from table in SQLite.
Fixed an issue with executing SQL from mcp server.
Other Changes
Plugin is changed. not capable with previous version. if you encounter any issue with startup. please delete the plugin folder in ${user.home}/.sqlife/plugins and restart the application.
Improve integration for Model Context Protocol.
Release connection resource after MCP client disconnect abnormally.
2026-04-19
New Features
Add MCP (Management Control Port) server. in localhost:{port}/mcp.
Support H2 memory mode.
Support hiding specific columns in an Editor session.
Reinstall plugin is available in Plugin Manager.
Fixed Issues
Fixed an issue with TableProperty of MS SQL Server.
Fixed an issue with creating index of Oracle.
Fixed an issue with creating or changing index of PostgreSQL.
Fixed an issue with changing comment of MySQL and MariaDB.
2026-04-11
New Features
Add Oracle Scheduler Chain support: Chain List (grouped by owner in TreeView), Chain Detail (name, enabled, comments), Create Chain, Delete Chain via context menu, and manage Chain Steps (add/drop steps with program assignment) in a new Chains tab.
Add partition toolbar actions in Table Property and support copying add-partition SQL for PostgreSQL, MySQL, MariaDB, and Oracle.
Add Daily Tips feature: shows a tip window on startup (Help → Daily Tips) with Previous/Next navigation.
Add tip ticker in the main window status bar: shows a random tip every 60 seconds when no other message is active.
Add configurable SQL Editor shortcuts for line move (Alt+Up/Down).
In Sql Editor, remap shortcuts so Ctrl/Cmd + D deletes current line and Ctrl/Cmd + Alt + Down clones current line.
Add reusable nested-table viewer stage in MainWindow and load nested DbData into it to avoid recreating nested TableView controls per cell.
Add Plugin Manager to manage optional plugins, and move some features into plugins.
Move Apache Derby desktop/web support out of the core app and into the optional db-derby plugin.
Move HyperSQL desktop support out of the native app and into the optional db-hsqldb plugin.
Show database information for multiple databases.
Fixed Issues
Fixed diff row highlighting in File History and Schema Comparison so added/deleted/changed line colors follow the active light or dark theme.
Fixed MySQL/MariaDB DDL statements (e.g. ALTER TABLE ... DROP COLUMN) causing the application to freeze indefinitely.
Fixed an issue with money type for PostgreSQL.
Fixed SQL splitter issues for Oracle package/package body scripts: prevent early termination on / used as division operator and ignore semicolons inside SQL comments when splitting statements.
Fixed an issue with state saving. ask for unpinned tab first. then close all tabs.
Show configured shortcuts in database toolbar button tooltips and refresh them after key mapping changes in Preferences.
Fixed an issue in Sql Editor where moving a line down to the last line by Alt + Down appended text instead of swapping lines.
Fixed an issue with integer column length for MySQL and MariaDB.
Fixed an issue with operating table with upper/lower case name for MySQL and MariaDB
Fixed an issue with quote/unquote table name for MySQL and MariaDB.
Fixed an issue with tooltip during scrolling in ObjectView
Other Changes
In File History compare view, stop showing placeholder text for aligned diff lines; use visual empty lines instead with red(deleted)/green(added) highlighting.
Move Preferences from a separate dialog window into a tab in the main tab pane, with behavior similar to TaskView.
Use legacy html render to replace WebView. reduce memory usage and size of installation package.
Show context menu for right-click on table column of Data View. not sorting by default.
tinyInt1IsBit of MySQL and MariaDB set to false by default.
Improve file diff for file in workspace.
2026-03-15
New Features
Show task log in TextArea in TaskView.
Add clone menu in context menu of Sql Editor.
Add query or edit data in new tab in context menu of Object View. with shortcut Ctrl/Cmd + Mouse Primary Click.
Add SQL/JSON/YAML syntax selection in Text Viewer by switching from TextArea to CodeArea.
Save and restore filter text in Object View when switching schemas.
Add "Close Tabs to the Left" and "Close Tabs to the Right" actions in tab context menus.
Fixed Issues
Fixed an issue causing IllegalArgumentException: No group with name in Text Viewer syntax highlighting.
Improved JSON/YAML syntax styling in Text Viewer by adding a dedicated property-name class.
Save and restore Object View filter text per schema while switching schemas.
Fixed an issue with insert error for MS SQL Server in Data View.
Other Changes
Add Connection name in TaskView.
Validate connection before restarting task in TaskView.
2026-03-07
Fixed Issues
Fixed an issue with data exporting array for H2 and HyperSQL.
Fixed an issue with data exporting XML type for Oracle.
Fixed an issue with query data for HyperSQL.
Avoid of aborting transaction when error occurs for PostgreSQL
Fixed an issue with editing data in table with hidden columns for Oracle.
Fixed an issue editing data in tables with Oracle ROWID/LONG columns. User-created ROWID values cannot be
returned, and LONG is a legacy type; avoid creating it whenever possible.
Fixed an issue with clipping data in Clob and Blob View type.
New Features
Support custom type in Object View for Oracle and PostgreSQL
Add Popup Outline View by shortcut key Ctrl/Cmd + Shift + O in Sql Editor.
2026-03-01
Fixed Issues
Fixed an issue with for-clause query for SQL Server.
Use Fixed digit length to express timestamp nanoseconds.
Fixed an issue with explain sql for MariaDB.
Fixed an issue with shortcut setting in Preferences.
New Features
Use TaskView manage Object Export, Data Export/Import, Sql Execution tasks. run these tasks in background and show progress in TaskView.
Other Changes
8 connections for free version now.
2026-02-15
Happy Lunar New Year!
Fixed Issues
Fixed an issue with H2 view definition in Object View.
Fixed an issue with H2 data exporting in Data Exporter.
Fixed an issue with disable/enable index/constraint in Object View for MS SQL Server.
Fixed an issue with drop index for MySQL and MariaDB in Object View.
Append Trigger definition in Object View for MySQL and MariaDB.
Fixed an issue with context menu of Object View.
Fixed an issue with dropping trigger for SQL Server in Object View.
Fixed an issue with constraints and indexes for HyperSQL in Object View.
Other Changes
Hide compilation menu for databases except Oracle in Object View.
2026-02-11
Fixed Issues
Fixed an issue with editing column and constraint in Table Property for various databases.
Fixed an issue with query metadata for SqlServer in Sql Editor.
Other Changes
Support check constraint for MySQL 8.0+ in Table Property.
Finish table modification in Table Property for SqlServer.
2026-02-09
Fixed Issues
Fixed an issue with item toggle in context menu of Object View.
Fixed an issue with editing column in Table Property for MySQL and MariaDB.
Fixed an issue with editing column and constraint in Table Property for Apache Derby.
Other Changes
Improved the UI of Table Property.
Add language: Portuguese, Arabic, Turkish.
Remove Add/Drop buttons for Sqlite in Table Property, as SQLite does not support alter table statement for adding/dropping column.
2026-02-07
New Features
Support for H2 database file mode.
Support for HyperSQL database file mode.
Support import database connection from JDBC URL.
Fixed Issues
Fixed an issue with icon color in context menu of Object View.
Fixed an issue with icon font size in context menu of Data View.
Use correct connection properties for Apache Derby.
Set unCommitted status after execute sql in Apache Derby.
Fixed an issue with loading connections in Database Manager. avoid of restoring state again.
Fixed an issue with editing data for H2 database.
Fixed an issue with editing data for MariaDB database.
Fixed an issue with editing data for MS SQL Server database.
Fixed an issue with editing table index.
Fixed an issue with table property of HsqlDB.
Other Changes
Improved font color of Database tab under Dark Mode.
Improved UI of Table Property.
2026-01-31
Fixed Issues
Fixed a memory leak issue in Data View.
Fixed a line delimiter issue in Data View.
Other Changes
Add context menu for some components.
Improved website introduction.
2026-01-24
New Features
Support for H2 database server mode(Preview).
Support for HyperSQL database server mode(Preview).
Support for Apache Derby database(Preview).
Fixed Issues
Fixed an new file issue after reconnecting to database.
Fixed an issue with sql parsing for MySQL.
Fixed an memory leak issue in Data View.
Other Changes
clear outline after reconnecting to database.
2026-01-10
New Features
Support navigation between Sql Editors by Ctrl/Cmd + [Shift]+ Tab.
Use tags to filter objects in Object View. Objects will be shown when any tag matches.
Support show outline for HyperSQL.
Fixed Issues
Fixed an issue about navigation on outline view by keyboard arrows.
Fixed an issue about connection test for SQLite.
Fixed an issue about export data for SQLite.
Other Changes
Show view definition when holding a non-table field.
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.