HeidiSQL: vanhemmat versiot ja versiohistoria

12.22 - 2026-10-25
⛰️ Features
- New login manager for MS SQL Server, closes #17 - (7ffb2f1)
- New role manager UI for PostgreSQL, closes #80 - (4267133)
- Show hints in all controls if set. Same as in master/37d02ea3 - (e07a913)
- Inject branch commit count as build number at build time - (a8fd18e)
- Build, sign and notarize macOS app bundle in CI - (cae4e0c)
- Install Lazarus 4.8 on Windows and macOS runners, drop setup-lazarus action - (46ea9be)
- Use fully qualified table name in "Select Top x rows" action when a click on it is combined with Shift - (06ab070)
- Add Linux Qt theme selection - (816a819)
🚀 Enhancements
- Hint at "Send batch in one go" for undeclared variables on MS SQL - (4ed6e5f)
- Rephrase warning message displayed when a grid edit/delete did not affect any row - (9da8a80)
🐛 Bug Fixes
- Firebird access violation on macOS; fail app bundling on missing client libs - (b012582)
- Correct relative target of firebird.msg symlink - (c80253d)
- Link bundled firebird.msg from Contents into Resources - (de488ed)
- Place fbclient in Contents/Frameworks for session manager detection - (400944e)
- Single rpath and @loader_path rewrites for bundled Firebird client - (c83d850)
- Move bundled Firebird client to Contents/Resources to satisfy codesign - (512bd5f)
- Pkgutil --expand requires non-existing target directory - (e546c29)
- Bundle missing fbclient library in macOS app bundle - (feca7eb)
- Make "apply filter" and "clear" buttons visually distinguishable - (160187d)
- Crash when creating event in object editor - (d5ec718)
- Support InterBase BOOLEAN columns and its missing partial column load. See #2527 - (b572b2f)
- Only offer matching Firebird or InterBase client libraries - (821c2d4)
- Interbase/Firebird column types, DEFAULT clause order and SUBSTRING. Closes #2527 - (d9ab3cc)
- Make build number injection portable to BSD sed on macOS - (620e5b1)
- Crash when selecting a table on macOS x86_64 - (690972a)
- Session manager crash on macOS x86_64 from enum dictionary keys - (7c1608e)
- Repair tab sections with empty name in tabs.ini on restore. See #2637 - (805722c)
- Blinking caret in query editor after using code completion - (6b1a156)
- Non-appearing context menus on tree nodes in session manager, table and routine editor - (b280ef0)
- Visible dropdown arrow on toolbar buttons with dark Qt themes - (84c0f0e)
- Sort folders and files alphabetically in file open/save dialog - (285cb8b)
- Prevent slash in session names from corrupting settings import and session clone - (2f21438)
- Render VirtualTree content at correct size on macOS retina - (832ff89)
- Missing translation for error message - (a87845f)
- Indexes created with CREATE INDEX not shown on MS SQL - (8c41545)
- Hanging query tab and double execution of non-SELECT queries on MS SQL - (a48a722)
- Use TBlobField.SaveToStream instead of DataStream, unavailable in FPC - (816cbd2)
- Fetch MS SQL binary column values via TBlobField stream in GetColBinData - (8f34f5f)
- Wrong hex prefix/postfix for PostgreSQL, insecure break after testing 1024 characters in IsHex - (2b64345)
- Hide LIKE quick filters in context menu of binary grid values, which would now be broken through quoted hex values - (dc5c5ab)
- Use correct hex prefix/postfix on MS SQL and PostgreSQL, allow odd length of hex body in MySQL - (bdb27f1)
- Wrong IsHex result on non-MySQL connections, prevent escaping quotes in SQLite hex values x'aa...' - (29d26b5)
- Use connection specific hex prefix and postfix when editing binary values in grid - (e06a4ff)
- Implement TSQLiteQuery.GetColBinData for byte-exact BLOB access - (b49cd3d)
- Read SQLite BLOB columns via sqlite3_column_blob instead of truncated text - (24b80ba)
- Assign SQLite procedures sqlite3_column_blob and sqlite3_column_bytes to TSQLiteLib - (707543c)
- State updated Lazarus 4.8 version used in workflow - (7b0684d)
- Use Cmd instead of Ctrl for default keyboard shortcuts on macOS - (5aaa0eb)
- Splitter between query editor and results not d

