"SQL detective work that turns queries into real deduction"
About
You play a work-from-home Database Detective for the city of Los Zorangeles, solving ten criminal cases by writing SQL queries against a police database. SQL is the language used to pull records out of databases: you filter tables, join them together, and read back the rows that answer a question. Each case hands you a fictional operating system called copOS, where you browse mock 90s websites for clues, then translate what you find into queries that name a suspect or reconstruct events. The cases escalate from simple lookups to multi-table joins and self-joins, wrapped in a cartoon dystopia ruled by a dictator named Zoran, with a sarcastic Mole Man as your assistant.
Verdict
Database Detective pulls off the rare trick of making a database language feel like real deduction, and it wraps that in writing sharp enough to keep you reading between queries. The Mole Man's insults and the shabby copOS interface give it more personality than most puzzle games manage. It stumbles where it matters least to forgive: the jump at cases 5 and 6 loses players who were enjoying themselves, and having to restart a whole case after one failed submission stings. Fix the interface friction and it would be near flawless for what it wants to be. As it stands, it's a smart, funny puzzle game that most people should try, especially anyone curious about SQL.
You'll like it if …
- +You want to learn SQL and would rather solve crimes than grind exercises
- +You already know the basics and enjoy bending a limited toolset to crack a puzzle
- +Cozy 90s edutainment aesthetics and dry assistant banter are your thing
You'll dislike it if …
- −You want a full SQL sandbox with every command and multi-query workflows
- −A sharp difficulty jump that strands you mid-game kills your patience
- −You need replay value beyond a finite set of scripted cases
Breakdown
- +Writing a query and watching it name your suspect lands the same satisfaction as a real deduction, not just a coding exercise
- +Clue-hunting across the fake websites and query-writing feed into each other, so you're detective and programmer at once
- +The early curve teaches SELECT and joins by stealth, without a lecture
- −Cases 5 and 6 spike hard enough to wall non-programmers who were coasting until then
- −A few puzzles lean on ambiguous phrasing, leaving you unsure whether your logic or your reading was wrong
- +Ten cases that each pose a distinct problem, so no query template carries you through the whole game
- +Most problems accept more than one route to the right answer
- −No support for UNION, BETWEEN or CASE WHEN, closing off solutions SQL veterans expect to reach for
- −One query at a time strips out the incremental table-building that experienced users enjoy
- −Ten cases and it's done, with little reason to return once you know the answers
- +The writing carries real jokes, and Mole Man insulting you when you ask about your personal life is a highlight
- +Case premises stay absurd but internally consistent, so the logic never asks for a leap of faith
- +The dystopian Los Zorangeles setup gives the queries a reason to exist
- −Wordplay-heavy clues put non-native English speakers at a disadvantage on a handful of puzzles
- +The MSPaint art, CRT filter and royalty-free music build a shabby, warm edutainment feel that fits the premise
- +The mock 90s web pages are designed with real care, down to the period layouts
- +Runs cleanly and reports SQL errors clearly instead of dumping raw table spew on you
- −The copOS browser wants tabs, history and bookmarks it doesn't have, which slows clue-tracking
- +Onboarding eases you in without holding your hand, and most players never feel lost early on
- −A sloppy Cartesian join can soft-lock the game
- −Fail a case submission and you restart the whole case rather than resume from your progress
- −Notes have a character limit and much of the on-screen text can't be selected or copied
- −Occasional bugs in the automatic result generation
score
