HeidiSQL

Ansgar Becker · HeidiSQL.HeidiSQL

A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL and SQLite, written in Delphi

HeidiSQL is free software for people who work with databases, and aims to be intuitive to use. "Heidi" lets you connect to a variety of databases, like MariaDB, MySQL, Microsoft SQL, PostgreSQL, SQLite, Interbase and Firebird. Once you are connected, you can edit data and structures in these databases. Invented in 2002 by Ansgar, HeidiSQL is still a popular tool for MariaDB and MySQL, and actively maintained.

winget install --id HeidiSQL.HeidiSQL --exact --source winget

Latest 12.16.0.7229

Release Notes

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 assigned in TfrmTableEditor.listForeignKeysNewText() were lacking the referencing table's table name in case the referencing table was not created yet (pr from Jochen Neubeck) - (d8cd61c)
  • Wrong schema queries in SQLite, always shows columns and indexes of first database file - (7072986)
  • BIT values in MS SQL grid queries prefixed with MySQL b'' style - (7456c38)
  • Random crash in dodgy typecast TEdit/TEditButton - (37add0f)
  • Crash when moving added column to very bottom - (b739799)
  • Load any foreign keys, anyway if the user owns them, on PostgreSQL - (dbab4cb)
  • Wrong captions on quick filter actions shown in preferences > shortcuts - (3e0bf91)
  • Crash in OpenTextFile, for a 0-bytes file - override the encoding to one without BOM - (27e26a6)
  • Keep column default value in table editor, when user changes its datatype to one in the same category as before (int β‡’ bigint) - (3c518ad)
  • Trim away spaces around name of routine parameter silently - (b681ebf)
  • Re-enable dropping sql files on main form - (314db47)
  • Missing translations, and rephrase the "themes not supported" text - (7dfad02)
  • TDBQuery.TableName always returned an empty string on MS SQL - (520a90c)
  • TDBQuery.Col() crashes with "Column not available" on certain locales - (a01acd1)
  • Reset DesignTimePPI in all forms from 120 to the default 96, let the IDE scale controls down and move or add some defaults like LCLVersion. - (e635ae5)
  • Allow $$ as delimiter again on non-PostgreSQL connections, and ` on non-MySQL connections - (71bb25b) 🚜 Refactor
  • Migration from Array[TSQLSpecifityId] to TSqlProvider - (31ba8bf) πŸ“š Documentation
  • (ui) Mark VCL styles as deprecated - (1ce80ea) 🎨 Styling
  • (ui) Remove border around reverse foreign key list - (6ed145e) βš™οΈ Miscellaneous Tasks
  • Bump version for v12.16 release - (d141124)
  • Move OpenSSL license file out of the dll folder - (5772d09)
  • Add Wine deprecation note used in the Windows builds - (5e34fa9) Localize
  • Update compiled translation files from Transifex - (a5f1a19) Ui
  • Hint the user in which path we are going to look for sshpass (macOS and Windows) - (86a96bd) Contributors
  • @ansgarbecker

Installer type: inno

Architecture Scope Download SHA256
x64 user Download D6632C9FB7041AA6CF9B7F72E36B8CF7C5C5B5AAC14265C7D55A39EA32613A91
x64 machine Download D6632C9FB7041AA6CF9B7F72E36B8CF7C5C5B5AAC14265C7D55A39EA32613A91

Details

Homepage
https://www.heidisql.com/
License
GPL-2.0
Publisher
Ansgar Becker
Support
https://www.heidisql.com/help.php
Privacy Policy
https://www.heidisql.com/privacy.php
Copyright
Copyright (c) 2000-2026 Ansgar Becker
Moniker
heidisql

Tags

databasedb2developdevelopmentidemssqlmysqlpostgrespostgresqlprogrammingsqlsqlite

Older versions (19)

12.15.0.7171
Architecture Scope Download SHA256
x64 user Download 1B46636E7D9E3A101E7062D9EA5F870BFEA7F8906B1FEB373C586C6ED4B82E40
x64 machine Download 1B46636E7D9E3A101E7062D9EA5F870BFEA7F8906B1FEB373C586C6ED4B82E40
12.14.0.7165
Architecture Scope Download SHA256
x64 user Download C21749DB01D35D807AC986A827BE5B6647B1FE9EE5909A46B0854D8090E713B3
x64 machine Download C21749DB01D35D807AC986A827BE5B6647B1FE9EE5909A46B0854D8090E713B3
12.13
Architecture Scope Download SHA256
x64 user Download AA0810276401D650950B85DBEE0079BE1363C10DDCE91B357E25377148C59FCB
x64 machine Download AA0810276401D650950B85DBEE0079BE1363C10DDCE91B357E25377148C59FCB
12.12
Architecture Scope Download SHA256
x64 user Download 0A877AFBA8AEF7413791D0D43D0D45D3641FC8D995AE4CE6254B90DC600BAEA8
x64 machine Download 0A877AFBA8AEF7413791D0D43D0D45D3641FC8D995AE4CE6254B90DC600BAEA8
12.11
Architecture Scope Download SHA256
x64 user Download DB670B2122B5BCC407F5B9CCA37289B4D8BAC1B658AD7213988D014B4E183590
x64 machine Download DB670B2122B5BCC407F5B9CCA37289B4D8BAC1B658AD7213988D014B4E183590
12.10
Architecture Scope Download SHA256
x64 user Download 5DC23998F6E82A157EA07A3577E390FBCAC35174B47CD668038640500EA84573
x64 machine Download 5DC23998F6E82A157EA07A3577E390FBCAC35174B47CD668038640500EA84573
12.9
Architecture Scope Download SHA256
neutral β€” Download 5F6B3FA95327927F2B6E5A02E9044680218323119F45E164295E4763196B5AC4
12.8
Architecture Scope Download SHA256
neutral β€” Download 0F47CA8662511F6182FB5580953CF4B098B5AA8FC1BBE1FF32EB5A1C5052286A
12.7
Architecture Scope Download SHA256
neutral β€” Download 0C2CDD45C4BF69A51DAB5F6AB3EC231B3EE072EB6FE70F47A379164A221A1AE7
12.6
Architecture Scope Download SHA256
neutral β€” Download 6D6E25348EB5C879CA35AC49CBE808A253C03B5CE229B2B12EEC4866301C0DD6
12.5
Architecture Scope Download SHA256
neutral machine Download B8D4840FF581EF54D06DB0328F8E98EC16AF91A9A8E15A758A273422452751EE
12.4
Architecture Scope Download SHA256
neutral β€” Download 205DA1014259B36891981B1044F5429412B9A3050DFC2E2864B9FD724200F227
12.3
Architecture Scope Download SHA256
neutral β€” Download 6BD45948EED317B0AB59989A7AF0F76C4AA7B9C6D79B5A5E7760888BA6A67C79
12.1
Architecture Scope Download SHA256
neutral β€” Download CF3DEEB4345A6A9431701030B649A3732779ACB173B8A349A4E45E347A9AA37E
12.0
Architecture Scope Download SHA256
neutral β€” Download F6D1791EC940F0A4B83E2C33DE1312E889BEEDCDAF43C85CD700B7D69F51EC08
11.3
Architecture Scope Download SHA256
neutral β€” Download C1DC9C2779C2E4A0FA171C70DDA1446B7C97FAF60EE47A24D476B527B62B4299
11.2
Architecture Scope Download SHA256
neutral β€” Download E449425684B38CE52E87FFCBA1227002118DDC23EE8EEDF50A4FF845CB06D850
11.1
Architecture Scope Download SHA256
neutral β€” Download C3BDC65C3DA06669EC91149C40877DB28E407F0FDD8BF6C64CCF5F48BD533B7A
11.0
Architecture Scope Download SHA256
neutral β€” Download 2EE3B8AE04681BD0E3717E88BC6C79CD6D26ECE6FA73F6D10B58BE171CD1CE23