Portable HeidiSQL

Portable HeidiSQL is a reliable and straightforward application whose main purpose is to help you manage and organize multiple database connections effortlessly.

When you launch the application for the first time, you are required to add a new connection. Irrespective of which database you choose to connect to, be it MySQL or SQL Server, you need to specify the hostname, the user name and the password. The Advanced tab from the ‘Session manager’ window allows you to use SSL encryption so you can secure your databases and protect them from unauthorized access.

After you configure the connection, a new entry will appear in the left panel of the application. You can double-click it and all the available tables will appear in a drop-down list. Then, you can easily view the columns, the indexes and the foreign keys for each table. What’s more, you are able to alter the current table the way you want by removing or adding new columns, changing the primary keys or setting new variables.

Because it is mainly designed for web developers and database administrators, Portable HeidiSQL enables them to export structure and data either to a new SQL file, clipboard or to other servers.

What’s more, using Portable HeidiSQL you are able to manage user authentication and privileges by changing its credentials and limitations, dump database objects to a new SQL file and close or open multiple database connections.

You can automatically reformat disordered SQL scripts so you can make them more readable, stop on errors in batch mode and view binary data as text.

For those of you who want to change data appearance and shortcuts, modify the font and enable completion proposal, the ‘Preferences’ window stays at your disposal. You are able to change the tab width, the grid text colors and customize other settings as you want.

Because it is a portable utility, you can carry it with you wherever you go on a removable drive and use it on any computer. It has the same functionality as the standalone edition, still it creates no registry entries and you can remove it simply by deleting its containing folder.

Considering all of the above, Portable HeidiSQL proves to be a steady and effective solution when it comes to managing and storing multiple database connections, as well as performing various modifications to specific tables such as altering them, changing the primary key and adding new columns.