12.21 - 2026-08-03
⛰️ Features
- Create opt-in option for displaying columns in database tree - (f492bed)
- Enhance order of items in completion proposal, so exact matches are at the top - (c1b817b)
- For keyboard navigation on the completion proposal, wrap around the item list - (db952f8)
- First attempt to create a user manager for PostgreSQL - (f0d7103)
- Show index icons on columns in tree, and the data type text color - (e6e90aa)
- Auto-adjust width of various combo boxes - (ca9b748)
- Show table columns in tree, as child nodes - (0e20e70)
- Query size of all indexes in one query - (c5201eb)
- Display size of each index and paint a color bar behind it - (48a93d2)
- Make custom proposal popup interval effective - (500c529)
- Icons, colors and padding in completion proposal - (3d1254d)
🐛 Bug Fixes
- (ui) Exchange icon for "column" and its variants for add, delete, edit - (08558f9)
- Sporadic crash in DBtreePaintText with columns - (f76c54f)
- Enable foreign key drop down on grid field in MS SQL mode - (9f83561)
- Remove column nodes from tree in table tools dialog - (b09823e)
- Empty command line part for sshpass on FreeBSD - (ed881b3)
- Handle MONEY column types as float - (67521d4)
- Hang and wrong check states in data grid column selection on macOS - (6c5b66c)
- Invalid folder path for SQL export cannot be created if it contains a duplicated path delimiter - (4555274)
- Various CVEs regarding libssl and libcrypto - (379d28a)
- Context menu does not appear at right-click on a tree node text - (8befce3)
- Crash when opening textfile import dialog, with 0 tables in database - (83c4947)
- Crash when cancelling session manager while a session rename is active - (1da8683)
- Prevent crashes from SetFocus on various controls - (bf46821)
- Data grid header keeps showing previous table's columns on macOS - (255695d)
- Prevent SQL error "Property 'MS_Description' already exists" - (ac50b73)
- Enhance anchors on some of the table editors controls - (bfebd9e)
- Bad width of collation combo box - (a90f73c)
- File > "New window" does nothing on macOS - (0583a4e)
- Still wrong proposal background color in dark mode - (e62c47f)
- Wrong proposal background color in dark mode - (eec978c)
- Crash when opening a table, due to using the TCanvas member of a not yet visible form or frame - (bfe29c1)
- Give the trees and grids more height for the header - (568098a)
- Widen many TSpinEditEx instances to either 80px or align them with neighbor controls - (5964be6)
- Some trees have their own OnContextMenu logic set at design time, do not overwrite - (7c2870a)
- Work around unused Header.PopupMenu menu on Linux when a tree has a PopupMenu - (2030a91)
- DPI related scale glitches, mainly on completion proposal - (905b126)
- Do not paint size bar in nodes of level 2, and do not show "-" text there neither - (3e678bc)
- Bad text color for selected item in proposal - (1c46db7)
- Propose items when editor already contains a leading backtick quote - (8f12b3e)
- Missing support for custom keyboard shortcut for executing completion popup - (79f1d38)
- Glitches with padding in completion proposal, and non-restored width - (cf67d11)
- EXPLAIN actions either disabled or non-working for PostgreSQL and SQLite - (2572681)
- Hanging in a loop over result nodes by right-click on query result - (bc8f903)
- Detect release version string from Lazarus project file, and insert into Contents/Info.plist of macOS bundle - (2171b58)
- Crash during refresh on disconnected session - (0b0106d)
- When parsing the command line, make use of Application.GetOptionValue and friends, instead of ParamStr(x) with regular expressions - (f436354)
- Use default library of connection when the one from a stored session contains an invalid path/file - (51023c3)
- Refresh session tree after import per More > Import settings file - (cfca46f)
- CAS(x AS CHAR) not supported by MySQL below v4.0.2 - (e9e5263)
- Always enable release link label on update check dialog, which points to the general 

12.20 - 2026-06-22
⛰️ Features
- Support some keywords like CURRENT_TIMESTAMP in SQLite default value drop-down - (dbadd37)
🐛 Bug Fixes
- SelectUserNode on macOS cannot find a newly created node with a TUser, probably because nodes were refreshed too late in OnBeforePaint - (f6c5d2d)
- Expect "IF NOT EXISTS" clause in trigger definition - (71af8d3)
- Reveal procedures and function in MySQL which are stored with correct case in mysql.proc - (106010e)
⚙️ Miscellaneous Tasks
- Ignore all .po translation files pulled from Transifex - (611212a)
- Restrict cliff release notes from previous tag to current one, prefer spaces indentation in Makefile variable assignment - (548f44f)
Note

For a list of all the changes up to date, please read CHANGELOG.md.

