QuackDB

KO | EN

gitlite — search

#react #typescript #go #machine-learning #rust #deep-learning #linux #windows #awesome #cli #kubernetes #vue #security #open-source

(★ 206)

Open-source in-browser DuckDB SQL editor

File Explorer

Download Latest Version (.zip)

- settings.json
- - .env.example
  - .eslintignore
  - .eslintrc.cjs
  - .gitignore
  - .prettierignore
  - env.d.ts
  - package.json
  - postcss.config.mjs
  - prettier.config.js
  - README.md
  - tailwind.config.js
  - tsconfig.json
  - vite.config.ts
- - editor.tsx
- focus-manager.ts
- online-manager.ts
- opfs.ts
- README.MD
- service-worker.ts
- subscribable.ts
.commitlintrc
.editorconfig
.gitignore
.npmrc
biome.json
commitlint.config.cjs
LICENSE
package.json
pnpm-lock.yaml
pnpm-workspace.yaml
README.md
turbo.json

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# QuackDB - Online DuckDB SQL Playground

[![Release](https://github.com/mattf96s/QuackDB/actions/workflows/release.yml/badge.svg)](https://github.com/mattf96s/QuackDB/actions/workflows/release.yml)
![License](https://img.shields.io/github/license/mattf96s/QuackDB)

QuackDB is a privacy-preserving in-browser DuckDB SQL playground and editor.

Demo available at [quackdb.com](https://www.quackdb.com).

- **In-Browser**: The DuckDB Wasm library is used to run SQL queries in the browser.
- **File Types**: Supports `.csv`, `.json`, `.parquet`, `.sqlite`, `.duckdb` and `.arrow` files.
- **Privacy**: no screen recordings or client-side error monitoring (only Vercel Analytics).
- **Filesystem Access**: OPFS is used to store files in the browser's filesystem for persistence.

![QuackDB Screenshot](https://www.quackdb.com/screenshot.jpg)

## Motivation

I wanted a quick and simple tool for iterating on DuckDB queries and visualizing the results. I also wanted to experiment with the new Filesystem Access API (OPFS) and explore the capabilities of DuckDB in the browser.

## Tech Stack

| Category      | Tool                                                                                                                                |
| ------------- | ----------------------------------------------------------------------------------------------------------------------------------- |
| Database      | [DuckDB Wasm](https://duckdb.org/)                                                                                                  |
| Frontend      | [Remix](https://remix.run/) &middot; [Tailwind CSS](https://tailwindcss.com/docs/table-layout), [shadcn/ui](https://ui.shadcn.com/) |
| Backend       | [Vercel](https://vercel.com/docs/frameworks/remix)                                                                                  |
| Visualization | [Observable Plot](https://observablehq.com/plot/), [Tanstack Table](https://tanstack.com/table/latest)                              |
| Web APIs      | [Comlink](https://github.com/GoogleChromeLabs/comlink), [OPFS](https://web.dev/file-system-access/)                                 |

> An earlier version of this project used [SST](https://docs.sst.dev/start/remix) for the backend infrastructure, but I switched to Vercel for simplicity.

## TODO

- [ ] Safari support 😁
- [ ] Improved UI / charts / tables / etc.
- [ ] Data import/export
- [ ] Responsive design improvements
- [ ] Performance improvements with Arrow
- [ ] Snippets / examples

## Maybe

- [ ] [NSQL](https://motherduck.com/blog/duckdb-text2sql-llm/) integration for natural language queries.
- [ ] Co-pilot (or similar) integration for code suggestions.

## Inspiration

- [CMU Data Interaction Group](https://github.com/cmudig)
- [SQL Workbench](https://sql-workbench.com/)
- [Evidence](https://github.com/evidence-dev/evidence)
- [Malloy](https://github.com/malloydata/malloy)
- [wa-sqlite](https://github.com/rhashimoto/wa-sqlite/blob/master/demo/demo-worker.js)
- [Rill](https://github.com/rilldata/rill)
- [Observable](https://github.com/observablehq)

## License

MIT

## Disclaimer

This project is not in any way affiliated with DuckDB or any of the other projects mentioned above.

## Tips

- Built in chrome OPFS viewer can be accessed from <https://www.quackdb.com/temporary>. To navigate, manually change the URL to the desired path as Chrome does not allow navigation by clicking on the links.

## Known Issues

- Safari will not be fully supported until this [bug](https://bugs.webkit.org/show_bug.cgi?id=256712#c0) is fixed (serializing file handles is not supported in Safari).

QuackDB

File Explorer

Today's picks

Was this content helpful?

Recent Feedback

QuackDB

File Explorer

Today's picks

Was this content helpful?

Recent Feedback

Download README