Database Detective: Minor Crimes Division
by Thomas Hsu · 17 Jul, 2026
76 downloads
About the Game

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.
Job benefits also include…
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!
Screenshots
9 imagesVersion Information
Steam Patch Notes
Official update history
Now you can right click on the taskbar to close a window or minimize all windows!
[img src="{STEAM_CLAN_IMAGE}/45766296/185973219613777044de7f358589a05f5742cc83.gif"]
You'll also be able to indent/unindent selected text in the Search Tables window by pressing Shift/Shift+Tab respectively!
[img src="{STEAM_CLAN_IMAGE}/45766296/f64e79f4c97aada03854ac85f862756dc0d616f6.gif"]
Update Notes:
Gameplay Changes:
Add animation for right click dropdowns
Add ability to right click on the taskbar to close a window or hide all windows
Add ability to indent and unindent selected text in the Search Tables window
Alt+W now cycles between two most recent windows
Bug Fixes
Right click dropdowns are no longer obscured by the taskbar
Ensure traveling through time makes message timeline consistent
Remove arrest icon after failing final case
Fix issues with assistant dialogue after failing final case
Fix typo in calmail tables
This update addresses the crashes that happen on Mac when loading the final two cases. Apologies this took so long for the Mac users, this was probably the most difficult bug fixes that I had to do! If anyone has more issues with Mac builds, please let me know.
Update Notes:
Bug Fixes
Fix Mac crashing on the last two cases
Prevent time traveling from allowing access to chapters that should be locked
Restoring queries from Query History now brings the Search Tables window to the top
Gameplay Changes:
Parser Improvements:
Better, more descriptive warnings
Block queries with non-aggregate columns in the HAVING statement
Don't show warning when grouping by column number (GROUP BY 1)
Ok I was wrong, it looks like there were more problems! As always, let me know if you're having any unexpected issues and I'll take a look at them.
Update Notes:
Bug Fixes
Fix cursor misalignment in the Search Tables window after a long line of text is wrapped around
Fix ending cutscene not loading
Fix issue where quoted identifiers were not recognized as valid column names by the parser when written like tableName."columnName"
Gameplay Changes:
Parser Improvements:
Add support for LIMIT
Add more specific error messages when a keyword appears after a special character (like a comma) in a FROM or JOIN
The most important change here is adding back a semi-colon I accidentally removed in the previous update which caused some issues when downloading tables in the final level. Hopefully there should be no more problems! Ever!!!!! But if there are more issues please let me know.
Update Notes:
Bug Fixes
For the final case:
Fix bug which prevented tables from being downloaded
Gameplay Changes:
Removed syntax highlighting for "LEFT" and "RIGHT" keywords and instead only highlight "LEFT JOIN" and "RIGHT JOIN".
Parser Improvements:
Specific error messages when trying to access a column from a table using commas (such as table,column instead of table.column)
Remove cross join errors when joining with subqueries
Wanted to get this out to fix a rare bug that occurs less than 5% of the time in the 8th case (with LZU) causing there to be two valid suspects. This bug occurs when there are two students sitting next to a single smart student with a test score greater than theirs and the texter combined. Sincerest apologies if this happened to you, and if this is currently what you're stuck on, you can hopefully use this detail to get the right suspect: the true culprit has been to exactly 1/4th of the classes.This isn't knowledge required to solve this case, but it might help if you're one of the victims of this rare bug. You can also reload the current case, but do note that the classes are randomized so that will be regenerated as well.
Update Notes:
Bug Fixes
For the 8th case (LZU level):
Ensure there is always only one possible valid suspect to be arrested
For the 9th case:
Loading this case no longer drops tables from previous levels.
For the final case:
Ensure no crop has both a small and large variant
Wanted to get this out quickly to fix a bug introduced in the previous update for the seventh case (with the wiki) preventing you from downloading payup transactions tied from accounts tied to websites. Luckily, this isn't required to solve the case, but if this happened to you, reloading the case should fix things.
Update Notes:
Gameplay Changes
Increased maximum length of table names for table icons
Bug Fixes
For the 7th case (wiki level):
Rename payup account tables tied to websites to make sure they can be downloaded
Fix hint that references an old table name in the last level
Fix icon selection not resizing to fit the name of a table after renaming
Fix drag box not disappearing after dragging and clicking quickly
You can now view your internet history!
[img src="{STEAM_CLAN_IMAGE}/45766296/2912a2e8a883981f8f6d35e30aa8b04b66bb531c.png"]
You can also bookmark websites which will show up in your internet history.
Also, clicking on a website in a table will bring up that website in a web browser automatically.
Clickable websites will have underlined blue text when hovered over (like below).
[img src="{STEAM_CLAN_IMAGE}/45766296/d9a908f7ca96be699593f522813ce8c59e84ee08.png"]
Many more updates to come!
Update Notes:
Gameplay Changes
Add internet history and ability to bookmark websites
Tables containing websites now automatically opens the website when clicked
Add sound effects when restoring or deleting from query history
Bug Fixes
Ctrl+Enter now only works when the Search Tables window is focused
Hotkeys now relies on key output instead of key locations
This was an issue with non QWERTY keyboards where keys were bound to QWERTY keyboard locations instead of where actual key characters were
Fix issue where loading large tables would cause the game to freeze
For the 6th case (web history level):
Fix typo in smoothie nutrition requirements
For the 7th case (wiki level):
Fix damage range for in wiki combat page for Electrified Mace
Renamed certain payup accounts tied to websites to be clickable
For the 8th case (texting level):
Fix attendance dates in Philosophy and Science classes to be M/W/F instead of M/W/Th
Trying again should no longer drop the tables you created or reload the case.
This is also true with switching between cases, with one big caveat: this only affects cases that have been loaded after this update. This means that if you played the first case before this update and now are on the second case, your tables for the second case will be preserved but not the tables for the first case if you switch back to it. However, if you played the first case after this update, you should be able to switch to it without losing progress.
In other words, your current progress should not be affected but your progress before this update has not been saved. All cases loaded after this update should have their progress preserved.
This update is a pretty big change, so please let me know if there are any issues.
Update Notes:
Gameplay Changes
Retrying cases no longer erases created tables
NOTE: This only affects cases you have played after this update
Any case currently loaded will have their tables saved
Any cases loaded before this update will not have their tables saved.
For the 7th case (wiki level):
xCalibur32 now mentions selling passwords in his player profile
Misc Changes
Make game's executable icon consistent on all platforms
Batch inserts when loading tables
Hopefully prevents some crashes on Mac
Bug Fixes
Fix formatting in credit tables
For the 9th case:
Fix time column in *_price tables being a TEXT type instead of INT
Whoops, did not mean to do that!
Update Notes:
Gameplay Changes
Disable Dev Window
More bug fixes! Notably fixed the bug where Linux builds of the game were missing SQLite functions.
Next update will focus on quality of life improvements such as preserving progress if you get a case wrong.
Update Notes:
Gameplay Changes
Reduce assistant's thinking time before and between hints
Bring up Steam Deck virtual keyboard when an input field is clicked
Improve how default table names are generated
Bug Fixes
Fix missing SQLite functions on Linux
Huge thank you to neattaken for helping out with this!
Fix unsaved tables not having syntax highlighting
Fix Webtrotter achievement not unlocking
For the 8th case (LZU):
Fix attendance dates not matching with class schedules
For the 10th case:
Fix inconsistency with naming of production materials
For the 7th case (wiki level):
Remove non-bard from Bards Only guild
Use player's payup name instead of player name for transactions
Thanks everyone for submitting your issues through the feedback form! Many more fixes to come!
Update Notes:
Gameplay Changes
Add a few additional, more direct hints from your assistant
Bug Fixes
Fix Ctrl + Enter not saving new tables
Add UNION as a keyword for syntax highlighting
Fix multiple Web Browser taskbar buttons having the same number
Fix volume slider in settings not affecting the Startup screen
Increase character limit when searching for traders on broker.com
Minor Clarity Changes
For the 7th case (wiki level):
Fix damage stat for the Electric modifier in the wiki combat page
Changed wording in the forum post regarding the rarity of a certain weapon
For the credit sequence:
Make dates consistent
Casually adding time travel in the game: now you can go back to cases you've already unlocked at any time!
Update Notes:
Gameplay Changes
Added new option in the assistant dialogue to travel through time, allowing you to switch between cases.
Also, your assistant should stop bothering you if you tell them you don't want to retry a case.
Bug Fixes
Fix floating point formatting causing occasional crashes during the 9th case.
Minor Clarity Changes
For the 7th case (wiki level):
Modified description of Skeletal Warriors to make it clear they have the same base stats as a warrior
Current Release
Build 24523373
Uploaded Aug 03, 2026
Update already requested
Uploaders have been notified
A newer version is available but not yet uploaded
Help keep this updated
Login Required
You need to be logged in to request game updates. Would you like to go to the login page?
Request Update
Request an update for Database Detective: Minor Crimes Division? This will notify uploaders that this game has an available update.
Request Submitted
Your update request has been submitted successfully! Uploaders will be notified.
Request Failed
Failed to submit update request:
System Requirements
How to Install
copOS.exe to play
Troubleshooting tips
• Run Redist/_CommonRedist installers if game won't start
• Add folder to Windows Defender exclusions
• Run as administrator
Download
Direct link available
Needed when extracting (WinRAR / 7-Zip) — not a site login.
8EF5C11D
9848fc4587405432f8453ea8e5c8bb6f5a9b143b23c2251af099eb4f9bc847a4
You May Also Like
View AllDownload Database Detective: Minor Crimes Division for PC with a direct link or via torrent. Get the full version of Database Detective: Minor Crimes Division for free. Database Detective: Minor Crimes Division is a Indie released by Thomas Hsu.