{"repo":"mattf96s/QuackDB","free":true,"listed":false,"github":"https://github.com/mattf96s/QuackDB","clone":"git clone https://github.com/mattf96s/QuackDB.git","description":"Open-source in-browser DuckDB SQL editor","language":"TypeScript","stars":206,"topics":["comlink","duckdb","duckdb-wasm","parquet","sql","apache-arrow","shadcn","remix","remix-run","sst"],"license":"MIT","category":"databases-storage","readme_excerpt":"QuackDB - Online DuckDB SQL Playground QuackDB is a privacy-preserving in-browser DuckDB SQL playground and editor. Demo available at 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. 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 Frontend Remix · Tailwind CSS, shadcn/ui Backend Vercel Visualization Observable Plot, Tanstack Table Web APIs Comlink, OPFS An earlier version of this project used SST 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 integration for natural language queries. - [ ] Co-pilot (or similar) integration for code suggestions. Inspir","default_branch":null,"files":null,"tree":[],"storefront":"/r/mattf96s","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/mattf96s/QuackDB/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}