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

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

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

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

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

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

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

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

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

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

11. Revision
    10.3.0.5820

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

    committed: 14 Jan 2020 20:59

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

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

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

15. Revision
    10.3.0.5816

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

    committed: 13 Jan 2020 14:13

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

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

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

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

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

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

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

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

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

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

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

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

28. Revision
    10.3.0.5803

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

    committed: 01 Jan 2020 18:51

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

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

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

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

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

34. Revision
    10.3.0.5797

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

    committed: 01 Jan 2020 11:50

35. Revision
    10.3.0.5796

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

    committed: 01 Jan 2020 11:44

36. Revision
    10.3.0.5795

    Issue #12: Simplify code in Tconnform.ValidateControls

    committed: 01 Jan 2020 11:42

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

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

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

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

41. Revision
    10.3.0.5790

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

    committed: 27 Dec 2019 17:19

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

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

44. Revision
    10.3.0.5787

    Issue #12: Implement TSQLiteQuery.TableName, and
    * free Psqlite3_stmt later, in TSQLiteGridRows.Destroy, not in TSQLiteConnection.Query directly after execution
    * move code from TAdoDBQuery.TableName to TDBQuery.TableName, as this is generic SQL parsing which works for all layers (though not so reliable)

    committed: 27 Dec 2019 08:30

45. Revision
    10.3.0.5786

    Issue #12: On "Host" tab, prefer visible filename over visible file path

    committed: 25 Dec 2019 12:58 compiled: 25 Dec 2019 13:27

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

46. Revision
    10.3.0.5785

    Issue #12:
    * define and use SQLite column datatypes, at least the few groups (int, text, real, blob, date)
    * TSQLiteConnection.GetThreadId now returns the application process id, as there is no connection pid in SQLite

    committed: 25 Dec 2019 12:34 compiled: 25 Dec 2019 12:57

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

47. Revision
    10.3.0.5784

    Introduce experimental implementation of SQLite support, alias "Jingle Bells v2", for issue #12

    committed: 24 Dec 2019 14:32 compiled: 24 Dec 2019 14:40

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

48. Revision
    10.3.0.5783

    Revert a part of commit:7ed97b3fe2f989b19bd282ae00c64de8e7b4871d which should have fixed a resizing bug on the query helpers box. See https://www.heidisql.com/forum.php?t=35096

    committed: 19 Dec 2019 21:25 compiled: 19 Dec 2019 21:57

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

49. Revision
    10.3.0.5782

    Use the newer KNOWNFOLDERID TGUID constants from Winapi.KnownFolders instead of CSLID integer constants. Probably fixes wrong FOLDERID_RoamingAppData folder for #815

    committed: 18 Dec 2019 21:36 compiled: 18 Dec 2019 21:57

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

50. Revision
    10.3.0.5781

    Make TDBObject.IsSameAs more crash stable, in case the second object is nil. See https://www.heidisql.com/forum.php?t=35109

    committed: 16 Dec 2019 08:11 compiled: 16 Dec 2019 08:28

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

Imprint