Repository Structure

Information architecture designed for discoverability, governance, and long-term maintainability.

sql/

Curated SQL entrypoint with domain categories and promoted scripts.

sandbox/

Exploration and historical script inventory prior to promotion.

docs/

GitHub Pages site including search explorer and write-up pages.

tools/

Automation scripts including SQL catalog/index generation.

.github/

Issue templates, workflows, quality checks, and repo automation.

Promotion Workflow

  1. Draft and validate SQL in sandbox.
  2. Promote high-value scripts into the sql curated categories.
  3. Run the index generator to refresh search metadata.
  4. Submit PR with quality checks and index drift validation.

Indexing Pipeline

tools/build-sql-index.ps1 scans all SQL files, assigns categories/tags, and writes docs/data/sql-index.json, which powers SQL Explorer.