What this tool does
The SQL playground runs SQLite, the world's most used database engine, inside your browser. Open a database file to browse and query it, or turn spreadsheets and JSON exports into tables you can filter, group, sort and join with plain SQL.
CSV and JSON as tables
Each CSV, TSV or JSON file becomes a table named after the file. Column names are cleaned up, and numbers are detected so sums, averages and sorting work as expected. Nested JSON objects become columns like user_name, and arrays are kept as JSON text.
Examples
Find your best customers with SELECT customer, SUM(total) FROM orders GROUP BY customer ORDER BY 2 DESC, or combine two exports with a JOIN. Create tables, insert and update rows, then download the whole database as a .sqlite file.
Privacy
Your files are opened in your browser's memory and never uploaded. Close the tab and everything is gone, unless you download the database.
Questions
How big can the files be?
Files of tens of megabytes work well on most computers. Everything is held in memory, so very large databases need a desktop browser with plenty of RAM.
Which SQL does it support?
Full SQLite: joins, subqueries, window functions, common table expressions, JSON functions and more.