HeidiSQL are MySQL and Microsoft SQL database management applications. This tool allows the user to view and edit data, create and edit tables, procedures, triggers and scheduled events. The database structure and data itself can be exported to SQL files, clipboard or other servers.
- the program is free - OpenSource;
- will connect to multiple servers in the same window;
- can connect to the server via the command line;
- SSH encryption of the connection;
- Direct export of data structure and data itself from one server to another;
- Setting user rights;
- import of text files;
- Export tables to CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array formats;
- Viewing and editing tabular data in a convenient graphical shell;
- batch import of ascii and binary files to tables;
- Writing queries with syntax highlighting and code line autocompletion functions;
- search for specific text in all tables, all databases on one server;
- Optimization and recovery of tables in batch mode;
- Launch the mysql.exe command line parallel window using the current connection settings and much more...