Skip to content

Pro Changelog

⚠️ Windows automatic update notice (5.3.5 and 5.3.6-beta.2): In-app updates may fail when the installation directory name contains spaces, such as Chat2DB Pro. Rename the installation directory so it contains no spaces before updating. This issue was fixed in 5.3.6-beta.3.

5.3.7

2026-09-22

  • 🔥【New Feature】Import preview, field mapping and basic configuration: CSV, XLS, XLSX, JSON and SQL imports can be previewed before they run, the mapping between source and target fields can be adjusted, individual fields can be skipped, and unmapped fields can take a default value or NULL. CSV supports the file encoding, delimiter, quote and escape characters, header and data row ranges, null handling and date/number formats; Excel/XLS select the worksheet, header row, first and last data row and the column range, treat empty fields as NULL, and set the date, time and decimal formats for text cells; JSON selects the encoding, the data structure (array of objects, single object, JSON Lines) and the data node path, and can skip individual nested fields; SQL supports a file encoding (detected automatically or given explicitly, such as GBK). The preview and the import run use the same options, so the mapping shows what is imported.
  • 🔥【New Feature】Ultra-fast CSV import mode: after the file preview an "Ultra-fast mode" can be enabled, which imports in parallel batches over a dedicated connection and adapts concurrency and batch size to the measured throughput; a failure or cancellation cancels the registered statements and waits for every worker to stop, and the standard mode stays the default.
  • 🔥【New Feature】Oracle EXPLAIN PLAN shows the execution plan: the statement runs under a generated statement id, the plan is read back from PLAN_TABLE through DBMS_XPLAN.DISPLAY and returned as a result set; a missing PLAN_TABLE reports an actionable message, and EXPLAIN PLAN ... INTO <custom table> still goes to the database.
  • ⭐【Optimization】Desktop updates are more reliable: a downloaded update is kept when the application restarts or checks for updates again, so it installs without downloading again and also works offline (a beta update is no longer discarded after a restart); on macOS the update helper runs independently of the application so the update survives the application closing; an install that replaces the whole package restores and reopens the previous version when an update fails; on Windows the installer falls back to a compatible launch mode and keeps the original installation directory when the automatic install cannot start. Repeated clicks on "Check for updates" send a single request, the button shows a loading state, and a check reports its result at most once; an unreachable update source reports a failed check instead of "no new version available".
  • ⭐【Optimization】Update Time column in the table list: shown after Create Time, left empty when unknown, translated in all five languages.
  • ⭐【Optimization】SQL execution log filtering: records can be filtered by data source, database, schema and SQL content, and the available filters follow the capabilities of the data source.
  • ⭐【Optimization】More reliable task center polling and paging: records are merged by id and update time, terminal states and already loaded history are kept, responses that arrive after a task was deleted or the panel was closed are dropped, a failed load ends the loading state with a retryable error, tasks cancelled abnormally no longer stay in RUNNING, and cancelling a task no longer cancels the same statement twice.
  • ⭐【Optimization】MCP token reset is serialized: a reset shows a busy state, repeated clicks no longer create several tokens, and a stale callback no longer overwrites the newest token.
  • ⭐【Optimization】Editable results for single-table subqueries: queries such as SELECT * FROM (SELECT * FROM APP.EVENT_LOG ORDER BY CREATE_TIME DESC) WHERE ROWNUM <= 100 now resolve the physical table key, so the result set can be edited directly and a single row can be located.
  • 🐞【Fixed】Fixed Redis key updates falling back to string commands that delete and recreate the key when the old or new key type is missing or unknown; an error is reported instead.
  • 🐞【Fixed】Fixed ClickHouse connection failures when a database name contains spaces or special characters, and wrong connection parameters when switching databases.
  • 🐞【Fixed】Fixed row identification when editing a table without a primary key on CockroachDB: updates and deletes use the native LIMIT 1 form and keep the original row predicate instead of PostgreSQL's ctid.
  • 🐞【Fixed】Fixed create-database failures on Redshift, and Redshift / CockroachDB now stop after the first failing statement when creating a database or schema, so a duplicate-name error no longer overwrites an existing database comment.
  • 🐞【Fixed】Fixed Informix SQL syntax errors when renaming a table, changing a column or reading the execution plan, and wrong owner references and character type aliases; column changes now validate constraints first instead of silently removing constraints or foreign keys.
  • 🐞【Fixed】Fixed SQL syntax errors when viewing view, function and stored procedure definitions on DB2.
  • 🐞【Fixed】Fixed table data paging on DuckDB failing from the second page on; pagination uses LIMIT … OFFSET instead of the comma syntax DuckDB does not support.
  • 🐞【Fixed】Fixed JSON imports failing on empty records, and a missing field and an explicit null are now distinguished; both are written as SQL NULL.
  • 🐞【Fixed】Fixed import failures reporting only a generic error: a failed CSV, XLSX, XLS, JSON or SQL import now names the setting that caused it (encoding, data node, file row or column, duplicated source field, column range, row range) or reports the database error class with its SQLState and error code.
  • 🐞【Fixed】Fixed exports overwriting a file with the same name: an occupied name falls back to a numbered available name, and a failed copy is rolled back and cleaned up on the next start.
  • 🐞【Fixed】Fixed deleting a finished task leaving task records or export files behind when the application exits or a file operation fails; the cleanup continues after a restart.
  • 🐞【Fixed】Fixed the dashboard list not loading more when scrolled to the bottom and throwing an index error for an oversized page number; a failed request now shows a retryable error state while keeping already loaded data, and a failed refresh no longer leaves the dashboard loading forever.
  • 🐞【Fixed】Fixed console records and table data paging wrapping around or throwing IndexOutOfBoundsException for a very large page number; offsets are computed with long arithmetic.
  • 🐞【Fixed】Fixed a corrupted metadata cache making a database or its table structure unopenable: only the damaged key is removed and the cached value is rebuilt.
  • 🐞【Fixed】Fixed a failed save showing the change as saved and reverting it after a refresh: data source order, namespace position, ER-diagram position and small data writes are persisted before memory is updated.
  • 🐞【Fixed】Fixed saving twice quickly creating duplicate data sources and a failed drag or move showing a wrong position; a data source created from the group menu now expands the group and locates the new connection, hidden settings are kept when the tree is refreshed, and a successful save is no longer reported as failed when the refresh fails.
  • 🐞【Fixed】Fixed an invalid filter or sort condition closing the editor: the previous result is kept and the query can continue after the condition is fixed or cleared.
  • 🐞【Fixed】Fixed broken table and view suggestions for @ in AI input, and stale suggestions after switching data sources.
  • 🐞【Fixed】Fixed AI conversation history losing or corrupting records when a write is interrupted, and failing to recover when a message deletion fails; sessions and messages are written with a temporary file and an atomic replace.
  • 🐞【Fixed】Fixed a custom model connection test overflowing the dialog when the error message is very long; the detail is bounded and scrollable.
  • 🐞【Fixed】Fixed copied result rows merging into one line when pasted into Excel, SAP GUI and other external tools on Windows (CRLF is used).
  • 🐞【Fixed】Fixed the SSH connection test staying in a loading state and reporting repeatedly when it fails.
  • 🐞【Fixed】Fixed cursor flickering in the SQL editor on Windows; moving the mouse inside the editor no longer switches between the arrow, I-beam and zoom cursors.
  • 🐞【Fixed】Fixed duplicating a data source losing connection fields such as the login user, Service Name, key file and BigQuery settings, which made asynchronous tasks behave differently from a manual connection.
  • 🐞【Fixed】Fixed local data source alias search and type filters applying after paging and counting, and PRIVATE/SHARED now match case-insensitively.
  • 🐞【Fixed】Fixed process termination being blocked by the cookie cleanup thread when exiting or stopping the service.
  • 🐞【Fixed】Fixed passwords, SSH passphrases and JDBC connection strings being written to desktop request and response debug logs.
  • 🐞【Fixed】Fixed permission checks in team navigation, organization settings, the approval flow and SQL audit, restoring the previous team permission behavior.

