AIUse the AI service of your choice: your own OpenAI or Anthropic account, a local model, or your organization's LLM
Connection SetupImport connections from Oracle SQL Developer
DB Support: CouchbaseAdd support for Couchbase
SQL FormatterIntroduce a new SQL formatter
Schema & Data SyncCompare and sync the structure of two databases, schemas or tables Copy tables between database connections
SecurityUnlock the password vault using Touch ID or Windows Hello
Improvements
AreaDetails
AIRename, delete, pin and search chats in the AI chat history
Client-side commandsReport unknown client-side command parameters as errors
DB Support: MariaDBAdd support for system-versioned tables in MariaDB Add support for the VECTOR data type in MariaDB Improve support for JSON, UUID and INET4/INET6 data types in MariaDB
DB Support: QuestDBAdd support for the latest PostgreSQL driver in QuestDB
Driver ManagerAdd an option to lock a driver to a specific version to prevent automatic updates Update template drivers
FavoritesRestore the Favorites toolbar, available via View->Show Favorites Toolbar
OS Support: macOSLet administrators configure DbVisualizer without breaking the application's code signature
SQL CommanderUse tree order for recent connections in SQL Commander's connection selector, and also list them under All Databases
SQL FormatterFormat named arguments in function calls the same way as positional arguments Support the Format SQL option when scripting functions and procedures
Value ViewerDelete JSON object keys directly from the tree in the Value tab
Bugs Fixed
AreaDetails
Client-side commands@export doesn't quote text values when exporting to a .sql file without an explicit format @export writes no data rows when TextFunction is not written with the exact case
DB Support: CockroachDBScript Table may generate a CREATE TABLE that fails in CockroachDB
DB Support: MariaDBAlter Table drops check constraints in MariaDB
DB Support: OracleAlter Table may generate MODIFY statements for unchanged columns in Oracle
DB Support: PostgreSQLAuto-complete suggests partitions instead of partitioned tables in PostgreSQL
DB Support: SQL ServerAlter Table may generate ALTER COLUMN statements for unchanged columns in SQL Server Formatting may break bracketed identifiers in SQL Server
DB Support: SnowflakeFormatting ignores Snowflake table types such as TRANSIENT, HYBRID, DYNAMIC and ICEBERG QUALIFY clause is not formatted correctly in Snowflake
DDL GeneratorScript Table may leave out or change identity column settings such as the start value, increment and bounds
Driver ManagerDriver update fails when the new version requires additional artifacts
ExportA numeric Null Value Text is written to Excel as text in numeric columns SQL export may qualify INSERT statements with the wrong catalog
OS Support: LinuxCan't extend the main window to two monitors on Linux Changing the database connection in SQL Commander may be slow on Linux Frameless dialogs close immediately on the COSMIC desktop on Linux
OS Support: WindowsThe main window may not appear after startup on Windows Windows Security may block parts of the application, breaking the AI Assistant and the map viewer
OS Support: macOSDbVisualizer may freeze at startup or when running the first query on macOS
SQL FormatterCustom comment delimiters are ignored when formatting Formatting may not use the chosen formatting profile after a restart Formatting may split the :: cast operator, causing errors on execution
SSHDisconnecting a database connection that uses an SSH tunnel may not complete, or may report an error, if the database has already closed the connection