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
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
Wanted to get this out quickly to fix reports of crashing on Linux during syntax highlighting.
Update Notes:
Bug Fixes
Optimize syntax highlighting for column names to prevent crashes on Linux
Minor Clarity Changes
For the 7th case (wiki level):
Changed wording for what qualifies as a premium member
Ensure rent payments are consistent across players
Bringing the demo up to date with the full release!
There are a lot of changes and bug fixes introduced in this version, so this isn't a comprehensive list of what's been added, but should include some notable differences.
Update Notes:
Some Notable Changes
Added login screen
Added custom parser support for CONCAT and IN
Improve Undo/Redo hotkey functionality
And many more!
Wanted to get this update out there since I noticed that some Twitch VODs were being muted due to a song in the Royalty Free Music Player.
Update Notes:
Gameplay Changes
Remove song that was causing Twitch VODs to being muted
Table cells now highlight when hovered over
Decrease tab size (I didn't notice how long tabs were in the demo!)
I've noticed that most people didn't realize that when you click on your assistant after asking for a hint, he'll give you more hints! I've improved this so that you can cycle through hints when you simply ask for help once.
Update Notes:
Gameplay Changes
You can now click "Next" when asking for help to get more hints!
[img src="{STEAM_CLAN_IMAGE}/45766296/f300e2da4dac1322f88094fdb100c4010b5e765c.gif"]
Add a clearer parser error when query is just SELECT FROM
Made selected book chapters a different color than unavailable locked chapters
Squashing some more bugs - thanks all for reporting these issues!
Update Notes:
Bug Fixes
Prevent soft lock when a wrong suspect is arrested twice
Fixed notepad issues that might have caused some weird behavior
Parser: add backtick (``) and square bracket (\[]) support for identifiers (table and column names)
Parser: fixed issue where a valid column alias of a subquery cannot be used
Current Release
Build 24523373
Uploaded Aug 03, 2026
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.
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.