
Sim Analyst - SQL Edition
โ ๏ธ Desktop/Laptop only — not optimised for mobile or tablet.
Best played in a full browser window on a laptop or desktop.
What is this?
Forget the magnifying glass. Real detective work happens at a desk — and that's exactly where you'll be.
Pull records. Run the data. Spot the pattern nobody else caught. Every clue is real evidence, and every accusation has to be backed by proof, not a hunch.
This is investigation as it actually feels: messy, data-driven, and ridiculously satisfying when it all clicks.
What you'll be doing
- ๐ Analyzing fingerprints & DNA evidence
- ๐ Tracing phone records & call logs
- ๐ Reading interview transcripts
- โ๏ธ Filing subpoenas to unlock new evidence
- ๐งฉ Spotting patterns & solving evidence-based puzzles
- ๐ Building spreadsheets, dashboards & data visualizations
- ๐๏ธ Writing real SQL queries to dig through case data
- โฑ๏ธ Piecing together timelines of who-was-where-when
No prior SQL knowledge required — but if you know your way around a database, you'll feel right at home.
Current Build
This is an early alpha demo — one case, fully playable, start to finish. It's rough around the edges and we're actively building, but it's a real taste of the core loop: gather evidence, run the data, build your case, make the accusation.
We'd love your feedback. Seriously — bugs, confusing moments, things that felt great, things that didn't. It all helps.
How to Play
Everything happens at your desk. Use the tabs to move between your case file, timeline, terminal (SQL), dashboards, and inbox. Interview suspects, subpoena records, query the database, and build out dashboards as evidence comes in. When you think you've got enough to make it stick — make your case.
A Note from the Dev
This is a passion project built solo/indie, human artwork, music and animations will be included in later builds. When I was learning SQL I found a serious lack of genuinely engaging learning tools, outside youtube tutorials and practice datasets. So the idea was born and i've been trying ever since to make something that blends genuine hands on data use and investigative work with something that's actually fun to play. If you like detective games, data, puzzles, or just appreciate something a little different — give it a shot.
Due to growing interest i've created a discord server. Join the community: https://discord.gg/PYVAJyfMw
| Updated | 21 hours ago |
| Published | 8 days ago |
| Status | Prototype |
| Platforms | HTML5 |
| Author | ChiefKegwin |
| Genre | Simulation, Puzzle |
| Tags | Crime, data-simulator, Detective, Pixel Art, Singleplayer, sql, Walking simulator |
| AI Disclosure | AI Assisted, Code, Graphics |
Development log
- Devlog #2 โ What's Changed & How It Actually Works1 day ago
- demo is live8 days ago





Leave a comment
Log in with itch.io to leave a comment.