12.19 - 2026-06-20
⛰️ Features
- Label the new tab like the selected table, in the "Select top x rows" action - (f87cc85)
🚀 Enhancements
- Pass LogLevel=error to the SSH command line - (923296d)
🐛 Bug Fixes
- (ui) Apply "disabled painting" to tree node icons, not to the text which gets unreadable - (4b2f469)
- Crash in grid export with no focused column and usage of IfThen() which evaluates all arguments before the function is called - (bfe336b)
- Reveal default text value of SQLite columns - (7f6e368)
- Do not use INVISIBLE keyword on MariaDB - (fb082b8)
- Prevent duplicate icons in Linux Alt-Tab by providing StartupWMClass with what xprop told me in the WM_CLASS line - (249c311)
- Compiler error 4001 on arm64: Incompatible type - (1dbe1ae)
- Compiler error 4001 and 4025on arm64: Incompatible type for arg no. 1: Got "SYSTEM.UITYPES.TFontStyles", expected "GRAPHICS.TFontStyles" - (aefc8fb)
- Compiler error 4001 on arm64: Incompatible types: got "TFontStyles" expected "Set Of TFontStyle" - (f67445f)
- Unhide hint on lblPasswordHint - (5f35d41)
- Initially visible password hint may confuse user - (ed0f932)
- Set new authentication plugin only if the user changed it, and then hint the user this will reset the password - (4ed89b8)
- Error dialog due to unsupported SHOW GLOBAL VARIABLES query on MySQL 3.x servers - (49c70f8)
- Truncate strings on UTF-8 boundaries in StrEllipsis - (2174388)
- Prevent access violation on session disconnect (nil ActivePage) - (f878277)
- "sort alphabetically" checkbox in column selector does nothing on macOS - (ec2b942)
- A checkbox does not seem to have Focused on macOS during a mouse-click - (c21f646)
- Work around mysql bug for "hidden" routines in UPPERCASE databases - (f51834c)
⚙️ Miscellaneous Tasks
- Add missing download QT6ARM step to release job - (7df0567)
- Align hostname in Transifex config file with the one in my ~/.transifexrc - (1a316c6)
- Align Transifex config to current directory structure, and add a client for Windows - (40bfb69)
- Require new step in release job, fix /tmp naming - (1fb805d)
- Attempt to compile a QT6 binary for Linux ARM64 / RaspiOS - (5dc2bc4)
Localize
- Update compiled .mo translation files - (ae730a8)
Contributors
- @ansgarbecker
- @ in #2514

12.18 - 2026-06-09
⛰️ Features
- (packaging) Create .rpm package through Makefile, plus let GH action run that step in release mode - (fc728cf)
- Create checkbox in advanced session setting for new ForceUnicode setting - (75a0f7f)
- Create opt-out setting "ForceUnicode", for sessions which shall not force Unicode communication - (ed9a94f)
- Enable connection port visible in a column of the session tree - (7cfdb97)
- Display auth plugin in a new column of the user listing tree - (3e4f562)
- Support authentication plugin selection in user manager - (07112a0)
- Grid export option for exporting the focused grid column only - (d896680)
- Bypass automatic foreign key lookup in data grid editing through new menu item - (a5ae04b)
- Add a separate menu item "copy formatted text", using the old code for copying SynEdit-highlighted text as HTML - (84c63c6)
- Filter edit box for shortcuts in preferences - (fb243fc)
- Create CLI app for adding PE security flags to heidisql.exe - (3e797e2)
- Rename snippet per right-click on query helpers tree - (7171e48)
- Name columns in SELECT when exporting table with invisible columns - (1799b0d)
- Support invisible indexes on MySQL 8.0+ and ignored indexes on MariaDB 10.6+ - (b3fa484)
- Support assigning a default role to a user - (96d2aef)
- Support assigning roles to a user or role - (96717cd)
- Do not require MySQL's RELOAD privilege just for opening the user manager - (f79d9a5)
- When nodes are filtered, change "Check all" action to "Change all visible" - (ebd60b3)
- Disable role rename, add menu item for creating a role, support role deletion - (83472c5)
- Prevent editing contents of generated columns in data grid - (9ecdff0)
- Basic support for MariaDB user roles, loaded without SQL error and shown with a different icon - (3249401)
- Add context menu item for deleting a single query from the history - (0035d5e)
- Reset a table's current auto_increment value in "delete + insert data" mode - (0422bb3)
- Support cancelling server login dialog - (e5b9574)
- Keep EXPLAIN output format traditional, on newer MySQL servers - (90f9937)
- Make HTML export dark/light mode aware - (dc046e9)
- Allow setting database to in PostgreSQL connections, and show and in the pulldown selector - (950e2ca)
🚀 Enhancements
- Disable plugin selector as long as no user was selected - (54dd7d8)
- Do not copy default type and value from previous column when adding columns to a table - (42a061d)
- Suppress dialog for saving modified SQL on app close, when tabs get auto-restored - (4ca01d9)
- Remove FLUSH PRIVILEGES from the user managers FormShow handler. If a click on a non-flushed user in the tree produces an exception, that is caught and shown as a normal error message. - (fe7a5ef)
- 50% black grid lines, should fit on both light and dark theme - (1872916)
- Increase supported table size and row limit for quick filter menu showing distinct values - (48eca57)
🐛 Bug Fixes
- (ui) Filter away vertical writing fonts with an @ prefix - (1814ee9)
- (ui) Size and margin of buttons on SQL help dialog - (61bc258)
- (ui) Apply the same larger tree node height on Linux - (c770406)
- (ui) Remove default "add user" event from add button, turn it into a pure dropdown button - (d7910c1)
- Copy table dialog crashes when none of dbtree and listtables has Focused=True - (9216061)
- Prefer SHOW KEYS over SHOW INDEXES, which are synonyms, while very old servers only accept the one with KEYS - (b97122c)
- Prevent grid queries from doing "WHERE intcol::text = 1", due to "1" being incompatible to the text value on the left - (bcea889)
- Vulnerability CVE-2025-70873, updating SQLite libs to v3.53.1 - (2930be8)
- Complaint about invalid password length on user plugins which have no fixed password length - (510b141)
- SUBSTRING() on array typed VARCHARs throw "function substr(...) does not exist" - (5f2959d)
- MS SQL throws "Cannot drop database xyz, because it is currently in use" when user is about to drop the current database - (fa2bb05)
- Wrong

