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

   Fix wrong sorting in database tab and various other lists. Closes #570

   committed: 18 May 2019 09:58 compiled: 18 May 2019 10:24

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

2. Revision
   10.1.0.5568

   Cache the myriad of SELECT 123::regclass queries in a hash table on the PostgreSQL connection object. Closes #249, closes #538

   committed: 18 May 2019 08:27 compiled: 18 May 2019 08:53

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

3. Revision
   10.1.0.5567

   Update recently moved Transifex project url

   committed: 18 May 2019 07:14 compiled: 18 May 2019 07:24

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

4. Revision
   10.1.0.5566

   Remove -batch parameter from plink command line, so we have a prompt when a host key is not yet cached. Closes #639

   committed: 15 May 2019 20:21 compiled: 15 May 2019 20:24

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

5. Revision
   10.1.0.5565

   Add support for SSH tunneled PostgreSQL connections. See issue #78

   committed: 14 May 2019 07:57 compiled: 14 May 2019 08:24

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

6. Revision
   10.1.0.5564

   Set up SSL parameters not only in TCP/IP mode

   committed: 14 May 2019 06:59 compiled: 14 May 2019 07:26

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

7. Revision
   10.1.0.5563

   Allow using SSL for SSH tunneled connections. See https://www.heidisql.com/forum.php?t=27120

   committed: 14 May 2019 06:55 compiled: 14 May 2019 07:24

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

8. Revision
   10.1.0.5562

   Phrasing fix, see #648

   committed: 13 May 2019 07:41 compiled: 13 May 2019 07:55

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

9. Revision
   10.1.0.5561

   As suggested by #634
   
   User: @cookieguru

   committed: 13 May 2019 06:59 compiled: 13 May 2019 07:54

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

10. Revision
    10.1.0.5560

    Restore data grid's horizontal scroll offset after refresh, so the just clicked column header stays at the same position. Closes #451

    committed: 12 May 2019 20:21 compiled: 12 May 2019 20:24

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

11. Revision
    10.1.0.5559

    When creating a query result tab, let the grid be visible until it's aligned correctly. Potentially fixes artefacts at the top left of the query memo. Closes #410.

    committed: 07 May 2019 20:17 compiled: 07 May 2019 20:25

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

12. Revision
    10.1.0.5558

    Issue #627: add some notes to the readme file about how to translate HeidiSQL

    committed: 07 May 2019 18:53 compiled: 07 May 2019 19:24

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

13. Revision
    10.1.0.5557

    Issue #640: prevent crashes when future versions of the server return key clauses unsupported by HeidiSQL

    committed: 06 May 2019 20:33 compiled: 06 May 2019 20:57

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

14. Revision
    10.1.0.5556

    Issue #640: fix crash in table editor with DESC/ASC in a key

    committed: 06 May 2019 20:24 compiled: 06 May 2019 20:55

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

15. Revision
    10.1.0.5555

    Issue #74: remove no longer used hackish helper function GetColumnDefaultType()

    committed: 06 May 2019 06:36 compiled: 06 May 2019 06:57

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

16. Revision
    10.1.0.5554

    Issue #637: No need to upper-case when calling StartsWith() with ignore case flag. Also, prefer StartsWith() over various ugly calls to UpperCase(Copy()).

    committed: 06 May 2019 06:32 compiled: 06 May 2019 06:54

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

17. Revision
    10.1.0.5553

    Detect ON UPDATE clause's content with a two-step approach, so it does not eat a potentially existing COMMENT clause after it. Closes #637. Broken in 9fc7150a9fc15d400a836df8b20765a1864a9c80 for #74.

    committed: 05 May 2019 20:01 compiled: 05 May 2019 20:24

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

18. Revision
    10.1.0.5552

    Search on server: Lower-case columns after casting to text, to prevent data type error: "function lower(integer) does not exist". Closes #235

    committed: 03 May 2019 07:59 compiled: 03 May 2019 08:23

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

19. Revision
    10.1.0.5551

    Fix emergency exception when trying to call DeleteCurrentKey without session path, which is reset by MessageDialog() in some cases. Closes #168.

    committed: 03 May 2019 07:45 compiled: 03 May 2019 07:53

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

20. Revision
    10.1.0.5550

    Issue #411: append search engine's hostname to "Find help" link in error dialogs, now that it's customizable

    committed: 30 Apr 2019 12:32 compiled: 30 Apr 2019 12:54

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

21. Revision
    10.1.0.5549

    Ensure "Delete row" button state is valid while navigating in a grid by keyboard. Closes #624.

    committed: 30 Apr 2019 08:18 compiled: 30 Apr 2019 08:23

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

22. Revision
    10.1.0.5548

    Issue #74: turn expression + on update edit boxes into drop down boxes, with known MySQL functions in them

    committed: 29 Apr 2019 14:30 compiled: 29 Apr 2019 14:54

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

23. Revision
    10.1.0.5547

    Revert a part of 406ab56060f370c2414c5041d766203cd3b75c32: Prefer TEncoding.UTF8 again over the TUTF8NoBomEncoding with an overridden .GetPreamble(). The grid export crashed when used a second time, probably because the TStringStream overtakes ownership of the encoding. Also, I see no BOM in files encoded via TEncoding.UTF8, so this was probably a fix for nothing anyway.

    committed: 28 Apr 2019 12:42 compiled: 28 Apr 2019 12:54

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

24. Revision
    10.1.0.5546

    Readme: Minor grammar fixes, add year into notice.

    committed: 24 Apr 2019 13:37 compiled: 24 Apr 2019 17:24

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

25. Revision
    10.1.0.5545

    Detect MS SQL data type DATETIMEOFFSET as such, not as UNKNOWN. Closes #496 and closes #98

    committed: 22 Apr 2019 13:59 compiled: 22 Apr 2019 14:25

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

26. Revision
    10.1.0.5544

    Fix crash while casting Sender to TAction for debugging purposes

    committed: 22 Apr 2019 13:57 compiled: 22 Apr 2019 14:24

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

27. Revision
    10.1.0.5543

    Issue #496: show UNKNOWN data type in table editor for MSSQL and MySQL, as already for PG. Avoids casting its values to int for the data grid, and at least does not show the data type from the prior column in the table editor.

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

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

28. Revision
    10.1.0.5542

    Find and replace dialogs in grid popup text editor:
    * Cancel dialog when user presses Cancel, regardless of which dialog has focus.
    * Show selection when dialog found some text, without having to focus the memo.

    committed: 22 Apr 2019 10:03 compiled: 22 Apr 2019 10:24

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

29. Revision
    10.1.0.5541

    Issue #140: Flag query editor as modified after pasting text

    committed: 21 Apr 2019 20:27 compiled: 21 Apr 2019 20:54

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

30. Revision
    10.1.0.5540

    Issue #74: attempt to support all kinds of expressions in column DEFAULT + ON UPDATE clauses

    committed: 21 Apr 2019 15:40 compiled: 21 Apr 2019 15:54

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

31. 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)

32. 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)

33. 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)

34. 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)

35. 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)

36. 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)

37. 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)

38. 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)

39. 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)

40. 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)

41. 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)

42. 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)

43. 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)

44. 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)

45. 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)

46. 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)

47. 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)

48. 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)

49. 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)

50. 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)

Imprint