SQLParity

SQL Scratchpad

Query a CSV, Parquet or JSON file with real SQL. The engine runs inside this tab, so the file is never uploaded.

Engine not started
1

Your data

Files are read straight off your disk by the engine in this tab. They are not copied anywhere, and closing the page discards everything.

2

Your query

Ctrl / ⌘ + Enter to run
3

Result

Run a query and the rows appear here.

What this is, and what it is not

This is an engine in your browser, not your warehouse. Its SQL is close to PostgreSQL, so Athena, T-SQL and Oracle specifics will not run here — use it to check that logic is right against sample rows, then take the query to the engine it belongs to.

Nothing is uploaded, and that is checkable rather than promised. The engine itself is served from this same origin, so even loading it makes no request to anyone else. Watch the network tab while you drop a file: it stays silent.

How to Use SQL Scratchpad

How to inspect, query, and analyze CSV and Parquet files in your browser tab.

1

Drop in a Data File

Drag and drop any CSV, TSV, Parquet, or JSON Lines file from your computer into the SQL Scratchpad drop zone.

2

Run Real SQL Queries

Your file is registered as a table automatically. Write queries with aggregations, CTEs, window functions, and joins.

3

Inspect & Export Results

Browse query results in the table viewer, sort columns, and export data subsets back to CSV or TSV with one click.

Frequently Asked Questions

Common questions about privacy, supported dialects, and how SQL Scratchpad works under the hood.

How does a SQL engine run inside a web browser tab?

The engine is compiled into WebAssembly (WASM). It executes directly within your browser’s virtual machine, reading file bytes from your local disk into memory without requiring any server infrastructure.

Is my data file uploaded to any remote server or cloud bucket?

No. The browser File System API loads the file into local memory only. The page’s Content Security Policy strictly blocks network requests, ensuring total privacy for sensitive datasets.

What is the file size limit for Parquet and CSV files?

The limit depends on your computer’s available RAM. Files up to several hundred megabytes (and hundreds of thousands of rows) query smoothly in seconds.

Can I drop multiple files and join them with SQL?

Yes. Each file you drop becomes a distinct table named after the filename (e.g., dropping orders.csv and customers.parquet lets you run SELECT * FROM orders JOIN customers ON ...).