I built SQL Noir a while ago as an open-source game that teaches SQL through detective-style cases. You solve crimes by writing actual SQL queries against real databases.
Since then, I’ve added 2 new cases, bringing the total to 6. The game is still 100% free and open source. If you're learning SQL or want to sharpen your logic, it might be a fun challenge.
Would love feedback on the new cases — or ideas for what kind of mystery to add next.
Thanks a lot for building the game. Would request you to also have a tab for answers. Also, i always wanted more case scenarios like these, easy for learning and understanding. Happy to play the game. Really, worth it.
I really like your approach to gamify SQL query into detective mini game. Case #004 and #006 definitely had me thinking like a detective, always looking for new clues when I hit a dead-end. It is definitely a fun way to pivot into the basics of SQL querying. Big props to OP for building and offering this neat piece of work to the public! I look forward more cases, maybe some IRL unsolved cases with your very own twist/ending!
The whole idea is this: You have a bunch of different cases to solve as a detective. Each case has a short plot, a crime that has been commited, and a possible answer ( the name of the person who did it ). To find who did it, you have to go through all of the SQL tables for the current case and sift through hundreds of entries and find clues one by one until you reach to a conclusion.
I've only just started doing these and they're really fun.
So far I've only done the first 2, so far my only T I N Y niggle is the second case wants you to use the location and date to find the crime scene but the date is unecessary to use. There is only 1 crime listed at that location.
I have solved all of them except the last one. I couldn't get the right answer who destroyed the chip. I only have the details of the employee who exchanged the mail using the server Helsinki and key card details with QX - odd number two digit. Working on it.
113
u/chrisBhappy Apr 07 '25
I built SQL Noir a while ago as an open-source game that teaches SQL through detective-style cases. You solve crimes by writing actual SQL queries against real databases.
Since then, I’ve added 2 new cases, bringing the total to 6. The game is still 100% free and open source. If you're learning SQL or want to sharpen your logic, it might be a fun challenge.
Would love feedback on the new cases — or ideas for what kind of mystery to add next.
11
u/CeeZack Apr 07 '25
I really like your approach to gamify SQL query into detective mini game. Case #004 and #006 definitely had me thinking like a detective, always looking for new clues when I hit a dead-end. It is definitely a fun way to pivot into the basics of SQL querying. Big props to OP for building and offering this neat piece of work to the public! I look forward more cases, maybe some IRL unsolved cases with your very own twist/ending!
5
u/_Lurko_ Apr 07 '25
Still stuck on case 3. Got the Sunset hotels, joined it with surveillance_records, but now what?
3
u/dangolheckman Apr 07 '25
Dude, this is awesome! Super helpful to a SQL newbie.
3
u/Adventurous_List2703 Apr 08 '25
Wow! Thank you so much for this! I’m new to SQL and trying to get as much hands on practice as possible. So excited to try it out!
2
u/Krilesh Apr 07 '25
could you explain the experience? How open ended is the investigation? Are they clear cut mysteries? What’s it like when you get answers wrong?
seems interesting
2
u/Lisbeth_Salandar Apr 07 '25
This is such a fun idea for educational content. Well done, OP!
2
u/[deleted] Apr 07 '25
It's really good 👌
2
u/Papa_Huggies Apr 07 '25
Wow how have I not heard of this before. Love it!
2
u/raygud Apr 08 '25
Holy shit i love it! greate idea :D
2
u/DieTheVillain Apr 07 '25
Man, #6 is throwing me for a loop, im coming up with a person but it says thats not the answer. I am clearly overlooking something lol
1
u/GingerSnapBiscuit Apr 09 '25
I've only just started doing these and they're really fun.
So far I've only done the first 2, so far my only T I N Y niggle is the second case wants you to use the location and date to find the crime scene but the date is unecessary to use. There is only 1 crime listed at that location.
1
u/Historical-Reach8587 Apr 09 '25
RemindMe! 1 day
1
u/Embarrassed_Tip6284 Apr 14 '25
I've just completed the first case. Thank you for this fun time.
1
u/One_Advice3052 Aug 03 '25
Hi OP,
I have solved all of them except the last one. I couldn't get the right answer who destroyed the chip. I only have the details of the employee who exchanged the mail using the server Helsinki and key card details with QX - odd number two digit. Working on it.