12.16 - 2026-03-10
⛰️ Features
- (packaging) Add libqt6pas dependency - (a3e6d0b)
- (packaging) Ship qt6 build in deb package, enhance control file fields - (992b673)
- (ui) Turn all TEdit's with NumbersOnly into TSpinEditEx - (96bb466)
- Select just created table copy - (18e9431)
- Add toolbar button for toggling reverse foreign key listing, so the user has the chance to disable its potentially long during query - (938f303)
- Reverse foreign keys on "Foreign keys" tab in table editor - (ca48343)
- Add menu item Edit > Copy column names - (ce93931)
- Prevent loading an SQL file multiple times into an editor - (153e61d)
- Add sshpass.exe v1.0.6 for Windows, and refactor Windows installer script - (d79d462)
- Inject app name and version into potentially long during SQL queries for the SQL export - (93e1b39)
- Run user startup script in DoAfterConnect call, which includes reconnects - (1b27b1d)
- Add "Display" main menu, move some spread items there, and add two items for toggling log panel and tree filters - (c0fbcff)
- Support BOOLEAN column type in MySQL - (e796ad1)
- Re-enable clickable "Analyze query" label on host > processes - (678c7b8)
- Create SQL export option for wrapping DML commands in a BEGIN/COMMIT transaction - (5560454)
- Display approximate row count of tables in database tab on MS SQL - (146044f)
- Support full table status option in SQLite, showing "Rows" from COUNT(*) for each table - (422935a)
- Add security policy for supported versions and reporting - (7ce4a23)
- Prefer KILL QUERY over KILL on MySQL and MariaDB, when using the "Kill process" menu item in Host > processlist - (b3743d8)
- New attempt to leave the main window invisible behind the session manager - (be5322c)
- Show virtual, stored and hidden columns in SQLite - (0a87a73)
🚀 Enhancements
- Move color scheme submenu from Tools to Display menu - (f7f90e8)
- Export tables which are hidden through the table filter - (42e5277)
🐛 Bug Fixes
- Crash on macOS, due to running Connection.ShowWarnings directly in the TQueryThread - (d62807a)
- Less aggressive debug compile mode, made the app unresponsive when trying to close - (8d48099)
- Two more exception causes found in uploaded reports - (e33ea1d)
- Sporadic "no database selected" when updating grid header with row details - (c9eb765)
- Wrong use of Copy(), which is one-based not zero-based, and remove translated appendix to snipped log message which may use critical chars and confuse SynEdit - (e3fc3f5)
- Various crash causes, reported in uploaded bug reports - (6215d19)
- Missing required package LazControls for TSpinEditEx - (519a84a)
- Remove default keystrokes from query editor: 2x ecRedo and 1x ecDeleteLine - (2bc9d78)
- Wrong SQL on MS SQL when renaming table per table editor - (a763fd1)
- Use default brew path to sshpass on macOS - (b7c3d07)
- Status bar text gets written into the panel right besides the current one, on Linux/macOS - (dfb86d5)
- Several crash causes Host subtabs when connection is lost externally - (1029657)
- Non stored global setting for "sort alphabetically" checkbox in column selection - (0ccb1ac)
- High CPU load and unresponsiveness through SynEdit highlighter when starting to edit large text in popup editor - (676fcd7)
- Crash when enabling TShellListView.MultiSelect in OnFormShow, now sets options per setter method, before FormShow - (2acce35)
- Crash on right-click in empty area of query result grid - (6309305)
- Data grid context menu not opening after click in empty area - (10fc117)
- Repaint columns list after move up/down a column - (6a0cbe3)
- Out-of-memory error in call to sqlite3_open() on a non-existent SQLite database file - (e93924f)
- Font bold + italic setting not stored in settings - (cc5b811)
- Potentially crashing typecast in LoadRecentFilter - (da07591)
- Non-themed white area on TTabControl, fix from https://github.com/zamtmn/metadarkstyle/issues/75 - (7554364)
- Forgotten files in c01a439ce5f3bd4b4ec748937175e6045e8d935e - (8098296)
- Initial FK names

