heidisql

[io.kent]

What's this?

HeidiSQL screenshot HeidiSQL screenshot: Session manager HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, 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.

HeidiSQL - MySQL, MSSQL and PostgreSQL made easy

Features

Free for everyone, OpenSource.

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, compress these afterwards, or put them on the clipboard.

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

Download HeidiSQL