Download HeidiSQL 10.1

Release date: 26 Jan 2019.

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

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.
• 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.1.0.5539

   Fix TDBConnection.ParseViewStructure so it orders the result from IS.COLUMNS by their ordinal/natural position. Closes #617.

   committed: 19 Apr 2019 12:08 compiled: 19 Apr 2019 12:24

   Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

2. Revision
   10.1.0.5538

   Add preference option for custom web search url, used in error dialogs. Closes #411

   committed: 17 Apr 2019 21:29 compiled: 17 Apr 2019 21:54

   Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

3. Revision
   10.1.0.5537

   Add new menu item "Duplicate row with keys" to grid context menu, and rename "Duplicate row" to "Duplicate row without keys". Closes #396

   committed: 17 Apr 2019 08:24 compiled: 17 Apr 2019 08:53

   Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

4. Revision
   10.1.0.5536

   Cheat when calculating percentage of done work, when exporting tables and data, so we never get more than 100%. Closes #180

   committed: 17 Apr 2019 07:57 compiled: 17 Apr 2019 08:24

   Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

5. Revision
   10.1.0.5535

   Exchange icon index of "Check all" button on CSV import dialog, to make it more intuitive (?). Closes #612

   committed: 16 Apr 2019 19:50 compiled: 16 Apr 2019 19:59

   Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

6. Revision
   10.1.0.5534

   Add some developer notes to unclear translation strings

   committed: 16 Apr 2019 19:43 compiled: 16 Apr 2019 19:57

   Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

7. Revision
   10.1.0.5533

   Don't prompt to save an empty query tab. Closes #614.

   committed: 16 Apr 2019 19:36 compiled: 16 Apr 2019 19:55

   Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

8. Revision
   10.1.0.5532

   Add new log category lcScript, for queries from large scripts and import operations. By default disabled, which should speed up importing large files.

   committed: 16 Apr 2019 07:19 compiled: 16 Apr 2019 07:24

   Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

9. Revision
   10.1.0.5531

   Issue #521: make debug output more readable

   committed: 16 Apr 2019 06:38 compiled: 16 Apr 2019 06:56

   Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

10. Revision
    10.1.0.5530

    Issue #521: increase waiting time after PLink output, from 1s to 2s, for slow connections.

    committed: 16 Apr 2019 06:32 compiled: 16 Apr 2019 06:54

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

11. Revision
    10.1.0.5529

    Issue #521: disable verbosity of plink again, due to weird extra dialogs appearing now

    committed: 15 Apr 2019 20:15 compiled: 15 Apr 2019 20:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

12. Revision
    10.1.0.5528

    Issue #515: Handle encoding errors in apphelpers.ReadTextfileChunk according to how Delphi 10.3 raises exceptions. And probably fix the issue by increasing the new chunk size by 1M instead of only 4B.

    committed: 14 Apr 2019 19:44 compiled: 14 Apr 2019 19:54

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

13. Revision
    10.1.0.5527

    Issue #521: add -ssh and -v arguments again to plink.exe command, as proposed in https://github.com/HeidiSQL/HeidiSQL/issues/521#issuecomment-482897896

    committed: 14 Apr 2019 14:05 compiled: 14 Apr 2019 14:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

14. Revision
    10.1.0.5526

    Attempt to fully support UTF8 encoding without BOM, as TEncoding.UTF8 has a non-empty preamble/bom. See https://forums.embarcadero.com/thread.jspa?threadID=112112 . Probably related to encoding issue #515

    committed: 13 Apr 2019 10:52 compiled: 13 Apr 2019 11:25

    Downloads: 32bit build (7.8 MB)64bit build (8.4 MB)32+64bit installer (19.1 MB)

15. Revision
    10.1.0.5525

    Issue #140: Store application process id in each tabs.ini section, and don't restore tabs from other running processes. If the process no longer runs, restore such tab sections again, so nothing gets lost with multiple running application instances.

    committed: 13 Apr 2019 10:43 compiled: 13 Apr 2019 11:23

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

16. Revision
    10.1.0.5524

    Issue #140:
    * store tab setup when application exits, as the TimerStoreTabs interval may not yet be reached
    * remember startup value of asRestoreTabs option, which may change while the application runs, which in turn may cause problems when RestoreTabs wasn't called

    committed: 13 Apr 2019 09:32 compiled: 13 Apr 2019 09:53

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

