HeidiSQL

HeidiSQL: An easy-to-use interface and a working-horse for web-developers.

An easy-to-use interface and a working-horse for web-developers.

HeidiSQL is simple tool designed for web-developers using the popular MySQL-Database. It allows you to manage multiple database connections and browse your databases or tables from an intuitive Windows interface.

HeidiSQL 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.

HeidiSQL 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

Requirements:

- MySQL Server
- SQL Server