About this SQL murder mystery game
Practice SQL by solving a crime. Query tables of crime scene reports, people, driver's licenses, interviews and gym check-ins with SELECT, JOIN, WHERE and LIKE to follow the clues and find the killer. A real SQLite database runs in your browser.
How to use the SQL Murder Mystery
- Read the case briefing.
- Write SQL queries and follow the clues.
- Name the killer to solve the case.
Example
SELECT * FROM crime_scene_report WHERE city = 'Codeburg' AND date = 20240115;
Frequently asked questions
Which SQL dialect is used?
SQLite, which supports standard SELECT, JOIN, GROUP BY, subqueries and common table expressions.
Can I break the database?
You can run UPDATE or DELETE, but Reset database restores the original data.
Is my data safe?
Yes. The tool runs entirely in your browser using WebAssembly. Nothing you type or upload is sent to a server, logged or stored.
Is it free?
Yes, completely free with no sign-up, no limits and no watermarks. It also works offline once the page has loaded.