HeidiSQL adalah perangkat lunak gratis, dan bertujuan agar mudah dipelajari. “Heidi” memungkinkan Anda melihat dan mengedit data dan struktur dari komputer yang menjalankan salah satu sistem database MariaDB, MySQL, Microsoft SQL, PostgreSQL, dan SQLite. Diciptakan pada tahun 2002 oleh Ansgar, HeidiSQL milik alat yang paling populer untuk MariaDB dan MySQL di seluruh dunia. untuk mengunduhnya silakan KLIK DISINI.
Compatibility notes
- HeidiSQL runs fine on Windows 8 and 10 (and on Windows 7 + 11 with some minor issues)
- Running HeidiSQL on newer Wine releases is currently quite unstable. Preferring Wine 4.0 likely solves various issues.
- Connecting to TLS 1.2 enabled MS SQL Servers requires an updated OLE DB Driver 18 for SQL Server to be installed.
Features
- Free for everyone, OpenSource
- Connect to multiple servers in one window
- Supported database systems: MariaDB, MySQL, MS SQL, PostgreSQL and SQLite
- 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
Sumber: https://www.heidisql.com