Download HeidiSQL 10.3

Release date: 11 Dec 2019.

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

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 7, 8 and 10
• Running HeidiSQL on Wine is currently quite unstable
• 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

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

   Detect foreign keys in MS SQL, and provide foreign values drop down in data grid. Closes #150

   committed: 26 Jan 2020 22:23 compiled: 26 Jan 2020 22:27

   Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

2. Revision
   10.3.0.5849

   Enable cut/paste actions when any control is focused, except read-only SQL editors. Closes #592.

   committed: 25 Jan 2020 20:04 compiled: 25 Jan 2020 20:27

   Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

3. Revision
   10.3.0.5848

   Rename "Save as" menu item more intuitively to "Duplicate / save as". Closes #865

   committed: 23 Jan 2020 20:56 compiled: 23 Jan 2020 21:27

   Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

4. Revision
   10.3.0.5847

   Bring back table keys on MS SQL. See https://www.heidisql.com/forum.php?t=35446

   committed: 23 Jan 2020 20:48 compiled: 23 Jan 2020 20:57

   Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

5. Revision
   10.3.0.5846

   Issue #12: fix empty "ALTER code" tab on table editor for SQLite

   committed: 22 Jan 2020 15:20 compiled: 22 Jan 2020 15:27

   Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

6. Revision
   10.3.0.5845

   Fix TDBConnection.GetTableColumns to get the length/set of a column on MSSQL and PG. Closes #864

   committed: 22 Jan 2020 15:19

7. Revision
   10.3.0.5844

   Issue #12: fix row count always -1 on SQLite, in "copy table" dialog

   committed: 22 Jan 2020 13:04 compiled: 22 Jan 2020 13:28

   Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

8. Revision
   10.3.0.5843

   Performance: use first 1000 rows only for calculating the CSV export size, and interpolate the rest. Closes #804

   committed: 21 Jan 2020 20:39 compiled: 22 Jan 2020 12:27

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

9. Revision
   10.3.0.5842

   In SQL foreground and background color dropdown, set NoneColorColor to "clNone", to activate that "None" color. Also, include system colors in both dropdowns. Closes #840

   committed: 21 Jan 2020 19:33 compiled: 21 Jan 2020 19:57

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

10. Revision
    10.3.0.5841

    Mask SSH key passphrase in user prompt. Closes #863

    committed: 21 Jan 2020 19:21 compiled: 21 Jan 2020 19:27

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

11. Revision
    10.3.0.5840

    Detect columns from PG table keys only in current schema, do not mix these with columns from an equally named table in a different schema. Closes #842

    committed: 21 Jan 2020 19:13

12. Revision
    10.3.0.5839

    Add some debug log output to TMySQLConnection.GetTableKeys for debugging #856

    committed: 21 Jan 2020 18:55

13. Revision
    10.3.0.5838

    Fix always empty comment on PostgreSQL columns. Closes #859

    committed: 20 Jan 2020 19:48 compiled: 20 Jan 2020 19:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

14. Revision
    10.3.0.5837

    Issue #12: remove "database." part from reference table in foreign key code, as this throws an error: near ".": syntax error. Makes "Create table copy" dialog compatible to SQLite, except for indexes yet

    committed: 19 Jan 2020 20:45 compiled: 19 Jan 2020 20:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

15. Revision
    10.3.0.5836

    Prefer CREATE code from SHOW CREATE TABLE in MySQL again, which includes table options which are yet unsupported in the generic TDBConnection.GetCreateCode .

    committed: 19 Jan 2020 13:48 compiled: 19 Jan 2020 13:56

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

16. Revision
    10.3.0.5835

    Issue #12: clear internal cache when closing an SQLite connection

    committed: 19 Jan 2020 13:26

17. Revision
    10.3.0.5834

    Finally, remove ParseTableStructure method, and use a text format of TTableColumn in the remaining caller "Paste columns"

    committed: 19 Jan 2020 13:25

18. Revision
    10.3.0.5833

    Issue #12: Support "find text on server" tool with compatible queries in SQLite

    committed: 19 Jan 2020 08:04 compiled: 19 Jan 2020 08:26

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