5.3.7-beta.3

2026-09-19

  • 🔥【New Feature】CSV imports now support Ultra-Fast Mode (Beta), which imports with multi-threaded parallelism for faster imports.
  • ⭐【Optimization】Excel imports now support selecting the worksheet, column range, and source rows; JSON imports now support selecting the JSON format (array of objects, single object, JSON Lines) and the data node; SQL imports now support selecting the file encoding.
  • ⭐【Optimization】The table list now shows an Update Time column.
  • ⭐【Optimization】Copying multiple result rows now uses Windows line endings, so pasting into Excel and other external tools no longer merges the rows.
  • 🐞【Fixed】Fixed SQL syntax errors in Informix when renaming tables or columns and when viewing execution plans. Column changes now validate constraints first, avoiding silent removal of constraints or foreign keys, and execution plan reads can be cancelled.
  • 🐞【Fixed】Fixed create-database failures on Redshift, removed the unusable Comment input from the create-database dialog, and stopped executing the remaining statements after the first statement fails.
  • 🐞【Fixed】Fixed incompatible create-database syntax on CockroachDB and incorrect row identity when editing single rows in tables without a primary key.
  • 🐞【Fixed】Fixed DuckDB table data failing to load from page 2 onward.
  • 🐞【Fixed】Fixed incorrect primary key resolution for single-table subqueries on Oracle, which prevented the result set from locating a single row.
  • 🐞【Fixed】Fixed Redis generating invalid commands when editing a value whose key does not exist or has an unknown type, such as RENAME, DEL, or EXPIRE against a missing key.
  • 🐞【Fixed】Fixed duplicate notifications when testing an SSH connection fails.
  • 🐞【Fixed】Fixed the dashboard list not loading more when scrolled to the end, and failed loads being shown as "No data".
  • 🐞【Fixed】Fixed repeated statement cancellation when cancelling a task, failed tasks that the user did not cancel being marked as cancelled, and duplicated or stale entries when loading more tasks in Task Center.
  • 🐞【Fixed】Fixed exported artifacts overwriting files with the same name; a numbered file name is now used instead.
  • 🐞【Fixed】Fixed missing connection fields such as login user, service name, and key file when copying a data source, which made async tasks behave differently from manual connections.
  • 🐞【Fixed】Fixed interrupted AI chat history writes that could lose or corrupt records, and failed deletions that could not be recovered.
  • 🐞【Fixed】Fixed corrupted metadata cache entries preventing a database or table structure from opening.
  • 🐞【Fixed】Fixed repeated clicks on Reset Token in MCP settings sending multiple requests.
  • 🐞【Fixed】Fixed JSON imports failing on empty records.
  • 🐞【Fixed】Fixed editor cursor flicker on Windows.
  • 🐞【Fixed】Fixed incorrect permission checks in team navigation, organization management, approval flows, and SQL audit, restoring the previous team permission behavior.

5.3.7-beta.2

2026-09-10

  • ⭐【Optimization】CSV imports now support configurable encoding, delimiters, quoting and escaping, header and data row ranges, empty-value handling, and date and number formats, with previews that reflect the selected settings.
  • 🐞【Fixed】Fixed invalid table filter or sort expressions making the editors disappear and preventing corrections. The previous results now remain visible, and queries can continue after correcting or clearing the expression.
  • 🐞【Fixed】Fixed table and view suggestions behaving incorrectly when typing @ in AI chat, including stale suggestions after switching data sources.
  • 🐞【Fixed】Fixed rapid repeated saves creating duplicate data sources and incorrect tree positions after repeated dragging or failed moves. Creating a data source from a group's context menu now automatically expands the group and locates the new connection.
  • 🐞【Fixed】Fixed hidden-node settings being lost when refreshing the data source tree, and successful data source saves being incorrectly reported as failures when the subsequent refresh fails.
  • 🐞【Fixed】Fixed failed dashboard refreshes remaining in the loading state and preventing another refresh.
  • 🐞【Fixed】Fixed incomplete cleanup of completed task records and export files when deletion is interrupted by application exit or a file operation failure. Pending cleanup can continue after restarting the application.
  • 🐞【Fixed】Fixed ClickHouse connection failures for database names containing spaces or special characters, and incorrect handling of connection parameters when switching databases.
  • 🐞【Fixed】Fixed possible SQL syntax errors when viewing DB2 view, function, and stored procedure definitions.
  • 🐞【Fixed】Fixed desktop update validation timing out because the page did not load, and Windows updates failing to continue when the update helper file is read-only.

5.3.7-beta.1

2026-09-08

  • 🔥【New Feature】CSV, XLS, and XLSX data imports now provide content preview and column mapping. Before execution, you can adjust source-to-target column mappings, skip unnecessary fields, and use default values or NULL for unmapped fields.
  • ⭐【Optimization】SQL execution logs can now be filtered by data source, database, schema, and SQL content. Applicable filters are shown based on the selected data source's capabilities, making execution records easier to locate.
  • ⭐【Optimization】Desktop update validation no longer displays a temporary application window, reducing window flashes during updates.
  • 🐞【Fixed】Fixed long custom-model connection-test errors overflowing the modal. Error details now remain inside the modal and can be viewed with its scrollbar.
  • 🐞【Fixed】Fixed Windows in-app updates failing to start the installer in some environments. If automatic installation cannot start, the app switches to a compatible launch method and continues while preserving the existing installation directory.

5.3.6

