SQL Playground
Full SQLite in your browser · zero upload · .sqlite files never leave your machine
▸ Database
no database loaded
loading sqlite wasm...
Yes — nothing is uploaded. This page runs SQLite compiled to WebAssembly directly inside your browser tab. When you drop a .sqlite file, it's read by JavaScript via the File API and handed to the in-memory SQLite instance. No network request carries your data anywhere.
The only external request is the initial one-time download of the sql.js WASM binary from a public CDN (cdnjs). After that, queries run entirely offline.
Full SQLite SQL — which means standard SQL plus SQLite-specific extensions: window functions, CTEs, JSON functions, FTS5, RTREE, and all the usual aggregates. Syntax like PRAGMA, ATTACH DATABASE, and WITH RECURSIVE works. What doesn't work: PostgreSQL-only or MySQL-only extensions (JSONB, ILIKE, MySQL's LIMIT x, y — use LIMIT y OFFSET x instead).
Practical limit is your browser's memory — SQLite loads the whole database into RAM. Databases up to a few hundred MB are fine on a modern laptop. Multi-gigabyte files will struggle or fail. For those, use a desktop client like DB Browser for SQLite.
Yes. INSERT, UPDATE, DELETE, CREATE TABLE, DROP, etc. all work on the in-memory database. When you're done, click ⬇ db in the run bar to download the modified .sqlite file. The original file on your disk is never touched.
⌘ / Ctrl + Enter — run the current query.
⌘ / Ctrl + Shift + Enter — run only the selected text.
Tab in the editor inserts two spaces instead of moving focus.
Chinook — a media-store schema (artists, albums, tracks, invoices) used in almost every SQL tutorial. Good for joins and aggregates.
Northwind — the classic Microsoft demo database (customers, orders, products, employees).
Employees — a tiny HR-style database good for quickly testing syntax.
Samples load fully in-memory and can be modified freely. Your edits don't persist unless you export the .sqlite.
Yes, completely free. No account, no subscription, no ads. It is one of the free browser-based tools at jasperbernaers.com.