Heidisql Free Download For Mac

HeidiSQL is free software, and has the aim to be easy to learn. 'Heidi' lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite. Invented in 2002 by Ansgar, HeidiSQL belongs to the most popular tools for MariaDB and MySQL worldwide.

Download HeidiSQL, read further about features, take part in discussions or see some screenshots.

HeidiSQL is an excellent tool for managing a MySQL database and is a serious alternative to applications such as phpMyAdmin. It provides a powerful graphic interface for managing tables, logs, and users of a MySQL database. The main things you can do with this program are: - Generate SQL reports - Sync the information of two different tables. 6 4 Cons 1 Specs. Professional Tool. This is a good and stable tool with.

  • 07 Sep 'HeidiSQL - Made with Delphi' webinar available

    Letzten Mittwoch sprach ich mit Matthias Eissing von Embarcadero über Delphi und HeidiSQL.Agenda:Woher kommt HeidiSQL?Warum Delphi?FeaturesPläne für die Zukunft'dies und das'Und hier d ...

  • 17 Mar HeidiSQL 11.0 with SQLite support

    Grab it from the download pageNew features and enhancements in this version:Support connecting to SQLite database filesdrop schema support for PostgreSQLsupport foreign keys in PostgreSQLsup ...

  • 11 Dec HeidiSQL 10.3 released

    Grab it from the download pageNew features and enhancements in this version:Theme preview in preferences dialog'Library' dropdown in session manager, to enhance support for older and newer MyS ...

  • 15 Jun HeidiSQL 10.2 released

    Grab it from the download pageNew features and enhancements in this version:High resolution icons from Icons8Save and restore query tabs automaticallyPostgreSQL connection over SSH tunnelCon ...

  • 29 Apr Restore your query tabs automatically

    Since a few nightly builds, your query tabs are now stored automatically. This means the code in them is back again when you restart HeidiSQL, without the need to select one or more files for each ...

  • Free for everyone, OpenSource
  • Connect to multiple servers in one window
  • Supported database systems: MariaDB, MySQL, MS SQL, PostgreSQL and SQLite
  • Connect via SSH tunnel, or pass SSL settings
  • Create and edit tables, views, stored routines, triggers and scheduled events.
  • Generate nice SQL-exports, compress these afterwards, or put them on the clipboard.
  • Export from one server/database directly to another server/database
  • Bulk edit tables (move to db, change engine, collation etc.)
  • Pretty reformat disordered SQL
  • Launch a parallel mysql.exe command line window using your current connection settings
  • And much more
Heidisql free download
Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

HeidiSQL users with enabled statistics feature work on these servers:

The author: Ansgar Becker
Summer 2015 in Egmond aan Zee, duinreservaat.
On holiday with my wife and two kids.


Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Release date: 17 Mar 2020.

  • Portable version (zipped): 32 bit , 64 bit
  • Previous releases
    • v10.3 from 11 Dec 2019: 32/64bit installer , Portable: 32 bit , 64 bit
    • v10.2 from 15 Jun 2019: 32/64bit installer , Portable: 32 bit , 64 bit
    • v10.1 from 26 Jan 2019: 32/64bit installer , Portable: 32 bit , 64 bit
    • v10.0 from 23 Jan 2019: 32/64bit installer , Portable: 32 bit , 64 bit

Compatibility notes

Heidisql Download Windows

  • HeidiSQL runs fine on Windows 7, 8 and 10
  • Running HeidiSQL on newer Wine releases is currently quite unstable. Preferring Wine 4.0 likely solves various issues.
  • Connecting to TLS 1.2 enabled MS SQL Servers requires an updated OLE DB Driver 18 for SQL Server to be installed.
  • Connecting to PostgreSQL may require to have Visual C++ Redistributable Package installed
Install heidisql

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

