Computer, Mysql, Software, Tech

HeidiSQL – MySQL made easy

heidisql_logoHeidiSQL is a brilliant, simple and free open source SQL tool for easy management of your MySQL server and databases. It does exactly what you expect it to – and a few extra things. It allows you to browse your databases, manage tables, view and edit records, manage user-privileges and more from an intuitive Windows® interface.


Downloading, installing and configuring is very simple and HeidiSQL is quickly running on your machine. Through the hierarchy on the left hand side – you can easily navigate the different database obejcts of your MySQL databases.

The main window allows you to manipulate the select objects – mainly tables – added or removing fields etc. All of the data in each table can be explored by clicking the “Data” tab. This presents a grid view of the entire table data, however BLOB fields are displayed in the bottom of the screen in the dedicated BLOB viewer and editor.

HeidiSQL’s query editor features field suggestion and completion – making work with any database a trivial task and limits the number of errors related to typing errors. Additional features of HeidiSQL includes import and export of databases, user management and more.

Furthermore, you can import data from text files, run SQL queries, synchronize tables between two databases and export selected tables to other databases or SQL scripts. HeidiSQL offers an easy-to-use interface with syntax highlighting for SQL queries and tabs to switch between database views. Other features include editing of BLOBs and MEMOs, support for large SQL scripts, user process management and more.

To download the software visit:

  • Thanks for sharing. Tried this just now and its very easy to use. I always use PHPMyAdmin and was in search for an alternate for one of my sites. This is cool !

  • hey guys, If mysql db management has become your Passion then let me help you guys with the latest technology, sqlyog an amazing tool offered under open source just for free and its best with improved gui and more secured and stable tool and also with more powertools like data sync, schema sync…Just try!!!

  • dbForge Studio for MySQL offers you a complete set of MySQL administration tools, database development, and SQL query tools. Combination of the very best features of existing MySQL front ends and MySQL GUI tools makes dbForge Studio a perfect tool for SQL developer.
    Try dbForge Studio for MySQL FREE Edition!

Comments are closed.