SQL Murder Mystery, the free browser game from Knight Lab at Northwestern, did something rare: it made thousands of people who thought SQL was dry realize that a query can feel like detective work. You get a crime, a database of police reports and witness interviews, and nothing else. The catch is that it is a single case. Most people finish it in an evening and immediately ask the same question: what else is like this? The pull is measurable: the game's open-source repo has collected more than 2,100 stars on GitHub.
Quite a lot, it turns out. The sql detective game has become its own small genre, and the wider world of sql puzzle games has picks for every level, from first SELECT to interview prep. When Hacker News asked “Are there any websites for SQL puzzle games?” in 2024, commenters surfaced several of the games below, including SQL Island, Schemaverse, and Lost at SQL. Here are seven games, all free to start, that capture the same learn-by-querying feel, with an honest verdict on each. If you have not played the original yet, start at mystery.knightlab.com and come back.
1. SQL Noir
The closest match on this list. SQL Noir is an open-source detective game with multiple cases, each a chain of clues you unlock by writing progressively harder queries. The beginner cases are free with no account needed; the intermediate and advanced cases require a one-time license. The noir styling is the best in the genre, and the case structure gives you more hours of play than the original mystery. It teaches filtering, joins, and multi-step investigation logic. sqlnoir.com
Verdict:if you want “SQL Murder Mystery but more of it”, play this first.
2. SQL Island
A free text adventure from a German university: your plane crashes on an island and you survive by querying the villagers, trading, and earning your escape. It is not a mystery, but it has the same story-first structure, and its difficulty curve is the gentlest here. It covers SELECT, WHERE, and basic updates, then tops out. sql-island.informatik.uni-kl.de
Verdict: the best pick for someone who has never written a query, and only that person.
3. SQL Police Department
You join the SQLPD and solve cases by querying evidence, one guided episode at a time. It leans harder on instruction than the others: each case introduces a concept, then makes you use it. The first cases are free and later content is paid, so treat it as a free starter with an optional upgrade. sqlpd.com
Verdict: the most tutorial-like of the detective games; great if you want guidance, less so if you want to be dropped into a case cold.
4. Lost at SQL
A story-driven game where you query your way through a workplace adventure, built by an SEO practitioner who wanted a friendlier on-ramp than documentation. It has real personality, a proper difficulty ramp, and covers joins and aggregation by the end. lost-at-sql.therobinlord.com
Verdict: charming and underrated; a solid second game for a beginner who finished SQL Island.
5. Schemaverse (honorable mention)
Not a detective game, but it belongs in any list of sql puzzle games for one reason: it is an entire multiplayer space-strategy game played through PostgreSQL. You command a fleet by writing queries and can script a bot to fight for you. It assumes you already know SQL and want to stretch it. The hosted server at schemaverse.com has been unreachable as of mid-2026; the code lives on GitHub if you want to run it yourself or watch for a revival.
Verdict: skip it as a learner, bookmark it for the day SQL feels easy.
6. Select Star SQL
An interactive book rather than a game, but it earns its slot: you analyze a real dataset of Texas death row inmates, writing every query in the browser as the chapters build from basic selection to serious analysis. It is the most substantive teaching on this list, with the least gamification. selectstarsql.com
Verdict: the pick when you want depth over atmosphere; pairs well with any game here.
7. SQL Protocol
Full disclosure: this is our game, so weigh the recommendation accordingly. SQL Protocol is a free browser game where you play a covert operative working through a 15-chapter story campaign that runs from your first SELECT through filtering, aggregation with GROUP BY and HAVING, multi-table joins, subqueries, and UNION. What sets it apart from the detective games is what sits next to the story: an Interview Mode with three floors of timed drills, and a 1v1 Arena where you and an opponent race to solve the same puzzle. It is the one with a full story campaign plus a 1v1 arena, aimed at people who want to go from spark to interview-ready in one place. Desktop only, with an instant guest mode: no signup needed to start.
Verdict: the longest structured path here; if you only want a one-evening puzzle, play SQL Murder Mystery or SQL Noir instead.
Which one should you play?
- More detective cases: SQL Noir, then SQL Police Department.
- Total beginner: SQL Island, then Lost at SQL.
- Depth and real analysis: Select Star SQL.
- A full campaign plus competition: SQL Protocol, free in your browser.
- Already fluent: Schemaverse.
For a broader comparison that includes non-mystery picks and interview-prep tools, see our roundup of the best SQL games.