2026-09-07

  • 🔥【New Feature】DM now supports real EXPLAIN execution plans.
  • 🔥【New Feature】MySQL 8.0+ now supports index visibility management, while MySQL 8.0.23+ supports column visibility management.
  • 🔥【New Feature】Added an active-transactions view for MySQL data sources, including transaction status, duration, locks, threads, users, and current SQL.
  • ⭐【Optimization】AI conversations can now be renamed, and message history provides quick navigation to earlier prompts.
  • ⭐【Optimization】Improved large-text result loading. Values larger than 10 KB initially show a 200-character preview and load their full content on demand, reducing transfer and rendering pressure for large result sets.
  • ⭐【Optimization】Database, schema, and result-column filters now scroll horizontally for long names, keep short lists aligned, and hide inactive scrollbars.
  • ⭐【Optimization】Workspace panels and editors now resize more smoothly with less lag and layout movement.
  • ⭐【Optimization】Improved data source colors and editor watermarks. The current theme color is used when no custom color is configured.
  • ⭐【Optimization】Table copy now lets you confirm or edit the destination name, handles quoted and special-character names correctly, retains input after failure, and shows the database reason.
  • ⭐【Optimization】Improved MySQL completion performance for large scripts and long IN lists.
  • ⭐【Optimization】The integrated terminal now tries another available platform Shell when the preferred Shell cannot start.
  • ⭐【Optimization】Redis key details can now be opened by clicking anywhere on a selectable row.
  • 🐞【Fixed】Fixed AI model configuration becoming corrupted or losing an API key when a write is interrupted.
  • 🐞【Fixed】Fixed result search not matching custom-rendered column names.
  • 🐞【Fixed】Fixed Hive databases not appearing as database nodes.
  • 🐞【Fixed】Fixed potential content loss when local SQL or Markdown files are saved, renamed, closed, or handled during application exit.
  • 🐞【Fixed】Fixed large files exhausting browser storage and preventing workspace recovery.
  • 🐞【Fixed】Fixed result sorting, filtering, refreshing, or paging opening extra result tabs, and fixed active-cell changes not being submitted correctly.
  • 🐞【Fixed】Fixed concurrent JDBC driver downloads exposing incomplete files or preventing the application from exiting.
  • 🐞【Fixed】Fixed common connection fields and authentication options in dynamic data source forms not following the selected interface language.
  • 🐞【Fixed】Fixed an existing Redis key retaining its TTL after being changed to persistent.
  • 🐞【Fixed】Fixed stale account permissions appearing after quickly switching between database accounts.
  • 🐞【Fixed】Fixed reversed SQL Server index sort directions and incorrect pagination handling when ORDER BY appears only in nested SQL.
  • 🐞【Fixed】Fixed Kingbase table DDL export failures while preserving complete type, default, auto-increment, identity, enum, and generated-column definitions.
  • 🐞【Fixed】Fixed the MCP service not being initialized when the application starts.
  • 🐞【Fixed】Fixed request parameters when deleting dashboards, charts, AI conversations, or desensitization rules.
  • 🐞【Fixed】Fixed team navigation, organization management, approval flows, and invitation-status display issues.
  • 🐞【Fixed】Fixed in-app updates failing on Windows when the installation path contains spaces.
  • 🐞【Fixed】Fixed repeated desktop launches showing Failed to launch JVM, failing to activate the existing window, or losing file-open requests, including launch handoff during close, restart, and update operations.

5.3.6-beta.6

2026-09-07

  • ⭐【Optimization】Table copy now lets you confirm or edit the destination table name and shows the database reason when copying fails. Special-character table names are also handled correctly when copying or truncating tables.
  • ⭐【Optimization】Database, schema, and result-filter popovers now support horizontal scrolling for long values while keeping short lists aligned. Scrollbars hide quickly after the pointer leaves and remain visible while being dragged.
  • 🐞【Fixed】Fixed multi-row edits sometimes failing when submitted from a result set produced by current-statement execution.
  • 🐞【Fixed】Fixed SQL Server index columns showing and generating the opposite ascending or descending direction.
  • 🐞【Fixed】Fixed Kingbase table DDL export failures and missing or incomplete definitions for auto-increment, identity, generated, and enum columns.
  • 🐞【Fixed】Fixed interrupted JDBC driver downloads deleting an existing driver, exposing incomplete files, or preventing the application from exiting.

5.3.6-beta.5

2026-09-03

  • 🔥【New Feature】Added an active-transactions view for MySQL data sources. Open it from the data source menu to inspect transaction status, duration, isolation level, lock details, connection information, and the current SQL. MySQL 5.7 and 8.0 are supported.
  • ⭐【Optimization】Improved workspace panel resizing. The database tree and SQL editor now resize more smoothly, and editor content follows the available space in real time.
  • ⭐【Optimization】Tabs and watermarks now use the current theme color when a data source has no custom color. Explicit data source colors continue to take priority.
  • 🐞【Fixed】Fixed stale requests overwriting the currently displayed grants or leaving an incorrect loading state when switching quickly between MySQL accounts.
  • 🐞【Fixed】Fixed an existing Redis key retaining its TTL after being changed from expiring to persistent.

5.3.6-beta.4

2026-09-02

  • 🔥【New Feature】Added visibility controls to the MySQL table editor: MySQL 8.0+ can display and toggle VISIBLE / INVISIBLE for non-primary indexes, while MySQL 8.0.23+ can display, create, and update invisible columns.
  • ⭐【Optimization】Improved SQL completion performance for large MySQL scripts, including scripts with multiple ordinary statements or long IN lists.
  • 🐞【Fixed】Fixed workspace state failing to save, close tabs, or restore correctly after opening large local text files. Existing workspace records are migrated automatically, and file contents are reloaded from disk.
  • 🐞【Fixed】Fixed result sorting, filtering, refreshing, or paging creating duplicate result tabs, consecutive sorts generating duplicate ORDER BY clauses, and incorrect revert, preview, or submit behavior after editing a cell. Cmd/Ctrl+S inside a result set no longer triggers Console saving, and results opened from local SQL files can now generate update SQL correctly.
  • 🐞【Fixed】Fixed workspace terminals failing to open when the default Shell is blocked by the operating system or enterprise security software. Chat2DB now tries another available Shell automatically.
  • 🐞【Fixed】Fixed dynamic data source connection forms displaying English labels in Chinese, Japanese, Spanish, and Korean interfaces.
  • 🐞【Fixed】Fixed parameter forwarding that could prevent dashboards, charts, or AI conversations from being deleted through online services in the desktop app.
  • 🐞【Fixed】Fixed invitation withdrawal statuses remaining in the previous language after switching the interface language.

5.3.6-beta.3

2026-09-01

  • ⭐【Optimization】Improved long and multiline result-cell rendering with compact previews by default and full content after resizing a row, reducing lag in large result sets.
  • 🐞【Fixed】Fixed potential content loss, stale save state, or stale paths when local files are saved, closed, renamed, deleted, or handled during application exit, and corrected unsaved-state detection for saved Consoles.
  • 🐞【Fixed】Fixed in-app updates failing on Windows when the Pro installation directory name contains spaces.

5.3.6-beta.2

2026-09-01

  • 🔥【New Feature】Added navigation and renaming for AI conversation history.
  • ⭐【Optimization】Added progress display to task execution logs for data import, export, and SQL-file tasks.
  • 🐞【Fixed】Fixed the first workspace terminal failing to render correctly on its first open.
  • 🐞【Fixed】Fixed unstable workspace-tree search, refresh, expansion state, and click behavior.
  • 🐞【Fixed】Fixed misaligned data-source titles.
  • 🐞【Fixed】Fixed Redis data rows failing to open their details when clicked.
  • 🐞【Fixed】Fixed search results not using custom-rendered column names.
  • 🐞【Fixed】Fixed DM EXPLAIN execution-plan handling and statement-type detection.
  • 🐞【Fixed】Fixed Hive metadata display issues.
  • 🐞【Fixed】Fixed desktop MCP service startup failures.

