PINE//OPS
STATUSSTANDBY

Online SQL (SQLite) playground

A real SQLite engine in WebAssembly — fresh database every run.

A real SQL engine, no server

Each run starts a new in-memory SQLite database, executes every statement in the editor in order and prints each result set as a table. Because SQLite itself is running, joins, window functions, CTEs and JSON functions behave as they do in production SQLite.

Frequently asked questions

Does my data persist between runs?

No. The database is recreated on every run, so include your CREATE TABLE and INSERT statements in the editor.

Is this MySQL or PostgreSQL syntax?

It is SQLite. Standard SQL works the same; vendor-specific features of other databases may not.

Related tools

Recon mode — drag to orbit · click to ping · scroll for altitude