MrTechKing

2 min readFree

SQL Murder Mystery

SQL Murder Mystery is a free online game where you solve a murder by writing SQL queries on a police database. It was made by Northwestern University's Knight Lab.

// at a glance

Is SQL Murder Mystery free?
Free. Yes. SQL Murder Mystery is free to use, with no paid plan.
Category
#Fun
Website
mystery.knightlab.com ↗
Try SQL Murder Mystery ↗
SQL Murder Mystery logo

What is SQL Murder Mystery?

SQL Murder Mystery is a detective game you play with database queries. A murder happened in SQL City on January 15, 2018, and you have lost the crime scene report. You type SQL into boxes on the page to search the police database, starting with the report, then follow the clues through witness interviews, gym check ins, driver's license records and more until you know who did it. When you think you have the killer, you check your answer with one last query.

It was created by Joon Park and Cathy He while they were fellows at the Northwestern University Knight Lab, and adapted for the web by Joe Germuska. The database runs in your browser with SQL.js, so there is nothing to install. Beginners can follow a walkthrough that teaches the commands step by step, and experienced players can open a schema diagram and dive straight in. The official site is mystery.knightlab.com, and the code is MIT licensed on GitHub.

Main Features

  • A murder case to solve with real SQL queries
  • SQL boxes on the page that run in your browser
  • A beginner walkthrough that explains each command
  • A schema diagram of the police database
  • A built in check for your final answer
  • Built on SQLite, so standard SQL works
  • No install, account or sign up
  • Open code under the MIT license

How to Get Started with SQL Murder Mystery

  1. Open mystery.knightlab.com in your browser.
  2. New to SQL? Start with the walkthrough. Otherwise scroll to the first query box.
  3. Run the starter query to list the tables in the database.
  4. Pull the crime scene report for January 15, 2018 in SQL City and follow the clues.
  5. Enter the name of the killer in the solution box to see if you cracked the case.

SQL Murder Mystery Pricing

SQL Murder Mystery is completely free, with no ads and no sign up needed. It is an open project from a university lab, so there is nothing to buy.

Who Should Use It?

  • Students learning SQL who want practice that feels like a game
  • Data analysts who want a fun refresher
  • Teachers looking for a database lesson with a story
  • Murder mystery fans who like logic puzzles
  • Job seekers brushing up before a SQL interview

SQL Murder Mystery Alternatives

Frequently Asked Questions

Is SQL Murder Mystery free?

Yes. SQL Murder Mystery is free to play, with no ads and no account.

Do I need to know SQL to play?

No. Beginners can follow the walkthrough, which explains each command. The game is meant more as practice than a full course, so the site suggests Select Star SQL if you want a complete tutorial.

Who made SQL Murder Mystery?

It was created by Joon Park and Cathy He as Knight Lab fellows at Northwestern University, and adapted for the web by Joe Germuska.

Do I need to install a database?

No. The SQLite database runs inside your browser with SQL.js, so you type queries right on the page.

Is SQL Murder Mystery open source?

Yes. The code is on GitHub under the MIT license, and the text is under Creative Commons CC BY-SA 4.0.