Database Detective: Minor Crimes Division isn’t a detective game where you’re expected to click the highlighted object and magically solve the mystery. Every investigation asks you to think like a real investigator, connect clues from multiple sources, and gradually narrow down your suspect list using logic.
One thing that’s important to know before starting this walkthrough is that the culprit’s identity is randomized for every save. That means giving you a suspect’s name wouldn’t actually help. Instead, this guide focuses on the reasoning behind every investigation so you can understand how each mystery is designed to be solved.
Database Detective Minor Crimes Division Walkthrough Wiki
Another important note is that this walkthrough intentionally doesn’t provide SQL queries. Building those queries is one of the game’s core mechanics, and learning how to write them is part of the experience. Instead, this guide explains what information you should be looking for, how the clues connect together, and why each database matters.
Spoiler Warning: This Database Detective Minor Crimes Division Walkthrough discusses every investigation and puzzle currently available in the game.
Case 1 – Learning to Observe
Available Clues
The very first case gives you:
- Four suspect photographs.
- A suspect number for each individual.
- A clue collected from the crime scene.
Although it feels incredibly simple compared to later investigations, this case teaches the most important habit you’ll use throughout the game: look at the evidence before touching the database.
Investigation Reasoning
The briefing tells you that blue paint was used during the act of vandalism.
Instead of immediately searching every suspect record, compare the photographs first.
Only one suspect visibly has blue paint on their face, making them the only person who matches the physical evidence.
Once you’ve identified that individual, the remaining work is simply locating their record using the provided suspect number.
This investigation exists to teach observation rather than database analysis.
Case 2 – Using Database Filters
Available Clues
Instead of photographs, you’re given the suspect’s identification card.
It contains several useful pieces of information:
- District
- Date Joined
- Date of Birth
- Eye Colour
- Height
- Weight
Investigation Reasoning
This investigation introduces filtering.
Every detail on the identification card exists for a reason.
Rather than searching every database row manually, begin combining attributes.
For example, matching someone’s height and weight already removes most records. Adding eye colour or district quickly reduces the list even further.
There isn’t any hidden trick here.
The purpose of the case is teaching players that databases become much easier once several pieces of information are combined together instead of searched individually.
Case 3 – Cross-Referencing Multiple Databases
Available Clues
The evidence includes:
- A photograph of the suspect.
- The approximate time of the crime.
- A firearm on the suspect’s belt.
- A security card marked with Roman numeral III.
Investigation Reasoning
Unlike the previous investigations, this one cannot be solved using a single database.
Start by focusing on the timestamp shown in the photograph.
Using the date and time, filter the timesheet records to find everyone who was present when the crime occurred. Anyone who had already left before that time can immediately be eliminated.
You’ll still have several possible suspects remaining.
Next, move to the police database.
The suspect’s photograph provides two additional clues:
- They carry exactly one issued firearm.
- Their security level is III.
Filtering officers with both of those characteristics dramatically reduces the list.
Finally, compare both results.
The badge number appearing in both filtered datasets belongs to your suspect.
The lesson here is learning how different databases support one another rather than trying to solve everything from a single table.
Case 4 – Solving Through Elimination
Available Clues
This investigation provides considerably more information than previous cases:
- Convention brochures.
- A photograph showing how many Forms, Lamps and Bottles the suspect carried.
- A diary entry describing the day’s events.
At first glance these clues seem unrelated, but together they reveal almost everything you need.
Step 1 – Determine Every Item Count
The photograph already tells you exactly how many Forms, Lamps and Bottles the suspect brought.
The only unknown value is the number of dumbbells.
Fortunately, the diary explains that the suspect carried the exact average number of dumbbells.
That means your first task is calculating the average value from the DumbCon database.
Once that’s finished, you’ll know every item total carried by the suspect.
Step 2 – Understand the Competition Rules
The convention brochures mention an important rule that many players overlook.
Each competition rewards the attendee who brings the largest quantity of that convention’s featured item.
Keep this rule in mind before checking attendance records.
Step 3 – Use the Diary
The diary contains several deductions that help eliminate possibilities.
The suspect states:
- They never actually won a contest.
- They would have won one event if they hadn’t arrived late.
- They couldn’t enter one convention because it had over 300 visitors.
- They only attended two conventions.
Each sentence removes possibilities.
If your item count exceeds the winning amount for a convention, then the suspect genuinely could have won that event.
Likewise, the convention with more than 300 attendees can be identified by counting visitors across each database.
After applying every diary clue, you’ll know exactly which conventions the suspect attended and which they definitely skipped.
Step 4 – Find the Attendee
Now compare attendee IDs across the remaining convention databases.
You’re looking for one participant whose attendance matches the diary while also carrying the correct number of items.
Only one attendee satisfies every condition.
This case is less about finding evidence and more about gradually eliminating impossible scenarios until only one answer remains.
Case 5 – Following Digital Evidence
Available Clues
The investigation begins with:
- A photograph of the suspect’s pizza.
- A restaurant business card.
- Testimony from the waitress.
Investigation Reasoning
The business card is your first major clue.
Instead of staying inside the game’s main database, visit the restaurant’s website.
There you’ll find additional downloadable databases including today’s orders and today’s tips.
The waitress claims the suspect always leaves the lowest percentage tip.
Notice that she says percentage, not amount.
Someone spending far more money could naturally leave a larger cash tip while still tipping a lower percentage.
Calculate the total price for every order before comparing tip percentages.
Once you’ve identified the customer leaving the smallest percentage tip, verify the result by checking the order itself.
The photograph clearly shows pepperoni and pineapple, so the matching order should contain both.
After confirming the food order, use the order number to identify the customer.
This case introduces outside resources and demonstrates that clues often extend beyond the initial evidence provided.
Case 6 – Building a Suspect Profile
Available Clues
You’ll receive:
- Government website credentials.
- A month’s worth of web browsing history.
Step 1 – Access the Government Website
The administrator panel contains one review that is still under investigation.
That review provides the exact date and time the suspect visited the site.
Use this information to filter the browsing history.
Only one IP address visited the government website during that timeframe.
That IP becomes your suspect.
Step 2 – Examine Their Browsing Activity
Instead of stopping there, inspect every website visited from the same IP address.
Several sites become important, including:
- Smoothie World
- Errand Boy
- Select Your Star
- MMDB
Each website reveals another piece of information about the suspect.
Step 3 – Solve the Personality Quiz
The celebrity website stores participants’ answers to three questions.
Your task isn’t finding the suspect directly.
Instead, you’re figuring out their answers.
The smoothie recipe, grocery order and nutritional database reveal which life aspect they wanted to improve.
Their movie review profile reveals their favourite film.
Finally, comments elsewhere reveal dietary preferences, confirming their favourite food.
Step 4 – Estimate Their Age
The government review mentions that Zoran ruled for exactly half of the suspect’s lifetime.
Comparing that statement with historical information lets you determine the suspect’s age.
After combining favourite movie, favourite food, life goal and age, only one candidate remains.
This investigation is a perfect example of building a complete profile before identifying the person.
Case 7 – The Most Complex Investigation
Case 7 is easily the largest investigation currently available.
Rather than solving a simple database query, you’re effectively investigating a murder inside an online RPG.
Understanding the Game World
Your clues include:
- A crying player’s screenshot.
- A drawing of a missing weapon.
- A damage log.
Before searching anything, visit the game’s wiki.
You’ll need to understand its mechanics, locations, weapons, enemies, classes and guild system.
The victim’s profile eventually leads you to two guilds, both hiding valuable information behind forum passwords.
Accessing one guild requires completing a lore quiz based entirely on information scattered throughout the wiki.
Every answer teaches another part of the game’s mechanics.
Following the Evidence
Once inside the guild forums, the real investigation begins.
The damage log reveals:
- Which weapon killed the victim.
- Which rare weapon disappeared.
- Where the murder occurred.
Guild discussions reveal that the victim publicly showed off the rare weapon before being killed.
Election discussions suggest a possible motive.
Guild inventories reveal who could access the murder weapon.
Donation history identifies Premium members.
Election records reveal possible suspects.
Travel logs determine who actually reached the murder location.
Combat calculations reveal the killer’s class.
Each individual clue isn’t enough by itself, but together they gradually narrow the suspect list until only one person matches every requirement.
Identifying the Real Person
Once you’ve identified the in-game murderer, their financial records reveal several real-world services they use.
Cross-referencing donation history, rental information and employment records finally reveals their real identity.
Case 7 rewards careful note-taking more than any previous investigation.
Case 8 – Investigating University Records
Available Clues
The eighth investigation revolves around four screenshots showing conversations between students.
Those screenshots reference:
- Exam scores.
- Attendance.
- Classroom seating.
- Student projects.
Working Through the University Databases
The university website contains multiple courses, each with several downloadable databases.
These include:
- Attendance sheets.
- Seating charts.
- Homework.
- Exam scores.
Completing or understanding the exams helps identify which subjects the students share.
Once that’s known, the screenshots become much easier to interpret.
Accessing the Teacher Portal
The professor unintentionally explains how their password is constructed.
Using clues hidden throughout university history and campus information, you can determine both halves of the password and gain access to restricted student records.
Finding the Suspect
From there, combine:
- Seating positions.
- Exam scores.
- Attendance percentages.
- Art submissions.
- Student IDs.
Each screenshot removes more possibilities until only one student satisfies every clue.
Rather than identifying someone directly, the investigation slowly rebuilds the classroom around them.
Final Case (Current Walkthrough)
The final investigation begins very differently from previous cases.
Instead of presenting one obvious crime, you’re handed several unrelated stories involving newspapers, financial records, pension programs and a journalist’s research.
Initially it isn’t even clear what you’re investigating.
The best approach is reading every available resource carefully.
Jerry Webb’s personal website contains evidence suggesting someone attempted to manipulate the financial market through coordinated stock transactions.
Historical trading records downloaded from the broker website become the starting point for uncovering that larger conspiracy.
Since the investigation is still being developed, additional reasoning will be added as the remaining content becomes available.
Database Detective: Minor Crimes Division isn’t about memorizing answers. Every investigation introduces another detective technique, whether that’s filtering databases, comparing independent datasets, reconstructing timelines or eliminating impossible scenarios through logical reasoning.
If you ever feel stuck, avoid guessing. Go back to the evidence, read every clue again and ask yourself one simple question: