Download HeidiSQL 10.2

Release date: 15 Jun 2019.

• Installer, 32/64 bit combined
• Portable version (zipped): 32 bit , 64 bit
• Microsoft Store App, 32 bit
• Sourcecode
• Previous installers
  • HeidiSQL 10.1 (26 Jan 2019)
  • HeidiSQL 10.0 (23 Jan 2019)
  • HeidiSQL 9.5 (19 Dec 2017)
  • HeidiSQL 9.4 (20 Oct 2016)

Please disable your adblocker and reload the page to enable HeidiSQL downloads.

Or, if you can't overcome the temptation, rightclick the anchor and click "copy link" to get it. Don't blame anyone for waking up on the dark side afterwards.

Compatibility notes

• HeidiSQL runs fine on Windows XP, Vista, 7, 8 and 10. Using Wine, it mostly runs fine on Linux and MacOS.
• Connecting to TLS 1.2 enabled MS SQL Servers requires an updated OLE DB Driver 18 for SQL Server to be installed.
• Wine users: For MS SQL connections, avoid using Wine 3.15 up to 4.1. Instead, use Wine 3.14 or 4.2 - these should work.
• Connecting to PostgreSQL may require to have Visual C++ Redistributable Package installed

Nightly Builds of heidisql.exe

Latest automatically compiled main executable and installers for HeidiSQL. Just download and overwrite your existing C:\Program Files\HeidiSQL\heidisql.exe. Be aware that these builds are not official releases and therefore probably have more bugs, possibly serious ones.

1. Revision
   10.2.0.5769

   Break Plink wait loop when server has sent an "Access denied" error. Closes #774.

   committed: 08 Dec 2019 12:28 compiled: 08 Dec 2019 12:57

   Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

2. Revision
   10.2.0.5768

   Add checkbox option to remove line breaks from field contents in grid export dialog. Closes #474

   committed: 08 Dec 2019 11:59 compiled: 08 Dec 2019 12:27

   Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

3. Revision
   10.2.0.5767

   Disable some controls on VIEW editor, which the underlying server does not support, and don't generate SQL clauses for these. Closes #39.

   committed: 03 Dec 2019 20:47 compiled: 03 Dec 2019 20:57

   Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

4. Revision
   10.2.0.5766

   Support very low max_allowed_packet setting in TMySQLConnection.MaxAllowedPacket, so it has to be >10K only, for not assuming 1M for SQL exports. See https://www.heidisql.com/forum.php?t=35046

   committed: 01 Dec 2019 11:13 compiled: 01 Dec 2019 11:27

   Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

5. Revision
   10.2.0.5765

   Turn simple message box into a prompt when SSH tunnel asks for key passphrase. Closes #284.

   committed: 30 Nov 2019 18:05 compiled: 30 Nov 2019 18:27

   Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

6. Revision
   10.2.0.5764

   Store and restore bind parameters per query tab in tabs.ini, including activation state. Closes #689

   committed: 30 Nov 2019 13:55 compiled: 30 Nov 2019 14:27

   Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

7. Revision
   10.2.0.5763

   Do not trigger file reload prompt after file access. See https://www.heidisql.com/forum.php?t=15500

   committed: 29 Nov 2019 22:00 compiled: 29 Nov 2019 22:27

   Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

8. Revision
   10.2.0.5762

   Add CURRENT_TIMESTAMP to function list, especially for the dropdown in the default editor. See https://github.com/HeidiSQL/HeidiSQL/issues/74#issuecomment-559321533

   committed: 28 Nov 2019 06:38 compiled: 28 Nov 2019 06:57

   Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

9. Revision
   10.2.0.5761

   Use up to 70 characters on a main tab caption before adding ellipsis. Gives long table names more room.

   committed: 26 Nov 2019 21:12 compiled: 26 Nov 2019 21:27

   Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

10. Revision
    10.2.0.5760

    Refactor code for query bind parameters

    committed: 24 Nov 2019 16:46 compiled: 24 Nov 2019 16:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

11. Revision
    10.2.0.5759

    Support modifying columns per table designer in PostgreSQL mode, including rename. Closes #595

    committed: 24 Nov 2019 15:47 compiled: 24 Nov 2019 15:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

12. Revision
    10.2.0.5758

    Let TConnectionParameters.NetTypeName and TConnectionParameters.IsCompatibleToWin10S rely on a correctly set FNetType property. So we can safely use GetNetTypeGroup on it, and need less parameter passing. Closes #812. The default FNetType should probably not be ntMySQL_TCPIP any longer, so such bugs get seen earlier.

    committed: 22 Nov 2019 20:00 compiled: 22 Nov 2019 20:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

