HeidiSQL provides you with an easy-to-use option to view and edit data/structures from machines running MariaDB, MySQL, Microsoft SQL, or PostgreSQL database systems.

This database management program also allows you to create and run custom queries, with extended capabilities provided by the included tools. This incorporates a user management module that enables you to specify ala carte user access permissions.

HeidiSQL will allow you to browse and edit data, create and edit tables, views, procedures, triggers, as well as scheduled events. Additionally, you can export structure and data either to an SQL file, clipboard, or other servers. It can also quickly export and import various other settings via a single click.

HeidiSQL Features:

● Connect to multiple servers in one window
● Connect to servers via command line
● Connect via SSH tunnel, or pass SSL settings
● Create and edit tables, views, stored routines, triggers, and scheduled events.
● Generate nice SQL-exports, compress these afterward, or put them on the clipboard.
● Export from one server/database directly to another server/database
● Manage user-privileges
● Import text files
● Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup, and PHP Array
● Browse and edit table data using a comfortable grid
● Bulk edit tables (move to DB, change the engine, collation, etc.)
● Batch-insert ASCII or binary files into tables
● Write queries with customizable syntax-highlighting and code-completion
● Pretty reformat disordered SQL
● Monitor and kill client processes
● Find specific text in all tables of all databases of one server
● Optimize and repair tables in a batch manner
● Launch a parallel mysql.exe command line window using your current connection settings
● And much more