5.3.5

2026-08-31

  • 🔥【New Feature】Added data-source identity colors and editor watermarks to make different data sources and environments easier to distinguish.
  • 🔥【New Feature】Added output sorting, follow mode, and a history-retention toggle to the Output console.
  • 🔥【New Feature】Query history can now be opened directly in an editable Console.
  • 🔥【New Feature】Result sets now support column visibility management, multi-column hiding and freezing, pinning important result tabs, and copying as Markdown. Frozen columns remain read-only, while unfreezing restores editing and the original order.
  • 🔥【New Feature】The SQL editor now provides field-type-aware INSERT value suggestions and configurable line-comment and block-comment shortcuts.
  • 🔥【New Feature】Added settings search for quickly locating configuration options.
  • 🔥【New Feature】Added rich local-file previews with Markdown Source, Review, and side-by-side modes, plus GFM, Mermaid, KaTeX, image zoom, and embedded PDF viewing.
  • 🔥【New Feature】Added an embedded PTY terminal to the workspace with Shell selection, color themes, and terminal session management.
  • 🔥【New Feature】Tabs can now be dragged to any side of a panel to create a split view.
  • 🔥【New Feature】Added database-tree shortcuts for opening, editing, creating, and refreshing tables.
  • 🔥【New Feature】Added MiniMax support to custom model configuration.
  • 🔥【New Feature】PostgreSQL PostGIS geometry and geography spatial values now support WKT display.
  • ⭐【Optimization】Reworked Task Center to manage data import, export, and SQL file tasks in one place, with improved progress, logs, status, cancellation, and result-file downloads.
  • ⭐【Optimization】Redesigned the desktop title bar and workspace navigation with shortcuts to frequently used pages and a cleaner window-control area.
  • ⭐【Optimization】Improved tab navigation, split-view interactions, terminal layout, and Output panel resizing.
  • ⭐【Optimization】Improved query-result interactions, including execution and fetch timing, row counts, field metadata, result search, and context menus. The result inspector now supports sidebar and dialog modes, Record, Value, and Aggregates views, and remembers the last selected mode.
  • ⭐【Optimization】Improved SQL editor save and close flows. The first save can set a name directly, saving refreshes the query file tree, and closing unsaved content offers Save, Don't Save, or Cancel to prevent accidental data loss.
  • ⭐【Optimization】Preserved the user's manual Files / Data Browser panel selection instead of overriding it automatically.
  • ⭐【Optimization】Improved settings navigation, custom-font guidance, action icons, and Session panel dragging.
  • ⭐【Optimization】Removed the easily triggered / AI entry from the SQL editor.
  • ⭐【Optimization】Made custom model configuration easier to discover.
  • ⭐【Optimization】New table columns are nullable by default.
  • 🐞【Fixed】Fixed missing table and column comments in GaussDB and openGauss table DDL.
  • 🐞【Fixed】Fixed column completion in MySQL multi-table queries.
  • 🐞【Fixed】Fixed pagination compatibility with older SQL Server versions and missing IDENTITY attributes when copying tables.
  • 🐞【Fixed】Fixed Redis string-key editing, key renaming and deletion, value editing across data types, and incomplete incremental scans.
  • 🐞【Fixed】Fixed MongoDB result filtering, sorting, and null-value handling.
  • 🐞【Fixed】Fixed empty UPDATE SET clauses, pagination overflow, oversized SQL validation, and comment escaping.
  • 🐞【Fixed】Fixed column precision and scale handling for ClickHouse, MySQL, Hive, Snowflake, and SQLite.
  • 🐞【Fixed】Fixed Excel imports failing when table names, column names, comments, or data contain special characters.
  • 🐞【Fixed】Fixed result-table hangs when editing large fields, lost change markers after undo, and incorrect highlight restoration.
  • 🐞【Fixed】Fixed missing chart fields after desktop queries, sorting and axis issues, and errors caused by empty chart data.
  • 🐞【Fixed】Fixed duplicated request paths when custom AI service URLs end with /v1, undefined in streamed messages, requests cancelling each other, and lost state after renaming a conversation.
  • 🐞【Fixed】Fixed cache initialization and corruption handling, JDBC connections, and resource cleanup.
  • 🐞【Fixed】Fixed deleted local data reappearing, tree nodes returning after deletion, and non-atomic save and delete operations.
  • 🐞【Fixed】Fixed local-file encoding detection on Windows for a more reliable experience when opening SQL and text files in different encodings.
  • 🐞【Fixed】Fixed macOS installer and desktop interaction issues.
  • 🐞【Fixed】Fixed a race between desktop MCP settings persistence and application restart that could cause lost configuration, state rollback, duplicate restarts, or conflicts between old and new processes.
  • 🐞【Fixed】Fixed failure to restore the last main page, workspace navigation, console names, and terminal layout after restart, plus incorrect drag-cursor display.

5.3.0

2026-07-21

  • 🔥【New Feature】Added local file workspaces to the desktop app. You can manage local directories and SQL or text files, create, rename, delete, refresh, save, copy paths, reveal files in Finder, and open them in a terminal. Open files stay synchronized between tabs and the file tree.
  • 🔥【New Feature】Added SQL content comparison for database views, functions, stored procedures, trigger DDL, saved consoles, and local files, showing changes from the loaded or saved baseline.
  • 🔥【New Feature】Expanded MySQL administration with account creation, deletion, password changes, lock and unlock operations, common grants and revocations, plus generated and executable SQL for functions, stored procedures, and DDL migrations.
  • 🔥【New Feature】Redis browsing now supports cursor-based incremental scans, search, and load more, with switchable list and :-delimited hierarchy views.
  • 🔥【New Feature】The database tree can now locate the current console, database object, or local file, sort names naturally, and display loaded-object and search-result counts.
  • 🔥【New Feature】Workspace tabs now support pinning, drag sorting, duplication, reference copying, recently closed recovery, bulk closing, search, and middle-click close, plus persistent horizontal or vertical split layouts.
  • 🔥【New Feature】Added a structured Output console to the SQL editor, showing SQL, data source context, execution status, row count, and elapsed time, with support for reopening results, copying, clearing, and following the latest output.
  • 🔥【New Feature】Result sets now support SQL IN (...) copying, anchored table-data paste, page sizes from 10 to 100000 rows, Record / Value inspectors, and selection statistics such as average, count, and sum.
  • ⭐【Optimization】Menu shortcuts now use clearer keycap styling and stay synchronized with user shortcut settings.
  • ⭐【Optimization】Improved streamed AI responses and Markdown rendering to reduce formatting issues in headings, lists, code blocks, and charts.
  • 🐞【Fixed】Fixed Windows installation-directory selection and upgrade or rollback failures on non-system drives, with administrator installation, detailed logs, and clearer error messages.
  • 🐞【Fixed】Fixed Kingbase function metadata and data source search, plus missing table and column comments in GaussDB / openGauss DDL.
  • 🐞【Fixed】Fixed dropped duplicate messages in SQL execution output and unstable execution-context or result-tab labels.
  • 🐞【Fixed】Fixed external Framework path detection in the macOS desktop app.

5.2.4