13. Revision
    10.2.0.5757

    Display last system error when plink process could not be started for some reason. Helps in debugging. See https://www.heidisql.com/forum.php?t=34556#p35000

    committed: 20 Nov 2019 21:02 compiled: 20 Nov 2019 21:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

14. Revision
    10.2.0.5756

    Fix unwanted wrapping in help label on find dialog

    committed: 19 Nov 2019 21:18 compiled: 19 Nov 2019 21:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

15. Revision
    10.2.0.5755

    Add "Find text" item to context menu in data grid and query grids. Users may not be aware that find feature supports data grids, when it's only in the main menu.

    committed: 19 Nov 2019 21:13

16. Revision
    10.2.0.5754

    Suppress errors in GetLockedTableCount, which is not working on all servers: https://www.heidisql.com/forum.php?t=34984

    committed: 19 Nov 2019 06:45 compiled: 19 Nov 2019 06:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

17. Revision
    10.2.0.5753

    On Amazon Redshift servers, display "Redshift PG x.y" in status bar. Closes #802

    committed: 17 Nov 2019 17:15 compiled: 17 Nov 2019 17:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

18. Revision
    10.2.0.5752

    Issue #805: fall back to translated button captions if GetLocaleString returned an empty string. Setting an empty button caption raises an exception in TTaskDialogButtonItem

    committed: 14 Nov 2019 21:32 compiled: 14 Nov 2019 21:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

19. Revision
    10.2.0.5751

    Issue #88: remove definer clause also for views and events, if wanted

    committed: 13 Nov 2019 14:40 compiled: 13 Nov 2019 14:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

20. Revision
    10.2.0.5750

    SQL export: add drop down menu item for removing DEFINER clauses from triggers, procedures and functions

    committed: 13 Nov 2019 14:29

21. Revision
    10.2.0.5749

    Issue #88: consistently use DBObject.CreateCode also for trigger exporting

    committed: 13 Nov 2019 12:56

22. Revision
    10.2.0.5748

    Issue #685: Fix fatal performance bug, calling GetSQL on each examined character of a TSQLSentence. See report on https://www.heidisql.com/forum.php?t=34935

    committed: 13 Nov 2019 08:16 compiled: 13 Nov 2019 08:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

23. Revision
    10.2.0.5747

    Issue #802: filter away not owned databases only on Redshift servers. See https://www.heidisql.com/forum.php?t=34635#p34946

    committed: 12 Nov 2019 19:56 compiled: 12 Nov 2019 20:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

24. Revision
    10.2.0.5746

    Issue #802: Detect Amazon Redshift via IsRedshift and give servers a fitting icon

    committed: 12 Nov 2019 19:50

25. Revision
    10.2.0.5745

    Issue #802: Redshift: modify query for retrieving accessible databases. See https://www.heidisql.com/forum.php?t=34635#p34937

    committed: 12 Nov 2019 07:47 compiled: 12 Nov 2019 07:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

26. Revision
    10.2.0.5744

    Reactivate TSynHotKey again, after removing it accidentally in recent SynEdit update. Should fix a crashing preferences dialog.

    committed: 11 Nov 2019 19:22 compiled: 11 Nov 2019 19:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

27. Revision
    10.2.0.5743

    Always use an empty query tab for loading an sql file. Don't load contents into a currently non-empty tab. Closes #270.

    committed: 10 Nov 2019 18:36 compiled: 10 Nov 2019 18:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

28. Revision
    10.2.0.5742

    Reapply SingleLineMode feature for SynEdit, which we need in the SQL log panel

    committed: 10 Nov 2019 09:22 compiled: 10 Nov 2019 09:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

29. Revision
    10.2.0.5741

    Update SynEdit component to latest sources from their master branch

    committed: 10 Nov 2019 08:57

30. Revision
    10.2.0.5740

    Alternative to pg_relation_size() for pre-8.1 PG servers. See https://www.heidisql.com/forum.php?t=34635

    committed: 07 Nov 2019 07:39 compiled: 07 Nov 2019 07:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

31. Revision
    10.2.0.5739

    Never prepend "AND " in first quick filter. Closes #796

    committed: 07 Nov 2019 06:59 compiled: 07 Nov 2019 07:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

