A SQL-based murder mystery game that teaches SQL concepts through interactive crime-solving.
SQL Murder Mystery is an educational game that teaches SQL through an interactive crime-solving scenario. Players investigate a murder by writing SQL queries to analyze evidence, interview witnesses, and identify the culprit within a provided database. It transforms learning SQL from abstract syntax practice into an engaging, story-driven experience.
SQL beginners seeking hands-on practice and experienced database users looking for a fun challenge to test their query skills. Educators and workshop facilitators can also use it as a structured teaching tool.
It combines gamification with practical SQL education, offering immediate feedback through crime-solving progression. Unlike traditional tutorials, it provides a complete, realistic dataset and narrative context that makes learning memorable and enjoyable.
Inspired by @veltman's command-line mystery, use SQL to research clues and find out whodunit!
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Transforms abstract SQL commands into a tangible crime-solving narrative, making education interactive and memorable as described in the project's philosophy of hands-on, gamified learning.
Offers separate prompts for beginners and experienced users, ensuring appropriate challenge and progression, as highlighted in the README with specific PDF files for each level.
Includes a complete SQLite database file with all crime scene data, ready for immediate analysis without external dependencies, simplifying setup for local use.
Provides reference guides, installation instructions, and troubleshooting resources, supporting independent study and reducing barriers for beginners, as detailed in the README.
The project uses SQLite exclusively, which may not cover syntax or features of other popular databases like MySQL or PostgreSQL, limiting transferable skills.
With only one murder mystery to solve, it lacks replayability or varied exercises, making it less suitable for ongoing practice or advanced learning.
For offline use, beginners must install and configure a SQLite environment like SQLiteStudio, which can be cumbersome compared to the web-based version, as admitted in the setup instructions.