SQL Query (DuckDB WASM)
Query CSV or Parquet locally. Each file becomes a table named after the file.
Query local files with SQL — powered by DuckDB
Run SQL queries directly against your local Parquet, CSV, or Excel files using DuckDB. No database server required. Supports standard SQL including joins, aggregations, and window functions — all processed client-side.
Frequently Asked Questions
- What SQL dialect does this tool use?
- Queries execute on DuckDB, but you can write SQL in popular dialects — Snowflake, BigQuery, PostgreSQL, MySQL, Oracle, SQL Server (T-SQL), Redshift, ClickHouse, Databricks, Spark, Trino, and SQLite. Pick your dialect and the query is automatically transpiled to DuckDB before execution.
- What is DuckDB?
- DuckDB is an in-process analytical database optimised for fast query execution on columnar data. It is similar to SQLite but built for analytics workloads — ideal for querying Parquet, CSV, and Excel files locally.
- Do I need to install anything?
- No. The tool runs in your browser. Just upload your file and start writing SQL.
- Are there result size limits?
- Query results are capped at 1,000 rows in the preview pane. The full result set is available for export.