BroadSQL BroadSQL Download
On this page
Documentation / Release notes / Release Notes 5.5.0

Release Notes 5.5.0

Published October 17, 2026

New features

  • Production: on a connection whose Environment is flagged Production, BroadSQL asks before every statement that can modify the database (ProductionConfirmEveryChange=TRUE) or once per connected session (FALSE); without a terminal such statements are refused
  • Security: SET MASTER PASSWORD works on a verified copy with a backup, recovers an interrupted change at the next login, and refuses spaces and characters outside Latin-1 that would make the CDF unopenable
  • Security: SET PASSWORD changes passwords only on H2, Derby (NATIVE authentication) and HSQLDB, proves the change with a new connection before saving it, and is refused before any change on other databases
  • Settings: CONFIG has an Application Settings tab that shows and safely edits every setting of the INI file
  • Logs: LogRetentionDays (default 90) deletes old activity and application log files at startup; leftover DUMP temporary files are removed
  • Downloads: every release has a SHA-256 checksum on the Downloads page and in a .sha256 file
  • Documentation: a rewritten Security page
  • Console: the command history keeps the last 1,000 commands, in order, across restarts, and an unreadable line no longer hides the whole history
  • Settings: in CONFIG, paths are typed as they are, and a missing folder is created after confirmation
  • Connections: BroadSQL starts at the BroadSQL> prompt without a database connection; SQL without a connection is refused with "No active database connection."
  • Connections: RememberLastConnection=TRUE reopens the last connection at startup and makes DISCONNECT, BYE and CLOSE return to the previous connection
  • Connections: DISCONNECT, BYE and CLOSE return to BroadSQL> (or to the previous connection), never to the CDF
  • Configuration: CONFIG and CONFIG API work from any prompt
  • Security: CONNECT $CDF asks for the master password every time and opens CDF maintenance mode ($CDF [MAINTENANCE]>)
  • Security: no ordinary connection, test, export, linked table or monitoring file can reach the CDF, under any name, path or copy
  • Security: LOGOUT (alias LOGOFF) closes every connection and window and asks for the master password again
  • Configuration: the CDF has a schema version; an older CDF is upgraded once at startup after a verified backup in conf/backups, a newer one is refused unchanged
  • Scripts: a -- @param parameter that the call does not pass takes the value of the session variable of that name set by LET, otherwise its default; a session value of the wrong type refuses the call
  • Scripts: the arguments of a Script call last as long as the call; afterwards each variable of the same name has its previous value again (a LET run by the Script itself stays)
  • Editor: the Run Parameters dialog takes a text without quotes and a list without parentheses, starts each field with the session variable or the default, keeps Run enabled and lists every invalid value in one error dialog
  • Scripts: typed, optional and defaulted Script parameters, -- @param <name> <type> [= <default>] ["<description>"], checked and converted before the Script starts
  • Scripts: list parameters, -- @param ids LIST OF <type>, passed as ids=(1, 2, 3) and used as IN (${ids}), each value sent as its own typed parameter
  • Scripts: -- @access: read | write (information, checked by LIB LINT) and -- @dialect: <types> (a warning on another connection type)
  • Scripts: LIB TREE shows the Scripts Library as a folder tree; LIB LIST and LIB FIND group their Scripts with BY TAG, GROUP, ENVIRONMENT, DIALECT, STATUS, ACCESS or FOLDER
  • Scripts: LIB LINT reports duplicate Scripts and checks @param, @access and @dialect lines
  • Editor: the Metadata tab shows the typed parameters and edits Access and Dialect; the Run dialog checks values like the command line; search matches tags
  • Export: after a successful DUMP or PULL, a second line gives the completion date and time with its UTC offset and the elapsed time (Completed: 2026-10-14 19:25:43 +02:00 (0:01:12).)
  • Export: DUMP <source> TO <connection>.<table> AS H2 MODE MERGE KEY(<column>[, <column> ...]) inserts new rows, updates changed rows and keeps the others, in one transaction; a NULL or duplicate key, a conversion failure or different columns write nothing
  • Export: AS XLSX to a new file, a new worksheet or with MODE OVERWRITE streams its rows: a million rows need a few hundred megabytes instead of several gigabytes, about three times faster
  • Export: Ctrl+C cancels a DUMP or PULL while the database runs its query and between two written rows, with a message saying what was left behind; long exports print a progress line every 10 seconds
  • Editor: Edit > Replace... (Ctrl+H) opens one Find and Replace dialog (Find what, Replace with, Match case, Find Next, Replace, Replace All); Replace All is one undo step
  • Editor: the Scripts pane has a Recent view listing the 20 Scripts most recently opened, saved or run
  • Documentation: HELP <command> and every page of the command reference give the purpose, the syntax, an argument table, examples, the details by topic and the related commands and guides, with a quick start for the commands that take several forms

Problems solved

  • Connections: H2 passwords containing a semicolon, a quote or a backslash now work, and a refused login no longer shows part of the password
  • Export: DefaultFolder works without a final separator, and a relative DefaultFolder works with DUMP AS H2
  • Export: a cancelled or failed export no longer leaves a .tmp file in the export folder, and running out of memory gives a clear error with the destination unchanged

Installing BroadSQL 5.5.0

See Installation.

Upgrading from previous releases

No special steps required for this release.

Known issues

None known at release time.

← All release notes