HeidiSQL

HeidiSQL is a free, open-source graphical database management tool designed to administer MySQL, MariaDB, PostgreSQL, and Microsoft SQL Server databases. It runs on Windows and can connect to local or remote servers, including through SSH tunnels, enabling secure access to databases behind firewalls.

Its interface supports multiple sessions in tabs and includes a SQL editor with syntax highlighting, code completion, and query history. Users can browse database objects, edit table data, create and modify tables, views, stored procedures, and triggers, and manage routines. The program offers data export and import capabilities, as well as a database synchronization feature to compare and synchronize structures and data between databases.

Connectivity relies on the respective database client libraries, and HeidiSQL provides built-in support for encrypted connections (TLS) and SSH tunneling. It also offers features such as data export in SQL, CSV, or XML formats, and session templates.

Platform availability and licensing: HeidiSQL is primarily a Windows application, distributed as an installer or portable package; Linux and macOS users can run it under Wine or similar compatibility layers. It is distributed as free and open-source software with ongoing community development.