Database Detective: Minor Crimes Division
by Thomas Hsu · 17 Jul, 2026
98 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 images
Version Information
Steam Patch Notes
Official update history
Bug Fixes:
Fixed issue where the shift key maps keys to the QWERTY keyboard layout.
This was caused by an attempt to fix the shift key not working on the Steam Deck virtual keyboard, so that fix has been undone.
Now you can tab between queries in the Search Tables window!
[img src="{STEAM_CLAN_IMAGE}/45766296/cd1590247b350484a1b98cae46d0370441f5f0a6.gif"]
With this in place, I'm pretty happy with how things are at the moment and will start working on some larger updates. Barring any other bug fixes or issues that might come up, this means there will probably be longer times between updates.
As for what's next, I'll be working on making assets for Steam Community Items for Trading Cards and the Points Shop. After that, I'll start looking at how to integrate Workshop Support to this game. As always, let me know if you have any bugs to report or any additional feedback!
Update Notes:
Gameplay Changes:
Add tabs to the Search Tables window.
Queries written in the Search Tables window are now saved and persist after the game is closed.
Bug Fixes:
Fix Shift key not working on the Steam Deck virtual keyboard.
This might fix other keyboard issues related to the Shift key.
Fix the ability to scroll through the Search Tables window with a scroll wheel.
Parser Fixes:
When preventing cross joins, ensure only queries joined in the FROM statement are counted.
Previously, a query such as SELECT t1.column = t2.column FROM table1 t1, table2 t2 would be considered joined and not throw an error.
Fix parser error when an alias of the outer query is used in a subquery.
Took a short two day break - now I'm back fixing bugs! As always, please let me know if you notice any more issues.
Update Notes:
Gameplay Changes:
Changed hotkey to unindent selected text from Shift+Tab to Tab+Z.
Refactored how arrested suspects are tracked.
The game should now remember arrested suspects per case.
This means you won't be able to arrest the same person twice when you go back to a case.
Refactored how valid suspects are tracked.
Improved how valid suspects are tracked for each case.
This affects the error popup informing you if the suspect is a valid suspect.
Bug Fixes:
Fixed issue where the custom parser terminated early.
This started occurring as of the previous update, which made the custom parser not work for larger queries.
Fixed internet history issues when resetting the game.
For the 9th case:
Fixed issue where bets were rounding to an incorrect number
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
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 All
Download 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.