2026-10-03

New Features

• Added SSH support with multiple terminal and SFTP browser tabs per connection.
• SSH terminals support colors, Unicode, interactive command-line applications, keyboard and mouse input, text selection, copy/paste, and input methods.
• SSH connection tabs can be reconnected, disconnected, renamed, and pinned.
• charts now show up to 50 rows at a time, with a range selector and background processing progress.
• The desktop MCP server can create, list, monitor, stop, and restart SQL, import, and export tasks.
• MCP clients can manage saved database configurations, inspect open database/editor tabs, and create or select tabs.
• MCP clients can open a database tab from a saved connection, or select its existing tab.
• MCP clients can read and edit SQL editor content, including inserting, replacing, deleting, appending, and selecting text ranges.
• Show column suggestions for unqualified fields in a single-table WHERE clause and fields even there is no alias name for this table.

Fixed Issues

• Reconnect the SFTP server and retry when the connection pipe closes during directory listing.

2026-09-25

Happy Mid-Autumn Festival!

New Features

• Added chart view to FastDataView with pie, line, area, and bar charts, plus copy and PNG download actions.
• The AI assistant can now work with Redis, MongoDB, Kafka, RabbitMQ, and Elasticsearch through SQLife, for example listing databases, collections, topics, queues, and indices, reading data, and running Redis commands.
• Read-only requests no longer need approval, while requests that can change data (such as Redis commands, producing Kafka messages, publishing to RabbitMQ, or creating and deleting Elasticsearch resources) still ask you to confirm.
• When a plug-in is installed or removed, the AI assistant is notified that its available tools changed, so it can use the new tools without reconnecting.
• SQL editor suggestion popups can now find tables and columns by their comments.
• Allow MCP DML and DDL execution when modification access is enabled, with a modal SQLife audit dialog that shows the operation, reason, SQL, and assumed result before execution.
• Add a Reject all audit action that prevents subsequent SQL modifications and informs the AI that execution has been blocked.

Fixed Issues

• Quarantine incompatible saved UI state files so a changed AI tool-call class cannot prevent application startup.
• Keep explicitly selected SQL columns visible in FastDataView even when they are listed in the default hidden headers.
• Fix Oracle result editing while wildcard select is used.

2026-09-19

New Features

• Move the AI model selector beside the send button, make it searchable, and show available models from every provider with a configured API key as provider/model.
• Notify users through the taskbar, Dock, or Linux window urgency marker when an AI response completes or input is required while SQLife is not focused.
• Preserve SQL comments as outline blocks and render Markdown-style headings in the SQL outline view.
• Added a column visibility menu to the data grid's top-left # header, including hidden columns and persistent multi-column toggling.
• Support uploading and downloading complete folders in the SFTP file browser.
• Move SFTP folder trees to collapsible side tabs and provide more space for transfer tasks.
• Added persistent favorite paths with filtering, rename/delete actions, and double-click navigation in SFTP.
• Show caret position in Text Viewer and other viewers, even when the text is not editable.
• Enhanced AI assistant with session management, mcp tools, activity logs, and interactive form ui for pre-checks and confirmations.
• SQL editor suggestions now expand Oracle packages and list their procedures and functions after a package qualifier.

Fixed Issues

• Fixed the Linux system tray failing to start (and logging a GTK "has not been initialized" panic) by using a DBus StatusNotifierItem backend instead of GTK.
• Fixed database column comments missing from the fast data grid's column visibility menu.
• Prompt for a database password when connecting to a server configuration that does not save its password.
• Fixed CSV/TSV data pasted into FastDataView shifting into hidden columns.
• Added MCP SSE heartbeat cleanup and a 32-client connection limit, bounded request size and concurrency, race-safe session expiry, and reliable JDBC resource cleanup when clients disconnect abnormally.
• Fixed MCP server lifecycle leaks by closing SSE clients and database sessions during shutdown, recreating the session cleanup executor after restart, retaining failed disconnects for retry, and releasing JDBC blob resources.
• Reduced high-frequency MCP SSE logging to bounded metadata instead of full request and response payloads.
• Fixed text selection in an editable data-grid cell being replaced by selection of the previous cell when the mouse was released over it.
• Fixed column mode sometimes showing no data after refreshing a query result.
• Fixed FastDataView resetting the selected view mode to row mode after refreshing data.
• Fixed Shift-click table ranges skipping columns or losing cell highlights outside the visible viewport.
• Holding Ctrl/Cmd while opening a view context menu can now run its query in a new SQL editor, matching table behavior.
• Sql Editor context actions now resolve unqualified tables against the current schema instead of the default schema.

