How fvossebeld/tailspin-toys-agent-skills-workshop works
Tailspin Toys is a statically rendered crowdfunding-game catalog. Visitors browse game listings and details; the home catalog supports browser-side category and minimum-rating filters that can be shared in the URL. Data is seeded from CSV into local SQLite, then read through the Drizzle data-access layer for page rendering. The graph also preserves database migration and catalog-export capabilities. Page and component internals were not sampled, so their finer call relationships are omitted; documented README relationships are cited where used.
Main entry points: games.ts Game queries · db.ts SQLite adapter · seed.ts Seed process · export-catalog.ts Catalog export
Components 16
Catalog website
- Astro pages
src/pages - Catalog components
src/components - Filter helpers
src/lib/game-filters.ts - Rating helpers
src/lib/ratings.ts
Catalog data
- Game types
src/types/game.ts - Game queries
src/lib/games.ts - SQLite adapter
src/lib/db.ts - Catalog schema
db/schema.ts - Local SQLite
Database operations
- Seed catalog
db/games.csv - Seed transforms
db/transforms.ts - Seed process
db/seed.ts - Migration process
db/migrate.ts
Catalog export
- Catalog export
db/export-catalog.ts - Grounding JSON
Other components
- Visitor
Connections 17
- Visitor → Astro pages: browses
README.md - Astro pages → Catalog components: renders
README.md - Astro pages → Game queries: queries games
README.md - Catalog components → Filter helpers: filters catalog
README.md - Filter helpers → Rating helpers: clamps ratings
src/lib/game-filters.ts - Game queries → SQLite adapter: queries through
src/lib/games.ts - Game queries → Catalog schema: selects tables
src/lib/games.ts - Game queries → Game types: returns games
src/lib/games.ts - SQLite adapter → Catalog schema: configures Drizzle
src/lib/db.ts - SQLite adapter → Local SQLite: executes SQL
src/lib/db.ts - Seed process → Seed catalog: reads rows
db/seed.ts - Seed process → Seed transforms: parses and maps
db/seed.ts - Seed process → SQLite adapter: writes records
db/seed.ts - Migration process → SQLite adapter: runs migrations
db/migrate.ts - Catalog export → Game queries: loads games
db/export-catalog.ts - Catalog export → Rating helpers: formats ratings
db/export-catalog.ts - Catalog export → Grounding JSON: writes JSON
db/export-catalog.ts