SQL DETECTIVE
CASE FILE
Loading case...
TASK:
Loading task...
INVESTIGATION NOTES:
PROGRESS:
Case 1 of 10
Tables Unlocked: 1
RAW SQL EDITOR
Write your own SQL query directly. Full access to all database tables and operations.
This website/app is an unofficial fan-made educational project. It is not affiliated with, endorsed by, sponsored by, or approved by Shogakukan, TMS Entertainment, Yomiuri Telecasting Corporation, or any other rights holders associated with Detective Conan / Case Closed. All trademarks, logos, character names, and related materials are the property of their respective owners. This project is provided free for educational purposes.
METROPOLITAN POLICE — DATABASE DIVISION
"The scenes are Conan's. The proof is yours." — Inspector Megure
ConanSQL is a Detective Conan–styled investigation where you learn SQL by working a real case file. Ten linked missions unlock the police database one table at a time. Each briefing gives you a question; you answer it with a query.
The story begins on a desk blotter in the Mouri Detective Agency: a short code nobody admits to writing. That tip opens a trail through Beika—a black star seal that keeps resurfacing, a courier who only appears when the cameras fail, and a network already hiding in the paperwork under the name BLACK_STAR.
You are the Database Analyst embedded with Conan Edogawa's team. While Conan connects the scenes, you prove them in SQL: SELECT the tip from the case files, filter locations and evidence, JOIN people, suspects, and witnesses, and assemble the final report Megure can put on a desk.
Open the blotter. Follow the trail. Make the network visible.