Other Changes

• show caret position even when text editor is not editable in text viewer.

2026-08-31

Fixed Issues

• Fixed an issue with upgrade check.

2026-08-29

New Features

• Added the first reusable Guide Framework implementation, including Guide Center support, bundled database connection/query/edit-save guides, provider-backed pre-checks, confirmations, and keyboard debug stepping.
• Added cross-platform "Launch SQLife at startup", "Minimize on startup", and "Close to system tray" preferences using user-level startup entries.
• A native system tray keeps hidden sessions accessible and provides Open and Exit actions.
• Added a Quick Query Palette. Trigger it with the global hotkey Option+Space / Alt+Space (configurable in Settings → Key Mapping, Menu.quickQuery) or via Database → Quick Query. It works against any saved connection (no need to open a database tab) and reopens on the previously used connection. Type @name to switch connections (Enter resolves a partial @postg to the highlighted @postgresql suggestion), a schema.table to auto-run SELECT * FROM ...; (Enter uses the nearest suggestion, so a partial public.emp runs against public.employee; Tab completes the name with the highlighted object), or any SQL to execute it; result sets are rendered in the fast data view. Suggestions and results share a single result area and toggle between each other.
• Support format view in clob and text viewer.
• Added Groovy syntax highlighting to the Text and Clob viewers.
• Support set Snowflake ID in table cell.

Fixed Issues

• Isolated JDBC adapter schema state per backend session to prevent concurrent connections from overwriting each other's default schema.
• Fixed editing data from an unqualified table after changing the session schema. Insert, update, and delete statements now use the JDBC session's current schema when no schema is specified.
• Fixed copying multiple rows as an Oracle-incompatible multi-row INSERT; copied rows are now separate INSERT statements.
• Fixed pasted cell values shifting one column to the right in the fast data grid.
• Fixed Table View cells becoming unselectable after deleting selected rows.
• Improved the Preferences layout on wide and narrow screens.
• Fixed object comments using an unreadable color when their tree item is selected in dark mode.
• Fixed Next/Previous row buttons in the Text, Clob, Blob and Map viewers not navigating when the data was shown in the fast data view.
• Fixed Table View long cell text (especially CLOB) overflowing into the next column until the cell was clicked.
• Fixed Table View cell selection offset when hidden columns are present (clicking a cell selected a leftward hidden column instead).
• Fixed result tab flashing once when clicking a cell in the fast data grid (focus transfer / TabPane focus ring).
• Fixed the tooltip for table and column not hiding itself when user switch to other applications.
• Fixed an issue with MCP server. tell LLM do not create connection by himself but got it from specific interface.
• Fixed an issue with items update in object view. non current schema's object will not be appended into current object list.

Other Changes

• Oracle connections now retry the alternate SID/service-name JDBC syntax and retain the syntax that succeeds.
• The AI assistant chat input is now a multi-line text area that grows with the content, up to 5 rows, and scrolls afterwards. Enter sends the message and Shift+Enter inserts a newline.
• Renamed the Functions tab tooltip to Built-In Functions in all supported languages.
• StatusBar clips comments if it has more than 20 characters. and show all content in tooltip
• Text Viewer and other Viewer window sizes are now remembered across sessions (default 40% of screen size).
• UI improvement.
• Version shows on splash screen.
• Extra information show in Data View.

2026-08-08

New Features

