# HeidiSQL — Lightweight Multi-Database Client for Windows and Linux

> HeidiSQL is a free, open-source database client supporting MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, Interbase, and Firebird with a fast, no-nonsense Windows-native interface.

## Install

Save in your project root:

# HeidiSQL — Multi-Database Client

## Quick Use
```bash
# Windows: download installer from heidisql.com
# Linux: run via Wine or use the portable edition
choco install heidisql   # Windows via Chocolatey
```

## Introduction
HeidiSQL is a veteran open-source database management tool that has served developers and DBAs since 2006. It provides a straightforward graphical interface for browsing, editing, and managing databases across multiple engines, all in a remarkably lightweight package written in Delphi/Lazarus.

## What HeidiSQL Does
- Connects to MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, Interbase, and Firebird
- Browses and edits table data, schemas, views, routines, and events
- Exports databases to SQL dumps, CSV, HTML, XML, or LaTeX formats
- Executes queries with syntax highlighting, auto-completion, and query profiling
- Manages user accounts and privileges across supported engines

## Architecture Overview
HeidiSQL is built with Delphi (and ported partially to Lazarus/FreePascal for Linux support). It uses native database client libraries for each engine and communicates over TCP or named pipes. The UI is a single-window MDI layout with a server tree, query tabs, and result grids. SSH tunneling is handled via PuTTY's plink.

## Self-Hosting & Configuration
- Download the installer or portable ZIP from heidisql.com
- Supports SSH tunnel connections via bundled plink.exe
- Session manager stores multiple connection profiles with color coding
- Query and export settings are configurable per session
- Portable mode keeps all settings in the application directory

## Key Features
- Supports seven database engines from a single interface
- SSH tunnel support via integrated plink
- Batch table editor for bulk schema changes across tables
- Data and structure synchronization between two databases
- Completely free and open source under GPL

## Comparison with Similar Tools
- **DBeaver** — Java-based, cross-platform, supports more engines; HeidiSQL is faster and lighter on Windows
- **MySQL Workbench** — official Oracle tool with ER modeling; HeidiSQL is simpler and snappier
- **Sequel Ace** — macOS-only for MySQL; HeidiSQL covers more engines and runs on Windows/Linux
- **phpMyAdmin** — web-based for MySQL only; HeidiSQL is a desktop app with multi-engine support
- **DataGrip** — JetBrains commercial product; HeidiSQL is free

## FAQ
**Q: Does HeidiSQL run on macOS?**
A: Not natively. HeidiSQL targets Windows and Linux (via Lazarus build or Wine).

**Q: Can I connect via SSH?**
A: Yes. HeidiSQL bundles plink.exe for SSH tunneling to remote database servers.

**Q: Is it suitable for PostgreSQL work?**
A: Yes. HeidiSQL supports PostgreSQL including schemas, functions, and materialized views.

**Q: How lightweight is it?**
A: The portable edition is under 20 MB and launches in under a second on modern hardware.

## Sources
- https://github.com/HeidiSQL/HeidiSQL
- https://www.heidisql.com

---
Source: https://tokrepo.com/en/workflows/asset-6904e12b
Author: AI Open Source