Quack Drawer v2

Import Data

Imported tables live in memory for this session.

or drag & drop into the zone below

Drag & drop files here (CSV, JSON, NDJSON, Parquet)

Paste Data

URL Import

Import Queue

No tables loaded yet.

Profile

SQL Editor

Charts

Type

X Column

Y Column

Group/Color

Aggregation

Row Limit

Chart Title

Map

Source

Map Type

Latitude

Longitude

Report Builder

AI Analyst

AI is disabled. Enable it in Settings and configure your API key.

Saved Queries

Query History

Export

Import Saved Queries JSON

Appearance

Theme

Compact Mode

Large Text

Reduced Motion

Max Displayed Rows

Data

Max Query History

Auto-Profile After Import

Auto-Preview After Import

Confirm Before Drop

Enable Query History

AI

Enable AI

Provider

API Key

Model

Max Sample Rows

Max Result Rows

System Prompt

Reset

Debug

About Quack Drawer v2

Quack Drawer is a browser-local DuckDB-WASM data workbench. It lives entirely in your browser — no backend, no build step, no external tracking. All data stays on your machine.

What it does

Import CSV, JSON, NDJSON, and Parquet files
Inspect table schemas and row counts
Profile columns (nulls, distinct, min/max/avg, top values)
Run SQL with autocomplete and saved queries
Visualize with Bar, Line, Scatter, Pie, Area, and Heatmap charts
Map coordinates as markers or choropleth maps
Build Markdown reports
Optional AI analyst (OpenRouter) with query generation
Export results as CSV, JSON, or Markdown

Privacy & Storage

All data is stored locally in your browser (IndexedDB / OPFS)
Nothing is sent to any server unless you enable the AI analyst
Settings and saved queries persist in localStorage
Works offline after first load

GeoJSON & Boundary Data Sources

Quack Drawer can render choropleth maps using built-in boundaries or your own GeoJSON files. Here are recommended sources:

Source	Best for	License	Notes
Natural Earth (naturalearthdata.com)	Global base maps	Public Domain	The gold standard. Available at 1:110m (small), 1:50m (medium), 1:10m (detailed)
world-atlas (jsDelivr/npm)	World countries	ISC	Pre-built TopoJSON from Natural Earth. Only ~108KB at 110m resolution
us-atlas (jsDelivr/npm)	US states / counties	ISC	Pre-built TopoJSON from US Census. States ~115KB, counties ~842KB
geojson.xyz	Quick CDN testing	Public Domain	Natural Earth served via CloudFront with CORS headers
geojson-maps.kyd.au	Custom subsets	Public Domain	Interactive tool: pick countries + resolution, download a custom GeoJSON
geoBoundaries (geoboundaries.org)	Any country's admin divisions	CC-BY 4.0	ADM0 (country) through ADM5 (sub-municipal). Peer-reviewed boundaries
QuickMapTools (quickmaptools.com)	Easy downloads	varies	Great UI for downloading Natural Earth or geoBoundaries in multiple formats
US Census Bureau (census.gov)	US states / counties / ZIPs	US Gov (free)	Authoritative US boundaries. Download via TIGER/Line or cartographic boundary files
eric.clst.org	US GeoJSON quickstart	US Gov (free)	Pre-converted Census files at 20m (tiny), 5m, and 500k resolutions

Quick recommendation: Need a small world map? Use world-atlas countries-110m.json. Need US states? Use us-atlas states-10m.json. Need a specific country or province? Use geoBoundaries or geojson-maps.kyd.au.