What's this?
HeidiSQL is a lightweight, Windows based interface for managing
MySQL and Microsoft SQL databases.
It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events.
Also, you can export structure and data either to SQL file, clipboard or to other servers.
read more...
News 
-
01 Mar New feature: Launch command line window
After having established a MySQL or MariaDB connection, HeidiSQL offers to launch a command line window (located in the "Tools" menu). This executes mysql.exe from the directory which is set in Tools > Preferences > Miscellaneous. The clue is that HeidiSQL passes all connection parameters from the current connection to that command line, including host/user/password, named pipes and SSL s ... [read]
-
12 Feb HeidiSQL 7.0 released
450 revisions after the 6.0 release follows the new 7.0 release of HeidiSQL now. Here are the most noticable changes since the 6.0 release:- Basic support for Microsoft SQL Server, allowing to execute queries, edit grid data and to do a data-only export- Introduce a separate dialog for all grid export actions, allowing to set up various options before file is created- Threaded query execution, ... [read]
-
22 Jan New feature: Pluggable authentication
Starting with MySQL 5.5.7 or MariaDB 5.2, the server allows the client to authenticate via plugin. HeidiSQL now fully supports establishing such connections, by providing an exported method called mysql_authentication_dialog_ask, which is automatically invvoked by libmysql.dll, if the server says so during the connection handshake.Curious how that works? Here's a simple example:1. Be sure to ha ... [read]
-
19 Jan New feature: SSL settings in user manager
In MySQL you can restrict users to connect only via SSL settings. HeidiSQL's user manager now adds support for these settings, which include cipher, subject and issuer. You can also select X509 certificate, in which case cipher etc. do not matter. To get this new feature, you just need to update to the latest build (see Help > Check for updates). [read]
-
10 Dec Automated installer creation
On the download page you will find the executable for each SVN commit in the HeidiSQL repository. The executables are processed in conjunction with a SVN post commit hook. I just extended this process so it also creates the installer with that executable, using a InnoSetup command line. This way, users who need a full installer and also want to use the latest build can do that in one download.T ... [read]
Features
- Connect to multiple servers in one window
- Connect to servers via commandline
- Connect via SSH tunnel, or pass SSL settings
- Create and edit tables, views, stored routines, triggers and scheduled events.
- Generate nice SQL-exports
- 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 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
HeidiSQL users work on these MySQL servers*
* Reported by HeidiSQL users over the last month, which have the statistics feature enabled in their preferences dialog.