Skip to content

anbeime/skill / skills/diagram-design/skills/diagram-design

diagram-design

Verified

Create branded architecture, architecture delta, IT current-state, flowchart, sequence, state machine, ER/data model, timeline, swimlane, quadrant, radar/spider, polar chart (polar/radial lollipop), loop/flywheel, nested, tree, org chart, layer stack, exploded axonometric, axonometric plan, Venn, pyramid/funnel, treemap and marimekko, heatmap, bar and dumbbell, waterfall, line (slopegraph, ridgeline, streamgraph, bump), Gantt and scatter charts (bubble, beeswarm), high-level, process, medallion, data flow, DP integration, DP security matrix, Sankey, fishbone, Wardley map, kanban, user journey, service blueprint, deployment, dependency graph, UML class, story map, or database schema diagrams as HTML/SVG/PNG, with .drawio, Mermaid, and .excalidraw import, plus lifecycle phase maps, block decomposition trees, and onboarding guidance.

FileKindSize
SKILL.mdskill md30.1 KB
assets/example-architecture-containment-dark.htmlother14.2 KB
assets/example-architecture-containment-full.htmlother17.1 KB
assets/example-architecture-containment.htmlother14.1 KB
assets/example-architecture-dark.htmlother11.8 KB
assets/example-architecture-delta-dark.htmlother20.1 KB
assets/example-architecture-delta-full.htmlother21.7 KB
assets/example-architecture-delta.htmlother20.0 KB
assets/example-architecture-full.htmlother14.6 KB
assets/example-architecture.htmlother11.8 KB
assets/example-axonometric-plan-campus-animated.htmlother46.8 KB
assets/example-axonometric-plan-campus-dark.htmlother30.9 KB
assets/example-axonometric-plan-campus-full.htmlother33.5 KB
assets/example-axonometric-plan-campus.htmlother30.9 KB
assets/example-axonometric-plan-coffee-shop-animated.htmlother54.3 KB
assets/example-axonometric-plan-coffee-shop-dark.htmlother38.6 KB
assets/example-axonometric-plan-coffee-shop-full.htmlother41.2 KB
assets/example-axonometric-plan-coffee-shop.htmlother38.5 KB
assets/example-axonometric-plan-dark.htmlother28.2 KB
assets/example-axonometric-plan-full.htmlother30.6 KB
assets/example-axonometric-plan-warehouse-animated.htmlother53.7 KB
assets/example-axonometric-plan-warehouse-dark.htmlother38.2 KB
assets/example-axonometric-plan-warehouse-full.htmlother40.6 KB
assets/example-axonometric-plan-warehouse.htmlother37.9 KB
assets/example-axonometric-plan.htmlother28.0 KB
assets/example-bar-dark.htmlother8.8 KB
assets/example-bar-full.htmlother11.0 KB
assets/example-bar.htmlother8.7 KB
assets/example-beeswarm-dark.htmlother31.9 KB
assets/example-beeswarm-full.htmlother35.6 KB
assets/example-beeswarm.htmlother31.4 KB
assets/example-bubble-dark.htmlother11.2 KB
assets/example-bubble-full.htmlother14.8 KB
assets/example-bubble.htmlother11.1 KB
assets/example-bump-dark.htmlother12.6 KB
assets/example-bump-full.htmlother16.2 KB
assets/example-bump.htmlother12.5 KB
assets/example-data-flow-dark.htmlother12.7 KB
assets/example-data-flow-full.htmlother15.5 KB
assets/example-data-flow.htmlother12.5 KB
assets/example-datalake-dark.htmlother24.3 KB
assets/example-datalake-full.htmlother27.7 KB
assets/example-datalake.htmlother25.8 KB
assets/example-db-schema-dark.htmlother24.2 KB
assets/example-db-schema-full.htmlother27.0 KB
assets/example-db-schema.htmlother23.9 KB
assets/example-dependency-dark.htmlother17.4 KB
assets/example-dependency-full.htmlother20.6 KB
assets/example-dependency.htmlother17.2 KB
assets/example-deployment-dark.htmlother13.2 KB
assets/example-deployment-full.htmlother16.4 KB
assets/example-deployment.htmlother13.1 KB
assets/example-dp-integration-dark.htmlother14.4 KB
assets/example-dp-integration-full.htmlother16.9 KB
assets/example-dp-integration.htmlother14.4 KB
assets/example-dp-security-matrix-dark.htmlother10.0 KB
assets/example-dp-security-matrix-full.htmlother12.3 KB
assets/example-dp-security-matrix.htmlother10.6 KB
assets/example-er-dark.htmlother13.9 KB
assets/example-er-full.htmlother16.7 KB
assets/example-er.htmlother13.8 KB
assets/example-exploded-ai-stack-animated.htmlother52.2 KB
assets/example-exploded-ai-stack-dark.htmlother35.2 KB
assets/example-exploded-ai-stack-full.htmlother38.0 KB
assets/example-exploded-ai-stack.htmlother35.2 KB
assets/example-exploded-dark.htmlother8.3 KB
assets/example-exploded-full.htmlother11.2 KB
assets/example-exploded-keyboard-animated.htmlother203.4 KB
assets/example-exploded-keyboard-dark.htmlother176.6 KB
assets/example-exploded-keyboard-full.htmlother189.1 KB
assets/example-exploded-keyboard.htmlother186.4 KB
assets/example-exploded-phone-animated.htmlother33.8 KB
assets/example-exploded-phone-dark.htmlother17.0 KB
assets/example-exploded-phone-full.htmlother19.6 KB
assets/example-exploded-phone.htmlother16.9 KB
assets/example-exploded-unboxing-animated.htmlother33.3 KB
assets/example-exploded-unboxing-dark.htmlother16.3 KB
assets/example-exploded-unboxing-full.htmlother18.9 KB
assets/example-exploded-unboxing.htmlother16.3 KB
assets/example-exploded.htmlother8.5 KB
assets/example-fishbone-dark.htmlother8.5 KB
assets/example-fishbone-full.htmlother11.1 KB
assets/example-fishbone.htmlother8.4 KB
assets/example-flowchart-dark.htmlother9.2 KB
assets/example-flowchart-full.htmlother12.0 KB
assets/example-flowchart.htmlother9.2 KB
assets/example-gantt-dark.htmlother10.0 KB
assets/example-gantt-full.htmlother11.6 KB
assets/example-gantt.htmlother9.8 KB
assets/example-heatmap-dark.htmlother17.8 KB
assets/example-heatmap-full.htmlother21.5 KB
assets/example-heatmap.htmlother17.7 KB
assets/example-high-level-dark.htmlother23.5 KB
assets/example-high-level-full.htmlother27.7 KB
assets/example-high-level-vertical-dark.htmlother24.3 KB
assets/example-high-level-vertical-full.htmlother27.9 KB
assets/example-high-level-vertical.htmlother29.7 KB
assets/example-high-level.htmlother26.3 KB
assets/example-import-drawio.htmlother11.8 KB
assets/example-import-excalidraw.htmlother7.5 KB
assets/example-import-mermaid.htmlother7.9 KB
assets/example-it-state-dark.htmlother11.7 KB
assets/example-it-state-full.htmlother13.9 KB
assets/example-it-state.htmlother12.2 KB
assets/example-journey-dark.htmlother8.9 KB
assets/example-journey-full.htmlother11.4 KB
assets/example-journey.htmlother8.9 KB
assets/example-kanban-dark.htmlother10.8 KB
assets/example-kanban-full.htmlother13.6 KB
assets/example-kanban.htmlother10.7 KB
assets/example-layers-dark.htmlother6.8 KB
assets/example-layers-full.htmlother9.8 KB
assets/example-layers.htmlother6.7 KB
assets/example-line-dark.htmlother7.3 KB
assets/example-line-full.htmlother9.8 KB
assets/example-line.htmlother7.3 KB
assets/example-loop-dark.htmlother6.7 KB
assets/example-loop-full.htmlother9.7 KB
assets/example-loop-terminal.htmlother9.8 KB
assets/example-loop.htmlother6.6 KB
assets/example-marimekko-dark.htmlother13.3 KB
assets/example-marimekko-full.htmlother16.6 KB
assets/example-marimekko.htmlother13.2 KB
assets/example-medallion-dark.htmlother12.7 KB
assets/example-medallion-full.htmlother15.5 KB
assets/example-medallion.htmlother12.6 KB
assets/example-nested-dark.htmlother6.6 KB
assets/example-nested-full.htmlother9.6 KB
assets/example-nested.htmlother6.7 KB
assets/example-org-chart-dark.htmlother11.3 KB
assets/example-org-chart-full.htmlother11.8 KB
assets/example-org-chart.htmlother11.3 KB
assets/example-paved-road-animated.htmlother27.7 KB
assets/example-polar-dark.htmlother10.2 KB
assets/example-polar-full.htmlother12.4 KB
assets/example-polar.htmlother10.1 KB
assets/example-policy-trace-animated.htmlother24.9 KB
assets/example-process-dark.htmlother14.7 KB
assets/example-process-full.htmlother17.1 KB
assets/example-process.htmlother14.6 KB
assets/example-pyramid-dark.htmlother6.5 KB
assets/example-pyramid-full.htmlother9.5 KB
assets/example-pyramid.htmlother6.4 KB
assets/example-quadrant-consultant.htmlother11.6 KB
assets/example-quadrant-dark.htmlother6.5 KB
assets/example-quadrant-full.htmlother9.4 KB
assets/example-quadrant.htmlother6.4 KB
assets/example-queue-animated.htmlother29.3 KB
assets/example-radar-dark.htmlother7.5 KB
assets/example-radar-full.htmlother10.2 KB
assets/example-radar.htmlother7.7 KB
assets/example-ridgeline-dark.htmlother10.1 KB
assets/example-ridgeline-full.htmlother13.9 KB
assets/example-ridgeline.htmlother10.0 KB
assets/example-sankey-dark.htmlother8.8 KB
assets/example-sankey-full.htmlother11.5 KB
assets/example-sankey.htmlother8.7 KB
assets/example-scatter-dark.htmlother9.3 KB
assets/example-scatter-full.htmlother11.3 KB
assets/example-scatter.htmlother9.2 KB
assets/example-sequence-dark.htmlother13.5 KB
assets/example-sequence-full.htmlother17.8 KB
assets/example-sequence-oauth-dark.htmlother11.8 KB
assets/example-sequence-oauth-full.htmlother16.2 KB
assets/example-sequence-oauth.htmlother14.0 KB
assets/example-sequence.htmlother13.4 KB
assets/example-service-blueprint-dark.htmlother14.6 KB
assets/example-service-blueprint-full.htmlother19.0 KB
assets/example-service-blueprint.htmlother15.5 KB
assets/example-slopegraph-dark.htmlother10.2 KB
assets/example-slopegraph-full.htmlother13.7 KB
assets/example-slopegraph.htmlother10.1 KB
assets/example-state-dark.htmlother8.5 KB
assets/example-state-full.htmlother11.4 KB
assets/example-state-lifecycle-dark.htmlother9.4 KB
assets/example-state-lifecycle-full.htmlother12.3 KB
assets/example-state-lifecycle.htmlother10.0 KB
assets/example-state.htmlother8.5 KB
assets/example-story-map-dark.htmlother12.0 KB
assets/example-story-map-full.htmlother15.1 KB
assets/example-story-map.htmlother11.9 KB
assets/example-streamgraph-dark.htmlother12.7 KB
assets/example-streamgraph-full.htmlother16.1 KB
assets/example-streamgraph.htmlother12.6 KB
assets/example-swimlane-dark.htmlother10.3 KB
assets/example-swimlane-full.htmlother13.2 KB
assets/example-swimlane.htmlother10.3 KB
assets/example-timeline-dark.htmlother7.2 KB
assets/example-timeline-full.htmlother10.1 KB
assets/example-timeline.htmlother7.2 KB
assets/example-tree-block-decomposition-dark.htmlother8.1 KB
assets/example-tree-block-decomposition-full.htmlother11.4 KB
assets/example-tree-block-decomposition.htmlother8.0 KB
assets/example-tree-dark.htmlother10.8 KB
assets/example-tree-full.htmlother13.7 KB
assets/example-tree.htmlother10.7 KB
assets/example-treemap-dark.htmlother7.5 KB
assets/example-treemap-full.htmlother10.5 KB
assets/example-treemap.htmlother7.4 KB
assets/example-uml-class-dark.htmlother12.1 KB