Note: You can already get a preview of v13 for Windows, built on the same codebase as the Linux version. See the
download page for a zip package.
3rd party updates:
- update SQLite library to v3.51.0
Bugfixes and enhancements:
- fix: crash when grid-exporting without required key (issue #2311)
- fix: cannot save new table when added column was removed (issue #2326)
- fix: delete CLI-created session settings from registry after disconnect (issue #2162)
- fix: query batch stops at second last query if it has errors but StopOnErrors is off (issue #2317)
- feat: support SSH tunnel configuration per commandline (issue #2322)
- disable tree option asDoubleClickInsertsNodeText by default (issue #2307)
- fix: require elevation per build button only if app directory is not writable by user (issue #2305)
- feat: keep time fractions intact for CSV exports (issue #2098)
- fix: crash in AnyGridPaintText with no query result
- feat: show NULL values in system variables listing (issue #1281)
- feat: highlight same text in grids based on all selected rows
- fix: crash in printer dialog with 0 printers available (issue #2283)
- feat: support fractional UNIX timestamps in grids (issue #884)
- feat: add "source table: xyz" hint to query result column headers https://www.heidisql.com/forum.php?t=44554

Get it from the release page on Github:
- Windows: https://github.com/HeidiSQL/HeidiSQL/releases/tag/v12.13.0.7147
- Linux: https://github.com/HeidiSQL/HeidiSQL/releases/tag/v12.13.1.1
The v12.13 files are now hosted on the Github release pages, in the "Assets" area.
New stuff:
- Linux releases are built through Github Actions, in QT5 and GTK2 variants. A big thank you goes to Gus for making this happen!!
- feat: sort sessions and folders according to user locale (issue #1828)
- feat: sort session folders at top per setting (issue #1828)
- feat: filter box in user manager (issue #2275)
- add checkbox "Open file after creation" to grid export dialog (issue #912)
Bugfixes and enhancements:
- fix: sort empty session folders like non-empty ones (issue #1828)
- fix: set modified flag after move per button (issue #2220)
- fix: column reordering per drag and drop (issue #2220)
- fix: list procedures in PostgreSQL(issue #2278)
- fix: missing DELETE HISTORY privilege on MariaDB (issue #1026)
- fix: prevent crash in auto-refresh action (issue #1060)
- fix: bad message with no library selected (issue #1020)
- Table data generator: generate missing values for geometry columns
- allow modify length of index with binary column (issue #900)
- fix no longer working move up/down of selected columns, see https://www.heidisql.com/forum.php?t=44467 (issue #2220)
- end global "edit function" mode for grid editing early (issue #875)
- take care for escaped ENUM definitions (issue #799)
- work around non-greedy expression when extracting the return data type of a stored function with a space in it. (issue #768)
- safety replacement for folder separator when renaming a session or folder (issue #682)
- leave away schema when double-click table for inserting into query editor (issue #551)
- fix sticky empty-password warning after setting a non-empty one (issue #441)
- allow sorting columns in table designer by click on their header (issue #2220)
- ignore semicolon between double-dollar quoted strings when separating SQL queries by semicolon, e.g. $$ foo; bar $$ (issue #1326)

3rd party updates:
- Issue #2076: exchange 32 bit SSL libraries with their 64 bit pendants, fixing SSL connections with libpq and libmariadb