# fvossebeld/tailspin-toys-agent-skills-workshop architecture

> Architecture diagram of the GitHub repository fvossebeld/tailspin-toys-agent-skills-workshop, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-02). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/fvossebeld/tailspin-toys-agent-skills-workshop
- Repository: https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop

## Overview

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: [`src/lib/games.ts`](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/src/lib/games.ts) (Game queries), [`src/lib/db.ts`](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/src/lib/db.ts) (SQLite adapter), [`db/seed.ts`](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/seed.ts) (Seed process), [`db/export-catalog.ts`](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/export-catalog.ts) (Catalog export)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_web["Catalog website"]
  node_pages["Astro pages"]
  node_ui["Catalog components"]
  node_filters["Filter helpers<br/>[game-filters.ts]"]
  node_ratings["Rating helpers<br/>[ratings.ts]"]
end

subgraph group_data["Catalog data"]
  node_types["Game types<br/>[game.ts]"]
  node_access["Game queries<br/>[games.ts]"]
  node_adapter["SQLite adapter<br/>[db.ts]"]
  node_schema["Catalog schema<br/>[schema.ts]"]
  node_sqlite[("Local SQLite")]
end

subgraph group_ops["Database operations"]
  node_csv["Seed catalog<br/>[games.csv]"]
  node_transforms["Seed transforms<br/>[transforms.ts]"]
  node_seed["Seed process<br/>[seed.ts]"]
  node_migrate["Migration process<br/>[migrate.ts]"]
end

subgraph group_export["Catalog export"]
  node_exporter["Catalog export<br/>[export-catalog.ts]"]
  node_grounding["Grounding JSON"]
end

node_visitor(("Visitor"))

node_visitor -->|"browses"| node_pages
node_pages -.->|"renders"| node_ui
node_pages -->|"queries games"| node_access
node_ui -->|"filters catalog"| node_filters
node_filters -->|"clamps ratings"| node_ratings
node_access -->|"queries through"| node_adapter
node_access -->|"selects tables"| node_schema
node_access -->|"returns games"| node_types
node_adapter -->|"configures Drizzle"| node_schema
node_adapter -->|"executes SQL"| node_sqlite
node_seed -->|"reads rows"| node_csv
node_seed -->|"parses and maps"| node_transforms
node_seed -->|"writes records"| node_adapter
node_migrate -->|"runs migrations"| node_adapter
node_exporter -->|"loads games"| node_access
node_exporter -->|"formats ratings"| node_ratings
node_exporter -->|"writes JSON"| node_grounding

click node_pages "https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/tree/main/src/pages"
click node_ui "https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/tree/main/src/components"
click node_filters "https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/src/lib/game-filters.ts"
click node_ratings "https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/src/lib/ratings.ts"
click node_types "https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/src/types/game.ts"
click node_access "https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/src/lib/games.ts"
click node_adapter "https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/src/lib/db.ts"
click node_schema "https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/schema.ts"
click node_csv "https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/games.csv"
click node_transforms "https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/transforms.ts"
click node_seed "https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/seed.ts"
click node_migrate "https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/migrate.ts"
click node_exporter "https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/export-catalog.ts"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_pages,node_ui,node_filters,node_ratings toneBlue
class node_types,node_access,node_adapter,node_schema,node_sqlite toneAmber
class node_csv,node_transforms,node_seed,node_migrate toneMint
class node_exporter,node_grounding toneRose
class node_visitor toneIndigo
```

## Components

### Catalog website

- [Astro pages](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/tree/main/src/pages): `src/pages`
- [Catalog components](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/tree/main/src/components): `src/components`
- [Filter helpers](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/src/lib/game-filters.ts): `src/lib/game-filters.ts`
- [Rating helpers](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/src/lib/ratings.ts): `src/lib/ratings.ts`

### Catalog data

- [Game types](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/src/types/game.ts): `src/types/game.ts`
- [Game queries](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/src/lib/games.ts): `src/lib/games.ts`
- [SQLite adapter](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/src/lib/db.ts): `src/lib/db.ts`
- [Catalog schema](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/schema.ts): `db/schema.ts`
- **Local SQLite**

### Database operations

- [Seed catalog](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/games.csv): `db/games.csv`
- [Seed transforms](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/transforms.ts): `db/transforms.ts`
- [Seed process](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/seed.ts): `db/seed.ts`
- [Migration process](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/migrate.ts): `db/migrate.ts`

### Catalog export

- [Catalog export](https://github.com/fvossebeld/tailspin-toys-agent-skills-workshop/blob/main/db/export-catalog.ts): `db/export-catalog.ts`
- **Grounding JSON**

### Other components

- **Visitor**

## Connections

- Visitor → Astro pages: browses (evidence: `README.md`)
- Astro pages → Catalog components: renders (evidence: `README.md`)
- Astro pages → Game queries: queries games (evidence: `README.md`)
- Catalog components → Filter helpers: filters catalog (evidence: `README.md`)
- Filter helpers → Rating helpers: clamps ratings (evidence: `src/lib/game-filters.ts`)
- Game queries → SQLite adapter: queries through (evidence: `src/lib/games.ts`)
- Game queries → Catalog schema: selects tables (evidence: `src/lib/games.ts`)
- Game queries → Game types: returns games (evidence: `src/lib/games.ts`)
- SQLite adapter → Catalog schema: configures Drizzle (evidence: `src/lib/db.ts`)
- SQLite adapter → Local SQLite: executes SQL (evidence: `src/lib/db.ts`)
- Seed process → Seed catalog: reads rows (evidence: `db/seed.ts`)
- Seed process → Seed transforms: parses and maps (evidence: `db/seed.ts`)
- Seed process → SQLite adapter: writes records (evidence: `db/seed.ts`)
- Migration process → SQLite adapter: runs migrations (evidence: `db/migrate.ts`)
- Catalog export → Game queries: loads games (evidence: `db/export-catalog.ts`)
- Catalog export → Rating helpers: formats ratings (evidence: `db/export-catalog.ts`)
- Catalog export → Grounding JSON: writes JSON (evidence: `db/export-catalog.ts`)
