How to Run SQL in Your Browser (Free SQLite Playground)

Step by step

1. Open the playgroundGo to the SQLite Playground. It loads the genuine SQLite engine (compiled to WebAssembly) in your browser and seeds a small demo table, so you have something to query the moment it is ready.
2. Load your own data (optional)Query the demo data, or drop in your own .sqlite / .db file, or import a CSV. An imported CSV becomes a real table named after the file, with columns taken from its header row.
3. Write and run SQLType standard SQL and press Run (or Ctrl/Cmd + Enter). A SELECT shows its rows as a table; an INSERT, UPDATE, DELETE, or CREATE reports how many rows changed. Click a table chip to drop in a ready-made SELECT for it.
4. Export or resetDownload any result set as CSV, or export the whole database back to a .sqlite file to keep working on it later. Use Clear to empty the editor, or Reset to demo database to start over from scratch.

It is the real SQLite, not an imitation

This is not a simplified toy that supports a handful of keywords — it is the actual SQLite engine, the same code that ships inside phones, browsers, and countless apps, compiled to WebAssembly so it can run in a tab. That means joins, subqueries, common table expressions, window functions, aggregate functions, indexes, views, and transactions all behave exactly as they do in a native SQLite database.

Because the behaviour is identical, it is a genuinely reliable place to learn SQL, prototype a query before you run it against production, or reproduce a bug — what works here works the same way when you copy it elsewhere.

Query a CSV or spreadsheet like a database

Exports from analytics tools, billing systems, and spreadsheets almost always arrive as CSV, and answering a real question about one in a spreadsheet often means wrestling with nested formulas. Import the CSV here instead and it becomes a table you can query with plain SQL: GROUP BY to summarise, WHERE to filter, ORDER BY to rank, and JOIN to combine it with a second import.

The header row becomes your column names (cleaned into valid identifiers), so a file called customers.csv turns into a customers table you can SELECT from straight away — no import wizard, no formulas.

A safe place for sensitive database files

Most online SQL sandboxes send whatever you paste to a server you do not control — fine for a textbook exercise, not for a real client export or a database dump with personal data in it. Here the engine and your data live entirely inside the browser tab. Nothing is uploaded, so you can open a production backup, a customer export, or a personal SQLite file and explore it without it ever leaving your machine.

What people actually use it for

Common jobs include inspecting an unfamiliar .sqlite file to see its tables and schema, checking or cleaning data before importing it somewhere else, testing a tricky query against sample rows, and converting between formats by importing a CSV and exporting the result. Because you can export the database back out again, it also doubles as a quick scratch database you build up over a single session.

Handy tips

Press Ctrl/Cmd + Enter to run without reaching for the mouse. To list every table in a file you have just opened, run SELECT name FROM sqlite_master WHERE type = "table" — or simply click a table chip to do it for you. If you alter the schema and want to begin again, Reset to demo database rebuilds the seeded example, while Clear wipes only the editor and keeps your data intact.