HeidiSQL/HeidiSQL

Features

• Database Protocol Connectors - Establishes connections to MariaDB, MySQL, MS SQL, PostgreSQL, SQLite, Interbase, or Firebird servers using TCP/IP, named pipes, or SSH tunnels.
• Data Import and Export - Writes database schema and table contents to SQL files, clipboard, or directly to another server.
• Portable Database Clients - Ships a portable version that runs from a USB drive without requiring installation.
• Database Object Editors - Creates and modifies tables, views, stored procedures, triggers, and events through visual editors.
• Database Table Editors - Provides a graphical editor to define and modify table columns, indexes, and other structural properties.
• Inline Editors - Displays table or view contents in a grid with inline editing, quick filters, and search-and-replace.
• SQL Query Editors - Provides a tabbed SQL query editor with syntax highlighting, autocomplete, and editable result grids.
• Multi-Engine Database Administration Clients - Manages MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase, and Firebird servers from a single graphical client.
• Visual Editors - Provides a visual editor for creating and editing stored procedures and functions.
• Visual Table Designers - Creates and edits tables with a visual editor that simultaneously shows the underlying CREATE or ALTER query.
• Multi-Object Database Designers - Provides a graphical interface to design and alter tables, views, stored procedures, triggers, and scheduled events.
• Multi-Protocol Connection Managers - Abstracts connections to MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase, and Firebird under a unified interface.
• Multi-Protocol Database Connectors - Connects to MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase, Firebird, ProxySQL, and Redshift in a single window.
• Database Server Monitors - Provides a live process monitor to view and terminate database connections and optimize tables.
• Editable Data Grids - Opens a visual grid to view, filter, sort, and modify table rows directly without writing SQL.
• Data Grids - Edits table contents in a grid with switchable columns, sorting, and filtering mechanisms.
• Delphi VCL Implementations - Builds the entire desktop interface using Delphi's VCL, providing native Windows controls and Win32 API access.
• Tabbed Interfaces - Organizes query editors, data grids, and object designers in a tabbed workspace with session persistence.
• Editable Data Tables - Displays table data in an editable grid for direct row modification, insertion, and deletion.
• Batch Query Execution - Executes a batch of SQL queries and displays each query's result in a separate tab.
• Cross-Database Search Tools - Searches for a specified text string across every table in every database on a connected server.
• SQL Exports - Generates SQL export files for structure and data with options to send to file, clipboard, or another server.
• CSV Imports - Loads data rows from CSV files into tables with configurable format settings like line terminators and enclosing characters.
• CSV Parsers - Parses CSV files client-side to enable data import even without server-side FILE privilege.
• Named Database Creators - Creates and modifies databases while assigning character sets and collations.
• BLOB Batch Insertions - Reads multiple files in a batch into BLOB columns with macros for neighbor fields in a binary-safe manner.
• SQL View Editors - Opens a view editor to write SELECT queries, save them as views, and display their data.
• Query Result Exporters - Saves data grid results to CSV, HTML, XML, LaTeX, Wiki markup, or PHP files.
• Database Object Management - Renames, deletes, empties, and modifies tables and views through a switchable column header interface.
• Visual Editors - Creates and modifies database triggers through a visual editor.
• Database User Privilege Management - Assigns roles and configures authentication plugins to control database access.
• External File Imports - Imports CSV and delimited files into database tables using a client-side parser.
• Logical Database Dumps - Dumps selected databases and data into a single file, one file per table, to clipboard, or directly to another host.
• Query File Importers - Executes commands from .sql files into a selected database with encoding selection.
• Stored Procedures - Provides an editor to write and save stored procedures and functions within a selected database.
• Database Content Find-and-Replace Tools - Searches and replaces text in query editors and table rows using regular expressions.
• Text Search - Searches for text within a table, a database, or across the entire server.
• Large SQL File Executors - Executes large SQL files without loading them entirely into the query editor.
• Database SSH Tunnelers - Tunnels database connections through SSH or secures them with SSL settings.
• SSH Tunneling - Routes database traffic through an embedded SSH client with key-based and password authentication.
• Database User Account Managers - Creates, modifies, and administers database user accounts with a visual interface showing assigned objects.
• Multi-Table Maintenance Runners - Runs maintenance operations on multiple tables at once to improve performance and fix corruption.
• Database Process Monitors - Monitors active database server processes and allows terminating problematic queries directly from the interface.
• Process Monitors - Views active server connections and terminates client processes as needed.
• Database BLOB - Provides inline preview of image BLOBs directly within the data grid, eliminating the need for external viewers.
• Intra-Server Table Duplicators - Creates exact copies of tables within the same database or to another database on the same server.
• Visual Query Builders - Translates drag-and-drop table and column selections into SQL statements with joins, filters, and sorting.
• Database IDEs - Lightweight client for managing MySQL, MSSQL, and PostgreSQL.
• GUI Clients - Offers a Windows-based GUI for database management.

سجل النجوم