DevToolsHub Free · Fast · 100% in your browser

SQL Murder Mystery

A murder happened in Codeburg on January 15, 2024. Query the city's database with real SQL to find the killer.

🕵️ A murder took place in Codeburg on 2024-01-15.

Start with the crime_scene_report table. Tables: crime_scene_report, person, drivers_license, interview, gym_member, gym_checkin. Dates are stored as integers like 20240115. The database runs SQLite in your browser.

Loading SQLite…

Solved it? Name the killer.

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

  1. Read the case briefing.
  2. Write SQL queries and follow the clues.
  3. 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.

An unhandled error has occurred. Reload ✕