SHORTLIST20
English
Englishالعربية中文日本語한국어EspañolFrançaisहिन्दी
Programming

Top 20 DuckDB GUIs and SQL clients

Where people open a DuckDB file or query Parquet by hand

Updated · GitHub stars (stars)

Why these 20

Ranked by GitHub stars: how many developers bookmarked the project. Stars measure attention, not quality, so each row also shows forks, licence, the last push and the section of the community list it sits in. Closed-source tools in the same list (DataGrip, Dataflare, qStudio, SQL Data Lens and others) have no public star count, so they can't be ranked here.

  1. 1

    DBeaver

    Free universal database manager and SQL client.

    52,150 stars 4,427 forkslast push 2026-10-20JavaApache-2.0

    Also in: #1 database GUIs and IDEs for any database#1 MySQL GUI clients#7 open-source databases#1 PostgreSQL GUI clients and admin tools

  2. 2

    Beekeeper Studio

    Open Source SQL Editor and Database Manager with a privacy commitment in their mission statement.

    23,776 stars 1,652 forkslast push 2026-10-20TypeScriptNOASSERTION

    Also in: #3 database GUIs and IDEs for any database#4 PostgreSQL GUI clients and admin tools

  3. 3

    marimo

    Unified data & AI platform that lets you work with SQL and Python with native support for DuckDB.

    23,260 stars 1,348 forkslast push 2026-10-20PythonApache-2.0

  4. 4

    Harlequin

    The DuckDB IDE (TUI) for your terminal.

    6,477 stars 184 forkslast push 2026-10-19PythonMIT

  5. 5

    rainfrog

    A database TUI with experimental support for DuckDB.

    5,378 stars 98 forkslast push 2026-10-13RustMIT

  6. 6

    Preswald

    WASM packager for Python-based interactive data apps.

    4,270 stars 647 forkslast push 2026-06-11PythonApache-2.0

  7. 7

    Tad

    A fast, free, cross-platform tabular data viewer application powered by DuckDB.

    3,494 stars 135 forkslast push 2025-03-05TypeScriptMIT

  8. 8

    Online DuckDB Shell

    Online DuckDB shell powered by DuckDB-Wasm.

    2,144 stars 233 forkslast push 2026-10-19C++MIT

  9. 9

    Codapi

    Embed executable code snippets directly into your product documentation, online course or blog post.

    2,139 stars 101 forkslast push 2026-08-22GoApache-2.0

  10. 10

    LibreDB Studio

    Browser-based SQL IDE for MySQL and nine other engines, deployed as a container or Helm chart next to the database.

    1,244 stars 265 forkslast push 2026-10-20TypeScriptMIT

    Also in: #12 MySQL GUI clients

  11. 11

    Duck-UI

    Duck-UI is a web-based interface for interacting with DuckDB with a SQL editor, data import/export, data explorer, query history, theme toggle and keyboard...

    641 stars 42 forkslast push 2026-10-03TypeScriptMIT

  12. 12

    l1xnan/duckling

    (576 TypeScript) - Duckling is a lightweight desktop application built with Tauri for fast browsing of CSV/Parquet files and various databases including Clickhouse.

    582 stars 32 forkslast push 2026-10-20TypeScriptMIT

    Also in: #14 ClickHouse GUIs and clients

  13. 13

    SQLRooms

    React app framework for small to mid-sized data analytics powered by DuckDB-WASM.

    515 stars 45 forkslast push 2026-10-19TypeScriptMIT

  14. 14

    rsql

    CLI for DuckDB, LibSQL, MariaDB, MySQL, PostgreSQL, SQLite3 and SQL Server.

    459 stars 16 forkslast push 2026-09-29RustApache-2.0

  15. 15

    PondPilot

    Open-source, 100% client-side data exploration tool that enables users to analyze local and remote data using SQL. Zero-copy direct access to local datasets...

    256 stars 18 forkslast push 2026-10-01TypeScriptAGPL-3.0

  16. 16

    QuackDB

    Open-source in-browser DuckDB SQL playground and editor.

    204 stars 12 forkslast push 2026-07-01TypeScriptMIT

  17. 17

    magic_duckdb

    DuckDB native %dql and %%dql magics for Jupyter/IPython.

    58 stars 2 forkslast push 2026-04-10PythonBSD-3-Clause

  18. 18

    DuckQuery

    Open-source visual SQL workbench to query local files (CSV/Excel/Parquet/JSON) and remote databases (MySQL/PostgreSQL) in one cross-source JOIN, plus AI...

    47 stars 3 forkslast push 2026-10-20TypeScriptMIT

  19. 19

    tuitab

    A Rust TUI for fast, in-depth analytics on large datasets (CSV, JSON, Parquet, Excel, SQLite) powered by DuckDB.

    30 stars 4 forkslast push 2026-10-07RustNOASSERTION

  20. 20

    VSCode SQLTools

    Free open-source VSCode extension to query and explore your DuckDB databases with latest DuckDB support.

    29 stars 11 forkslast push 2025-09-27TypeScriptMIT

How it is measured

Every tool in the DuckDB Clients and UIs, SQL Clients and IDE that Support DuckDB section(s) of the community list davidgasquez/awesome-duckdb on GitHub that has a public repository (linked directly, or its project's own repository when the list links the homepage), ranked by GitHub stars from the GitHub API; archived repositories are left out. Refreshed every 6 hours.

References

  1. davidgasquez/awesome-duckdb: DuckDB Clients and UIs, SQL Clients and IDE that Support DuckDB, GitHub community list (list text CC0/MIT per repository; star counts from the GitHub API). Checked 2026-10-20 22:30 UTC.
  2. davidgasquez/awesome-duckdb (DuckDB Clients and UIs, SQL Clients and IDE that Support DuckDB), GitHub community list, 26 tools with a public repository.

Also in

Top 20 open-source tools built on DuckDBTop 20 PostgreSQL GUI clients and admin toolsTop 20 database GUIs and IDEs for any databaseTop 20 MySQL GUI clientsTop 20 open-source databasesTop 20 ClickHouse GUIs and clientsTop 20 AI agent frameworks on GitHubTop 20 self-hosted appsTop 20 static site generatorsTop 20 open source projects in the Rust programming language