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-er-dark.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>Content platform · ER model</title>
  <link href="https://fonts.googleapis.com/css2?family=Instrument+Serif:ital@0;1&family=Geist:wght@400;500;600&family=Geist+Mono:wght@400;500;600&display=swap" rel="stylesheet">
  <style>
    *, *::before, *::after { box-sizing: border-box; margin: 0; padding: 0; }
    :root {
      --color-paper:   #2d3142;
      --color-ink:     #f5f5f5;
      --color-muted:   #bfc0c0;
      --color-accent:  #f08a59;
      --font-sans:     'Geist', system-ui, sans-serif;
      --font-serif:    'Instrument Serif', serif;
      --font-mono:     'Geist Mono', ui-monospace, monospace;
    }

    body {
      font-family: var(--font-sans);
      background: var(--color-paper);
      color: var(--color-ink);
      min-height: 100vh;
      display: flex;
      align-items: center;
      justify-content: center;
      padding: 3rem 2rem;
    }

    .frame { max-width: 1200px; width: 100%; }

    .eyebrow {
      font-family: var(--font-mono);
      font-size: 0.66rem;
      font-weight: 500;
      letter-spacing: 0.18em;
      text-transform: uppercase;
      color: var(--color-muted);
      margin-bottom: 0.5rem;
    }

    h1 {
      font-family: var(--font-serif);
      font-size: clamp(1.5rem, 2.4vw + 0.75rem, 2rem);
      font-weight: 400;
      letter-spacing: -0.02em;
      line-height: 1.15;
      color: var(--color-ink);
      margin-bottom: 1.5rem;
    }

    svg { width: 100%; min-width: 900px; display: block; }
  </style>