assets/example-medallion-full.html

View on GitHub
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>E-commerce analytics · Medallion · Full</title>
  <link href="https://fonts.googleapis.com/css2?family=Instrument+Serif:ital@0;1&amp;family=Geist:wght@400;500;600&amp;family=Geist+Mono:wght@400;500;600&amp;display=swap" rel="stylesheet">
  <style>
    *, *::before, *::after { box-sizing: border-box; margin: 0; padding: 0; }
    :root {
      --paper: #f5f5f5; --paper-2: #ececec; --ink: #2d3142; --muted: #4f5d75;
      --soft: #5a6580; --rule: rgba(45,49,66,0.12); --accent: #bf4520;
      --accent-tint: rgba(191,69,32,0.08); --link: #2e5aa8;
      --sans: 'Geist', system-ui, sans-serif; --serif: 'Instrument Serif', serif;
      --mono: 'Geist Mono', ui-monospace, monospace;
    }
    body { min-height: 100vh; padding: 3rem 2rem; background: var(--paper); color: var(--ink); font-family: var(--sans); }
    .container { width: 100%; max-width: 1200px; margin: 0 auto; }
    .eyebrow { margin-bottom: 0.5rem; color: var(--muted); font: 500 0.66rem var(--mono); letter-spacing: 0.18em; text-transform: uppercase; }
    h1 { margin-bottom: 1.5rem; color: var(--ink); font: 400 clamp(1.5rem, 2.4vw + 0.75rem, 2rem)/1.15 var(--serif); letter-spacing: -0.02em; }
    svg { display: block; width: 100%; min-width: 1040px; }
    .tier-title { fill: var(--ink); font: 600 13px var(--sans); text-anchor: middle; }
    .bucket, .field-value, .example-value { fill: var(--muted); font: 400 9px var(--mono); }
    .bucket { text-anchor: middle; }
    .field-value { color: var(--muted); }
    .focal-text { fill: var(--accent); }
    .field-label { fill: var(--ink); font: 600 11px var(--sans); }
    .example-label, .arc-label, .path-tag { font-family: var(--mono); font-weight: 500; letter-spacing: 0.08em; text-transform: uppercase; }
    .example-label { fill: var(--soft); font-size: 8px; }
    .arc-label { font-size: 10px; text-anchor: middle; }
    .path-title { fill: var(--ink); font: 600 11px var(--sans); }
    .path-sub { fill: var(--muted); font: 400 9px var(--mono); }
    .header { margin-bottom: 2.5rem; }
    .header h1 { margin-bottom: 0.5rem; }
    .subtitle { max-width: 62ch; color: var(--muted); font-size: 1rem; line-height: 1.55; }
    .diagram-container { overflow-x: auto; padding: 1.5rem; background: var(--paper-2); border: 1px solid var(--rule); border-radius: 8px; }
    .cards { display: grid; grid-template-columns: 1.1fr 1fr 0.9fr; gap: 1rem; margin-top: 1.5rem; }
    .card { padding: 1.25rem; background: #fff; border: 1px solid var(--rule); border-radius: 6px; }
    .card .card-eyebrow { margin-bottom: 0.5rem; color: var(--muted); font: 500 0.5rem var(--mono); letter-spacing: 0.18em; text-transform: uppercase; }
    .card-header { display: flex; gap: 0.6rem; align-items: center; margin-bottom: 0.875rem; padding-bottom: 0.875rem; border-bottom: 1px solid rgba(45,49,66,0.08); }
    .card-dot { width: 7px; height: 7px; border-radius: 50%; }
    .card-dot.coral { background: var(--accent); } .card-dot.ink { background: var(--ink); } .card-dot.muted { background: var(--muted); }
    .card h2 { font-size: 0.875rem; font-weight: 600; }
    .card p, .card ul { color: var(--muted); font-size: 0.8125rem; line-height: 1.55; list-style: none; }
    .card li { position: relative; margin-bottom: 0.3rem; padding-left: 0.875rem; }
    .card li::before { position: absolute; left: 0; color: rgba(45,49,66,0.25); content: '—'; }
    .footer { display: flex; flex-wrap: wrap; justify-content: space-between; gap: 0.5rem; margin-top: 2rem; padding-top: 1.5rem; color: var(--soft); border-top: 1px solid rgba(45,49,66,0.10); font: 400 0.72rem var(--mono); letter-spacing: 0.06em; }
    @media (max-width: 820px) { .cards { grid-template-columns: 1fr; } }
  </style>
</head>
<body>
  <main class="container">
    <header class="header">
      <p class="eyebrow">Medallion · Diagram Design</p>
      <h1>Five-tier e-commerce analytics storage</h1>
      <p class="subtitle">A quality ladder for clickstream events and order records, from immutable landing data to dashboard-ready metrics and cold retention.</p>
    </header>

    <div class="diagram-container">
    <svg viewBox="0 0 1040 548" xmlns="http://www.w3.org/2000/svg" role="img" aria-labelledby="medallion-full-title medallion-full-desc">
      <title id="medallion-full-title">Five-tier e-commerce analytics medallion</title>
      <desc id="medallion-full-desc">Clickstream events and order records move from raw storage through anonymized, staging, and aggregated tiers before lifecycle archiving.</desc>
      <defs>
        <marker id="arrow" markerWidth="8" markerHeight="6" refX="7" refY="3" orient="auto"><polygon points="0 0, 8 3, 0 6" fill="#4f5d75"/></marker>
        <marker id="arrow-accent" markerWidth="8" markerHeight="6" refX="7" refY="3" orient="auto"><polygon points="0 0, 8 3, 0 6" fill="#bf4520"/></marker>
        <marker id="arrow-link" markerWidth="8" markerHeight="6" refX="7" refY="3" orient="auto"><polygon points="0 0, 8 3, 0 6" fill="#2e5aa8"/></marker>
        <clipPath id="clip-raw"><rect x="16" y="80" width="172" height="380" rx="6"/></clipPath>
        <clipPath id="clip-anon"><rect x="204" y="80" width="172" height="380" rx="6"/></clipPath>
        <clipPath id="clip-stage"><rect x="392" y="80" width="172" height="380" rx="6"/></clipPath>
        <clipPath id="clip-aggregate"><rect x="580" y="80" width="172" height="380" rx="6"/></clipPath>
        <clipPath id="clip-archive"><rect x="768" y="80" width="172" height="380" rx="6"/></clipPath>
      </defs>
      <rect width="1040" height="548" fill="#f5f5f5"/>

      <!-- Promotion arcs are the medallion type's required connector grammar. -->
      <path d="M102 80 C102 0 290 0 290 80" fill="none" stroke="#4f5d75" stroke-width="1.4" marker-end="url(#arrow)"/>
      <path d="M290 80 C290 0 478 0 478 80" fill="none" stroke="#4f5d75" stroke-width="1.4" marker-end="url(#arrow)"/>
      <path d="M478 80 C478 0 666 0 666 80" fill="none" stroke="#bf4520" stroke-width="1.6" marker-end="url(#arrow-accent)"/>
      <path d="M666 80 C666 0 854 0 854 80" fill="none" stroke="#4f5d75" stroke-width="1.4" stroke-dasharray="4,3" marker-end="url(#arrow)"/>
      <text x="196" y="50" class="arc-label" fill="#4f5d75">MASK IDS</text>
      <text x="384" y="50" class="arc-label" fill="#4f5d75">CLEAN + JOIN</text>
      <text x="572" y="50" class="arc-label" fill="#bf4520">AGGREGATE</text>
      <text x="760" y="50" class="arc-label" fill="#4f5d75">LIFECYCLE</text>

      <!-- Raw -->
      <rect x="16" y="80" width="172" height="380" rx="6" fill="#fff"/>
      <rect x="16" y="80" width="172" height="50" fill="rgba(79,93,117,0.10)" clip-path="url(#clip-raw)"/>
      <rect x="16" y="80" width="172" height="380" rx="6" fill="none" stroke="#4f5d75"/>
      <text x="102" y="106" class="tier-title">Raw</text>
      <text x="102" y="144" class="bucket">raw-commerce</text>
      <text x="32" y="180" class="field-label">Tool</text>
      <foreignObject x="32" y="186" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">NiFi ingest</div></foreignObject>
      <text x="32" y="220" class="field-label">Format</text>
      <foreignObject x="32" y="226" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">JSON · Parquet</div></foreignObject>
      <text x="32" y="260" class="field-label">Writer</text>
      <foreignObject x="32" y="266" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">Data Engineer</div></foreignObject>
      <text x="32" y="360" class="example-label">E-COMMERCE EXAMPLE</text>
      <text x="32" y="374" class="example-value">clickstream events</text>
      <text x="32" y="388" class="example-value">order records</text>

      <!-- Anonymized -->
      <rect x="204" y="80" width="172" height="380" rx="6" fill="#fff"/>
      <rect x="204" y="80" width="172" height="50" fill="rgba(45,49,66,0.06)" clip-path="url(#clip-anon)"/>
      <rect x="204" y="80" width="172" height="380" rx="6" fill="none" stroke="#2d3142"/>
      <text x="290" y="106" class="tier-title">Anonymized</text>
      <text x="290" y="144" class="bucket">anon-commerce</text>
      <text x="220" y="180" class="field-label">Tool</text>
      <foreignObject x="220" y="186" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">Trino SQL</div></foreignObject>
      <text x="220" y="220" class="field-label">Format</text>
      <foreignObject x="220" y="226" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">Iceberg · partitioned</div></foreignObject>
      <text x="220" y="260" class="field-label">Writer</text>
      <foreignObject x="220" y="266" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">Data Engineer</div></foreignObject>
      <text x="220" y="360" class="example-label">E-COMMERCE EXAMPLE</text>
      <text x="220" y="374" class="example-value">session pseudonyms</text>
      <text x="220" y="388" class="example-value">masked customer IDs</text>

      <!-- Staging -->
      <rect x="392" y="80" width="172" height="380" rx="6" fill="#fff"/>
      <rect x="392" y="80" width="172" height="50" fill="rgba(45,49,66,0.06)" clip-path="url(#clip-stage)"/>
      <rect x="392" y="80" width="172" height="380" rx="6" fill="none" stroke="#2d3142"/>
      <text x="478" y="106" class="tier-title">Staging</text>
      <text x="478" y="144" class="bucket">staging-commerce</text>
      <text x="408" y="180" class="field-label">Tool</text>
      <foreignObject x="408" y="186" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">Trino · notebooks</div></foreignObject>
      <text x="408" y="220" class="field-label">Format</text>
      <foreignObject x="408" y="226" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">Iceberg · cleaned</div></foreignObject>
      <text x="408" y="260" class="field-label">Writer</text>
      <foreignObject x="408" y="266" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">Data Scientist</div></foreignObject>
      <text x="408" y="360" class="example-label">E-COMMERCE EXAMPLE</text>
      <text x="408" y="374" class="example-value">joined order facts</text>
      <text x="408" y="388" class="example-value">validated event rows</text>

      <!-- Aggregated focal tier -->
      <rect x="580" y="80" width="172" height="380" rx="6" fill="rgba(191,69,32,0.07)"/>
      <rect x="580" y="80" width="172" height="50" fill="rgba(191,69,32,0.14)" clip-path="url(#clip-aggregate)"/>
      <rect x="580" y="80" width="172" height="380" rx="6" fill="none" stroke="#bf4520" stroke-width="1.6"/>
      <text x="666" y="106" class="tier-title">Aggregated</text>
      <text x="666" y="144" class="bucket focal-text">analytics-marts</text>
      <text x="596" y="180" class="field-label">Tool</text>
      <foreignObject x="596" y="186" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">Trino INSERT</div></foreignObject>
      <text x="596" y="220" class="field-label">Format</text>
      <foreignObject x="596" y="226" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">Iceberg · metrics</div></foreignObject>
      <text x="596" y="260" class="field-label">Writer</text>
      <foreignObject x="596" y="266" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">Data Scientist</div></foreignObject>
      <text x="596" y="360" class="example-label">E-COMMERCE EXAMPLE</text>
      <text x="596" y="374" class="example-value focal-text">daily conversion rate</text>
      <text x="596" y="388" class="example-value focal-text">revenue by channel</text>

      <!-- Archive -->
      <rect x="768" y="80" width="172" height="380" rx="6" fill="#ececec"/>
      <rect x="768" y="80" width="172" height="50" fill="rgba(79,93,117,0.18)" clip-path="url(#clip-archive)"/>
      <rect x="768" y="80" width="172" height="380" rx="6" fill="none" stroke="#4f5d75" stroke-dasharray="5,3"/>
      <text x="854" y="106" class="tier-title">Archive</text>
      <text x="854" y="144" class="bucket">archive-commerce</text>
      <text x="784" y="180" class="field-label">Tool</text>
      <foreignObject x="784" y="186" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">Object storage lifecycle</div></foreignObject>
      <text x="784" y="220" class="field-label">Format</text>
      <foreignObject x="784" y="226" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">Cold tier · immutable</div></foreignObject>
      <text x="784" y="260" class="field-label">Writer</text>
      <foreignObject x="784" y="266" width="140" height="24"><div xmlns="http://www.w3.org/1999/xhtml" class="field-value" style="line-height:1.25">Data Engineer</div></foreignObject>
      <text x="784" y="360" class="example-label">E-COMMERCE EXAMPLE</text>
      <text x="784" y="374" class="example-value">retained clickstream</text>
      <text x="784" y="388" class="example-value">closed order snapshots</text>

      <!-- Write-method paths -->
      <rect x="16" y="476" width="460" height="56" rx="6" fill="#fff" stroke="rgba(45,49,66,0.20)"/>
      <rect x="24" y="482" width="64" height="12" rx="2" fill="none" stroke="rgba(45,49,66,0.30)" stroke-width="0.8"/>
      <text x="56" y="491" class="path-tag" fill="#2d3142" font-size="7" text-anchor="middle">SQL PATH</text>
      <text x="96" y="506" class="path-title">Trino INSERT INTO … SELECT</text>
      <text x="96" y="522" class="path-sub">filter · join · aggregate — repeatable transforms</text>
      <rect x="492" y="476" width="460" height="56" rx="6" fill="#fff" stroke="rgba(45,49,66,0.20)"/>
      <rect x="500" y="482" width="96" height="12" rx="2" fill="none" stroke="rgba(45,49,66,0.30)" stroke-width="0.8"/>
      <text x="548" y="491" class="path-tag" fill="#2d3142" font-size="7" text-anchor="middle">NOTEBOOK PATH</text>
      <text x="604" y="506" class="path-title">Python notebooks on object storage</text>
      <text x="604" y="522" class="path-sub">explore · validate · model — interactive analysis</text>
    </svg>
    </div>

    <section class="cards" aria-label="Diagram summary">
      <article class="card">
        <p class="card-eyebrow">THE HEADLINE</p>
        <div class="card-header"><span class="card-dot coral"></span><h2>Aggregated is the query surface</h2></div>
        <p>Dashboards read stable metrics instead of recomputing joins across raw commerce records.</p>
      </article>
      <article class="card">
        <div class="card-header"><span class="card-dot ink"></span><h2>Quality rises by tier</h2></div>
        <ul><li>Identifiers are masked first</li><li>Events and orders are validated</li><li>Metrics are versioned for reuse</li></ul>
      </article>
      <article class="card">
        <div class="card-header"><span class="card-dot muted"></span><h2>Two write modes</h2></div>
        <p>Trino handles repeatable promotion jobs; notebooks support exploration before logic is operationalized.</p>
      </article>
    </section>

    <footer class="footer">
      <span>e-commerce analytics · medallion</span>
      <span>example · schematic skill</span>
    </footer>
  </main>
</body>
</html>
rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit.Stars: 471kUpdated Claude CodeCodexVerifiedInstall
rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure.Stars: 471kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 471kUpdated Claude CodeCodexVerifiedInstall
ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first.Stars: 194kUpdated Claude CodeCodexVerifiedInstall