Description
SQLNoir is an interactive game that teaches SQL by having you solve crimes. You step into a smoky 1980s detective agency, question suspects by writing SQL queries against a database, and work out the culprit one statement at a time. Every clue is hidden in the data, so you use SELECT, filters, joins, grouping and subqueries to expose the answer, with harder cases introducing more advanced SQL as you go. A built-in SQL workspace runs in the browser, so there is no setup: you open a case and start digging. You earn detective XP as you solve cases, and a journal keeps track of your notes. You can open and solve cases without an account, and signing in lets you track XP, progress and solved cases across devices. Three starter cases are free, and the rest unlock with a one-time Detective License, which the site describes as a single lifetime purchase rather than a subscription. The project is on GitHub.…
Highlights
- Learn SQL by solving detective cases
- Built-in SQL workspace in the browser
- Cases from simple SELECT to joins and subqueries
- XP and a detective's journal
- Three free starter cases
Ratings & Reviews
No ratings yet
Be the first to rate SQLNoir.
People also visit
SQLNoir FAQ
Do I need an account?
No. You can open and solve cases without one. Signing in tracks your XP and progress across devices.
Is it free?
Three starter cases are free to play. The remaining cases unlock with a one-time Detective License, which the site describes as a lifetime purchase rather than a subscription.
What SQL do I need to know?
Beginners start with simple SELECT statements, and harder cases introduce joins, grouping, filters and subqueries.
What if I get stuck?
The site has a FAQ entry on what to do when you are stuck on a case.
What are the best SQLNoir alternatives?
Popular alternatives to SQLNoir include SQL Police Department, Lost at SQL and Animate SQL. See all SQLNoir alternatives




