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.18.0.7304

Release Notes

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 tab order after inserting new checkbox in the middle - (59d4f1f)
  • Space missing in CREATE TABLE code of PG table with SERIAL column - (1633c33)
  • Quick filter prompts on numbers break WHERE clause through local formatting - (e7646a0)
  • Restore displayed session name in message dialog caption, was removed in commit:63028518f8b0d5869383d3bc0c42f188851797ed - (a6d6e70)
  • Missing bottom anchor on shortcuts tree - (f8c4bde)
  • Broken ci compilation for Windows - (570fab1)
  • Broken ci compilation, move -WB -WR linker options to the conditionals section of the lpi file - (97ec20b)
  • Turn exception in ParseViewStructure into a log message - (7562a1e)
  • Data grid filter cut with several double-dash comments on one line - (dac7b0e)
  • Hidden input box for line terminator in csv import dialog - (f20d634)
  • Mouse click in edited row calls save action although focus did not change - (b8313e5)
  • SSH command line tweaks, patch from jarczakpawel - (454571e)
  • Broken compilation due encoding update to utf-8: ellipsis char constant seen as string now, instead of char - (26b9696)
  • Replace hardcoded Windows directory separator with DirectorySeparator - (41615e6)
  • Explicitly set client encoding on PG connection - (79c5e4c)
  • MSSQL foreign key lookup to include table schema - (305534d)
  • Wrong ENUM column type detection, due to less strict regex - (e731fd0)
  • Do not start edit mode in ListTables on right mouse button click - (89ccbac)
  • Staying on current table by click on "follow foreign key" when the foreign table lives in a different database - (8643172)
  • Some crashes found in uploaded crash reports - (7bed735)
  • Enable save button after changing default role per combobox - (508b139)
  • Support backtick quoted user roles, and some other TValueListEditor related bug fixes - (86ea19c)
  • A few compiler warnings - (c6dffe1)
  • Pre-select nothing in BOOL grid cell editor on PostgreSQL - (1895959)
  • Allow non existent SQLite files, only complain when its path does not exist - (02cf4cb)
  • Solution for #2431 breaks other stuff, reverting a part of it - (e940863)
  • Editing table data on mysql versions without generated column support - (32f3e6b)
  • EAbort crash when copying text from SynEdit without a highlighter - (6c219b9)
  • Missing anchors and autosize in user manager form - (91b90bc)
  • Reset tree refresh marker earlier, so SetActiveDatabase triggers events and hides the table + data tab after dropping tables - (d2c9c96)
  • Prevent crash due to unsupported edit-database feature on MS SQL - (68aeb96)
  • Clear data grid before indicating a broken or temporary table for which we get no columns from IS.COLUMNS - (b4ec223)
  • Populate SSH executable combo with only a global "ssh" command, do not add .exe files on Linux and macOS - (37f57ce)
  • Call to non existent inherited constructor version of TSQLBatch - (b2f4d5b)
  • TSQLBatch using backslash for escaping single quotes on all server types. Introduce server type specific TSQLBatch.FEscape char. - (e9af525)
  • Crash in SQL export to database for zero length SQL, plus upgrade old-style string handling - (056b5e9)
  • Do not delete selected SQL text from editor when trying to focus the position of erroneous SQL - (f5c5f33)
  • Crash after canceling query - (ee16571) 🚜 Refactor
  • Convert remaining latin1 unit to utf-8 - (85fb0bd)
  • Sync from master - (9727d53)
  • Revert most of what I did for #2424 - (3d547fd)
  • Prefer qAutoInc in SQLProvider over dedicated AutoIncName method - (2fbb779)
  • Simplify some more calls to Query() with the overloaded variants - (b0ab0fc)
  • Convert more TFeatureOrRequirement's to TQueryId - (9f21853) Localize
  • Update compiled .mo translation files - (53f95d2) Contributors
  • @ansgarbecker New Contributors ❀️
  • @jonathanp12 made their first contribution

Installer type: inno

Architecture Scope Download SHA256
x64 user Download 2EF48652853A353277AA2D671D955A4C90E4768DA810901BAD1F902C091FDFF9
x64 machine Download 2EF48652853A353277AA2D671D955A4C90E4768DA810901BAD1F902C091FDFF9

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 (21)

12.17.0.7270
Architecture Scope Download SHA256
x64 user Download 938E9F8B364BF23D19C329B5EDA49C654E4B80D1BD91DE113B42687F5831B48D
x64 machine Download 938E9F8B364BF23D19C329B5EDA49C654E4B80D1BD91DE113B42687F5831B48D
12.16.0.7229
Architecture Scope Download SHA256
x64 user Download D6632C9FB7041AA6CF9B7F72E36B8CF7C5C5B5AAC14265C7D55A39EA32613A91
x64 machine Download D6632C9FB7041AA6CF9B7F72E36B8CF7C5C5B5AAC14265C7D55A39EA32613A91
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