</head>
<body>
  <div class="frame">
    <p class="eyebrow">ER · Diagram Design</p>
    <h1>Content platform · data model</h1>

    <svg viewBox="0 0 1000 480" xmlns="http://www.w3.org/2000/svg" role="img" aria-labelledby="er-dark-title er-dark-desc">
      <title id="er-dark-title">Content platform · data model</title>
      <desc id="er-dark-desc">Entity-relationship diagram showing authors writing articles and articles connecting to tags and categories.</desc>
        <defs>
          <pattern id="dots" width="22" height="22" patternUnits="userSpaceOnUse">
            <circle cx="1" cy="1" r="0.9" fill="rgba(245,245,245,0.10)"/>
          </pattern>
          <marker id="arrow" markerWidth="8" markerHeight="6" refX="7" refY="3" orient="auto"><polygon points="0 0, 8 3, 0 6" fill="#bfc0c0"/></marker>
        </defs>

        <rect width="100%" height="100%" fill="#2d3142"/>
        <rect width="100%" height="100%" fill="url(#dots)" opacity="0.55"/>

        <!-- Relationship lines (drawn first) -->
        <!-- 1. Author — Article (1:N "writes") -->
        <line x1="260" y1="240" x2="400" y2="240" stroke="#bfc0c0" stroke-width="1" />
        <!-- 2. Article — ArticleTag (1:N) -->
        <path d="M 640,320 H 702 Q 710,320 710,328 H 780" fill="none" stroke="#bfc0c0" stroke-width="1"/>
        <!-- 3. Tag — ArticleTag (1:N, vertical) -->
        <line x1="880" y1="248" x2="880" y2="280" stroke="#bfc0c0" stroke-width="1" />

        <!-- Cardinality labels -->
        <rect x="266" y="232" width="12" height="12" rx="2" fill="#2d3142"/>
        <text x="272" y="242" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="middle" font-weight="600">1</text>

        <rect x="378" y="232" width="16" height="12" rx="2" fill="#2d3142"/>
        <text x="386" y="242" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="middle" font-weight="600">N</text>

        <rect x="646" y="316" width="12" height="12" rx="2" fill="#2d3142"/>
        <text x="652" y="326" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="middle" font-weight="600">1</text>

        <rect x="760" y="324" width="16" height="12" rx="2" fill="#2d3142"/>
        <text x="768" y="334" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="middle" font-weight="600">N</text>

        <rect x="872" y="252" width="16" height="12" rx="2" fill="#2d3142"/>
        <text x="880" y="262" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="middle" font-weight="600">1</text>

        <rect x="872" y="268" width="16" height="12" rx="2" fill="#2d3142"/>
        <text x="880" y="278" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="middle" font-weight="600">N</text>

        <!-- Relationship labels -->
        <rect x="304" y="220" width="56" height="14" rx="2" fill="#2d3142"/>
        <text x="332" y="230" fill="#bfc0c0" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle" letter-spacing="0.12em">WRITES</text>

        <rect x="688" y="300" width="56" height="14" rx="2" fill="#2d3142"/>
        <text x="716" y="310" fill="#bfc0c0" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle" letter-spacing="0.12em">TAGGED</text>

        <!-- Entity: Author -->
        <rect x="60" y="160" width="200" height="160" rx="6" fill="#393e53" stroke="#f5f5f5" stroke-width="1"/>
        <rect x="60" y="160" width="200" height="40" rx="6" fill="rgba(245,245,245,0.04)" stroke="none"/>
        <rect x="60" y="192" width="200" height="8" fill="rgba(245,245,245,0.04)"/>
        <line x1="60" y1="200" x2="260" y2="200" stroke="rgba(245,245,245,0.22)" stroke-width="1"/>
        <text x="76" y="176" fill="#bfc0c0" font-size="8" font-family="'Geist Mono', monospace" letter-spacing="0.14em">ENTITY</text>
        <text x="76" y="192" fill="#f5f5f5" font-size="14" font-weight="600" font-family="'Geist', sans-serif">Author</text>
        <text x="76" y="220" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace"># id</text>
        <text x="220" y="220" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>
        <text x="76" y="240" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">handle</text>
        <text x="220" y="240" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">text</text>
        <text x="76" y="260" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">name</text>
        <text x="220" y="260" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">text</text>
        <text x="76" y="280" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">bio</text>
        <text x="220" y="280" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">text</text>
        <text x="76" y="300" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">site_url</text>
        <text x="220" y="300" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">text</text>

        <!-- Entity: Article (focal coral) -->
        <rect x="400" y="120" width="240" height="240" rx="6" fill="rgba(240,138,89,0.04)" stroke="#f08a59" stroke-width="1"/>
        <rect x="400" y="120" width="240" height="40" rx="6" fill="rgba(240,138,89,0.10)" stroke="none"/>
        <rect x="400" y="152" width="240" height="8" fill="rgba(240,138,89,0.10)"/>
        <line x1="400" y1="160" x2="640" y2="160" stroke="rgba(240,138,89,0.40)" stroke-width="1"/>
        <text x="416" y="136" fill="#f08a59" font-size="8" font-family="'Geist Mono', monospace" letter-spacing="0.14em">ENTITY · AGGREGATE ROOT</text>
        <text x="416" y="152" fill="#f5f5f5" font-size="14" font-weight="600" font-family="'Geist', sans-serif">Article</text>
        <text x="416" y="180" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace"># id</text>
        <text x="600" y="180" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>
        <text x="416" y="200" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">title</text>
        <text x="600" y="200" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">text</text>
        <text x="416" y="220" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">slug</text>
        <text x="600" y="220" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">text · unique</text>
        <text x="416" y="240" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">body_mdx</text>
        <text x="600" y="240" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">text</text>
        <text x="416" y="260" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">published_at</text>
        <text x="600" y="260" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">timestamp</text>
        <text x="416" y="280" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">→ author_id</text>
        <text x="600" y="280" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>
        <text x="416" y="300" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">status</text>
        <text x="600" y="300" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">enum</text>
        <text x="416" y="320" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">og_image</text>
        <text x="600" y="320" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">text · url</text>

        <!-- Entity: Tag -->
        <rect x="780" y="120" width="200" height="128" rx="6" fill="#393e53" stroke="#f5f5f5" stroke-width="1"/>
        <rect x="780" y="120" width="200" height="40" rx="6" fill="rgba(245,245,245,0.04)" stroke="none"/>
        <rect x="780" y="152" width="200" height="8" fill="rgba(245,245,245,0.04)"/>
        <line x1="780" y1="160" x2="980" y2="160" stroke="rgba(245,245,245,0.22)" stroke-width="1"/>
        <text x="796" y="136" fill="#bfc0c0" font-size="8" font-family="'Geist Mono', monospace" letter-spacing="0.14em">ENTITY</text>
        <text x="796" y="152" fill="#f5f5f5" font-size="14" font-weight="600" font-family="'Geist', sans-serif">Tag</text>
        <text x="796" y="180" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace"># id</text>
        <text x="940" y="180" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>
        <text x="796" y="200" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">slug</text>
        <text x="940" y="200" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">text · unique</text>
        <text x="796" y="220" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">name</text>
        <text x="940" y="220" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">text</text>
        <text x="796" y="240" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">description</text>
        <text x="940" y="240" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">text</text>

        <!-- Entity: ArticleTag (join) -->
        <rect x="780" y="280" width="200" height="96" rx="6" fill="rgba(245,245,245,0.04)" stroke="#bfc0c0" stroke-width="1" stroke-dasharray="4,3"/>
        <rect x="780" y="280" width="200" height="40" rx="6" fill="rgba(245,245,245,0.06)" stroke="none"/>
        <rect x="780" y="312" width="200" height="8" fill="rgba(245,245,245,0.06)"/>
        <line x1="780" y1="320" x2="980" y2="320" stroke="rgba(245,245,245,0.22)" stroke-width="1"/>
        <text x="796" y="296" fill="#bfc0c0" font-size="8" font-family="'Geist Mono', monospace" letter-spacing="0.14em">JOIN</text>
        <text x="796" y="312" fill="#f5f5f5" font-size="14" font-weight="600" font-family="'Geist', sans-serif">ArticleTag</text>
        <text x="796" y="340" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">→ article_id</text>
        <text x="940" y="340" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>
        <text x="796" y="360" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace">→ tag_id</text>
        <text x="940" y="360" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>

        <!-- Legend -->
        <line x1="40" y1="404" x2="960" y2="404" stroke="rgba(245,245,245,0.10)" stroke-width="0.8"/>
        <text x="40" y="420" fill="#bfc0c0" font-size="8" font-family="'Geist Mono', monospace" letter-spacing="0.18em">LEGEND</text>

        <rect x="40" y="436" width="14" height="10" rx="2" fill="rgba(240,138,89,0.04)" stroke="#f08a59" stroke-width="1"/>
        <text x="60" y="444" fill="#bfc0c0" font-size="8.5" font-family="'Geist', sans-serif">Aggregate root</text>

        <rect x="180" y="436" width="14" height="10" rx="2" fill="#393e53" stroke="#f5f5f5" stroke-width="1"/>
        <text x="200" y="444" fill="#bfc0c0" font-size="8.5" font-family="'Geist', sans-serif">Entity</text>

        <rect x="268" y="436" width="14" height="10" rx="2" fill="rgba(245,245,245,0.04)" stroke="#bfc0c0" stroke-width="1" stroke-dasharray="3,2"/>
        <text x="288" y="444" fill="#bfc0c0" font-size="8.5" font-family="'Geist', sans-serif">Join table</text>

        <text x="372" y="444" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace" font-weight="600">#</text>
        <text x="388" y="444" fill="#bfc0c0" font-size="8.5" font-family="'Geist', sans-serif">Primary key</text>

        <text x="476" y="444" fill="#f5f5f5" font-size="10" font-family="'Geist Mono', monospace" font-weight="600">→</text>
        <text x="492" y="444" fill="#bfc0c0" font-size="8.5" font-family="'Geist', sans-serif">Foreign key</text>

        <text x="584" y="444" fill="#bfc0c0" font-size="10" font-family="'Geist Mono', monospace" font-weight="600">1 / N</text>
        <text x="616" y="444" fill="#bfc0c0" font-size="8.5" font-family="'Geist', sans-serif">Cardinality</text>
      </svg>
  </div>
</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