We Love It's Guide to…
Work as Los Zorangeles’ database detective, using SQL queries and online sleuthing to solve absurd minor-crime cases.
Released 17 Jul 2026
Query Crime Databases
Search 40+ Websites
Connect Clues Online
Solve criminal cases through the power of SQL queries! Help out the city of Los Zorangeles by becoming a Database Detective in this new (unpaid) work from home opportunity.
Developed by Thomas Hsu · Published by Thomas Hsu
You join the Los Zorangeles Police Department’s Minor Crimes Division as a database detective, tackling cases involving offenses from littering to overstaying a hotel checkout. Each case asks you to identify a culprit from evidence and data.
Write SQL queries to inspect, filter, and combine records, then use the results to narrow down suspects. An introductory manual teaches the basics, while an assistant and error messages offer help as you work.
Across ten increasingly complex cases, you also search more than 40 in-game websites for leads and data, piecing together clues beyond the tables. The cases combine query puzzles with broader investigation in a cartoon, hand-drawn setting.
In the supplied reviews, players often enjoy the blend of SQL puzzles and detective work, finding it satisfying to use queries and clues to narrow a case to an answer. Many also appreciate the manual as an approachable way to learn SQL basics, along with the game’s silly writing and setting. Some reviewers find later investigations much harder or more focused on searching websites than writing queries.
There’s been a backlog of unsolved cases piling up in the Minor Crimes Division of the Los Zorangeles Police Department and we’ll need a Database Detective to help solve them.
We’ll need you to analyze clues and manipulate data using SQL, a database querying language, to figure out who perpetrated crimes from as minor as littering to as serious as not checking out of a hotel after the check-out time.
Don’t worry! This role is intended to be accessible for those without any SQL experience, so each Database Detective is given an introductory textbook when they start! This short textbook is less than 20 pages and explains everything that’s needed to solve each case.
If you still have trouble writing queries, our comprehensive error messaging system will tell you exactly where your query went wrong, making it easy to correct your mistakes.
Still not enough? Each Database Detective is assigned an assistant who’s ready to answer any questions you might have, whether they be about the case itself or the SQL queries you’ll need to write!
Understanding how to manipulate data using SQL is not the only part of being a Database Detective! Your job will also require you to piece together evidence and clues, just like a real detective! Further on in your Database Detective career, you’ll have to sleuth through the internet and piece cases together yourself.
Fully voice acted mission briefings at the beginning of each case!
Fully hand drawn art for you to enjoy!
More than 40 websites to explore!
10 cases for you to solve, each case getting longer and more complex!
A total of around 8-10 hours of valuable work experience to add to your resume!
| Platforms | Windows, macOS, Linux |
|---|---|
| Achievements | 34 |
| Age ratings |
|
| Controller required | No |
| Demo | View demo on Steam |
Games similar to Database Detective: Minor Crimes Division
