Product Design, Manufacturing & Innovation Resources
Home » Online Tools » DuckDB Web Shell Online

DuckDB Web Shell Online

The DuckDB Web Shell runs the DuckDB analytical database inside the browser through WebAssembly. It offers a SQL prompt with no server component, so tables can be created, joined and aggregated entirely on the local machine.

Local CSV, JSON and Parquet files can be registered in the shell and queried directly with standard SQL, including window functions, common table expressions and aggregates over millions of rows. Remote files can be read by URL as long as the host allows cross-origin access.

The shell fits quick exploration of large log, sensor and measurement files that are too heavy for a spreadsheet, and it is a convenient place to test DuckDB SQL before using it in Python, R or the command line. Memory is bounded by the browser tab and the session state is lost when the tab is closed.

Disciplines: Data engineering, Data science, Analytics, Software engineering, Finance.
Free alternative to pgAdmin, DBeaver, Excel Power Query.
DuckDB Web Shell compared with pgAdmin, DBeaver and Excel Power Query
DuckDB Web ShellpgAdminDBeaverExcel 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.

Privacy: we have no feedback of potential problem with this tool and author. But like many online services, you are here providing them with your own data. Depending of the criticity of your data, this is your responsibility to assess author's reputation and potential misusage, and to check and accept their terms and conditions, or not.

More Coding, Data Analysis & Visualization tools

Suggest your best online tool:

Do you know a better, a complementary or a replacement website to the one listed above ?

> Suggest it here <

10th year anniversary

Full size images and downloads are only available, 100% free, for registered members.

> Login <