SQL Playground

A real SQL engine running in your browser against six seeded databases. EXPLAIN ANALYZE, CREATE INDEX and CREATE UNIQUE INDEX all do actual work — read the plan, add an index, and watch the plan change.

SQL Playground7 tables · 17,994 rows

View query internals →

SELECT id, name, country, created_at
FROM users
WHERE email = 'jonas.olsen7@example.com';

Run a query, or pick one from the list. Prefix it with EXPLAIN ANALYZE to see the plan the engine actually executed.

E-Commerce: 900 users, 240 products, 3,200 orders, 8,000 order items, payments and reviews. The default: it has a junction table, a self-referencing tree, deliberate denormalization and deliberately missing indexes.