19. Revision
    10.3.0.5832

    Issue #12: SQLite allows any column type declaration, even custom types.
    * support those declarations which are commonly used in other database systems, and for which Heidi has a fitting grid editor
    * move UNIQUEIDENTIFIER from text group to binary group
    * remove useless native type ids and empty descriptions

    committed: 19 Jan 2020 07:26 compiled: 19 Jan 2020 07:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

20. Revision
    10.3.0.5831

    Issue #12: detect UNIQUEIDENTIFIER column type, and sort that into the text type group

    committed: 18 Jan 2020 18:18 compiled: 18 Jan 2020 18:27

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

21. Revision
    10.3.0.5830

    Add missing CHAR datatype to SQLite column detection. Closes #858

    committed: 18 Jan 2020 08:19 compiled: 18 Jan 2020 08:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

22. Revision
    10.3.0.5829

    MSSQL: Fix not displayed column names of current table in data grid filter proposal, due to .QuotedName adding the Schema and detecting that as the database name

    committed: 18 Jan 2020 08:09

23. Revision
    10.3.0.5828

    Assign table columns and keys from the connection's database cache. Reduces internal queries to the minimum per table. Closes #852.

    committed: 17 Jan 2020 08:07 compiled: 17 Jan 2020 08:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

24. Revision
    10.3.0.5827

    Unify name and case of information_schema, per connection. Finally. Closes #855

    committed: 16 Jan 2020 08:03 compiled: 16 Jan 2020 08:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

25. Revision
    10.3.0.5826

    Issue #852: Implement Assign method on TTableColumnList and friends, TDBObject.LoadDetails and .UnloadDetails, and cross fingers that assigning details to Mainform.FActiveDbObj reduces the number of internal queries

    committed: 16 Jan 2020 07:40 compiled: 16 Jan 2020 07:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

26. Revision
    10.3.0.5825

    Issue #12: detect SQLite data type TEXT on result columns without rows. sqlite3_column_decltype() and sqlite3_column_type() already failed in such cases.

    committed: 16 Jan 2020 06:27 compiled: 16 Jan 2020 06:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

27. Revision
    10.3.0.5824

    Issue #12: detect SQLite data type of non-table result columns, using sqlite3_column_type(). See https://stackoverflow.com/questions/59749418/sqlite-c-api-equivalent-to-typeofcol

    committed: 15 Jan 2020 22:48 compiled: 15 Jan 2020 22:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

28. Revision
    10.3.0.5823

    Issue #852: Return copy of once queried columns, keys and foreign keys object lists in TDBObject, instead of re-querying from database each time.

    committed: 15 Jan 2020 21:17 compiled: 15 Jan 2020 21:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

29. Revision
    10.3.0.5822

    Sort column names in data grid by their ordinal position. Closes #854

    committed: 15 Jan 2020 19:55 compiled: 15 Jan 2020 20:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

30. Revision
    10.3.0.5821

    Detect SQLite BOOL columns as TINYINT

    committed: 14 Jan 2020 21:15 compiled: 14 Jan 2020 21:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

31. Revision
    10.3.0.5820

    Separate join in TDBConnection.GetTableForeignKeys into two separate and faster queries. Closes #852

    committed: 14 Jan 2020 20:59

32. Revision
    10.3.0.5819

    Issue #12: Add support for foreign key dropdown in SQLite grid fields. Note that SQLite does not support LEFT(), while MSSQL does not support SUBSTR(), so here's a template per network type: spFuncLeft.

    committed: 13 Jan 2020 21:56 compiled: 13 Jan 2020 22:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

33. Revision
    10.3.0.5818

    Fix some crashes, where the caller frees the result of GetTableColumns/Keys/ForeignKeys. Probably fixes #849 and #848

    committed: 13 Jan 2020 19:44 compiled: 13 Jan 2020 19:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

34. Revision
    10.3.0.5817

    Detect static date/time values as text type, not expression. See https://www.heidisql.com/forum.php?t=35370

    committed: 13 Jan 2020 14:27

35. Revision
    10.3.0.5816

    Fix crash in suggest popup without table or view. Closes #848

    committed: 13 Jan 2020 14:13