17. Revision
    10.1.0.5523

    Issue #521: use -batch instead of -ssh parameter for plink, to prevent creating a shell and to reduce interactive prompts

    committed: 13 Apr 2019 08:38 compiled: 13 Apr 2019 08:54

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

18. Revision
    10.1.0.5522

    Issue #140: Move code for all remaining common directory paths settings to TAppSettings (UserAppData, UserDocuments, Snippets)

    committed: 11 Apr 2019 21:47 compiled: 11 Apr 2019 21:54

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

19. Revision
    10.1.0.5521

    Issue #140: Use local tabs.ini and Backups directory in portable mode

    committed: 11 Apr 2019 21:21 compiled: 11 Apr 2019 21:25

    Downloads: 32bit build (7.8 MB)64bit build (8.4 MB)32+64bit installer (19.1 MB)

20. Revision
    10.1.0.5520

    Issue #140: Avoid writing the tabs.ini file through WriteString if nothing was effectively changed

    committed: 10 Apr 2019 16:51 compiled: 10 Apr 2019 18:57

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

21. Revision
    10.1.0.5519

    Issue #140: Add some more missing translation strings. Shame on me, I am always forgetting these.

    committed: 10 Apr 2019 15:06 compiled: 10 Apr 2019 18:55

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

22. Revision
    10.1.0.5518

    Issue #140: remove a tab section from tabs.ini within RestoreTabs(), if its file does not exist

    committed: 10 Apr 2019 12:41 compiled: 10 Apr 2019 13:23

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

23. Revision
    10.1.0.5517

    Issue #140: make auto-backup/restore feature stable against running multiple application instances:
    * use unique date/time with milliseconds as ini sections
    * open ini file for each read + write, separately, don't keep it open all the time

    committed: 10 Apr 2019 12:19 compiled: 10 Apr 2019 12:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

24. Revision
    10.1.0.5516

    Issue #140:
    * fix: very last tab backup was not yet done
    * tell user about activated auto-restore feature in very last question dialog for saving tab
    * add missing translation strings

    committed: 08 Apr 2019 20:51 compiled: 08 Apr 2019 21:25

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

25. Revision
    10.1.0.5515

    Issue #140: Do not auto backup unsaved tab contents if it's larger than 10MB

    committed: 07 Apr 2019 13:47 compiled: 07 Apr 2019 13:53

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

26. Revision
    10.1.0.5514

    Issue #140: Auto-backup unsaved query tab contents to C:\Users\<username>\AppData\Roaming\HeidiSQL\Backups\*.sql, and tab setup in C:\Users\<username>\AppData\Roaming\HeidiSQL\tabs.ini

    committed: 07 Apr 2019 13:14 compiled: 07 Apr 2019 13:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

27. Revision
    10.1.0.5513

    Put a new filter box above query helpers tree, for quickly finding snippet or function

    committed: 07 Apr 2019 11:13 compiled: 07 Apr 2019 11:24

    Downloads: 32bit build (7.8 MB)64bit build (8.4 MB)32+64bit installer (19.1 MB)

28. Revision
    10.1.0.5512

    Support selecting wrong cased columns in MariaDB 10.4, so the user manager shows up. Closes #599.

    committed: 04 Apr 2019 20:35 compiled: 04 Apr 2019 20:55

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

29. Revision
    10.1.0.5511

    Issue #360: remove no longer used translation string, and add a new one, for the new background color label

    committed: 30 Mar 2019 09:57 compiled: 30 Mar 2019 10:26

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

30. Revision
    10.1.0.5510

    Move tree background color setting from File menu to the Advanced tab of the session manager. Closes #360

    committed: 30 Mar 2019 09:52 compiled: 30 Mar 2019 10:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

31. Revision
    10.1.0.5509

    Silence EAccessViolation in PQfinish() of 32bit libpq.dll . Closes #37

    committed: 30 Mar 2019 09:26 compiled: 30 Mar 2019 09:54

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

32. Revision
    10.1.0.5508

    Issue #577: skip informational error output from new plink version

    committed: 28 Mar 2019 20:04 compiled: 28 Mar 2019 20:24

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

