OSI-licensed open source
SQL tools are the clients, editors, linters and engines developers use to write and run queries. Open-source options cover GUI database managers, command-line clients, SQL linting and embedded analytical engines, all without licence fees.
This page lists OSI-licensed tools verified on their repositories. pgAdmin and Adminer are omitted because their repository pages did not state a licence when we checked, so check them separately.
Tools, licences and pricing checked against vendor and repository pages on November 7, 2026.
| Tool | Best for | Pricing | Licence |
|---|---|---|---|
| DBeaver | Universal database GUI | Free, open source (Community); paid editions, See vendor pricing | Apache-2.0 |
| Beekeeper Studio | Clean desktop SQL editor | Free Community Edition (GPL); paid premium, See vendor pricing | GPL-3.0 |
| HeidiSQL | Windows-first MySQL and MariaDB administration | Free, open source | GPL-2.0-only |
| SQLFluff | SQL linting in CI and dbt projects | Free, open source | MIT |
| DuckDB | Local analytics and querying files with SQL | Free, open source | MIT |
| usql | Universal terminal client | Free, open source | MIT |
| pgcli | PostgreSQL terminal users | Free, open source | BSD-3-Clause |
Best for: Universal database GUI · Free, open source (Community); paid editions, See vendor pricing
DBeaver is a cross-platform database tool for developers, SQL users, DBAs and analysts. It supports over 100 databases out of the box and any database with a JDBC or ODBC driver.
Best for: Clean desktop SQL editor · Free Community Edition (GPL); paid premium, See vendor pricing
Beekeeper Studio is a desktop SQL editor and database manager for Linux, macOS and Windows supporting PostgreSQL, MySQL, SQLite and SQL Server, with a free Community Edition.
Best for: Windows-first MySQL and MariaDB administration · Free, open source
HeidiSQL is a graphical tool for browsing, editing and administering MariaDB, MySQL, PostgreSQL and SQLite. It is written in Delphi and can export structure and data.
Best for: SQL linting in CI and dbt projects · Free, open source
SQLFluff checks SQL for style and errors and can fix many issues automatically. It supports dozens of dialects and templating systems such as Jinja and dbt.
Best for: Local analytics and querying files with SQL · Free, open source
DuckDB is an in-process analytical database that runs inside an application without a server. It reads and writes CSV, Parquet and JSON and connects to other databases.
Best for: Universal terminal client · Free, open source
usql is a command-line client for many SQL and NoSQL databases, modelled on psql, with syntax highlighting, completion and data copying between databases.
Best for: PostgreSQL terminal users · Free, open source
pgcli is a command-line client for PostgreSQL with context-aware autocompletion and syntax highlighting, written in Python.
One email a week with the tools, launches and releases added to TechLogHub. Unsubscribe in one click.
One email a week: new and trending developer tools, fresh comparisons, and what shipped. Unsubscribe in one click.
| If you need… | Start with |
|---|---|
| One GUI for many databases | DBeaver |
| Simple modern SQL editor | Beekeeper Studio |
| MySQL or MariaDB admin on Windows | HeidiSQL |
| SQL linting in CI | SQLFluff |
| Query local files with SQL | DuckDB |
| Terminal clients | usql, pgcli |
Quick answers to common questions
Clients, editors, linters and engines used to write, run and manage SQL queries.
DBeaver Community covers the most databases; Beekeeper Studio and HeidiSQL are lighter alternatives.
pgAdmin is generally known to use the PostgreSQL licence, but its repository page did not state it, so we did not list it.
It is an embedded analytical engine, great for local analysis but not a multi-user server.
List it on TechLogHub and we'll review it for this guide.