36. Revision
    10.3.0.5815

    Issue #12: detect foreign keys of SQLite tables

    committed: 13 Jan 2020 12:17 compiled: 13 Jan 2020 12:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

37. Revision
    10.3.0.5814

    Detect empty string without quotes as text default type. See https://www.heidisql.com/forum.php?t=35365

    committed: 13 Jan 2020 11:53 compiled: 13 Jan 2020 11:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

38. Revision
    10.3.0.5813

    Issue #12: Implement TDBConnection.GetTableForeignKeys, failing on all db systems except MySQL. Closes #845

    committed: 12 Jan 2020 19:56 compiled: 12 Jan 2020 20:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

39. Revision
    10.3.0.5812

    Add sqlite file extension to database selector

    committed: 10 Jan 2020 20:30 compiled: 10 Jan 2020 22:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

40. Revision
    10.3.0.5811

    Issue #12: Implement TPgConnection.GetTableKeys, and now call GetTableColumns and GetTableKeys from GetCreateCode. TMySQLConnection should also use that, at least for tables.

    committed: 10 Jan 2020 08:11 compiled: 10 Jan 2020 08:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

41. Revision
    10.3.0.5810

    Issue #12: Get column comments in MSSQL back. See http://www.heidisql.com/forum.php?t=19576

    committed: 09 Jan 2020 21:27 compiled: 09 Jan 2020 21:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

42. Revision
    10.3.0.5809

    Issue #12: restore compatibility to MySQL pre-5.0 servers, which have no IS.columns table

    committed: 09 Jan 2020 20:50 compiled: 09 Jan 2020 20:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

43. Revision
    10.3.0.5808

    Issue #12: restore compatibility to MySQL pre-5.5 servers, which have no "Index_comment" column in IS.columns

    committed: 09 Jan 2020 20:19 compiled: 09 Jan 2020 20:27

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

44. Revision
    10.3.0.5807

    Issue #12: Implement TDBConnection.GetTableColumns and .GetTableKeys (todo: .GetTableForeignKeys), as a replacement for the error prone ParseTableStructure. SQLite columns and keys should be parsed correctly now, MS SQL and PostgreSQL may now have some glitches to fix.

    committed: 08 Jan 2020 15:28 compiled: 08 Jan 2020 15:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

45. Revision
    10.3.0.5806

    Restore previous logic: Allow empty result in TableName(Column), which is the case for data tab TEXT columns with LEFT(..) clause. Other columns may have a table name in that case. Closes #837

    committed: 03 Jan 2020 18:45 compiled: 03 Jan 2020 18:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

46. Revision
    10.3.0.5805

    Do not set DataTypeCompatibility=80 in ADO connection string with old SQLOLEDB driver. Probably solves some connection issues, see https://www.heidisql.com/forum.php?t=35208

    committed: 03 Jan 2020 16:32 compiled: 03 Jan 2020 16:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

47. Revision
    10.3.0.5804

    Issue #12: Proper implementation of TSQLiteQuery.ColIsPrimaryKeyPart()

    committed: 01 Jan 2020 19:12 compiled: 01 Jan 2020 19:27

    Downloads: 32bit build (8.0 MB)64bit build (8.5 MB)32+64bit installer (21.2 MB)

48. Revision
    10.3.0.5803

    Overload TDBQuery.TableName with TableName(Column), for future usage in ColIsPrimaryKeyPart and friends

    committed: 01 Jan 2020 18:51

49. Revision
    10.3.0.5802

    Issue #12: Call sqlite3_total_changes() after at least one call to sqlite3_step(), otherwise SQLite does not seem to execute a non-result query. Should make updates in data and query grid working now.

    committed: 01 Jan 2020 17:40 compiled: 01 Jan 2020 17:57

    Downloads: 32bit build (8.0 MB)64bit build (8.8 MB)32+64bit installer (21.2 MB)

50. Revision
    10.3.0.5801

    Add two newer header constants for MySQL/SSL, yet unused by HeidiSQL

    committed: 01 Jan 2020 11:59 compiled: 01 Jan 2020 12:28

    Downloads: 32bit build (8.0 MB)64bit build (8.5 MB)32+64bit installer (21.2 MB)

Imprint