HeidiSQL is free software and aims to be easy to learn. “Heidi” lets you view and edit data and structures from a computer running one of MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite database systems. HeidiSQL was invented by Ansgar in 2002 and is among the most popular MariaDB and MySQL tools in the world.。

Software features

Free and open source for everyone
Connect to multiple servers in one window
Supported database systems: MariaDB, MySQL, MS SQL, PostgreSQL and SQLite
Connect to the server via command line
Connect via SSH tunnel, or via SSL setup
Create and edit tables, views, stored routines, triggers, and scheduled events。
Generate beautiful SQL exports, then compress them, or put them on the clipboard。
Export directly from one server/database to another
Manage user permissions
Import text file
Export table rows to CSV, HTML, XML, SQL, LaTeX, Wiki markup and PHP arrays
Browse and edit table data using a comfortable grid
Batch edit tables (move to database, change engine, organize, etc.）
Batch insert ascii or binary files into table
Write queries with customizable syntax highlighting and code completion
Beautifully reformatted unordered SQL
Monitor and kill client processes
Find specific text in all tables of all databases on one server
Batch optimization and repair table
Launch a parallel mysql.exe command line window using your current connection settings
and more

Working with a MySQL database is a specialized job that requires extensive knowledge in the field and appropriate procedures to make the task easier. For developers and database administrators, the sorts or HeidiSQL utilities are really popular. Focused on facilitating the management of compatible databases, this software solution has a pretty decent interface that contains all the features and commands you need to manage your data。

Thanks to the innovative technology behind HeidiSQL Session Manager, you can establish connections and run multiple databases at once. The application can handle a large number of tasks and makes creating and editing tables a simple job. With the help of this program, you can also create and run custom queries, while it comes with tools that extend the functionality of this utility. So you can use user management module where you can specify permissions for each user that will access the database。

Data such as hosts, logs, tables, status or permissions can be easily refreshed through HeidiSQL’s own functions. Database tables can be batch edited, which means you can load multiple tables at once and process them all through the Bulk Table Editor。

Another neat feature of this software is the ability to export and import settings with just one click. The possibility to export databases to SQL and synchronize them doubles this. Other tools include file interpolation within TEXT and BLOB fields, importing data from CSV, and more。

All in all, it is safe to say that HeidiSQL is indeed one of the best tools of its kind, and due to its full range of features, it should satisfy the needs of many users who specialize in this field。

Change log

• Update DDetours sources to latest (2021-01-01)
• Update vcl-styles-utils sources to latest (2021-01-11)
• Update gnugettext.pas to rev 148 from http://svn.code.sf.net/p/dxgettext/code/trunk/dxgettext/sample/gnugettext.pas
• PostgreSQL: update OpenSSL libraries to v1.1.1s, taken from http://wiki.overbyte.eu/wiki/index.php/ICS_Download#Download_OpenSSL_Binaries_.28required_for_SSL-enabled_components.29
• PostgreSQL: Issue #1758: add libpq-15.dll and its 4 dependent files, all signed with my Authenticode certificate (see #1733)
• madExcept 5.1.2, including a fix for ASLR.

Download address HeidiSQL