Skip to content

drafael/coding-harness / skills/diagram-design

diagram-design

Verified

Create branded architecture, 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, Venn, pyramid/funnel, treemap, bar, line, Gantt and scatter charts, high-level, process, medallion, data flow, DP integration, DP security matrix, Sankey, fishbone, Wardley map, kanban, user journey, deployment, dependency graph, UML class, story map, or database schema diagrams as standalone HTML/SVG/PNG. Redraw .drawio/.drawio.png/.drawio.svg or Mermaid .mmd sources at a chosen size/detail; onboard brand tokens from a website; add semantic patterns, callouts, accessible motion, or sketchy/hand-drawn styling.

FileKindSize
LICENSEother1.0 KB
README.mdmarkdown5.6 KB
SKILL.mdskill md38.6 KB
THIRD_PARTY_LICENSES.mdmarkdown2.6 KB
assets/example-architecture-dark.htmlother11.8 KB
assets/example-architecture-full.htmlother14.6 KB
assets/example-architecture.htmlother11.8 KB
assets/example-bar-dark.htmlother8.8 KB
assets/example-bar-full.htmlother11.0 KB
assets/example-bar.htmlother8.7 KB
assets/example-bubble-dark.htmlother11.2 KB
assets/example-bubble-full.htmlother14.8 KB
assets/example-bubble.htmlother11.1 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.1 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.7 KB
assets/example-er-dark.htmlother13.9 KB
assets/example-er-full.htmlother16.7 KB
assets/example-er.htmlother13.8 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.0 KB
assets/example-flowchart-full.htmlother11.9 KB
assets/example-flowchart.htmlother9.0 KB
assets/example-gantt-dark.htmlother10.0 KB
assets/example-gantt-full.htmlother11.6 KB
assets/example-gantt.htmlother9.8 KB
assets/example-high-level-dark.htmlother23.6 KB
assets/example-high-level-full.htmlother27.8 KB
assets/example-high-level-vertical-dark.htmlother24.4 KB
assets/example-high-level-vertical-full.htmlother28.1 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-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.5 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-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.6 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.2 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-slopegraph-dark.htmlother10.2 KB
assets/example-slopegraph-full.htmlother13.6 KB
assets/example-slopegraph.htmlother10.1 KB
assets/example-state-dark.htmlother8.5 KB
assets/example-state-full.htmlother11.4 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-swimlane-dark.htmlother10.3 KB
assets/example-swimlane-full.htmlother13.2 KB
assets/example-swimlane.htmlother10.2 KB
assets/example-timeline-dark.htmlother7.2 KB
assets/example-timeline-full.htmlother10.1 KB
assets/example-timeline.htmlother7.2 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-uml-class-full.htmlother15.3 KB
assets/example-uml-class.htmlother12.1 KB
assets/example-venn-dark.htmlother6.5 KB
assets/example-venn-full.htmlother9.7 KB
assets/example-venn.htmlother5.0 KB
assets/example-wardley-dark.htmlother8.7 KB
assets/example-wardley-full.htmlother11.1 KB
assets/example-wardley.htmlother8.7 KB
assets/icons.htmlother106.0 KB
assets/index.htmlother15.2 KB
assets/template-dark.htmlother3.1 KB
assets/template-full.htmlother22.0 KB
assets/template-motion.htmlother19.4 KB
assets/template-terminal.htmlother4.8 KB
assets/template.htmlother3.2 KB
local-patches/playwright-chromium-discovery.patchother32.2 KB
references/animation.mdmarkdown11.5 KB
references/doctor.mdmarkdown5.4 KB
references/export.mdmarkdown8.3 KB
references/import-drawio.mdmarkdown12.8 KB
references/import-mermaid.mdmarkdown8.7 KB
references/onboarding.mdmarkdown13.5 KB
references/output-spec.mdmarkdown10.9 KB
references/primitive-annotation.mdmarkdown1.7 KB
references/primitive-icons.mdmarkdown103.5 KB
references/primitive-sketchy.mdmarkdown1.7 KB
references/primitive-terminal.mdmarkdown3.8 KB
references/profiles.mdmarkdown13.9 KB
references/semantic-patterns.mdmarkdown10.1 KB
references/style-guide.mdmarkdown8.5 KB
references/type-architecture.mdmarkdown4.9 KB
references/type-bar.mdmarkdown13.3 KB
references/type-data-flow.mdmarkdown20.8 KB
references/type-db-schema.mdmarkdown4.8 KB
references/type-dependency.mdmarkdown4.1 KB
references/type-deployment.mdmarkdown4.1 KB
references/type-dp-integration.mdmarkdown21.7 KB
references/type-dp-security-matrix.mdmarkdown18.6 KB
references/type-er.mdmarkdown1.5 KB
references/type-fishbone.mdmarkdown5.6 KB
references/type-flowchart.mdmarkdown1.1 KB
references/type-gantt.mdmarkdown2.4 KB
references/type-high-level.mdmarkdown26.1 KB
references/type-it-state.mdmarkdown29.3 KB
references/type-journey.mdmarkdown5.0 KB
references/type-kanban.mdmarkdown4.2 KB
references/type-layers.mdmarkdown1.5 KB
references/type-line.mdmarkdown26.8 KB
references/type-loop.mdmarkdown12.3 KB
references/type-medallion.mdmarkdown21.7 KB
references/type-nested.mdmarkdown1.4 KB
references/type-org-chart.mdmarkdown3.0 KB
references/type-polar.mdmarkdown7.6 KB
references/type-process.mdmarkdown27.9 KB
references/type-pyramid.mdmarkdown1.7 KB
references/type-quadrant.mdmarkdown6.1 KB
references/type-radar.mdmarkdown5.5 KB
references/type-sankey.mdmarkdown8.7 KB
references/type-scatter.mdmarkdown11.0 KB
references/type-sequence.mdmarkdown6.5 KB
references/type-state.mdmarkdown1.1 KB
references/type-story-map.mdmarkdown4.7 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: #7a8399; --rule: rgba(45,49,66,0.12); --accent: #eb6c36;
      --accent-tint: rgba(235,108,54,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="#eb6c36"/></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="#eb6c36" 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="#eb6c36">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(235,108,54,0.07)"/>
      <rect x="580" y="80" width="172" height="50" fill="rgba(235,108,54,0.14)" clip-path="url(#clip-aggregate)"/>
      <rect x="580" y="80" width="172" height="380" rx="6" fill="none" stroke="#eb6c36" 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