Query, join, and analyze your CSV files with SQL

Load CSV, JSON, and Parquet into a local DuckDB engine running in your browser. Visualise results, inspect column stats, and export what you need — without uploading data.

Open EditorView DocsFree & open source
No account requiredLocal-only processingWorks offline after first load

Powered by DuckDB-WASM, Monaco, and Apache Arrow.

SQL for Files
Query 1
Query 2
-- Find top customers by revenue
SELECT
customer_name,
SUM(amount) AS total
FROM orders.csv
GROUP BY customer_name
ORDER BY total DESC
LIMIT 5;
Results
5 rows12ms
DataVisualisationClassification
customer_nametotal
Acme Corp48,250
Globex Inc35,100
Initech29,800

100% Private

Everything runs in your browser. Your files stay on your device, and query data is never uploaded to a server.

Full SQL Engine

Powered by DuckDB. Use joins, aggregations, window functions, and CTEs across CSV, JSON, and Parquet files.

Advanced File Import

Preview files before creating tables, tune CSV parsing options, and load multiple formats side by side.

Visualisation

Turn query results into bar, line, and pie charts, then export them as SVG or PNG.

Column Classification

Inspect numeric, date, string, and boolean statistics on full result sets without leaving the browser.

Backup & Restore

Export your full in-browser database as a Parquet ZIP backup, then import it later in one step.

How it works

1

Drop your files

Add CSV, JSON, or Parquet files and preview CSV import settings when you need more control.

2

Write or paste SQL

Use Monaco autocomplete, query history, and multiple tabs to iterate quickly. Or paste AI-generated queries.

3

Inspect and export

Review tables, build charts, check column stats, and export full results or database backups locally.

Built-in learning track

Learn SQL while exploring your own files

Launch the Learn SQL panel for guided lessons, sample data, and hands-on challenges — all inside the real editor.

Guided lessons

Step-by-step SQL lessons from basics to advanced queries

One-click sample data

Load practice datasets instantly so you can start querying right away

Practice in the real editor

Write and run queries with full autocomplete and results

Start Learning

Once inside the editor, click Learn SQL in the top navigation.

Use AI to draft SQL — keep the data local

Generate queries with ChatGPT, Gemini, or Claude, then run them here against sensitive files locally. You get faster query drafting without sending the underlying data to an AI provider.

Ready to explore your data locally?

Open the editor to start, or read the docs for import tips, SQL examples, and troubleshooting.

Open EditorView Docs