2026-06-17

  • 🔥【New Feature】Upgraded the MySQL SQL completion engine for complex SQL scenarios including SELECT / FROM / JOIN / WHERE / GROUP BY / ORDER BY, INSERT / UPDATE, CREATE TABLE, foreign key REFERENCES, function calls, and stored procedure calls. Suggestions for tables, columns, aliases, functions, stored procedures, data types, and keywords are now more accurate.
  • 🔥【New Feature】SQL execution now supports progressive result return, so long-running SQL, AI-generated SQL, and continuous execution can show progress and results sooner.
  • 🔥【New Feature】Added large-field viewing. Large text, JSON, images, and binary content can now be viewed in chunks and downloaded.
  • 🔥【New Feature】Added the Chat2DB CLI runtime and CLI Skill. The CLI can query data sources, test database connections, read metadata, and execute SQL. AI assistants can also use data source discovery, metadata query, and SQL execution capabilities.
  • 🔥【New Feature】Added support for deleting MySQL / PostgreSQL databases. PostgreSQL now also supports deleting schemas.
  • 🔥【New Feature】MySQL result-set editing now supports date, time, and datetime controls for DATE, TIME, DATETIME, and TIMESTAMP fields.
  • 🔥【New Feature】Added Oscar database support, including connection, object browsing, SQL editor suggestions, and common object operations.
  • 🔥【New Feature】Completed MongoDB right-click menu capabilities. Data sources now support closing connections, and collections support copying names.
  • 🔥【New Feature】Added network proxy settings, making database connections and AI capabilities easier to use in complex network environments.
  • 🔥【New Feature】Expanded shortcut-key configuration. All shortcuts can now be adjusted by scenario group, with conflict warnings and reset-to-default support.
  • ⭐【Optimization】MCP no longer needs to be bound to a single data source configuration. AI assistants can directly view and operate all data sources, then choose the database and schema for the current task.
  • ⭐【Optimization】Improved SQL completion candidate display. Column types, table names / aliases, and data source information are grouped more clearly, while long candidate lists automatically control width and position.
  • ⭐【Optimization】The SQL editor completion accept key is now configurable. You can choose Enter or Tab to accept completions and reduce accidental selections.
  • ⭐【Optimization】The SQL editor now supports table-name navigation and quick DDL viewing, making it easier to locate target tables while writing SQL.
  • ⭐【Optimization】SQL punctuation input is more stable with Chinese input methods. Periods, commas, and semicolons can be entered correctly next to English identifiers.
  • ⭐【Optimization】Enhanced MySQL table-structure maintenance. Table engines, charsets, collations, index methods, and generated ALTER DDL are now displayed, read, saved, and generated more completely.
  • ⭐【Optimization】Query history and saved-query lists are clearer, with hierarchical browsing by data source / database / schema, search, SQL copying, and reopening support.
  • ⭐【Optimization】SQL execution operation logs are more complete, making execution history tracking and troubleshooting easier.
  • 🐞【Fixed】Fixed IPv6 JDBC address connection issues so IPv6 hosts can be generated and parsed correctly.
  • 🐞【Fixed】Fixed SQL Server result-set export so it correctly uses the currently selected result set.
  • 🐞【Fixed】Fixed editor operation issues including duplicated retained SQL result pages and lost clipboard read targets.
  • 🐞【Fixed】Fixed copy, cut, and paste issues in the SQL editor find-and-replace box opened with Cmd/Ctrl+F.
  • 🐞【Fixed】Fixed Redis database-list display when config get databases is disabled.
  • 🐞【Fixed】Fixed unstable fetch size when exporting MariaDB table data.
  • 🐞【Fixed】Fixed DM result-set CLOB reading when the driver returns an empty Clob object.
  • 🐞【Fixed】Fixed inconsistent auto-increment primary-key handling when adding rows, cloning rows, or copying and pasting row data in result-set editing.
  • 🐞【Fixed】Fixed PostgreSQL table-data sorting failures caused by missing double quotes around uppercase or reserved-word column names.
  • 🐞【Fixed】Fixed DM / Oracle parsing and result-editing issues.

4.0.6

2025-09-09

  • 🔥【New Feature】In the data result display, support for directly viewing the data annotation and type of the column in the table header (enable/disable it at the end of the data toolbar)
  • 🔥【New Feature】Add the function of copying data sources
  • Table list view:
  • 🔥【New Feature】Double-click to open a table directly
  • 🐞【Bug Fix】Fixed the issue where tables with the same name could not be opened when using the right-click menu to open a table
  • ⭐【Optimization】Optimized the issue where the hot zone of the right-click cell was too small, which easily triggered the default right-click menu

4.0.1

2025-07-09

  • 👉👉👉【Important Notice】Due to major architectural changes, version 4.0 requires manual download and installation, and does not support automatic upgrades.
  • 🔥🔥🔥【New Feature】We provide MCP Server services and work perfectly with other MCP clients, allowing you to operate the database in a conversational way anytime and anywhere.
  • ⭐⭐⭐【Optimization】The client architecture has been upgraded to enhance system security and stability, making the query of millions of data 10 times faster
  • 🐞【Fixed】Several issues

3.1.11

2025-4-30

  • 🔥🔥🔥【New Feature】Adding knowledge management can significantly improve the accuracy of Text2SQL by configuring the knowledge base
  • 🔥【New Feature】Support GaussDB, GBase8s database
  • 🔥【New Feature】Support the QWen3 model
  • 🔥【Optimization】Optimize data annotation
  • 🐞【Fixed】Several issues

3.0.0

2025-3-10

🔥🔥🔥【New Feature】AI Reconstruction

  • Open Chat2DB Copilot with (ctrl/cmd)+k
  • Significant improvement in natural language to SQL accuracy, enhanced self-correction capability and SQL generation accuracy assessment to avoid AI hallucinations
  • Removed AI dataset dependency restrictions - start asking questions immediately after establishing data source connection, no manual AI dataset creation needed
  • Direct answers to database queries - get data results immediately after asking without manual SQL execution
  • Added debug functionality for database development to troubleshoot SQL development errors and provide solutions
  • AI Q&A now supports 10+ cutting-edge models including code models, reasoning models and hybrid models with one-click switching
  • Experience advanced models from major vendors in one Chat2DB tool without purchasing and switching between different vendors
  • AI Q&A evolved beyond SQL copilot to a comprehensive office assistant - generate code in Python, Java and other languages using code models, get technical solutions using reasoning models
  • AI Q&A not limited to single-round conversations - supports more context for multi-round dialogues
  • 🔥【New Feature】Added ER diagram view for intuitive understanding of database structure
  • 🔥【New Feature】Left tree supports filtering database nodes to improve search efficiency
  • 🔥【New Feature】Query result sets can directly generate reports
  • ⭐【Optimization】Added search support for data selection, database and schema selection in editor
  • ⭐【Optimization】Optimized query result set - supports Cmd/Ctrl+S for data modification, Cmd/Ctrl+R for data refresh
  • ⭐【Optimization】Optimized result set scrollbar
  • ⭐【Optimization】Optimized data query efficiency
  • 🐞【Fixed】Fixed issue of not distinguishing between null and empty strings when copying result set data
  • 🐞【Fixed】Fixed window reopening as fullscreen instead of maximized after closing in maximized state
  • 🐞【Fixed】Fixed issue where result set data couldn't be batch deleted after clicking single line execution in console
  • 🐞【Fixed】Fixed field auto-completion issues caused by table name case sensitivity
  • 🐞【Fixed】Fixed issue of reserved keywords not being quoted in SQL completion
  • 🐞【Fixed】Fixed missing semicolon at end of Oracle anonymous block statements
  • 🐞【Fixed】Removed redundant index creation statements caused by primary keys and unique constraints in DM DDL view
  • 🐞【Fixed】Fixed SQL Server select...into statement not inserting all data
  • 🐞【Fixed】Fixed missing semicolon at end of SQL Server merge statements
  • 🐞【Fixed】Fixed SQL generation errors for TIME, DATETIME2, DATETIMEOFFSET types in SQL Server table modifications
  • 🐞【Fixed】Fixed SQL Server time type precision display
  • 🐞【Fixed】Fixed precision loss when querying time type data in SQL Server

