Ghost in the SQL Data

Paris becomes a database of alibis, timestamps, and overlooked connections in this detective puzzler built around real SQL queries. Ghost in the SQL Data turns criminal investigations into hands-on data work, asking you to comb through a year of emergency-switchboard calls to untangle cases involving a school fire, an anonymous Metro ticket, and a stolen crown from the Musée d’Orsay. Its tone is more methodical than action-heavy: every breakthrough comes from reading evidence carefully and asking the system the right question. Rather than merely selecting dialogue choices, you reconstruct the truth from records that initially look like an impenetrable mass of information.

Each investigation begins with a crime and a focused question, then gives you access to datasets filled with calls, people, locations, and other potentially relevant details. You write SQL commands to search tables, narrow results with filters, compare dates and times, and join separate records into useful leads. Early cases teach core concepts such as selecting columns and applying conditions, while later mysteries expect you to interpret clues and build the necessary queries with far less guidance. Findings can be pinned to an investigator’s board alongside notes and visual charts, where connecting evidence transforms raw results into a coherent accusation.

What makes the format work is that SQL is not treated as dry homework; it becomes the actual detective tool, with every query feeling like a new line of inquiry. The case board gives the experience a satisfying point-and-click investigation rhythm, while the database structure rewards patience, logical thinking, and a willingness to test assumptions. Players who enjoy Return of the Obra Dinn’s deduction, Case of the Golden Idol’s evidence chains, or programming puzzles with a practical purpose should find plenty to like here. It is especially well suited to newcomers who want to learn SQL through structured problems, but experienced users can appreciate the increasingly open-ended cases and the pleasure of solving them efficiently.