👉 Play Free at: https://sqlcasefiles.com
SQL Case Files is a gamified, story-driven way to learn SQL for free. Instead of boring corporate datasets, you solve crimes using real SQL queries against a live SQLite database—right in your browser.
It’s part mystery game, part SQL tutorial, part interactive coding challenge.
If you've ever wished learning SQL felt more like playing a detective RPG than reading documentation… Welcome to the squad.
Traditional SQL learning tools are:
- repetitive
- academic
- disconnected from real-world stakes
Most tutorials teach syntax, not problem-solving.
We fix that. Every challenge in SQL Case Files is a realistic crime investigation powered by real datasets. The only way to solve each case? Write SQL that uncovers clues, exposes lies, and reveals suspects.
If you want a reason to care about your queries, this is it.
In SQL Case Files, you:
- interrogate crime databases using SQL
- follow leads hidden in messy datasets
- uncover motives through JOINs
- identify red flags using aggregates
- expose criminal networks with CTEs and recursive queries
Every clue is a SQL statement. Every mistake has narrative consequences. Every win moves the story forward.
We use WebAssembly to run the real SQLite engine client-side.
- No servers. No accounts. No tracking.
- Instant query results.
- Everything stays on your device.
You get:
- step-by-step hints
- query analysis
- explanations why your SQL works or fails
- adaptive support based on your skill level
Never stuck. Never spoiled.
A full curriculum disguised as a detective campaign.
Each season is a new type of SQL problem disguised as a case file.
| Season | Case Theme | SQL Skills Learned |
|---|---|---|
| 1 | The First Murder | SELECT, WHERE, ORDER BY |
| 2 | Payroll Poisoning | COUNT, GROUP BY, Aggregates |
| 3 | Supply Chain Double Dealer | JOINs (Inner, Left) |
| 4 | Disappearing Cargo | Outer JOINs, NULLs |
| 5 | Market Manipulation | Date/Time functions |
| 6 | Cold Case Files | Subqueries |
| 7 | Ghost Accounts | CASE, conditional logic |
| 8 | Public Doubts | EXISTS, HAVING |
| 9 | Insider Threat | Window functions |
| 10 | The Syndicate Mastermind | CTEs, recursion |
Perfect if you're:
- learning SQL for the first time
- preparing for a tech interview
- brushing up for a data job
- teaching SQL in a classroom
- bored of traditional SQL exercises
SQL Case Files is optimized for learning by doing:
✔ Contextual SQL queries ✔ Realistic datasets ✔ Narrative motivation ✔ Instant feedback ✔ Zero setup ✔ Completely free
Users consistently report absorbing SQL concepts faster because the story keeps them emotionally engaged.
SQL Case Files is created by @darpanbhadra, built with:
- WebAssembly
- SQLite
- TypeScript
- A custom AI assistant
- A carefully designed 10-season investigative storyline