2.14.5

2025-1-13

  • ⭐【Optimization】Data export performance
  • ⭐【Optimization】Fixed issue where bottom half of execution results couldn't be closed after SQL error
  • 🐞【Fixed】Fixed field name display error when viewing data through right-click in result set
  • 🐞【Fixed】Fixed issue where DDL view couldn't be opened in certain cases
  • 🐞【Fixed】Unable to pay the problem

2.14.4

2025-1-3

  • ⭐【Optimization】Optimized word cloud in charts
  • ⭐【Optimization】Disabled all editing functions when query result data is not editable
  • ⭐【Optimization】Added close button to AI input box in SQL editor
  • ⭐【Optimization】Fixed issue where AI box would overlap SQL in editor
  • ⭐【Optimization】Left tree search now supports ignoring underscores
  • ⭐【Optimization】Added sticky configuration to editor
  • 🐞【Fixed】Fixed various structure synchronization issues
  • 🐞【Fixed】Fixed data overwrite issue in result set when duplicate field names exist
  • 🐞【Fixed】Fixed Slash issues in editor
  • 🐞【Fixed】Fixed quick execution issues on left side of editor

2.14.1

2024-12-24

  • 🐞【Fixed】Bug fixes

2.14.0

2024-12-23

  • 🔥🔥🔥【New Feature】Support for database structure synchronization
  • 🔥【New Feature】Support for shortcuts and custom shortcuts
  • ⭐【Optimization】Query data supports 50k and 100k levels
  • ⭐【Optimization】More reasonable arrangement of X-axis labels in charts
  • ⭐【Optimization】Adjusted hot zone size for row height handle in result set table
  • 🐞【Fixed】Data modification failure when queried data has no primary key
  • 🐞【Fixed】Java Class generation error
  • 🐞【Fixed】Tab positioning issue when opening new tabs
  • 🐞【Fixed】Fixed various database issues

2.13.2

2024-12-14

  • 🐞【Fixed】Various bug fixes

2.13.0

2024-12-13

  • 🔥【New Feature】Supports import and export of all databases except REDIS\H2\PRESTO\MONGODB\SNOWFLAKE\KYLIN\KINGBASE\HIVE
  • 🔥【New Feature】Result set table supports search
  • 🔥【New Feature】Table supports adjusting row height and editing multi-line text
  • 🔥【New Feature】Result set supports copying where, update, and insert statements for selected cells
  • 🔥【New Feature】MYSQL, ORACLE, POSTGRESQL, SQLSERVER, CLICKHOUSE, DB2, DM, KINGBASE, SQLITE databases support generating java code
  • 🔥【New Feature】Execution result page table supports batch copying
  • 🔥【New Feature】Editor supports configuring custom fonts individually
  • ⭐【Optimization】Performance optimization, solving the problem of becoming slower over time
  • ⭐【Optimization】Charts support displaying all Label texts on the x-axis
  • ⭐【Optimization】Table time fields support updating based on the current timestamp
  • ⭐【Optimization】Editor adds copy and paste on right-click
  • 🐞【Fixed】Windows result set scrollbar dragging issue
  • 🐞【Fixed】AI dialog copy and paste penetration issue

2.12.0

2024-11-27

  • ⭐【Optimization】Optimized data transmission speed for large-scale data on desktop
  • 🐞【Fixed】Issue of new rows not having default values
  • 🐞【Fixed】Issue of table not following theme switch
  • 🐞【Fixed】Data operation issues after moving columns
  • 🐞【Fixed】Issue of unable to undo new rows
  • 🐞【Fixed】Issue of data modification error not being notified
  • 🐞【Fixed】Occasional issues after sorting and filtering

2.11.0

2024-11-25

  • 🔥🔥🔥【New Feature】Dataset table reconstruction and optimization
  • 🔥【New Feature】Table supports multi-select copy, multi-select modification, and column dragging
  • 🔥【New Feature】Expanded data display capacity, can display 10,000 rows of data
  • 🔥【New Feature】Table supports column filtering
  • 🔥【New Feature】Support hover header to display field comments and field types
  • 🔥【New Feature】Support direction keys up/down/left/right + CTRL + SHIFT shortcuts to move selected content or edit cells
  • ⭐【Optimization】AI Copilot memory usage
  • ⭐【Optimization】AI Copilot display issues in multiple editor windows
  • ⭐【Optimization】AI Copilot style when editor MiniMap mode is enabled

2.10.0

2024-11-18

  • 🐞【Fixed】Group moving issues
  • 🐞【Fix】The problem of garbled test data generated by AI
  • 🐞【Fix】Syntax errors in AI table creation in different databases
  • 🐞【Fixed】Chat question may cause circular call issue
  • 🐞【Fixed】Issue of unable to call AI under certain input methods on Windows
  • 🐞【Fixed】Issue of editor right-click menu being hidden by Hover prompt
  • 🐞【Fixed】DDL view scrollbar issue
  • 🐞【Fixed】Occasional Hover duplicate request issue
  • ⭐【Optimization】Optimized Hover display effect

2.9.0

2024-11-11

  • 🔥【New Feature】Linux supports .deb and .rpm package installation
  • 🔥【New Feature】Left tree supports collapsing
  • 🔥【New Feature】Query result set supports exporting to EXCEL
  • 🐞【Fixed】Issue with table styles when uploading Excel sheets in ChatExcel
  • 🐞【Fixed】Issue of white screen caused by certain operations while editing charts
  • 🐞【Fixed】Error in query list after deleting a table when viewing all tables
  • 🐞【Fixed】Occasional issue of the left tree not scrolling to the bottom
  • 🐞【Fixed】Problem of flickering tabs in query results
  • 🐞【Fixed】Occasional slow SQL execution results
  • 🐞【Fixed】Some errors in importing links from other third-party sources
  • 🐞【Fixed】Issue of unable to access the password when importing links from other third-party sources
  • 🐞【Fixed】Fix oceanbase database's tinyint type processing
  • 🐞【Fixed】Fix dm database's bit type processing
  • 🐞【Fixed】Fix postgresql issue where table names cannot be deleted due to case sensitivity
  • 🐞【Fixed】Fix replace into and insert ignore into not prompting table names
  • 🐞【Fixed】Fix where condition field hover prompt
  • 🐞【Fixed】Fix alter table statement table name hover prompt
  • 🐞【Fixed】Fix editor prompt refresh issue
  • ⭐【Optimization】Console SQL dropdown box positioning issue
  • ⭐【Optimization】Editor string color optimization
  • ⭐【Optimization】Editor supports keyword case sensitivity and table full qualifier name configuration
  • ⭐【Optimization】Compatible with low-version postgresql ddl view
  • ⭐【Optimization】Client window size adaptation
  • ⭐【Optimization】Execution record overall style optimization
  • ⭐【Optimization】Database list tree scrollbar optimization
  • ⭐【Optimization】Optimize the way device ID is obtained when offline activation

