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

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

3. Revision
   10.3.0.5835

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

   committed: 19 Jan 2020 13:26

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

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

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

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

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

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

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

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

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

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

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

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

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

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

18. Revision
    10.3.0.5820

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

    committed: 14 Jan 2020 20:59

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

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

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

22. Revision
    10.3.0.5816

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

    committed: 13 Jan 2020 14:13

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

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

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

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

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

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

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

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

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

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

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

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

35. Revision
    10.3.0.5803

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

    committed: 01 Jan 2020 18:51

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

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

38. Revision
    10.3.0.5800

    Issue #12: Detect more granular data types on SQLite, which we need for the table designer and other things

    committed: 01 Jan 2020 11:56

39. Revision
    10.3.0.5799

    Issue #12: Fix TDBConnection.ApplyLimitClause for SQLite, which does not support a LIMIT clause in UPDATE/DELETE statements

    committed: 01 Jan 2020 11:53

40. Revision
    10.3.0.5798

    Issue #12: Get TDBConnection.GetSessionVariables running for SQLite, with an empty list of variables for now

    committed: 01 Jan 2020 11:52

41. Revision
    10.3.0.5797

    Issue #12: Implement TSQLiteConnection.GetCreateCode, and support square brackets for identifier quoting

    committed: 01 Jan 2020 11:50

42. Revision
    10.3.0.5796

    Move TDBConnection.FRegClasses one down in class hierarchy, where it belongs

    committed: 01 Jan 2020 11:44

43. Revision
    10.3.0.5795

    Issue #12: Simplify code in Tconnform.ValidateControls

    committed: 01 Jan 2020 11:42

44. Revision
    10.3.0.5794

    Issue #12: Support query batch fired in one go, and get multiple results per query running. Using pzTail out parameter of sqlite_prepare_v3(), not sqllite_next_stmt(), which returns statements from previously fired queries.

    committed: 29 Dec 2019 09:52 compiled: 29 Dec 2019 09:57

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

45. Revision
    10.3.0.5793

    Make TDBConnection.GetLastResults generic for all network types, and only override it for MSSQL with a manual query-separator, so we have less code

    committed: 28 Dec 2019 09:35

46. Revision
    10.3.0.5792

    Issue #12: Clean up code, attempt to get multiple SQLite results per query working, move FStatementNum from TDBConnection to the only caller TMySQLConnection

    committed: 28 Dec 2019 09:29

47. Revision
    10.3.0.5791

    Issue #12: Provide file pick icon in SQLite database file edit box. Database file is created by sqlite3_open() silently if it does not yet exist. Show a confirmation message in such cases.

    committed: 27 Dec 2019 17:53 compiled: 27 Dec 2019 18:27

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

48. Revision
    10.3.0.5790

    Session manager: populate library dropdown when user selects a different net type

    committed: 27 Dec 2019 17:19

49. Revision
    10.3.0.5789

    Introduce function TDBConnection.ResultCount and use that instead of syncing FResultCount variable in many places

    committed: 27 Dec 2019 09:05

50. Revision
    10.3.0.5788

    Issue #12: Get real/origin names of columns in a SQLite result into FColumnOrgNames list, and remove Columns list from TGridRows now that we can use the statement pointer later

    committed: 27 Dec 2019 08:53 compiled: 27 Dec 2019 08:58

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

Imprint