SQL Engines
SQLite Playground
SQLite queries with pre-seeded tables - students, employees, orders.
Runtime: sql.js (SQLite in WebAssembly)
About this playground
Practice SQL on real tables. The engine is sql.js - SQLite compiled to WebAssembly - so SELECT, JOIN, GROUP BY, window functions, CTEs and triggers all work. The DB is pre-seeded with three tables (students, employees, orders) you can join and aggregate. Everything is local; no rows are uploaded.
FAQs
Which SQL dialect is this?
SQLite. It supports most of standard SQL plus a generous set of extensions (window functions, common table expressions, JSON functions). Things like LIMIT, RETURNING and INSERT OR REPLACE all work; some MySQL-only syntax doesn't.
Can I create my own tables?
Yes - any CREATE TABLE / INSERT / UPDATE / DELETE you run modifies the in-memory database for the current session. Refresh the page to reset to the seed data.
What tables are pre-loaded?
students (8 rows), employees (6 rows) and orders (5 rows). Click 'Show Tables' to see the schemas. Great for practising JOINs and aggregations.
Does this hit any server?
No. The whole SQLite engine runs as WebAssembly inside your browser. Queries never leave your machine.