Active forum threads:

• SQL Error: can't connect to MySQL server on 'localhost' (10061)
  Jul 30 by dogra_vj
• Insert Files Into Fields Question
  Jul 29 by anse
• Back up/ restore login info
  Jul 28 by jolt1
• Editor Question
  Jul 28 by jamsession
• fields as CHAR i see as VARCHAR
  Jul 28 by JacekBudzyn
• Ctrl+Enter error
  Jul 26 by doinkxs
• Please build plink timeout into the front end!?
  Jul 26 by Hendrik
• Procedure Question
  Jul 26 by jamsession
• Weird interface resizing isssue
  Jul 25 by anse
• Wamp and Heidisql sync
  Jul 23 by kalvaro
• Plotting data
  Jul 23 by maxman92
• Install instructions
  Jul 22 by anse
• Data / Row Filtering
  Jul 22 by anse
• Negative TIME
  Jul 21 by energiesysteme
• Ideas for HeidiSQL
  Jul 21 by anse

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

• 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]

• 29 May Multiple query results and server details

  After having updated to the latest build via Help > "Check for updates" you will be able to see more than only the result of the last SELECT query in any "Query" tab. By default, HeidiSQL displays up to 10 result sets in subtabs. In case you want more just go toTo... [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 43327 HeidiSQL users over the last month, which have the statistics feature enabled in their preferences dialog. (Implemented in build r2497)

Random Screenshots

Usermanager

Create Db

Table Editor

Copy Table

Multiresults

More images...