32. Revision
    10.2.0.5738

    Refactor: rename helper function sstr() to something more readable, and optimize it slightly

    committed: 04 Nov 2019 20:15 compiled: 04 Nov 2019 20:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

33. Revision
    10.2.0.5737

    Display help text for SQL function as tooltip hint in query helpers tree.

    committed: 04 Nov 2019 20:05

34. Revision
    10.2.0.5736

    Update MySQL/MariaDB function list and their help texts

    committed: 03 Nov 2019 13:45 compiled: 03 Nov 2019 13:56

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

35. Revision
    10.2.0.5735

    Update code from vcl-styles-utils to current master branch from Oct 10 2019. Closes #649. Also related to background color of selected VirtualTree nodes, reported in #789

    committed: 01 Nov 2019 15:56 compiled: 01 Nov 2019 16:26

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

36. Revision
    10.2.0.5734

    Apply DBtree's OnPaintText code to dialog for selecting user privilege object, so we get bold focused path there as well. Related to #785

    committed: 01 Nov 2019 13:49 compiled: 01 Nov 2019 13:56

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

37. Revision
    10.2.0.5733

    Set bold text for database tree nodes in focused path. Related to #785

    committed: 01 Nov 2019 13:42

38. Revision
    10.2.0.5732

    Centralize some code for checking validity of column number in current row of TDBQuery. Fixes a crash after canceling new row insertion, through ValidateControls(). Related to #788.

    committed: 01 Nov 2019 12:41 compiled: 01 Nov 2019 12:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

39. Revision
    10.2.0.5731

    Fix crash when trying to add a new grid row while a first one was not yet saved. Closes #788

    committed: 01 Nov 2019 12:37

40. Revision
    10.2.0.5730

    Highlight same grid cell text also in current row, not only in current column. Closes #707

    committed: 30 Oct 2019 08:01 compiled: 30 Oct 2019 08:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

41. Revision
    10.2.0.5729

    Don't fool detection of unsafe queries by comments. Closes #685

    committed: 29 Oct 2019 21:46 compiled: 29 Oct 2019 21:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

42. Revision
    10.2.0.5728

    Fix definition of PostgreSQL Oid from Integer to Cardinal, as it is in postgres_ext.h . Should fix negative Oids in TPGQuery.TableName. See https://www.heidisql.com/forum.php?t=34819

    committed: 27 Oct 2019 22:26 compiled: 27 Oct 2019 22:56

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

43. Revision
    10.2.0.5727

    Activate toVariableNodeHeight option in query helpers tree, which triggers FixVT() to set HintMode to hmHint. This in turn displays full queries on query history nodes. Closes #693

    committed: 27 Oct 2019 12:09 compiled: 27 Oct 2019 12:26

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

44. Revision
    10.2.0.5726

    Restore previously used collation when creating new database. Closes #702

    committed: 27 Oct 2019 11:59

45. Revision
    10.2.0.5725

    After pressing save button on table editor, use the fresh DBObject from SHOW TABLE STATUS row, not the old one. This fresh one also has the new table comment. Closes #683

    committed: 27 Oct 2019 11:46 compiled: 27 Oct 2019 11:56

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

46. Revision
    10.2.0.5724

    Populate target database drop-down only with unchecked database nodes in object tree, to prevent overwrites. Closes #775

    committed: 27 Oct 2019 08:38 compiled: 27 Oct 2019 08:57

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

47. Revision
    10.2.0.5723

    Issue #777: Fix crash, happening in actToggleCommentExecute(), when commenting a line in the data tab filter

    committed: 23 Oct 2019 14:20 compiled: 23 Oct 2019 14:27

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

48. Revision
    10.2.0.5722

    popupDataGridPopup is also used in query tab result grids, so here's a check for which grid is active. Closes #776

    committed: 22 Oct 2019 22:11 compiled: 22 Oct 2019 22:26

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

49. Revision
    10.2.0.5721

    Issue #769: append ::text to JSON column names in PostgreSQL WHERE clauses. Fixes "Operator does not exist" errors

    committed: 20 Oct 2019 16:47 compiled: 20 Oct 2019 16:56

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (20.2 MB)

50. Revision
    10.2.0.5720

    Performance: Search libraries on system once per app instance and net type group. Cache these in TConnectionParameters.FLibraries. OLE DB providers take some time to collect.

    committed: 20 Oct 2019 09:47 compiled: 20 Oct 2019 09:56

    Downloads: 32bit build (7.9 MB)64bit build (8.8 MB)32+64bit installer (20.2 MB)

Imprint