• Added a new style Material Design You.
• identities in SQL editor now support to change case for Oracle™ for now. this option can be changed from connection manager.
• SQL editor suggestion popup can now be triggered manually with a configurable shortcut, default Shortcut+Shift+P. The key can be changed in Settings → Key Mapping (Script.triggerSuggestion). And it also shows when there is no word character before the caret, resolving the table from the from clause (e.g. select <caret> from table1) to list its columns.

Fixed Issues

• Fixed an issue with clearing selecting value of property for connection in connection manager.
• Do not quote built-in functions from suggestion list in SQL editor.

Other Changes

• Tag input component is more friendly to user.
• suggestion in SQL editor now include schema names.
• SQL editor column suggestion for a bare field (without alias. prefix) now also lists matching tables, views and routines, in addition to the columns of the resolved table.

2026-07-31

New Features

• Add XML and JavaScript/TypeScript syntax highlighting support in CellViewText and CellViewClob.
• CellViewClob now uses CodeArea with syntax highlighting and language selector, replacing the plain TextArea.
• Add OpenCode, Grok (xAI), Xiaomi (MiMo), and Moonshot (Kimi) as new AI providers in the ai-connector module.
• Remember the last selected AI model per provider in AssistantView and prefer it when loading available models.
• Use searchable ComboBox in Schema Comparison.
• Add per-workspace full-text search indexing. Supports CJK and content snippet display. Each workspace stores its index in .sqlife-index/. Index status toggle in PrefsWindow per workspace. Search falls back to filename-only mode when index is disabled. All index operations run on virtual threads.
• Add support for SFTP file transfer between local and remote directories. Supports multiple SFTP connections with password or private key authentication. Connection credentials are encrypted with AES and Base64-stored in config. Remembers the last connection per database.
• Add SFTP remote directory browser as a sidebar tab (next to Script tab).
• Use faster data view to show data. speed up rendering for tables with more than 100 columns.

Fixed Issues

• Fixed an issue with empty combo box in Schema Comparison.
• Check whether the database type is supported before connect
• Support editing PostgreSQL bit(n) (n > 1) columns: display/edit as a 0/1 bit string and bind the value with an explicit cast on save so it is not treated as character varying.

2026-07-18

New Features

• Add new file operation for database with file mode.
• Support multiple workspace directories in Script Explorer. Workspaces are stored semicolon-separated in preferences. A ComboBox in ScriptView allows switching between workspaces.
• Add a searchable combobox in SQL History window to filter history by database connection. Default shows all connections.
• Column tables in table property views now support sorting by column name.
• Add a clearable filter TextField in the Columns tab of table property, allowing instant column filtering.
• Add "Add Column" and "Drop Column" context menu items in the column table rows.
• Add MCP SSE link display in Preferences, with context menu to copy link or open in browser. The link updates automatically when the MCP port changes.

Fixed Issues

• Show upgrade required version in plugin downloader.
• Fixed an issue with null column name in data view.
• Fixed Oracle data editing clause not updating column values in DataView after save. allowing DataView to correctly map returned values and mark changes as committed.
• Fixed Oracle index creation syntax for unique index.

Other Changes

• Add native file/folder reveal in file explorer using Rust native library. selects and highlights the file.

2026-07-11

New Features

• Error alert dialogs now include a "Report This" button to collect error info, stack trace, and system context, with user confirmation before submitting to Bitifyware.
• Add feedback dialog under Help menu to submit feedback via Bitifyware issues.
• Import connection configurations from DBeaver (data-sources.json) and Navicat (Windows registry) with preview dialog.
• Support SSH tunnel for database connection.

Fixed Issues

• Escape quote when copying text into sql insert statement from context menu in data view.
• Fixed connection manager save-before-connect flow so clicking Yes persists edited connection settings before connecting (including double-click connect).
• Fixed InfoView rendering for large text by showing clip content instead of object text and adding paperclip open-in-viewer behavior for not-fully-loaded clips.
• Fixed issue with database link query for Oracle.

Other Changes

• Use searchable ComboBox in Database Manager for quick selection.

2026-06-27

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

Fixed Issues

• Properly displayed NClob types.

Other Changes

• Improved the performance of large text selection.