If you often deal with systems running on MySQL, MariaDB, PostgreSQL, then, this application will be of great help for you. It is a straightforward PC software app that helps you to organize and manage various database connections conveniently. This application is for advanced PC users such as developers, admin managers, and the likes. After installation, when you launch the app, you will need to set up a connection, specifying the hostname, user name, and password of your database server ( MySQL or SQL Server). There is an advanced tab available on the “Session manager” settings menu; there, you can configure SSL encryption to secure your databases from being accessed by unauthorized persons.
After you have finished setting up a connection, a new entry will display in the left panel, click on the entry to view all available tables which will appear in a drop-down list. Also, you can view the indexes, columns, and foreign keys for each table. The app equally allows you to export your work to other servers or a new SQL file; you could even copy the work to the clipboard. Also, you can open or close database connections, as well as dump database objects into a new SQL file. Furthermore, it is possible to reformat unarranged SQL scripts and make them readable.
Portable HeidiSQL is licensed as freeware for PC or laptop with Windows 32 bit and 64 bit operating system. It is in servers category and is available to all software users as a free download.