---
title: "Discussion on \"Using DuckDB-WASM for in-browser Data Engineering\" | Hashnode"
description: "Discussion on \"Using DuckDB-WASM for in-browser Data Engineering\". Rapid prototyping SQL Queries & Data Visualizations"
url: "https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Using DuckDB-WASM for in-browser Data Engineering](https://tobilg.com/using-duckdb-wasm-for-in-browser-data-engineering?utm_source=hashnode&utm_medium=feed)

Rapid prototyping SQL Queries & Data Visualizations

Jan 27, 2024 · 18 min read · tobilg.com  
Updated Oct 15, 2024  
Read the article

-   [#data-engineering](https://hashnode.com/tag/data-engineering)
-   [#wasm](https://hashnode.com/tag/wasm)
-   [#sql](https://hashnode.com/tag/sql)
-   [#duckdb](https://hashnode.com/tag/duckdb)
-   [#data-analytics](https://hashnode.com/tag/data-analytics)

## Written by

[Tobias Müller](https://hashnode.com/@TobiLG)

@TobiLG · Hamburg, Germany

  
[View profile](https://hashnode.com/@TobiLG)

## Responses 6

Markdown supported · ⌘↵ to post

[Michael Booth](https://hashnode.com/@mjboothaus)

[Jun 23, 2024](https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456/comment/66789782a454cf7b7c2e021d)

Really nice work!! Apologies if this is described elsewhere - can you connect to a local (or e.g. S3 hosted) version of a DuckDB database (i.e. .duckdb) file? Or only CSV, Parquet, JSON etc?

[Tobias Müller](https://hashnode.com/@TobiLG)

[Jul 11, 2024](https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456/comment/66789782a454cf7b7c2e021d#reply-668fd56d24085a461e972f33)

Yes, you can attach to a remote database, see [tobilg.com/using-duckdb-wasm-for-in-browser-data-…](https://tobilg.com/using-duckdb-wasm-for-in-browser-data-engineering#heading-attaching-remote-databases)

[Fabio Chen](https://hashnode.com/@fabiochen)

[May 4, 2024](https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456/comment/66362372f3e385bb111fc307)

Hello, the SQL workbench is awesome. May I know which technique is required to build the UI and BE? And how to get started for a new programmer? Thanks.

[Tobias Müller](https://hashnode.com/@TobiLG)

[May 31, 2024](https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456/comment/66362372f3e385bb111fc307#reply-6659915aba881612fe1636c9)

Thanks! It's a React application just running in the frontend.

[David Laplante](https://hashnode.com/@dlaplante)

[May 2, 2024](https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456/comment/6633b1b0b852ac11ddede9b7)

Very very nice tool you built there. Congrats!

Is there any possibility to ".open" a local duckdb file instead of working in ":memory:" ?

[Celso G](https://hashnode.com/@hades646)

[Mar 7, 2024](https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456/comment/65e9abf95f6ea38ebb7c8ac0)

Very nice tool. I am missing, however, a mention of whether the data is processed exclusively in the local browser or if some data is shared with the server. If so, which data is shared with the server and how it is used. A privacy statement/data protection policy, basically.

I would also love to be able to run this locally in my machine using a light http server, if possible.

[Tobias Müller](https://hashnode.com/@TobiLG)

[Mar 12, 2024](https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456/comment/65e9abf95f6ea38ebb7c8ac0#reply-65f0ac7c4e5af37779a68be2)

The SQL Workbench is based on DuckDB WASM, as stated in the article, and works entirely in your browser. No data is sent to other servers etc.

Regarding running it locally, it's currently not Open Source, so there's no way to do this right now.

[Fred Guth](https://hashnode.com/@fredguth)

[Jul 26, 2024](https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456/comment/65e9abf95f6ea38ebb7c8ac0#reply-66a37d1ac59e8698635ae43d)

[Tobias Müller](https://hashnode.com/@TobiLG) :-(

[Markus Allen](https://hashnode.com/@Founderstowne)

[Feb 28, 2024](https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456/comment/65dfa70c4e626cbb743c6df4)

This article and Workbench are mind-blowing. Super impressed.

[Tobias Müller](https://hashnode.com/@TobiLG)

[Feb 29, 2024](https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456/comment/65dfa70c4e626cbb743c6df4#reply-65e0a19ea8c712723e5d598a)

Thank you for the nice feedback!

[Thuc Nguyen Canh](https://hashnode.com/@thucnc)

[Feb 16, 2024](https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456/comment/65cf238bad1dc6e70a17c7d1)

May you open source your duckdb playground, it's so fascinating that I'm curious to build my own customized version :)

[Harry Stafford](https://hashnode.com/@HaNoSt)

[Feb 15, 2024](https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456/comment/65cdd4113e3b248a4f5ca8b8)

Hi Tobias, I am an SQL beginner and wanted to use this to examine CSVs I work with - looks to be a great interface and works fine with the example files. But using CSVs on my laptop give errors for various CSVs including a copy of the aws\_services.csv

ERROR Parser Error: syntax error at or near \\2024. LINE 1: SELECT \* FROM 2024-02-06 feed full.csv LIMIT 10. ^

or ERROR IO Error: No files found that match the pattern \\aws\_services.csv)

It seems to recognise the file ok as it generates columns correctly on the Tables view - but trying to query the table gives various errors

Am I doing something wrong? Using:Chrome, Windows10

[Harry Stafford](https://hashnode.com/@HaNoSt)

[Feb 15, 2024](https://hashnode.com/posts/using-duckdb-wasm-for-in-browser-data-engineering/65b97c6965712f3801df1456/comment/65cdd4113e3b248a4f5ca8b8#reply-65cddcff76fafb907b906410)

Ah - it seems that just the apostrophes around the filenames were missing, so adding '' around filename.csv - 'filename.csv' - makes it all work fine. Is this a bug with uploaded files?
