Queryfiles - A SQL based CSV, XLSX, JSON and Parquet query tool
Queryfiles is a SQL based CSV, XLSX, JSON and Parquet query tool built with DuckDB.
Technical stack
- Tanstack Start
- React
- DuckDB Wasm
Why did I build this?
I often need to manipulate data in CSV or JSON files. As a developer, I'm used to using SQL for data manipulation, so I wanted a tool that would allow me to query these files using SQL.
That's exactly what DuckDB offers: a light and fast SQL engine that can query CSV, XLSX, JSON and Parquet files directly without needing to import them into a database. It's perfect for this use case.
However, using DuckDB directly can be a bit cumbersome, especially for non-technical users. Also, it has no graphical interface.
I wanted to create a simple and user-friendly interface that would allow anyone to easily query their files without needing to set up a database or write complex scripts.