HeidiSQL
A long-running Windows client for MariaDB, MySQL, SQL Server, PostgreSQL, SQLite and Firebird, small and quick.
These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
3 more ways to get HeidiSQL
Other download sites
Run by third parties, not by Ansgar Becker. Prefer the official page above when it works.
Package managers
- winget
winget install --id HeidiSQL.HeidiSQL - Chocolatey
choco install heidisql
About HeidiSQL
HeidiSQL has been the default free Windows database client for years. It browses and edits data, creates and edits tables, views, procedures, triggers and scheduled events, and exports structure and data to a SQL file, the clipboard or straight to another server, which is the feature people remember it for.
It is written in Delphi, so it is a small native Windows application that starts immediately, with none of the weight of an Electron or Java client. Linux builds exist through a Lazarus branch with Qt6 DEB and RPM packages, but Windows is the first-class platform.
Strengths
- Exports structure and data directly to another server, not just to a file
- Native Delphi application; it starts instantly and stays small
- Handles MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird
- Portable ZIP available alongside the installer
Limitations
- Windows-first; the Linux builds come from a separate Lazarus branch
- No macOS build
- Building it requires a commercial Delphi licence, which limits contributors
- The interface is functional rather than modern
Details
- Pricing
- FreeFree and open source under the GPL. Donations are welcomed but nothing is withheld.
- License
- GPL-2.0
- Developer
- Ansgar Becker
- Platforms
- Windows, Linux
- How it runs
- Downloadable app
- Account
- Not required
- Works offline
- Yes
- Best suited for
- Day-to-day MySQL and MariaDB work on Windows
- Categories
- Database tools
- Last verified
- Added
- Provenance
- Selected from the TechWalrus downloads catalog (Dev Tools); facts checked against the developer's own pages, 2 sources on file.
Alternatives to HeidiSQL
Compare allSoftware that can replace HeidiSQL for an important use case, and what changes if you switch.
DBeaver Community
One database client for more than a hundred databases, with a proper SQL editor and ER diagrams.
DBeaver Community runs on macOS as well and supports over a hundred drivers with ER diagrams, but it is Eclipse-based, heavier and slower to start.
Beekeeper Studio
A SQL client that is pleasant to look at and works the same on Windows, macOS and Linux.
Beekeeper Studio offers the same features on Windows, macOS and Linux with a modern interface, but it is Electron-based and uses more memory.
TablePlus
Native database client for many engines with a clean interface.
TablePlus is a native client that also runs on macOS and iOS, but it is closed source and its free tier limits tabs and connections.
DbGate
One database client for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite, Redis and a dozen more, on desktop or as a web app.
DbGate adds macOS, NoSQL engines and a self-hosted web mode, with schema compare and a visual query designer, but it is heavier as an Electron app.
DataGrip
Multi-database IDE with an intelligent SQL console and schema navigation.
DataGrip provides schema-aware SQL completion and data comparison across platforms including macOS, but it is a closed-source paid subscription with no free tier.
phpMyAdmin
Web-based administration for MySQL and MariaDB.
phpMyAdmin handles MySQL and MariaDB administration through a web browser on a server, instead of a desktop app, and must be protected if publicly reachable.
HeidiSQL as an alternative
Listings that name HeidiSQL as an alternative.
DB Browser for SQLite
Opens a SQLite file in a spreadsheet-like window so you can look at the data without writing SQL.
HeidiSQL is a small native client that handles SQLite plus MySQL, PostgreSQL and others, but has no macOS build.
Similar software
Related functionality, not necessarily a direct replacement.
Adminer
Database management in a single PHP file.
pgAdmin
The standard open-source administration tool for PostgreSQL.
usql
Use one command-line interface for many database systems.
Mariabackup
MariaDB's bundled hot physical backup tool.
