Chat2DB Files

Chat2DB Community 5.3.6 adds import preview and mapping, flexible CSV settings, MySQL transaction inspection, and execution-history filters, while improving table browsing, database compatibility, and desktop reliability.

Added (4)

• CSV and Excel imports now offer data preview and column mapping on Web and Desktop, with field skipping and validation for duplicate mappings and missing required columns by @Aias00 and @openai0229 in PR [#2652] and PR [#2887].
• CSV imports support encoding, delimiter, text qualifier, and escape settings, header and data row ranges, empty-value handling, and date, time, and decimal formats by @Aias00 in PR [#2653].
• MySQL 5.7 and 8.0 users can inspect active InnoDB transactions, duration, SQL, lock waits, and blocking connections, then open a console to inspect a related connection; unavailable metadata and insufficient privileges are explained explicitly by @Aias00 in PR [#2636].
• Execution history can now be filtered by datasource, database, and schema, with SQL keyword search by @HandSonic in PR [#2696].

Improved (5)

• Copying table structure or data now shows an editable target-name confirmation and preserves the entered name on failure. Copy and truncate operations also handle special table names without double quoting by @openai0229 in PR [#2880].
• Large text and JSON/JSONB cells use compact previews with full values loaded on demand, reducing large result-page loading failures. JSON formatting and compression also preserve value-inspector actions and reset the view to the start by @openai0229 in PR [#2882].
• Workspace sidebars resize more smoothly while editor bounds stay aligned, and tabs and enabled watermarks use the theme accent when no custom datasource color is set by @openai0229 in PR [#2870].
• Database, schema, and result-filter lists support horizontal scrolling for long values, keep short lists aligned, and show scrollbars only when needed by @openai0229 in PR [#2878] and PR [#2881].
• Built-in JDBC drivers can be downloaded again even when drivers are already installed. Concurrent downloads publish complete files safely, and background downloads no longer prevent application exit by @openai0229 and @HandSonic in PR [#2883] and PR [#2687].

Fixed (18)

• Invalid WHERE or ORDER BY expressions no longer remove the table's filter editors or its last successful result; correcting or clearing the expression allows browsing to recover by @openai0229 in PR [#2899].
• Editing multiple result rows no longer inherits current-statement execution options that caused saves to fail on MySQL connections with multi-statement execution disabled by @openai0229 in PR [#2877].
• Repeated datasource saves no longer create duplicate connections, failed moves preserve the displayed tree, and creating a datasource inside a group expands and locates the new connection by @openai0229 in PR [#2891] and PR [#2901].
• Tree refreshes preserve hidden-node settings during overlapping refresh and hide operations, and a failed refresh after a successful datasource save is no longer reported as a failed save by @HandSonic in PR [#2743].
• JSON and SQL files uploaded in Community Web can be submitted for import correctly by @Aias00 in PR [#2652].
• SQL Server pagination recognizes only top-level ORDER BY clauses, and index metadata and generated DDL preserve ASC/DESC sort direction by @HandSonic in PR [#2694] and PR [#2686].
• Kingbase table DDL export works with catalog variants that lack expected information-schema columns and preserves identity, generated-column, enum, and default-value definitions by @openai0229 in PR [#2879].
• Switching ClickHouse databases handles spaces, Unicode, and special characters without corrupting the JDBC URL by @HandSonic in PR [#2692].
• DB2 procedure, function, and view definitions and related DDL exports no longer fail because JDBC queries contain trailing statement terminators by @HandSonic in PR [#2738].
• Changing a Redis key to no expiration now clears its previous TTL by @HandSonic in PR [#2689].
• Switching database accounts quickly no longer displays grants returned for a previously selected account by @HandSonic in PR [#2691].
• Duplicate desktop launches activate the existing window, and file or protocol requests are retained during concurrent startup and exit handling by @openai0229 in PR [#2875].
• AI chat restores table and view suggestions on explicit @ input, supports keyboard and mouse selection, and ignores stale suggestion responses by @openai0229 in PR [#2888].
• Long custom-model connection-test errors stay inside a scrollable dialog instead of overflowing the page by @haizhi03 in PR [#2873].
• Dashboard refresh controls leave the loading state when a refresh fails by @HandSonic in PR [#2688].
• Interrupted task deletions can resume cleanup on application startup without deleting a newer export that reuses the original filename by @HandSonic in PR [#2742].
• SSH connection-error logs no longer include passwords, private-key passphrases, or key-file fields by @Aias00 in PR [#2471].
• The connection-close API now requires POST /api/connection/close with a JSON request body instead of GET query parameters. API clients that call this endpoint must update their requests by @HandSonic in PR [#2679].

Full Changelog: https://github.com/OtterMind/Chat2DB/compare/v5.3.5...v5.3.6