DuckDB Web Shell compared with pgAdmin, DBeaver and Excel Power Query| DuckDB Web Shell | pgAdmin | DBeaver | Excel Power Query |
|---|
| Architecture and data locality: DuckDB-Wasm is the DuckDB engine compiled to WebAssembly. It runs in the browser with no server, and no data leaves the machine. It is single-threaded by default and WebAssembly caps memory at 4 GB, with lower limits possible in some browsers. | Architecture and data locality: pgAdmin 4 is an administration and development platform for PostgreSQL, with desktop use on Windows, macOS and Linux and a web interface for remote access. | Architecture and data locality: DBeaver is a multiplatform database tool that connects to any database with a JDBC driver, so the data stays in the connected systems. | Architecture and data locality: Power Query connects to external data, reshapes it and loads it into Excel. Source data stays unchanged because each step is recorded as an applied step. |
| Supported data and sources: Parquet is named explicitly, and CSV, JSON and Apache Arrow can be imported. Local files, remote HTTP(S) servers and in-memory buffers go through one virtual filesystem. | Supported data and sources: pgAdmin supports PostgreSQL. Its page does not say whether other databases are supported. | Supported data and sources: The page lists MySQL, PostgreSQL, Oracle, SQL Server, SQLite, Snowflake, BigQuery and ClickHouse, plus file-based sources such as CSV. The commercial edition supports more sources than Community. | Supported data and sources: Sources include web sources, files, databases, Azure and Excel tables, and Fabric OneLake items on Windows. |
| Openness and licence: The shell and DuckDB-Wasm are provided by the DuckDB project. Its documentation links to the GitHub repository for the licence. | Openness and licence: pgAdmin is open source and free. | Openness and licence: DBeaver Community is free and open source under the Apache License version 2. | Openness and licence: Power Query is part of Excel and not a separate open source tool. |
| Language and workflow: Work is done at a SQL prompt, with examples such as Parquet and CSV datasets and options to share and import. Session state is not kept after closing the tab. | Language and workflow: pgAdmin has a query tool with syntax highlighting and code completion, an ERD tool, backup and restore, and a monitoring dashboard. | Language and workflow: DBeaver Community has plugins for ERD diagrams, data transfer, comparison, and data export and import. | Language and workflow: Transformations are done with menus and recorded steps, and custom steps can be written in the M language in the Advanced Editor. |
| Platform: The shell needs only a browser, without installing software. | | | Platform: Power Query runs on Excel for Windows, Excel for Mac and Excel for the web. Excel 2016 and 2019 for Mac do not support it. |