2.8.1

2024-11-06

  • 🐞【Fixed】Issue with table styles when uploading Excel sheets in ChatExcel
  • 🐞【Fixed】Issue of white screen caused by certain operations while editing charts
  • 🐞【Fixed】Error in query list after deleting a table when viewing all tables
  • 🐞【Fixed】Occasional issue of the left tree not scrolling to the bottom
  • 🐞【Fixed】Problem of flickering tabs in query results
  • 🐞【Fixed】Occasional slow SQL execution results
  • 🐞【Fixed】Some errors in importing links from other third-party sources
  • 🐞【Fixed】Issue of unable to access the password when importing links from other third-party sources

2.8.0

2024-10-25

  • 🔥【New Feature】Support for nested groups to facilitate the classification management of databases.
  • 🔥【New Feature】Right-click menu “Move to a group” operation item is now supported for data connections or groups.
  • 🔥【New Feature】Manual disconnection of connections is now allowed.
  • ⭐【Optimization】Increased the number of tables displayed in the left tree from 1000 to 100,000, solving the issue of tables not being found in the left search.
  • ⭐【Optimization】Improved the experience of scrolling, searching, and dragging in the left tree.
  • ⭐【Optimization】Reordered the right-click menu in the tree.
  • ⭐【Optimization】The Console no longer clears content after the AI sends a request, making it easier to modify the description later.
  • ⭐【Optimization】Fixed the issue of slow response when closing the software.
  • 🐞【Bug Fix】Fixed the issue where the Where query could only filter the current page’s data.
  • 🐞【Bug Fix】Fixed the issue of incomplete column field types in the left tree.
  • 🐞【Bug Fix】Fixed the issue of the AI’s table selection being ineffective in the console.
  • 🐞【Bug Fix】Fixed the issue where special characters such as English parentheses in tree search would cause an error.

2.7.0

2024-10-16

  • 🔥【New function】Export chat2db connections
  • 🔥【New function】Import navicat, navicat, datagrip, and dbeaver connections
  • 🐞【Fix】No comments when hovering over Oracle fields
  • 🐞【Fix】Known SQL suggestion issues
  • 🐞【Fix】Suggestion matching problem after manual input during SQL smart suggestions
  • 🐞【Fix】Abnormal modification when double-clicking Bit type
  • 🐞【Fix】Display issue for MongoDB large object queries
  • 🐞【Fix】Abnormal modification when double-clicking MySQL Bit type
  • 🐞【Fix】Successful test prompt for incorrect MongoDB account and password
  • 🐞【Fix】Editor does not have X-axis scroll bar
  • 🐞【Fix】Issue where unselected formatted sql could not be undone
  • ⭐【Optimization】The DDL on the right side can be wrapped

2.5.0

2024-09-04 🔥🔥Editor Refactoring🔥🔥

  • Smart hint upgrade
  • Support code block
  • Support error prompt
  • Hover trigger DDL display and other detailed information
  • Support right-click menu
  • More rich shortcut key support
  • SQL execution, automatically trigger editor related information refresh
  • Support theme, font size, line number, line height, wrap, thumbnail and other configurations

2.4.0

2024-08-14

  • 🔥🔥【New Feature】Support for AI table creation, automatic recommendation of suitable column names based on Chinese, can complete table creation more conveniently and quickly
  • 🔥【New Feature】Support for saving SQL to local files
  • ⭐【Optimization】All tables can be selected when creating AI datasets
  • ⭐【Optimization】Column width can be dragged when editing table structure
  • ⭐【Optimization】Report page adapts to mobile end
  • ⭐【Optimization】Reduce the memory usage of the software
  • ⭐【Optimization】Lag issue when result set has large strings
  • 🐞【Bug Fix】Fixed the issue where refreshing the report does not refresh the data

2.3.5

2024-08-2

  • 🔥【New Feature】Support saving SQL to local files
  • 🐞【Fix】Fixed the issue where some headers or data in ChatExcel could not be correctly recognized
  • 🐞【Fix】Fixed the conflict between the expand/collapse button of the result set and the scrollbar of the SQL area

2.3.0

2024-07-31

  • 🔥【New Feature】Support uploading EXCEL for Q&A on EXCEL files
  • 🔥【New Feature】Reports support free drag-and-drop layout
  • ⭐【Optimization】Report color optimization
  • ⭐【Optimization】Query result set can be expanded and collapsed

2.2.0

2024-07-25

  • 🔥【New Feature】Added plugin marketplace, added data migration/backup plugin

2.1.2

2024-07-17

  • 🐞【Fix】Problems that AI datasets don't show

2.1.1

2024-07-16

  • ⭐【Optimization】Hide buttons without permission in the left data source tree in team mode,
  • ⭐【Optimization】Sort Console by creation time in ascending order,
  • ⭐【Optimization】SQL style and SQL hint style in Console,
  • 🐞【Fix】Fix the issue where copying selected content in the input of the result set does not work,
  • 🐞【Fix】Fix the issue where switching pages in the result set does not work,
  • 🐞【Fix】Fix the issue where the Console frequently prompts no permission in team mode without permission,
  • 🐞【Fix】Fix the issue where DatabaseName is not displayed in the Console box on the report page,
  • 🐞【Fix】Fix the issue where extra line breaks are added when exporting LONGTEXT type

2.1.0

2024-07-09

  • 🔥【New Feature】Support for team collaboration
  • 🔥【New Feature】Support for table structure/data import and export
  • 🔥【New Feature】Support for database import and export
  • 🔥【New Feature】Support for executing SQL files
  • 🔥【New Feature】Support for API-based text-to-SQL calls
  • 🔥【New Feature】Support for clearing tables and copying table structures/data
  • 🔥【New Feature】Support for opening SQL files with Chat2DB, and dragging local files into the SQL console
  • 🔥【New Feature】Support for copying column data from query result tables
  • ⭐【New Feature】Support for SQL folding
  • ⭐【New Feature】View support for directly viewing data
  • ⭐【Optimization】Moved console save records to the database section in the left tree
  • 🐞【Fix】Fixed issue with multi-select row copying after sorting query result sets
  • 🐞【Fix】Fixed bug where data was not displayed after refreshing query result sets with where or order by clauses

2.0.1

