Free Online SQL Editor — run real SQLite in your browser, with persistence

SQL Editor
Copy
Query Results
Click "Run Code" to execute your sql code...
Try an example:

Pick an example, then press Ctrl/⌘ + Enter or click Run Code. Your database is saved in your browser (OPFS) — create a table, reload the page, and your data is still there.

A free online SQL editor that runs real SQLite — the official engine compiled to WebAssembly — entirely in your browser. Create tables, insert data and run full SQL — JOINs, CTEs, window functions and aggregates — with results shown as tables. Your database is saved locally via the browser's Origin Private File System (OPFS) and persists across reloads. No installation, no sign-up, and nothing you type or store ever leaves your browser.

What you can do

Real SQLite, in your browser

Runs the official SQLite engine compiled to WebAssembly — not a reimplementation. Standard SQL behaves exactly as it does locally.

Persists across reloads

Your database is saved in the browser (OPFS). Create tables and insert rows, reload, and your data is still there — one DB per browser, on your device only.

Full SQL

JOINs, GROUP BY aggregates, CTEs (WITH / recursive), window functions, UPSERT, RETURNING, JSON functions and FTS5 full-text search.

Results as tables

Query results render as clean tables; multiple SELECT statements in one run appear as separate result tables.

100% private

Your SQL and data never leave your browser — no upload, no account, no server-side execution. Needs no special headers.

Instant & offline

The engine (~0.5 MB) loads once, then it's cached for instant reloads and full offline use.

Use cases

Learn & practice SQL

A zero-install playground to learn SELECT, JOIN, GROUP BY and window functions hands-on.

Prototype queries

Sketch a schema, insert sample rows, and iterate on a query before taking it to production.

Interview prep

Practice SQL questions and verify your answers against a real engine — no setup.

Design a schema

Try table definitions, constraints and indexes; your work persists so you can come back to it.

Explore data

Paste in INSERTs (or build a table) and slice it with aggregates and joins.

Teaching & demos

Share a query in a tutorial that anyone can run instantly in their browser.

Frequently asked questions

Does this run real SQL in the browser?

Yes. It runs SQLite — the official SQLite engine compiled to WebAssembly — entirely in your browser. CREATE, INSERT, UPDATE, DELETE, JOINs, CTEs, window functions, aggregates and JSON functions all behave exactly as they would in a local SQLite database. No server is involved.

Does my database persist after I reload the page?

Yes. Your database is saved in your browser via the Origin Private File System (OPFS). Create tables and insert rows, reload the page, and your schema and data are still there. It is one shared database per browser, stored only on your device.

Is my SQL and data private?

Completely. SQLite runs client-side through WebAssembly — nothing you type or store is uploaded to a server, there is no sign-up, and the database lives only in your browser on your own device.

Which SQL dialect is supported?

SQLite (the latest release), including window functions, common table expressions (WITH and recursive), UPSERT, RETURNING, generated columns, JSON functions, FTS5 full-text search, R*Tree and math functions. MySQL/Postgres-only syntax such as AUTO_INCREMENT is not valid — use SQLite's INTEGER PRIMARY KEY AUTOINCREMENT instead.

Do I need to install anything?

No. There is nothing to install and no sign-up. The SQLite engine (about 0.5 MB) downloads once on first run, is cached for instant reloads and offline use, and then every query runs locally.

How do I run a query?

Press Ctrl/Cmd + Enter or click Run Code. Results render as a table; multiple SELECT statements in one run show as separate tables. Use the example buttons to load a ready-to-run query.

Related tools