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-db-schema-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>Commerce schema · database schema</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: 1240px; 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: 960px; display: block; }
  </style>
</head>
<body>
  <div class="frame">
    <p class="eyebrow">Database schema · Diagram Design</p>
    <h1>Commerce schema · public + billing</h1>

    <svg viewBox="0 0 1080 560" xmlns="http://www.w3.org/2000/svg" role="img" aria-labelledby="db-schema-dark-title db-schema-dark-desc">
      <title id="db-schema-dark-title">Commerce schema · public + billing</title>
      <desc id="db-schema-dark-desc">Physical database schema diagram showing five commerce tables with column-level foreign keys, SQL types, and constraint chips, including a cascading delete from orders into order_items and a billing schema group.</desc>
      <defs>
        <marker id="arrow" markerWidth="8" markerHeight="6" refX="7" refY="3" orient="auto"><polygon points="0 0, 8 3, 0 6" fill="#bfc0c0"/></marker>
        <marker id="arrow-accent" markerWidth="8" markerHeight="6" refX="7" refY="3" orient="auto"><polygon points="0 0, 8 3, 0 6" fill="#f08a59"/></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>
      </defs>

      <rect width="100%" height="100%" fill="#2d3142"/>

      <!-- BILLING schema group (drawn first so tables paint over it) -->
      <rect x="744" y="332" width="272" height="152" rx="8" fill="rgba(245,245,245,0.02)" stroke="rgba(245,245,245,0.20)" stroke-width="0.8" stroke-dasharray="4,4"/>
      <text x="756" y="348" fill="#bfc0c0" font-size="8" font-family="'Geist Mono', monospace" letter-spacing="0.14em">BILLING</text>

      <!-- FK connectors (drawn before boxes) -->
      <!-- FK1: orders.customer_id -> customers.id · ON DELETE RESTRICT -->
      <path d="M 400,104 H 348 Q 340,104 340,112 Q 340,120 332,120 H 280" fill="none" stroke="#bfc0c0" stroke-width="1" marker-end="url(#arrow)"/>
      <!-- FK2: order_items.order_id -> orders.id · ON DELETE CASCADE (focal) -->
      <path d="M 640,384 H 660 Q 668,384 668,376 V 96 Q 668,88 660,88 H 640" fill="none" stroke="#f08a59" stroke-width="1.2" marker-end="url(#arrow-accent)"/>
      <!-- FK3: order_items.product_id -> products.id · ON DELETE RESTRICT -->
      <path d="M 640,408 H 708 Q 716,408 716,400 V 88 Q 716,80 724,80 H 760" fill="none" stroke="#bfc0c0" stroke-width="1" marker-end="url(#arrow)"/>
      <!-- FK4: invoices.order_id -> orders.id · ON DELETE RESTRICT -->
      <path d="M 760,432 H 700 Q 692,432 692,424 V 416 a 8,8 0 0,0 0,-16 V 80 Q 692,72 684,72 H 640" fill="none" stroke="#bfc0c0" stroke-width="1" marker-end="url(#arrow)"/>

      <!-- FK labels (masked, 6-10px gap above/beside their connector) -->
      <rect x="284" y="82" width="112" height="12" rx="2" fill="#2d3142"/>
      <text x="340" y="91" fill="#bfc0c0" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle" letter-spacing="0.06em">ON DELETE RESTRICT</text>

      <rect x="572" y="274" width="88" height="12" rx="2" fill="#2d3142"/>
      <text x="616" y="283" fill="#f08a59" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle" letter-spacing="0.06em">ON DELETE CASCADE</text>

      <rect x="724" y="252" width="112" height="12" rx="2" fill="#2d3142"/>
      <text x="780" y="261" fill="#bfc0c0" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle" letter-spacing="0.06em">ON DELETE RESTRICT</text>

      <rect x="644" y="440" width="112" height="12" rx="2" fill="#2d3142"/>
      <text x="700" y="449" fill="#bfc0c0" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle" letter-spacing="0.06em">ON DELETE RESTRICT</text>

      <!-- Table: public.customers -->
      <rect x="40" y="80" width="240" height="100" rx="6" fill="#393e53" stroke="#f5f5f5" stroke-width="1"/>
      <rect x="40" y="80" width="240" height="28" rx="6" fill="rgba(245,245,245,0.04)" stroke="none"/>
      <rect x="40" y="100" width="240" height="8" fill="rgba(245,245,245,0.04)"/>
      <line x1="40" y1="108" x2="280" y2="108" stroke="rgba(245,245,245,0.22)" stroke-width="1"/>
      <text x="52" y="98" fill="#f5f5f5" font-size="12" font-weight="600" font-family="'Geist', sans-serif">public.customers</text>
      <rect x="228" y="88" width="40" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.40)" stroke-width="0.8"/>
      <text x="248" y="97" fill="#f5f5f5" opacity="0.8" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle" letter-spacing="0.08em">TABLE</text>

      <rect x="40" y="108" width="240" height="24" fill="rgba(245,245,245,0.02)"/>
      <text x="52" y="124" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">id</text>
      <rect x="160" y="116" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="170" y="125" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">PK</text>
      <text x="268" y="124" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>

      <text x="52" y="148" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">email</text>
      <rect x="160" y="140" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="170" y="149" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">UQ</text>
      <rect x="184" y="140" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="194" y="149" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="268" y="148" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">text</text>

      <rect x="40" y="156" width="240" height="24" fill="rgba(245,245,245,0.02)"/>
      <text x="52" y="172" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">created_at</text>
      <rect x="160" y="164" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="170" y="173" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="268" y="172" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">timestamptz</text>

      <!-- Table: public.orders -->
      <rect x="400" y="40" width="240" height="200" rx="6" fill="#393e53" stroke="#f5f5f5" stroke-width="1"/>
      <rect x="400" y="40" width="240" height="28" rx="6" fill="rgba(245,245,245,0.04)" stroke="none"/>
      <rect x="400" y="60" width="240" height="8" fill="rgba(245,245,245,0.04)"/>
      <line x1="400" y1="68" x2="640" y2="68" stroke="rgba(245,245,245,0.22)" stroke-width="1"/>
      <text x="412" y="58" fill="#f5f5f5" font-size="12" font-weight="600" font-family="'Geist', sans-serif">public.orders</text>
      <rect x="588" y="48" width="40" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.40)" stroke-width="0.8"/>
      <text x="608" y="57" fill="#f5f5f5" opacity="0.8" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle" letter-spacing="0.08em">TABLE</text>

      <rect x="400" y="68" width="240" height="24" fill="rgba(245,245,245,0.02)"/>
      <text x="412" y="84" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">id</text>
      <rect x="520" y="76" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="530" y="85" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">PK</text>
      <text x="628" y="84" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>

      <text x="412" y="108" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">customer_id</text>
      <rect x="520" y="100" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="530" y="109" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">FK</text>
      <rect x="544" y="100" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="554" y="109" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="628" y="108" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>

      <rect x="400" y="116" width="240" height="24" fill="rgba(245,245,245,0.02)"/>
      <text x="412" y="132" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">status</text>
      <rect x="520" y="124" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="530" y="133" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="628" y="132" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">text</text>

      <text x="412" y="156" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">total</text>
      <rect x="520" y="148" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="530" y="157" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="628" y="156" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">numeric(12,2)</text>

      <rect x="400" y="164" width="240" height="24" fill="rgba(245,245,245,0.02)"/>
      <text x="412" y="180" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">placed_at</text>
      <rect x="520" y="172" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="530" y="181" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="628" y="180" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">timestamptz</text>

      <line x1="400" y1="188" x2="640" y2="188" stroke="rgba(245,245,245,0.12)" stroke-width="0.8"/>
      <text x="412" y="202" fill="#bfc0c0" font-size="8" font-family="'Geist Mono', monospace" letter-spacing="0.14em">INDEXES</text>
      <text x="412" y="220" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace">idx_orders_customer_id</text>
      <text x="412" y="236" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace">idx_orders_status</text>

      <!-- Table: public.order_items (focal header — accent-tint, cascade target) -->
      <rect x="400" y="320" width="240" height="148" rx="6" fill="#393e53" stroke="#f5f5f5" stroke-width="1"/>
      <rect x="400" y="320" width="240" height="28" rx="6" fill="rgba(240,138,89,0.08)" stroke="none"/>
      <rect x="400" y="340" width="240" height="8" fill="rgba(240,138,89,0.08)"/>
      <line x1="400" y1="348" x2="640" y2="348" stroke="rgba(245,245,245,0.22)" stroke-width="1"/>
      <text x="412" y="338" fill="#f5f5f5" font-size="12" font-weight="600" font-family="'Geist', sans-serif">public.order_items</text>
      <rect x="588" y="328" width="40" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.40)" stroke-width="0.8"/>
      <text x="608" y="337" fill="#f5f5f5" opacity="0.8" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle" letter-spacing="0.08em">TABLE</text>

      <rect x="400" y="348" width="240" height="24" fill="rgba(245,245,245,0.02)"/>
      <text x="412" y="364" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">id</text>
      <rect x="520" y="356" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="530" y="365" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">PK</text>
      <text x="628" y="364" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>

      <text x="412" y="388" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">order_id</text>
      <rect x="520" y="380" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="530" y="389" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">FK</text>
      <rect x="544" y="380" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="554" y="389" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="628" y="388" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>

      <rect x="400" y="396" width="240" height="24" fill="rgba(245,245,245,0.02)"/>
      <text x="412" y="412" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">product_id</text>
      <rect x="520" y="404" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="530" y="413" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">FK</text>
      <rect x="544" y="404" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="554" y="413" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="628" y="412" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>

      <text x="412" y="436" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">qty</text>
      <rect x="520" y="428" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="530" y="437" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="628" y="436" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">integer</text>

      <rect x="400" y="444" width="240" height="24" fill="rgba(245,245,245,0.02)"/>
      <text x="412" y="460" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">unit_price</text>
      <rect x="520" y="452" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="530" y="461" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="628" y="460" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">numeric(12,2)</text>

      <!-- Table: public.products -->
      <rect x="760" y="40" width="240" height="184" rx="6" fill="#393e53" stroke="#f5f5f5" stroke-width="1"/>
      <rect x="760" y="40" width="240" height="28" rx="6" fill="rgba(245,245,245,0.04)" stroke="none"/>
      <rect x="760" y="60" width="240" height="8" fill="rgba(245,245,245,0.04)"/>
      <line x1="760" y1="68" x2="1000" y2="68" stroke="rgba(245,245,245,0.22)" stroke-width="1"/>
      <text x="772" y="58" fill="#f5f5f5" font-size="12" font-weight="600" font-family="'Geist', sans-serif">public.products</text>
      <rect x="948" y="48" width="40" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.40)" stroke-width="0.8"/>
      <text x="968" y="57" fill="#f5f5f5" opacity="0.8" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle" letter-spacing="0.08em">TABLE</text>

      <rect x="760" y="68" width="240" height="24" fill="rgba(245,245,245,0.02)"/>
      <text x="772" y="84" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">id</text>
      <rect x="880" y="76" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="890" y="85" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">PK</text>
      <text x="988" y="84" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>

      <text x="772" y="108" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">sku</text>
      <rect x="880" y="100" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="890" y="109" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">UQ</text>
      <rect x="904" y="100" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="914" y="109" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="988" y="108" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">text</text>

      <rect x="760" y="116" width="240" height="24" fill="rgba(245,245,245,0.02)"/>
      <text x="772" y="132" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">name</text>
      <rect x="880" y="124" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="890" y="133" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="988" y="132" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">text</text>

      <text x="772" y="156" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">price</text>
      <rect x="880" y="148" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="890" y="157" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="988" y="156" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">numeric(12,2)</text>

      <rect x="760" y="164" width="240" height="24" fill="rgba(245,245,245,0.02)"/>
      <text x="772" y="180" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace">+ 3 more columns</text>

      <line x1="760" y1="188" x2="1000" y2="188" stroke="rgba(245,245,245,0.12)" stroke-width="0.8"/>
      <text x="772" y="202" fill="#bfc0c0" font-size="8" font-family="'Geist Mono', monospace" letter-spacing="0.14em">INDEXES</text>
      <text x="772" y="220" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace">uq_products_sku</text>

      <!-- Table: billing.invoices (inside BILLING group) -->
      <rect x="760" y="368" width="240" height="100" rx="6" fill="#393e53" stroke="#f5f5f5" stroke-width="1"/>
      <rect x="760" y="368" width="240" height="28" rx="6" fill="rgba(245,245,245,0.04)" stroke="none"/>
      <rect x="760" y="388" width="240" height="8" fill="rgba(245,245,245,0.04)"/>
      <line x1="760" y1="396" x2="1000" y2="396" stroke="rgba(245,245,245,0.22)" stroke-width="1"/>
      <text x="772" y="386" fill="#f5f5f5" font-size="12" font-weight="600" font-family="'Geist', sans-serif">billing.invoices</text>
      <rect x="948" y="376" width="40" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.40)" stroke-width="0.8"/>
      <text x="968" y="385" fill="#f5f5f5" opacity="0.8" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle" letter-spacing="0.08em">TABLE</text>

      <rect x="760" y="396" width="240" height="24" fill="rgba(245,245,245,0.02)"/>
      <text x="772" y="412" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">id</text>
      <rect x="880" y="404" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="890" y="413" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">PK</text>
      <text x="988" y="412" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>

      <text x="772" y="436" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">order_id</text>
      <rect x="880" y="428" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="890" y="437" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">FK</text>
      <rect x="904" y="428" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="914" y="437" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="988" y="436" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">uuid</text>

      <rect x="760" y="444" width="240" height="24" fill="rgba(245,245,245,0.02)"/>
      <text x="772" y="460" fill="#f5f5f5" font-size="12" font-family="'Geist', sans-serif">issued_at</text>
      <rect x="880" y="452" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="890" y="461" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">NN</text>
      <text x="988" y="460" fill="#bfc0c0" font-size="9" font-family="'Geist Mono', monospace" text-anchor="end">timestamptz</text>

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

      <rect x="40" y="532" width="20" height="12" rx="2" fill="#393e53" stroke="#f5f5f5" stroke-width="1"/>
      <text x="68" y="540" fill="#bfc0c0" font-size="8.5" font-family="'Geist', sans-serif">Table</text>

      <rect x="180" y="532" width="20" height="12" rx="2" fill="rgba(245,245,245,0.02)" stroke="rgba(245,245,245,0.35)" stroke-width="0.8" stroke-dasharray="3,3"/>
      <text x="208" y="540" fill="#bfc0c0" font-size="8.5" font-family="'Geist', sans-serif">Schema group</text>

      <rect x="340" y="532" width="20" height="12" rx="2" fill="none" stroke="rgba(245,245,245,0.35)" stroke-width="0.8"/>
      <text x="350" y="541" fill="#f5f5f5" opacity="0.75" font-size="8" font-family="'Geist Mono', monospace" text-anchor="middle">PK</text>
      <text x="368" y="540" fill="#bfc0c0" font-size="8.5" font-family="'Geist', sans-serif">Constraint chip</text>

      <line x1="500" y1="538" x2="520" y2="538" stroke="#bfc0c0" stroke-width="1"/>
      <text x="528" y="540" fill="#bfc0c0" font-size="8.5" font-family="'Geist', sans-serif">Foreign key (column to column)</text>

      <line x1="740" y1="538" x2="760" y2="538" stroke="#f08a59" stroke-width="1.2"/>
      <text x="768" y="540" fill="#bfc0c0" font-size="8.5" font-family="'Geist', sans-serif">Destructive delete (CASCADE)</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