heidisql is an extremely powerful database management tool, written in Delphi. It supports MySQL, SQL Server and PostgreSQL, and lets you connect via named pipe, SSH tunnel, TCP/IP or experimental channels, so you can browse your databases, manage tables, views, procedures and triggers, edit records and assign user rights without leaving the window.
The interface is clean and intuitive, yet packed with features: create, alter, drop and query objects, import/export data, run backups, and write SQL with full syntax-highlighting and auto-completion. Multiple result tabs let you compare datasets side-by-side, while the data editor, table-structure manager and personal SQL-snippet library take care of everyday DBA tasks.
Advanced extras include bulk table operations, ASCII & binary file batch-inserts, live client-process monitoring, global text-search across all tables and one-click optimisation/repair routines.
Highlights
1. Free and open-source
2. Connect to multiple servers in one window
3. Command-line connection support
4. Secure access via SSH tunnel or SSL
5. Create & edit tables, views, stored procedures, triggers and scheduled events
6. Human-readable SQL export
7. Direct server-to-server/database-to-database copy
8. Granular user-rights management
9. Import text files (CSV, SQL, etc.)
10. Export data to CSV, HTML, XML, SQL, LaTeX, Wiki Markup or PHP Array
11. Spreadsheet-style data grid for easy browsing and editing
12. Batch table actions: move tables, change engine, collation and more
13. Bulk-insert ASCII or binary files into tables
14. Customisable syntax highlighting and auto-complete query editor
15. Automatic SQL formatter
16. Monitor and kill client processes
17. Global text search across all tables and databases
18. Batch optimise or repair tables
19. Launch parallel mysql.exe CLI window with current session settings and more