2024-6-17

  • 🐞【Fix】Fixed an issue where the modified table data on the desktop does not take effect after sql data is submitted or viewed.
  • 🐞【Fix】Fixed the issue that the AI dataset table field modification page could not scroll.
  • 🐞【Fix】Fixed the Chat page style issue.

2.0.0

2024-6-12

  • 🔥【New Feature】Brand Upgrade
  • 🔥【New Feature】Full Support for Redis Database
  • 🔥【New Feature】Support for TiDB Database
  • 🔥【New Feature】Support for CockroachDB Database
  • 🔥【New Feature】Support for Apache Kylin Database

1.2.4

2024-6-04

  • ⚡️【Optimization】Support for displaying column note styles
  • ⚡️【Optimization】Support for expanding child nodes after search
  • ⚡️【Optimization】Support for dropdown display of all tabs in the console and searchable
  • ⚡️【Optimization】Add pop-up in execution summary
  • 🐞【Bug Fix】Fix the issue of failing to copy a node name multiple times with shortcut keys
  • 🐞【Bug Fix】Fix the bug when deleting result page tabs
  • 🐞【Bug Fix】Fix the issue of not recognizing when the data changes from "" to null
  • 🐞【Bug Fix】Fix some bugs when switching data sources in saved console
  • 🐞【Bug Fix】Fix some bugs when modifying data without primary keys in the query results
  • 🐞【Bug Fix】Fix the issue of not being able to execute normally when creating or modifying stored procedures

1.2.0

2024-5-30

  • 🔥【New Feature】Support for AI datasets to improve AI accuracy.【Documentation】(/docs/ai-chat/ai-data-collection)
  • 🔥【New Feature】Support for openGauss database
  • 🔥【New Feature】Support for SUNDB database
  • 🐞【Fix】Fixed tree node search and other bugs
  • 🐞【Fix】Fixed MySQL field sorting adjustment issue
  • 🐞【Fix】Fixed issue with parsing MySQL functions
  • 🐞【Fix】Fixed SSH connection reuse issue
  • ⚡️【Optimization】Visual and functional improvements for viewing all tables
  • ⚡️【Optimization】Optimized MongoDB database usage
  • ⚡️【Optimization】Changed the way execution results are displayed, insert and update actions will no longer occupy a Tab
  • ⚡️【Optimization】Fixed Tab positioning issue in Console and added column positioning issue when modifying tables
  • ⚡️【Optimization】Visual optimizations

1.1.5

2024-5-15

  • ⚡️【Optimization】Automatically focus on input when double-clicking to edit data
  • ⚡️【Optimization】Automatically bring up the database focused on the tree node when clicking the plus sign to create a new console in the Console tab
  • ⚡️【Optimization】After AI conversation, do not clear the current text content
  • 🐞【Fix】Issue with collapsing functions, procedures, triggers
  • 🐞【Fix】Issue where no error message is displayed when data changes result in errors
  • 🐞【Fix】Issue with emoji garbling in default avatars
  • 🐞【Fix】Issue where clicking on a table in the tree does not display the ddl in the right information bar
  • 🐞【Fix】Issue where Oracle does not display schema
  • 🐞【Fix】Issue with deleting group errors
  • 🐞【Fix】Issue with local data source storage errors
  • 🐞【Fix】Query the total number of tables
  • 🐞【Fix】Unable to resolve now() time issue
  • 🐞【Fix】Unable to resolve issue where event cannot be created

1.1.2

2024-5-15

  • ⭐【New feature】Data source supports grouping
  • ⚡️【Optimization】Optimize personal center information display and enhance paying user experience
  • ⚡️【Optimization】Optimized the App lag problem
  • ⚡️【Optimization】Optimize the overall UI of the App
  • ⚡️【Optimization】Improved dark mode vision (Handsome dark mode is highly recommended)
  • ⚡️【Optimization】View all tables Support more information display, support right click operation
  • 🐞【Bug Fix】Mac Black screen issue
  • 🐞【Bug Fix】The SQL content exported is correct, but the suffix is incorrect
  • If you cannot complete the automatic update, please go to https://chat2db.ai/download (opens in a new tab) to download the version

1.0.7

2024-04-26

  • ⭐【New Feature】Support for lifetime membership
  • ⭐【New Feature】No need to log in daily after logging in
  • 🐞【Bug Fix】Fixed an issue where queries would keep loading due to errors in SQL syntax
  • 🐞【Bug Fix】Fixed an issue where editing table structure and only changing the field's null property would result in loss of table structure
  • 🐞【Bug Fix】Fixed a problem where viewing the update log resulted in a 404 error

1.0.5

2024-4-15

  • ⭐【New Feature】Support for adjusting the editor font size
  • ⭐【New Feature】Added a re-subscription entry in the settings
  • 🐞【Bug Fix】Fixed certain database connection issues
  • 🐞【Bug Fix】Fixed login-related issues
  • 🐞【Bug Fix】Fixed a series of issues with hot updates
  • 🐞【Bug Fix】Fixed an issue where stored procedures and views could not be viewed on the desktop version
  • 🐞【Bug Fix】Fixed an issue with headers overflowing on the query results page in the desktop version

1.0.3

2024-4-11

  • ⭐【New Feature】Support for one-click migration of community edition data sources to Pro version
  • ⭐【New Feature】Support for clone links
  • ⚡️【Optimization】Optimized the scrollbar of the query results page
  • 🐞【Bug Fix】Fixed the issue where the application would get stuck on the startup page
  • 🐞【Bug Fix】Fixed the data source information is garbled
  • 🐞【Bug Fix】Fixed the issue of data source import errors
  • 🐞【Bug Fix】Fixed the issue where the scrollbar could not be dragged
  • 🐞【Bug Fix】Fixed the issue where the language would be reset after switching languages and restarting
  • 🐞【Bug Fix】Fixed the issue where Console Tabs could not be scrolled

1.0.0

2024-4-09

🎉🎉 We made it, we all made it～ 🎉🎉 After two months of delay, Chat2DB is back with a strong Pro version! 💪💪 Click here for details 👉 https://chat2db-ai.com/en (opens in a new tab)

🚀 Major AI upgrade 🧠 A whole new experience of AI writing SQL: You can call up the AI assistant by typing "/" at any position in the SQL editing box, and exit by pressing esc 📝 Auto-complete SQL during the writing process, greatly improving SQL efficiency 🖱️ Right-click on the table to quickly generate test data 📊 AI generates data dashboards, now you just need to give instructions to the AI, and the entire dashboard can be quickly built

🎁 Open source Chat2DB-GLM fine-tuned SQL model Not only have we improved the capabilities of the product itself, but we have also decided to open source our own SQL model, which supports MySQL and PostgreSQL For more model details, click here 👉 https://github.com/codePhiliaX/Chat2DB-GLM (opens in a new tab)

🏗️ Architecture upgrade The new version of Chat2DB Pro has completely developed its own client architecture solution, reducing the startup time from the original 15s to 3s. The startup speed of java has also been reduced from the previous 12s to less than 1s. If you are interested in our technical implementation, you can keep following us, and we will reveal it to you later.

Let's look forward to and witness the changes brought by Chat2DB Pro together, and welcome you to join our journey to jointly promote the innovation in the field of data management and data analysis! 🎉🎉