33. Revision
    10.1.0.5507

    Show full filter in data tab's recent filter drop down, make it higher to show more items, plus optimize incremental searching when it has focus. See https://stackoverflow.com/questions/37477244/tcombobox-autocloseup-property-what-does-it-do

    committed: 28 Mar 2019 17:06 compiled: 28 Mar 2019 17:24

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

34. Revision
    10.1.0.5506

    Pause after compiling resources, so user has a chance to read the (error) output

    committed: 18 Mar 2019 21:50 compiled: pretty soon, be patient...

35. Revision
    10.1.0.5505

    Sort encoding names in CSV import dialog alphabetically. Closes #579.

    committed: 18 Mar 2019 20:22 compiled: 18 Mar 2019 20:55

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

36. Revision
    10.1.0.5504

    Issue #140: add "Files" tab to preferences dialog, move "Prompt for file save" checkbox there, and introduce two new checkboxes for restoring opened and unsaved query tab contents (both new yet without functionality in their back)

    committed: 17 Mar 2019 11:57 compiled: 17 Mar 2019 12:23

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

37. Revision
    10.1.0.5503

    Simplify language selector populating: extract potentially existing lang name from long string, rather than holding a complex list

    committed: 17 Mar 2019 09:06 compiled: 17 Mar 2019 09:25

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

38. Revision
    10.1.0.5502

    Reveal yet hidden languages in language selector on preferences dialog. Reveals hr_HR Croatian, which was present on Transifex but missing in hardcoded language list from dxgettext/languagecodes.pas

    committed: 17 Mar 2019 08:45 compiled: 17 Mar 2019 09:24

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

39. Revision
    10.1.0.5501

    Add missing zh_CN "Chinese (China)" to language selector. Closes #498.

    committed: 15 Mar 2019 19:48 compiled: 15 Mar 2019 19:54

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

40. Revision
    10.1.0.5500

    Issue #498: Update gettext unit to r124 from https://sourceforge.net/p/dxgettext/code/HEAD/tree/trunk/dxgettext/sample/gnugettext.pas

    committed: 15 Mar 2019 07:55 compiled: 15 Mar 2019 08:10

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

41. Revision
    10.1.0.5499

    Issue #433: Additional line break after SQL export comments for skipping data

    committed: 15 Mar 2019 07:44 compiled: 15 Mar 2019 07:54

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

42. Revision
    10.1.0.5498

    Issue #498: Display current locale abbreviation in "Auto detect" item of language selector

    committed: 14 Mar 2019 21:11 compiled: 14 Mar 2019 21:21

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

43. Revision
    10.1.0.5497

    Prevent sporadic crash on startup

    committed: 14 Mar 2019 20:22 compiled: 14 Mar 2019 21:18

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

44. Revision
    10.1.0.5496

    Protect from crash when pressing ctrl+tab before main form is displayed. Closes #574

    committed: 14 Mar 2019 20:21 compiled: 14 Mar 2019 21:16

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

45. Revision
    10.1.0.5495

    Support spaces in definer of a view. Closes #571.

    committed: 14 Mar 2019 20:06 compiled: 14 Mar 2019 20:24

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

46. Revision
    10.1.0.5494

    Don't export data of FEDERATED tables, just like MRG_MyISAM. Closes #433.

    committed: 14 Mar 2019 07:57 compiled: 14 Mar 2019 08:25

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

47. Revision
    10.1.0.5493

    Fix still disabled union text input on table designer, when engine MRG_MyISAM is selected

    committed: 14 Mar 2019 07:50 compiled: 14 Mar 2019 08:23

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

48. Revision
    10.1.0.5492

    Make preferences dialog resizable, and store/restore its dimensions for the next time it opens

    committed: 10 Mar 2019 14:18 compiled: 10 Mar 2019 14:23

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

49. Revision
    10.1.0.5491

    Issue #196: Prefer to take comment from SHOW TABLE STATUS result, to support single quotes without including some "compression" option on TokuDB

    committed: 10 Mar 2019 08:08 compiled: 10 Mar 2019 08:24

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

50. Revision
    10.1.0.5490

    If previous word is preceded by a dot, it is most probably a table, column or some alias, so do not uppercase it then. Closes #494

    committed: 09 Mar 2019 08:40 compiled: 09 Mar 2019 08:54

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

Imprint