Active forum threads:

• Keep Alive
  Sep 07 by anse
• filtered cells lose inserted data
  Sep 06 by member
• SQL error
  Sep 01 by HeuF
• Malware embedded in HeidiSQL
  Sep 01 by Rapid-eraser
• Tables names changes to lower case during Export
  Aug 25 by anse
• New function: Bulk table editor: Copy to database
  Aug 23 by anse
• Empty database
  Aug 21 by anse
• SQL Formatting
  Aug 21 by jason-fonseca
• duplicate database
  Aug 19 by aciobanu
• Save Query? prompt
  Aug 19 by anse
• Anyone having problems running HeidiSQL (5.1) on Win7 x64???
  Aug 18 by jacdc
• bugreport
  Aug 18 by vga
• Results of Query not displayed
  Aug 17 by cj868
• Error: Could not establish connection...
  Aug 17 by MySQLbuster
• error on export
  Aug 17 by lemon_juice

What's this?

HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows® interface.

News

• 18 Aug New feature: Query profile

  Users of the latest builds now have a GUI way to display a detailed query profile for the executed SQL in a query tab. Just check the Query profile tree node in the newly introduced "helpers" tree and run some query.This is basically what SHOW PROFILE in MySQL 5.0.37... [read]

• 19 Jul New feature: Prompt for user + password

  This is for users who don't like HeidiSQL to store usernames and passwords somewhere:Activating this new checkbox will ask you for username and password on demand, each time you connect to this session. Both previously stored username and password are taken as the de... [read]

• 18 Jun LaTeX output in grid export

  Users of the latest HeidiSQL build file will find a new option when rightclicking a data grid: "Copy selected rows as LaTeX table". Same applies to the "Export grid data ..." which is capable of storing rows in LaTeX format to a file.Thanks to brampton for the patch!... [read]

• 17 Jun Revamp "Copy table" dialog

  From time to time dialogs need some usability refactoring. So happened with the good old Copy table dialog in HeidiSQL. New features:- Select specific indexes or foreign keys to be created in the new table- An editor for a WHERE clause, for cases in which you only ne... [read]

• 04 Jun New feature: Image preview

  Users of HeidiSQL 3.x may have missed this feature since grid and BLOB editing was rewritten for v4: A preview area for images. Now it's even more powerful than before: it detects and loads various kinds of images (JPG, PNG, GIF, BMP, PSD, TIF and more). Also, the ne... [read]

Features

• Generate nice SQL-exports
• Synchronize tables between two databases
• Manage user-privileges
• Import text-files
• Export table-data as CSV, HTML, XML and SQL
• Browse and edit table-data using a comfortable grid
• Create and edit tables, views, stored routines and triggers
• 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
• Connect to servers via commandline
• Find specific text in all tables of all databases of one server
• Optimize and repair tables in a batch manner
• And much more

MySQL version usage*

* Reported by 49662 HeidiSQL users over the last month, which have the statistics feature enabled in their preferences dialog. (Implemented in build r2497)

Random Screenshots

Host Variables

Event Editor

Grideditors

Export Sql

Import Textfile

More images...