# hristo2612/SQLNoir

Solve mysteries through SQL.

Repository: https://github.com/hristo2612/SQLNoir
Canonical: https://ross.abutalabs.com/products/sqlnoir
Homepage: https://sqlnoir.com
Language: TypeScript
License: MIT
License Family: permissive
Last push: 2026-07-07T15:38:38+00:00

## Health v2 (maintenance only)
Score: 61/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 91, release rhythm 35, longevity 41
- inputs: {"age_days": 575, "days_push": 57, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1644, forks 65 (observed 2026-08-28T04:05:16.106211+00:00)

## What it is
SQLNoir is an interactive browser-based game where players solve detective mysteries by writing SQL queries against case databases. It is built with Next.js and Supabase, featuring a built-in SQL workspace powered by SQL.js, story-driven cases of varying difficulty, and XP-based progression.

## Use cases
- learn SQL by solving detective mysteries
- practice SQL joins and subqueries through story-driven cases
- prepare for data analyst interviews with realistic querying scenarios
- teach SQL in classrooms without environment setup
- gamified SQL practice with XP progression

## When to choose
- you want a fun, narrative-driven way to practice SQL fundamentals
- you are a student or analyst who learns better through interactive challenges than textbooks
- you are an instructor seeking engaging, zero-setup SQL exercises

## When to avoid
- you need a comprehensive SQL reference or full database course
- you require advanced database administration or production SQL skills training
- you need offline answer validation

## Facets
- artifact type: application
- maturity: active
- function: database, game
- domain: education, databases, developer-tools, gaming-tools
- platform: -
- tags: sql-learning, detective-game, interactive-learning, sql-practice, nextjs, supabase, sqljs, gamification, education, web, nodejs

## Member repositories
- hristo2612/SQLNoir (main) score 61

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:16.106211+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:45:49.710309+00:00, confidence not recorded.
  - readme: https://github.com/hristo2612/SQLNoir (fetched 2026-08-28T04:05:16.106211+00:00, sha b27190ea04bd)
  - homepage: https://sqlnoir.com (fetched 2026-08-29T11:19:17.054339+00:00, sha aa38b9ea13ad)
  - site_page: https://www.sqlnoir.com/faq (fetched 2026-08-29T11:19:17.063876+00:00, sha 7b47e9b2b0f5)
- Data as of 2026-08-30T08:39:29.467469+00:00.
