Murder Mystery LLM

paused

A murder mystery solved in SQL, with an AI detective reviewing every query.

Tech Stack

ReactViteNode.jsExpressPostgreSQLOpenAI

Meet Watson

An AI detective that reviews every SQL query and drops hints, in character.

What it is
The Luna Park murder: 12 tables, 260 timestamped records, red herrings, and a solution that takes at least six joins. Nobody finished it, including me.
Watson
Catches syntax errors and nudges toward better queries, all in character as a 1920s detective. “Elementary, my dear querier. Your JOIN syntax appears... questionable.”
The trick
Replies print word by word, which sells the illusion that Watson is thinking through the query.
Stack
React, Vite, Node, Express, PostgreSQL, GPT-4o-mini.