Built vastgrid (MIT) – Open 100M-row Parquet, CSV & DuckDB tables like a 60fps spreadsheet (VS Code, CLI, MCP, Jupyter, React)
Hi r/duckdb! I built vastgrid, an MIT-licensed HTML5 canvas data grid backed by DuckDB (vastgrid-duckdb on Node.js) and a matching Web Worker engine (vastgrid-js) that both pass the same 300-plan conformance suite.
Try 1,000,000 rows in browser (zero uploads): https://vastgrid.yhay81.com/open/?sample=1
200k-row demo (pivots, exact decimal formulas, conditional rules): https://vastgrid.yhay81.com/demo/
GitHub (MIT): https://github.com/yhay81/vastgrid
What it does with DuckDB:
npx vastgrid-cli sales.parquet(or the VS Code/Cursor extensionyhay81.vastgrid-vscode) queries Parquet, CSV, TSV, JSONL, Excel, and.duckdbdatabases in place — sorting a 100M-row (1.38 GB) Parquet file to first visible rows in 953 ms on an M2 Pro.Full-table multi-key grouping, cross-tab pivots, live column totals, exact decimal formulas (
ROUND(0.285, 2) = 0.29), and 60 fps canvas scrolling with an ARIA keyboard grid.Surgical CSV/TSV saves: editing a cell rewrites only the changed field's byte span, preserving untouched quotes (
"0019"), formatting, and CRLF/LF sogit diffstays clean.Also runs inside Claude Desktop / ChatGPT as an interactive MCP App (
npx -y vastgrid-mcp ./data) and in Jupyter (pip install vastgrid).
Would love feedback from DuckDB folks on tough Parquet/DuckDB schemas or features you'd want next!
