The database tree gives HeidiSQL a place to browse server databases and their tables, while the data grid lets you view and edit table rows. The Windows database tool also brings SQL queries, schema editing, and data transfer into a multi-connection workspace.
The database tree leads to table and schema editing
Connect to database servers and keep multiple connections open in one HeidiSQL window. The tree provides a way to navigate databases and tables; selecting a table brings its rows into a grid for browsing and editing. HeidiSQL can also create or modify tables, views, stored routines, triggers, and scheduled events.
For broader schema changes, the table tools include batch operations such as moving tables to another database or changing their storage engine or collation. User-privilege management includes roles and authentication-plugin settings.
The query editor supports composing and running SQL
The SQL editor provides customizable syntax highlighting and code completion. It can reformat disordered SQL, giving queries a more consistent layout before or after editing. HeidiSQL can also find text across tables in the databases on a server.
Connections can use an SSH tunnel or SSL settings. For command-line work, HeidiSQL can open a parallel mysql.exe window using the current connection settings.
Exports and imports cover common data handoffs
Export table rows as CSV, HTML, XML, SQL, LaTeX, Textile, PHP, Markdown, or JSON. SQL exports can be compressed or copied to the clipboard, and data can be exported directly from one server or database to another.
Text files can be imported into a database. For maintenance work, HeidiSQL can optimize or repair tables in a batch and can monitor or terminate client processes.
Pros
- Browse and edit table rows in a grid
- Write SQL with syntax highlighting and code completion
- Export rows in formats including CSV, JSON, and SQL
- Transfer data directly between servers or databases
System requirements: Windows 7, Windows 8, Windows 8.1, Windows 10, Windows 11
Which database systems can HeidiSQL connect to?
It supports MariaDB, MySQL, Microsoft SQL Server, PostgreSQL, SQLite, Interbase, Firebird, ProxySQL, and Redshift.
Can HeidiSQL edit table data and structures?
Yes. It provides a grid for browsing and editing rows, along with tools to create and edit tables and other database structures.
What formats can HeidiSQL export table rows to?
Supported formats include CSV, HTML, XML, SQL, LaTeX, Textile, PHP, Markdown, and JSON.
