Repository/Data Access Architecture Lens

Cognitive Mode: Data-Centric Primary Question: "How is data accessed?" Focus: Repository Pattern, Entity Relationships, Query Patterns, Format Conversion

When to Use

• Need to understand data access layer architecture
• Documenting repository pattern implementation
• Analyzing entity relationships and query patterns
• User invokes /autoskillit:arch-lens-repository-access or /autoskillit:make-arch-diag repository

Critical Constraints

NEVER:

• Modify any source code files
• Focus on data flow (that's data lineage lens)
• Include business logic details

ALWAYS:

• Focus on REPOSITORIES and their methods
• Show entity relationships (1:1, 1:N, N:N)
• Document key query patterns
• Identify format conversion boundaries
• BEFORE creating any diagram, LOAD the /autoskillit:mermaid skill using the Skill tool - this is MANDATORY

Analysis Workflow

Step 1: Launch Parallel Exploration Subagents

Spawn Explore subagents to investigate:

Repository Classes

• Find all repository implementations
• Identify base repository patterns
• Look for: Repository classes, DAO (Data Access Object) patterns, base repository abstractions

Entity Models

• Find entity/model classes
• Identify table/collection definitions
• Look for: ORM models (ActiveRecord, Entity Framework, TypeORM, etc.), data models, entity classes

CRUD Operations

• Find standard CRUD methods
• Identify specialized query methods
• Look for: create, get, update, delete, save, find_, get_by_, query methods

Query Patterns

• Find complex queries and joins
• Identify index usage patterns
• Look for: filter, where, join, order_by, group_by, query builders

Factory/Scoping

• Find repository factory patterns
• Identify scope management
• Look for: Factory patterns, dependency injection, session/context management

Format Conversion

• Find adapter/converter patterns
• Identify boundary conversions
• Look for: Adapters, DTOs, to_/from_ methods, serializers, mappers

Step 2: Map Entity Relationships

Document:

• Entities: All model classes
• Relationships: Foreign key relationships, cardinality
• Key Fields: Primary keys, business keys
• Repositories: Which repo manages which entity

CRITICAL - Analyze Read/Write Direction: For EVERY repository method and data access:

• Read methods: get_*, find_*, query_* - data flows OUT of storage
• Write methods: save_*, create_*, update_*, delete_* - data flows INTO storage
• Bulk operations: Direction of each operation in batch

For EVERY caller-to-repository relationship:

• Does the caller READ from this repository?
• Does the caller WRITE to this repository?
• Or both?

Label connections accordingly (reads, writes, reads/writes)

Step 3: Document Access Patterns

Step 4: Create the Diagram

Use flowchart with:

Direction: LR (left-to-right) for caller-to-storage flow

Subgraphs:

• Callers (who uses repositories)
• Factory (repository construction)
• Repositories by Category
• Conversion (format boundaries)
• Storage (database tables)

Node Styling:

• cli class: Callers (nodes, handlers)
• phase class: Factory, scoping
• newComponent class: Repositories (green to highlight)
• handler class: Conversion adapters
• integration class: Database storage

Show Relationships:

• Entity relationships with cardinality (1:N)
• Repository-to-table mapping
• Conversion flow

Step 5: Write Output

Write the diagram to: temp/arch-lens-repository-access/arch_diag_repository_access_{YYYY-MM-DD_HHMMSS}.md (relative to the current working directory)

After writing the diagram file, emit a structured output line:

diagram_path = {absolute_path_to_diagram_file}

Output Template

# Repository/Data Access Diagram: {System Name}

**Lens:** Repository/Data Access (Data-Centric)
**Question:** How is data accessed?
**Date:** {YYYY-MM-DD}
**Scope:** {What was analyzed}

## Repository Overview

| Category | Count | Key Repositories |
|----------|-------|------------------|
| {category} | {N} | {names} |

## Data Access Diagram

```mermaid
%%{init: {'flowchart': {'nodeSpacing': 50, 'rankSpacing': 60, 'curve': 'basis'}}}%%
flowchart LR
    %% CLASS DEFINITIONS %%
    classDef cli fill:#1a237e,stroke:#7986cb,stroke-width:2px,color:#fff;
    classDef stateNode fill:#004d40,stroke:#4db6ac,stroke-width:2px,color:#fff;
    classDef handler fill:#e65100,stroke:#ffb74d,stroke-width:2px,color:#fff;
    classDef phase fill:#6a1b9a,stroke:#ba68c8,stroke-width:2px,color:#fff;
    classDef output fill:#00695c,stroke:#4db6ac,stroke-width:2px,color:#fff;
    classDef integration fill:#c62828,stroke:#ef9a9a,stroke-width:2px,color:#fff;
    classDef newComponent fill:#2e7d32,stroke:#81c784,stroke-width:2px,color:#fff;

    subgraph Callers ["CALLERS"]
        CALLER1["Handler/Service<br/>━━━━━━━━━━<br/>Business logic"]
    end

    subgraph Factory ["REPOSITORY FACTORY"]
        direction TB
        FAC["RepositoryFactory<br/>━━━━━━━━━━<br/>Dependency injection"]
        SCOPE["Scoping<br/>━━━━━━━━━━<br/>Context management"]
    end

    subgraph Repositories ["REPOSITORIES"]
        direction TB
        REPO1["EntityRepository<br/>━━━━━━━━━━<br/>CRUD methods"]
        BASE["BaseRepository<T><br/>━━━━━━━━━━<br/>Generic CRUD"]
    end

    subgraph Conversion ["FORMAT CONVERSION"]
        direction TB
        ADAPTER["Adapters/DTOs<br/>━━━━━━━━━━<br/>Serialization"]
    end

    subgraph Storage ["DATABASE"]
        direction TB
        DB[("Table/Collection<br/>━━━━━━━━━━<br/>Persistent storage")]
    end

    %% FLOW %%
    CALLER1 --> FAC
    FAC --> SCOPE
    SCOPE --> REPO1
    BASE --> REPO1
    REPO1 --> ADAPTER
    ADAPTER --> DB

    %% CLASS ASSIGNMENTS %%
    class CALLER1 cli;
    class FAC,SCOPE phase;
    class REPO1 newComponent;
    class BASE stateNode;
    class ADAPTER handler;
    class DB integration;

Color Legend:

Repository Categories

Key Query Patterns

Entity Relationships

---

## Pre-Diagram Checklist

Before creating the diagram, verify:

- [ ] LOADED `/autoskillit:mermaid` skill using the Skill tool
- [ ] Using ONLY classDef styles from the mermaid skill (no invented colors)
- [ ] Diagram will include a color legend table

---

## Related Skills

- `/autoskillit:make-arch-diag` - Parent skill for lens selection
- `/autoskillit:mermaid` - MUST BE LOADED before creating diagram
- `/autoskillit:arch-lens-data-lineage` - For data flow view
- `/autoskillit:arch-lens-c4-container` - For storage container view