HeidiSQL Free Database Management Tool For PC Download 11.3

What is HeidiSQL?

HeidiSQL is a free database management tool that supports MySQL, Microsoft SQL Server, and PostgreSQL databases. It allows you to browse and edit data, create and edit tables, views, procedures, triggers, and scheduled events. Features include managing multiple servers from one window, exporting from one database server into another, bulk editing, and advanced SQL syntax editor, and database optimization and repair functions.

HeidiSQL is Opensource for 9 years of active development, connects to multiple servers in one window, creates and edits tables, views, stored routines, triggers, and scheduled events.

Main Features of HeidiSQL

• Connection: The very first dialog asks for hostname and credentials. The list of wanted databases can be limited and sorted alphabetically.
• SSH Tunnel: Establishing connections to MariaDB/MySQL servers through an SSH tunnel, using plink.exe.
• User manager: Administer MariaDB/MySQL accounts as easily as a toy. A pulldown showing assigned database objects reveals everything.
• Host Variables: The list of server variables. Most of them are editable by DoubleClick. Filterable.
• Variable Editor: Editable server variables, either for the session or global scope.
• Host Processlist: The list of currently running processes. Used to analyze executed SQL and to kill bad processes.
• Host Commandstats: Graphical statistics on the amount of all different SQL commands.
• Database: Details about tables and views. Switchable column headers. Used to rename, delete, empty, and modify tables.
• Create DB: Create, modify databases, and assign a character set + collation.
• Table Editor: Visually create and edit tables, without hiding the CREATE/ALTER TABLE query.
• View Editor: Create and modify VIEWs on newer MariaDB/MySQL servers.
• Stored Routines: Create and edit stored procedures and functions.
• Trigger Editor: Create and modify TRIGGERs on newer MariaDB/MySQL servers.
• Event Editor: Create and modify scheduled scripts (EVENTs).
• Favorites: Mark tables and whatever as favorites.
• Copy Table: Create exact copies of an existing table, within the same database or in another one.
• Data: Table contents editable in a grid. Switchable columns and sorting orders. Various filtering mechanisms.
• Image Preview: BLOBs can contain various file formats. HeidiSQL displays JPEG, PNG, GIF, BMP, PSD, and some more image formats in a quick preview box.
• Grideditors: Grid editing using various editors for text, hex/binary, enum, set, date/time columns.
• Multiresults: Run a batch with multiple SQL queries and get one tab per query.
• Query: SQL query editing: Customizable syntax highlighting, snippet files, completion proposal pulldown, and editable results.
• Search Replace: Find and replace text in query editors, supporting regular expressions with callbacks. This dialog also supports searching and replacing table rows!
• Open Large Files: When SQL files are bigger, HeidiSQL asks you to run these without loading them as a whole into the query editor
• Import Large Files: Importing a large file displays a progress dialog with nice statistics details
• Export SQL: Dump selected databases and data into a single dump file, one file per table, directly to another host, to the clipboard, or to another database on the same server. Nearly as fast as mysqldump!
• Export Textfile: Save the result of any data grid to CSV, HTML, XML, LaTeX, Wiki markup, or PHP files.
• Import Textfile: Import CSV or delimited files produced by spreadsheet applications directly into a MariaDB/MySQL table. Users which are not allowed to execute LOAD DATA can activate a client-side parser.
• Insert Files: Read lots of files per batch into BLOBs, using macros for neighbor fields. Binary safe.
• Maintenance: Optimize, check, analyze, and repair tables with a few mouse clicks.
• Find Text On Server: Find text in a table, a database, or even on the whole server.
• Print: Send any list of tables, columns, variables, etc. to your printer. Switchable columns.
• SQL Help: Browse through the topics in MariaDB’s built-in help system.
• Update check: Keeps your free database management tool HeidiSQL version up to date with the latest features and bug fixes. Can be invoked automatically by option.