Heidisql 9.5 Download

  1. Attempt to fix issue #695 by removing the redraw message from the base grid editor constructor

    committed: 28 Sep 2020 16:56 compiled: 28 Sep 2020 17:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  2. Remove auto-stored section of closed tab only if section belongs to the current app instance. See https://www.heidisql.com/forum.php?t=36922

    committed: 22 Sep 2020 08:06 compiled: 22 Sep 2020 08:27

    Downloads: 32bit build (6.4 MB)64bit build (6.9 MB)32+64bit installer (19.2 MB)

  3. More contrast for background color of selected grid rows. See https://www.heidisql.com/forum.php?t=36889

    committed: 08 Sep 2020 16:30 compiled: 08 Sep 2020 16:57

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  4. Issue #760: add an appropriate error message when trying to change the case of a session name only

    committed: 28 Aug 2020 07:57 compiled: 28 Aug 2020 08:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  5. Auto-generate data grid filter on 'Apply filter' click only if filter box is empty. See https://www.heidisql.com/forum.php?t=36844 and issue #829

    committed: 26 Aug 2020 15:48 compiled: 26 Aug 2020 15:57

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  6. Fix LEFT() clause in data grid with NTEXT column on MSSQL. Closes #1136.

    committed: 22 Aug 2020 08:00 compiled: 22 Aug 2020 08:26

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  7. Issue #1133: enable 'drop' context menu item for databases again, at least in non-SQLite mode

    committed: 19 Aug 2020 15:23 compiled: 19 Aug 2020 15:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  8. Issue #1132: Include 'SQL delimiter' item in new Query main menu

    committed: 19 Aug 2020 08:16 compiled: 19 Aug 2020 08:27

    Downloads: 32bit build (6.3 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  9. Issue #350: add ProxySQL connection icon

    committed: 19 Aug 2020 08:15

  10. Enable 'drop' context menu item for SQLite tables. Broken in 843e462a8a22bb335379c53306e6676637c520e4. Closes #1133

    committed: 19 Aug 2020 08:13

  11. Issue #1132: fix missing msgstr section in translation file

    committed: 17 Aug 2020 18:08 compiled: 17 Aug 2020 18:19

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  12. Add new 'Query' main menu, and put most of the SQL relevant actions there, including a submenu with some new code folding actions. Closes #1132

    committed: 17 Aug 2020 17:50

  13. Update SynEdit's list of MySQL function names, taken from MariaDB 10.5.5 help tables

    committed: 16 Aug 2020 20:09 compiled: 16 Aug 2020 20:27

    Downloads: 32bit build (6.4 MB)64bit build (6.9 MB)32+64bit installer (19.2 MB)

  14. Issue #1132: Add basic support for code folding in SQL editors, using #region/#endregion markers

    committed: 16 Aug 2020 13:00 compiled: 16 Aug 2020 13:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  15. Accessing SelectedTableColumns by grid column index is wrong, since the user can deselect columns. Fix 3 places where this was done wrong.

    committed: 14 Aug 2020 15:57 compiled: 14 Aug 2020 16:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  16. Enable view editor if SHOW INDEXES command returned an error. Closes #1130

    committed: 14 Aug 2020 08:39 compiled: 14 Aug 2020 08:57

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  17. Unquote table name when retrieving via 123::regclass result. Closes #1124

    committed: 13 Aug 2020 06:57 compiled: 13 Aug 2020 07:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  18. Use TTableColumn.CastAsText in SELECT query for data tab, when applying LEFT() on large column. Closes #1122

    committed: 11 Aug 2020 19:35 compiled: 11 Aug 2020 19:57

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  19. Sort session path + names alphabetically, in menus with no header sort logic. Closes #1119

    committed: 10 Aug 2020 21:23 compiled: 10 Aug 2020 21:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  20. In grid updates and deletes, support key column values with international characters using MSSQL's 'N' prefix. Closes #1115

    committed: 09 Aug 2020 08:22 compiled: 09 Aug 2020 08:26

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  21. Respect user's plink timeout setting when plink takes longer than 2s after the first text output. Closes #1114

    committed: 09 Aug 2020 07:52 compiled: 09 Aug 2020 07:56

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  22. Disable creating issues without using a template

    committed: 08 Aug 2020 07:12 compiled: 08 Aug 2020 07:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  23. Remove old default issue template, in favor of multiple templates living in .github/ISSUE_TEMPLATE/*

    committed: 07 Aug 2020 12:01 compiled: 07 Aug 2020 12:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  24. Update issue templates

    committed: 07 Aug 2020 11:59

  25. Extend help instructions in readme file

    committed: 07 Aug 2020 08:36

  26. Move one constant out of const.inc into TAppSettings structure

    committed: 07 Aug 2020 08:33

  27. Set '0' as default port for new MSSQL TCP/IP connections, which leaves the port away from the connection string, enabling auto-detection. See https://www.heidisql.com/forum.php?t=34256#p36709

    committed: 07 Aug 2020 07:23 compiled: 07 Aug 2020 07:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  28. Issue #1114: send Enter after plink anti-spoof output 'Access granted. Press Return to begin session'

    committed: 06 Aug 2020 16:46 compiled: 06 Aug 2020 16:57

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  29. Fix all 11 compiler hints and 5 warnings

    committed: 06 Aug 2020 13:49 compiled: 06 Aug 2020 14:08

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  30. Update vcl-styles-utils project sources to current master branch. Among other things, this fixes the myriads of compiler hint H2443 in Vcl.Styles.UxTheme

    committed: 06 Aug 2020 13:19 compiled: 06 Aug 2020 13:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  31. Issue #937 and #1107:
    * be sure ActiveGridEditor is nil before and after editing, and check for that nil value
    * in TBaseGridEditorLink.Destroy constructor, call its parent at the end, not at the beginning, so some members stay accessible until the end
    * prefer to check with Tree.CanEdit
    * change the way how editing starts in a tabbed cell

    committed: 05 Aug 2020 08:42 compiled: 06 Aug 2020 08:40

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  32. Prevent access violation in DBTree.GetImageIndex, with no connection on connection root node

    committed: 05 Aug 2020 08:30

  33. Format decimal point with milliseconds in date/time values in locale format for Excel. Closes #922

    committed: 03 Aug 2020 13:28 compiled: 03 Aug 2020 13:57

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  34. Issue #1111: Add two safety checks in TAppSettings.GetSessionNames, trying to blindly fix some endless recursion happening on user nami0309's system when starting HeidiSQL

    committed: 03 Aug 2020 12:07 compiled: 03 Aug 2020 12:11

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  35. Grid export: escape special characters in LaTeX output

    committed: 03 Aug 2020 06:42 compiled: 03 Aug 2020 06:57

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  36. Issue #618:
    * fix size of sort arrows with larger custom grid font size
    * fix vertical text position of column header with large font

    committed: 02 Aug 2020 08:22 compiled: 02 Aug 2020 08:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  37. Prefer string constants from TTableKey over hardcoded literals

    committed: 01 Aug 2020 19:20 compiled: 01 Aug 2020 19:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  38. Overwrite data filter with newly generated one by click on 'Apply filter'. Closes #829

    committed: 29 Jul 2020 07:36 compiled: 29 Jul 2020 07:42

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  39. Extract contents for MySqlFunctions array out of MariaDB 10.5 help tables. Leave original function sorting by category, don't sort by their name.

    committed: 27 Jul 2020 18:23 compiled: 27 Jul 2020 18:27

    Downloads: 32bit build (6.4 MB)64bit build (7.2 MB)32+64bit installer (19.2 MB)

  40. Add contribution instructions to readme file

    committed: 27 Jul 2020 18:20

  41. More exact contribution instructions

    committed: 26 Jul 2020 10:06

  42. Add contribution instruction

    committed: 26 Jul 2020 07:43 compiled: 26 Jul 2020 07:57

    Downloads: 32bit build (6.3 MB)64bit build (7.1 MB)32+64bit installer (19.1 MB)

  43. Fix version detection in TConnectionParameters.IsMySQL, don't expect the word 'mysql' in version or version_comment variable. Ensures we detect CURRENT_TIMESTAMP default value in TDBConnection.IsTextDefault correctly (among other things). Closes #1099

    committed: 24 Jul 2020 07:25 compiled: 24 Jul 2020 07:57

    Downloads: 32bit build (6.3 MB)64bit build (7.1 MB)32+64bit installer (19.1 MB)

  44. Report major and minor Windows version in statistics call

    committed: 22 Jul 2020 08:50 compiled: 22 Jul 2020 08:57

    Downloads: 32bit build (6.3 MB)64bit build (7.2 MB)32+64bit installer (19.1 MB)

  45. Grid export: No longer force ANSI encoding for Excel output, but silently insert a BOM. Normally, TEncoding.UTF8 has that BOM, but TStringStream does not write that for some reason (bug in VCL?). Closes #1077

    committed: 20 Jul 2020 18:40 compiled: 20 Jul 2020 18:57

    Downloads: 32bit build (6.3 MB)64bit build (7.2 MB)32+64bit installer (19.1 MB)

  46. Limit number of rows per extended INSERT to 1000 in CSV import dialog. Closes #326

    committed: 19 Jul 2020 11:04 compiled: 19 Jul 2020 11:27

    Downloads: 32bit build (6.3 MB)64bit build (7.1 MB)32+64bit installer (19.1 MB)

  47. Use different characters as sorting arrow on Wine. See #1090

    committed: 17 Jul 2020 17:29 compiled: 17 Jul 2020 17:57

    Downloads: 32bit build (6.3 MB)64bit build (7.1 MB)32+64bit installer (19.1 MB)

  48. Decrease minimum height constraint for session manager by 20px, so buttons move lower again on Wine. Closes #1089. Broken in commit:a3cf8b3c927428ec33a0b1096188bc08f695b6c8 for #1074.

    committed: 17 Jul 2020 17:03 compiled: 17 Jul 2020 17:26

    Downloads: 32bit build (6.3 MB)64bit build (7.1 MB)32+64bit installer (19.1 MB)

  49. Related to issue #906: make first two menu items in header popup menu translatable

    committed: 17 Jul 2020 12:27 compiled: 17 Jul 2020 12:57

    Downloads: 32bit build (6.3 MB)64bit build (7.1 MB)32+64bit installer (19.1 MB)

  50. Issue #937: * disable the call to Tree.SetFocus in TBaseVirtualTree.DoEndEdit, which ends the grid editor when tabbed into a new cell. See https://github.com/JAM-Software/Virtual-TreeView/commit/de863b4417dfd98caffe8d0c283959b4842d2a82
    * reveal exception messages happening in the main control's WindowProc to the SQL log panel

    committed: 17 Jul 2020 07:47 compiled: 17 Jul 2020 07:58

    Downloads: 32bit build (6.3 MB)64bit build (7.1 MB)32+64bit installer (19.1 MB)