What is HeidiSQL?
HeidiSQL is free software for people who work with databases, and aims to be intuitive to use. "Heidi" lets you connect to a variety of databases, like MariaDB, MySQL, Microsoft SQL, PostgreSQL, SQLite, Interbase and Firebird. Once you are connected, you can edit data and structures in these databases. Invented in 2002 by Ansgar, HeidiSQL is still a popular tool for MariaDB and MySQL, and actively maintained.
The Windows version of HeidiSQL is currently built with Delphi 12.3. Lazarus v3.8 is used for compiling the Linux version.
Download HeidiSQL, read further about features, take part in discussions or see some screenshots.
News 
-
11 Dec HeidiSQL 12.14 Windows and Linux
Get it from the release page on Github: Windows: https://github.com/HeidiSQL/HeidiSQL/releases/tag/v12.14.0.7164 Linux: https://github.com/HeidiSQL/HeidiSQL/releases/tag/v12.14.1.1 Note: You can ...
-
03 Nov HeidiSQL 12.13 available for Windows and Linux
Get it from the release page on Github: Windows: https://github.com/HeidiSQL/HeidiSQL/releases/tag/v12.13.0.7147 Linux: https://github.com/HeidiSQL/HeidiSQL/releases/tag/v12.13.1.1 The v12.13 fil ...
-
06 Oct HeidiSQL 12.12 bugfix release
Get it from the download page The v12.12 Windows release now abandons the 32 bit portable releases and nightly builds. Only 64 bit releases from now on. Back in Jan 2019, for v10.0, I created the ...
-
20 Jun HeidiSQL 12.11.1.167 Linux beta release
Get it from the download page Full changelog: https://github.com/HeidiSQL/HeidiSQL/commits/lazarus/ Latest notable changes: Most of the updates done on the Windows version, plus: Issue #2197: Can ...
-
09 Jun HeidiSQL 12.11 with vector support on MariaDB, and quick action "Select top 1000 rows"
Get it from the download page 3rd party updates: Update plink executables to v0.83. See https://www.chiark.greenend.org.uk/~sgtatham/putty/ Update MariaDB Connector/C to v3.4.5. See https://maria ...
Features
- Free for everyone, OpenSource
- Connect to multiple servers in one window
- Supported database systems: MariaDB, MySQL, MS SQL, PostgreSQL, SQLite, Interbase and Firebird
- Connect to servers via commandline
- 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
- Manage user-privileges
- Import text-files
- Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
- Browse and edit table-data using a comfortable grid
- Bulk edit tables (move to db, change engine, collation etc.)
- Batch-insert ascii or binary files into tables
- Write queries with customizable syntax-highlighting and code-completion
- Pretty reformat disordered SQL
- Monitor and kill client-processes
- Find specific text in all tables of all databases of one server
- Optimize and repair tables in a batch manner
- Launch a parallel mysql.exe command line window using your current connection settings
- And much more
HeidiSQL users with enabled statistics feature work on these servers:
| Version | Users |
|---|---|
| 10.11 | 28,933 |
| 10.6 | 21,662 |
| 10.5 | 15,136 |
| 10.4 | 40,767 |
| 10.3 | 14,577 |
| 8.4 | 11,482 |
| 8.0 | 117,618 |
| 5.7 | 51,234 |
| 5.6 | 13,648 |
| 5.5 | 19,023 |
| Version | Users |
|---|---|
| 16.0 | 3,789 |
| 15.0 | 4,749 |
| 14.0 | 1,716 |
| 13.0 | 1,540 |
| 12.0 | 2,070 |
| 11.0 | 961 |
| 10.50 | 934 |
| 10.0 | 169 |
| 9.0 | 198 |
| 8.0 | 67 |
| Version | Users |
|---|---|
| 18.0 | 740 |
| 17.6 | 1,774 |
| 17.5 | 1,225 |
| 17.4 | 950 |
| 16.10 | 1,836 |
| 16.9 | 667 |
| 16.8 | 870 |
| 15.14 | 924 |
| 14.19 | 946 |
| 9.6 | 675 |
| Version | Users |
|---|---|
| 8.0 | 3 |
| 3.50 | 1,900 |
| 3.48 | 537 |
| 3.46 | 9 |
| 3.45 | 532 |
| 3.44 | 255 |
| 3.39 | 339 |
| 3.38 | 67 |
| 3.34 | 108 |
| 3.30 | 35 |
| Version | Users |
|---|---|
| 8.2 | 1 |
| 5.0 | 20 |
| 4.0 | 4 |
| 3.45 | 1 |
| 3.44 | 1 |
| 3.0 | 4 |
| 2.5 | 4 |
| 0.0 | 4 |
The author: Ansgar Becker
