Free universal database tool and SQL client
- General:
- Migration from Toad for Oracle was supported
- Sensitive information in the log files is now masked
- SQL Editor:
- Smart mode for 'Blank line as statement delimiter' option was added (enabled by default)
- Sub-select autocompletion was added
- Highlighting of column references in INSERT queries was fixed
- Outline viewer opening was fixed
- Issue with hidden text on macOS was fixed
- Connectivity:
- Space trimming when saving user credentials was added
- Saving SSH configuration with missing AWS private key was fixed
- Reconnecting via SSH tunnel was fixed
- ER Diagrams: foreign keys presentation was fixed
- AI:
- AI assistant is enabled by default
- Database metadata collection was fixed
- Dashboards: disappearance of custom dashboards after version update was fixed
- Connectivity:
- Space trimming when saving user credentials was added
- Saving SSH configuration with missing AWS private key was fixed
- Reconnecting via SSH tunnel was fixed
- Connectivity:
- Using multiple jumps tunnels when connecting via SSH was supported
- Enable tunnel sharing option was added
- Test connection was fixed
- SQL Editor:
- WHERE TRUE and SELECT UNIQUE support was added
- Error with single quoted string was fixed
- Syntax highlighting after active schema change was fixed
- Data Editor:
- Automatic row count option was added (thanks to @utsav1704)
- Metadata editor:
- Deleting table comments was fixed
- Linking with the editor was fixed
- General:
- Ability to collect log files from the interface was added
- Transaction rollback behavior was fixed
- Metadata changes were removed from the commit counter
- Autocommit in production databases was fixed
- Data transfer:
- Ability to specify header case in the target file was added
- Typo in the confirmation dialog was fixed
- Databases:
- Cubrid: Query plan feature was added (thanks to @rathana-pvs)
- Old MySQL drivers were repacked
- PostgreSQL: Jobs, roles, and system information were hidden in the Hide Folders mode
- SQLite: Deleting columns was fixed
- Connectivity:
- Shared SSH sessions support was added
- Connection via native proxy was fixed
- Dark theme support on the Connection page was improved
- SQL Editor:
- Highlighting, validation, and outline for INSERT, UPDATE, and DELETE were supported
- Incorrect cursor position during autocomplete was fixed
- QUALIFY keyword was supported (thanks to @ashu7896)
- Metadata editor: automatic reference column creation for a new foreign key was implemented
- Data Editor:
- Opening of a table with empty data was fixed
- SRID editing was fixed
- General:
- SVG icons support was added
- Error when checking checkboxes in the Formatting page in Preferences was fixed
- Disappearance of renamed project was fixed (thanks to @saikotek)
- Databases
- Dameng: Sequence creation was fixed
- DuckDB:
- Sequences, views, and table definitions were supported
- Ability to add comments via UI was added
- MySQL: link to the driver documentation was fixed
- RisingWave: non-working functions and folders were removed
- PostgreSQL: issues with scheduled jobs was resolved
- SQLite: errors when creating table was fixed
- SQL Server: redundant authentication types were hidden
- Sybase: stored procedures support was improved
- Teradata: procedures and functions DDLs reading was enhanced
- Localization:
- Romanian language support was added (thanks to @v613)
- French translation was updated (thanks to @Jean-BaptisteC)
Changes since 23.3.5:
- SQL Editor:
- Nested CASE statements were supported
- Deleting queries from Outline was fixed
- Type casts support was improved
- Handling of right-click on collapsed query was fixed
- Expanding collapsed group after the code execution was fixed
- Metadata editor: changing the key name when a constraint is changed
- Data Editor: SRID switching in the Spatial data viewer was fixed
- ER Diagram:
- Missing connection lines were fixed
- Mikami-Tabuchi routing type was disabled
- AI:
- Comment presentation was improved
- Sending unique keys and indexes was fixed
- Data Transfer:
- Export statistic was fixed
- Import blocking in case of table creation restriction was fixed
- Stack overflow on Linux was fixed
- Connectivity: closing timeout for an idle connection was increased and disabled for embedded drivers
- Security:
- Vulnerabilities display in Elasticsearch was fixed
- PosgtreSQL driver was upgraded due to CVE-2024-1597
- General:
- Smart commit mode was enhanced: if the manual commit mode was enabled and just after it the query failed, the smart commit mode is enabled again
- Links between preference pages were fixed
- Issue with not found tables was fixed
- Release note display was corrected
- Driver libraries download was fixed
- Previous workspace format was supported
- Usage statistics popup was redesigned
- Databases:
- DuckDB: WSL paths handling was fixed
- Greenplum: STRICT keyword was added to function definition
- Hana: Switch to the Kerberos authentication in the Connection page was fixed
- MariaDB: The exported JSON format was fixed
- MySQL and MariaDB:
- "Disable Triggers" option was added to the Context menu
- "Case-sensitive" option was added to the metadata search
- Databases with the same name but different name case are considered as different databases
- Oracle:
- Generating DDL for triggers was fixed
- SQL Server: additional table properties were added for tables and views in the properties editor
- Yellowbricks icons and link to the website were changed
- SQL Editor:
- Syntax highlighting was improved
- Highlighting in nested queries and on query editing was fixed
- Scrolling with opened Outline was fixed
- Applying settings to Outline was fixed
- Order by i.* was supported in Outline
- Joined tables presentation in Outline was fixed
- AI: Ability to send object descriptions to OpenAI was added
- Data Editor:
- Scrolling multiple tab result was improved. You can scroll all result sets using Ctrl
- Fetch next page shortcut was changed to CTRL+ALT+N
- ER Diagram: Connections rendering was improved
- Data transfer:
- The Proceed button at the last step became more visible
- On conflict expression was added to INSERT statements
- Crash when importing CSV file was fixed
- Extra space before the semicolon in export to SQL was removed
- General:
- Close idle connection setting saving was fixed
- Application launch was improved
- Unexpected transaction ending was fixed
- Settings are applied to new connections without a restart
- User credential dialog was fixed
- Issue with the background task of the dashboard update was fixed
- Temporary directory creation was fixed
- Security: Added warning when trying to open an encrypted project and risk losing all connection credentials
- New driver:
- StarRocks database support was added
- Databases:
- MariaDB driver was updated to version 3.3.2
- Oracle:
- Keywords and schemes highlighting was improved
- Default subpartition type was added
- PostgreSQL:
- Creating a new table from the user interface was fixed
- Duplication of procedures was fixed
- Snowflake: VIEW keyword highlighting and validation was improved
- SQL Server:
- Syntax highlighting was fixed
- Sybase:
- Stored procedure creation was added
- Using create view instead of Alter view was fixed
- Import with table mapping was fixed
- Localization:
- French translation was updated (thanks to @Jean-BaptisteC)
- Babel version was updated
- Metadata Editor:
- Constraint creation was fixed
- Editor performance on Linux was enhanced
- SQL Editor:
- Autocomplete for aggregate functions was added
- Arrays highlighting was added
- SELECT query validation was fixed
- Color and font settings with enabled semantic analysis was fixed
- Small font in the editor and result set was fixed
- Creating multiple parsing jobs was fixed
- Outline viewer:
- Composite types and arrays support and validation was added
- Data type decorations were added
- Error when saving SQL console as a script was fixed
- AI: Issue with using chat format in completion dialog was fixed
- Data Editor:
- Ignoring quotes option was added to Advanced paste
- Issue with multiple checks in filters was fixed
- ER Diagram: Self-connection rendering was enhanced
- Data Transfer:
- Delimiter selection when exporting in TXT format was added
- Target table change on the mapping page was fixed
- General: Idle connections behavior has changed, now they are automatically closed by default after some time
- New drivers:
- RisingWave driver support was added
- Cubrid driver support was significantly enhanced (thanks to @longhaseng52)
- Databases:
- Altibase:
- Adding and renaming constraint in metadata editor was fixed
- Reading data in columns with quote names was fixed
- Clickhouse: Legacy driver was fixed
- MySQL and MariaDB: 'Grant option' is checked only if grant permission exists
- Snowflake:
- Snowflake driver was updated to version 3.14.4
- Double-dash single-line comments highlighting was fixed
- Functions words were added to SQL Editor
- SQLite driver was updated to version 3.44.1.0
- TDengine: Unqoted table names presentation was fixed
- PostgreSQL: Option 'Show all databases' was moved to the main page in the Connection settings
- Redshift: Added extended support for stored procedures for early Redshift versions
- Misc:
- Links to download PRO version were added
- Ability to use waffle-jna in MariaDB, PostgeSQL, and Oracle was added
- Flipped splash screen on macOS Sonoma was fixed
- Metadata editor:
- Object creation dialog was redesigned
- SQL Editor:
- Autocomplete for INSERT statements was fixed
- Case sensitivity on highlighting and validation was fixed
- Duplicated table aliases in autocomplete were fixed
- Column aliases highlighting was fixed
- Dot character is not allowed again in variable name
- Data Editor: Column descriptions are displayed again
- Database Tasks: Display of task execution time was fixed
- ER Diagram: One-to-one connection rendering for unique/primary key was fixed
- Data Transfer:
- All columns can be marked as skipped when exporting data
- Statistics was excluded from exported data
- General:
- Changing the monospace font was fixed
- Unique key creation was fixed
- Finding local clients on Linux and macOS was improved
- Databases:
- Altibase support was added (thanks to @zennken)
- BigQuery: Structs and arrays are supported
- Dameng:
- Dameng driver was updated
- Users, roles, and categories are supported (thanks to @Stkai)
- MySQL: Path to the local client was fixed
- MySQL and MariaDB: Rendering columns with unique identifiers was fixed
- PostgreSQL:
- Schema permissions display was fixed
- Confirmation message for clean option of restore wizard was fixed
- SQLite: Import with 'truncate target tables before load' option was fixed
- SQL Server:
- Check constraint option was removed from primary/unique key creation page
- Displaying source in the index properties was fixed (thanks to @HansenChristoffer)
- SQL Server driver was updated
- Localization:
- Japanese localization was updated (thanks to @doew)
- Misc:
- Microsoft Store version was fixed
- Starting application when the workspace directory is a link was fixed
- Metadata editor:
- New database objects wizard was redesigned
- Primary/unique key can be created automatically along with new columns
- SQL Editor:
- Outline viewer of SQL queries structure was added
- Execution time format was improved
- Toolbar customization page opening was fixed
- Identifiers coloring was improved
- Autocomplete was fixed for multiline comments
- Accessibility: notifications can be read with a screen reader (JAWs, NVDA or Narrator)
- ER Diagram: connection errors handling was added
- Data Transfer: Iicorrect links in settings were fixed
- AI: legacy OpenAI models were removed
- General:
- Incorrect links to help articles were fixed
- Redundant items were deleted from the Context menu
- Global network settings preferences page is available again
- Databases:
- ClickHouse: leagacy driver configuration was fixed
- Dameng: tablespaces are supported (thanks to @Stkai)
- Google Cloud SQL: redundant options were removed from the context menu
- MySQL: TLS 1.3 support was added
- MySQL and PostgreSQL: local native database clients can be found on macOS and Linux
- Teradata: metadata search was significantly enhanced
- Localization:
- Ukrainian localization was added (thanks to @CrazyTapok-bit)
- Italian translation was improved (thanks to @coluzziandrea)
- Portuguese localization was fixed
- SQL Editor:
- New highlighting and script validation were enabled by default
- SQL highlighting performance was improved
- Connection variables and system environment variables now accessible from SQ Leditor
- Handling of special characters was fixed
- Data Editor:
- Value selector panel was improved: you can switch the active panel with 'Ctrl+Tab' and change the active value in the context menu
- Advanced paste of multiple records was enhanced
- Spatial data zooming was improved (thanks to @kalkun)
- ER Diagrams:
- Diagram layout was enhanced
- Data Transfer:
- Users can change the data export task output format
- Data export from table to table was fixed
- Security:
- Oracle driver version was updated to 23.2.0.0
- General:
- We switched to Eclipse 2023-12
- Language detection for locale containing language and country was fixed
- Workspace opening was fixed
- ‘Statistic’ tab display was fixed
- Broken links in connection dialogs were fixed
- New foreign key name generation was fixed
- Databases:
- DB2: Loading schema statistics was fixed
- EDB: Packages duplicating schemas in the Database Navigator were removed
- Firebird: Function and procedure presentation was enhanced
- Google Bigtable name was corrected
- Greenplum: Rows policies were supported
- MariaDB: Result fetch size was fixed
- PostgreSQL:
- Indexes and constraints are displayed in partition DDL
- Backup of several schemas and several tables was enhanced
Changes since 23.2.5:
- Security: database drivers were updated due to security reasons: DB2, Google BigQuery, Athena, and YugabyteDB
- SQL Editor:
- Autocompletion of column names with special characters was fixed
- Output panel display in the statistics tab was fixed
- Selected query execution was fixed
- Queries with CTE execution was fixed
- Data Editor:
- Filter value search was fixed
- Advanced Copy as HTML with spaces in the column names was fixed
- Numeric value "infinity" representation was fixed
- ER Diagrams:
- Diagram update on metadata changes was fixed
- Automatic re-layout on notation or routing change was fixed
- General:
- Tips of the day were updated
- Constraints rename was fixed
- Idle transaction rollback notification was fixed
- Data Transfer:
- "Native clients" were renamed into "Local clients"
- Update on conflict behavior was improved (now it respects indexes too)
- Database restore was fixed
- List of supported variables was updated
- Database tasks: missing line break was added to the task log file
- Connections:
- Driver download error handle was fixed was fixed
- ‘Check for new driver version’ setting save was fixed
- Databases:
- Firebird: default values for procedure parameters are now displayed
- PostgreSQL/Greenplum: foreign key creation was fixed
- MySQL5 driver is available again
- Oracle: comments were added to the newly created columns
- A number of minor UI bugs were fixed