SQL playground

0 uploads — runs entirely in your browser, works offline

SQL playground — run SQL on CSV or JSON

Run SQL queries against pasted CSV or JSON, entirely in your browser (0 uploads, works offline).

How to use it

  1. Paste CSV or a JSON array as your data.
  2. Write a SQL query using data as the table.
  3. See the results.

FAQ

How do I run SQL on a CSV for free?

Paste your CSV or JSON and write a query like SELECT city, COUNT(*) FROM data GROUP BY city; this page runs it in the browser and shows the result — on your device with no upload.

Is my data uploaded anywhere?

No. Queries run entirely in your browser and nothing is transmitted or stored, which you can verify by turning off your Wi-Fi.

Which SQL features work?

SELECT with WHERE, GROUP BY, ORDER BY, aggregates and joins, via the AlaSQL engine that runs on in-memory data.

How do I reference the table?

Use data (or ?) as the table name; it is bound to the rows you paste.

Limits

Queries the single dataset you paste; persistent databases and multi-table joins across files are not included.

Related

The JSONPath playground queries JSON; the CSV joiner merges two CSVs.

Bookmark this page (Ctrl+D, or ⌘D on Mac) or install the app — it works offline the next time you need it.