ln-723-mockdata-migrator

Migrates mock data from Drizzle ORM schemas to C# MockData classes

⭐25stars🔀7forks📁View on GitHub🕐Updated Jan 10, 2026

When & Why to Use This Skill

The ln-723-mockdata-migrator is a specialized Claude skill designed to automate the transformation of ORM schemas (including Drizzle, Prisma, and TypeORM) into C# MockData classes. It streamlines the development workflow by generating type-safe, realistic sample data and static accessor methods, ensuring seamless data mocking for .NET applications while maintaining complex foreign key relationships.

Use Cases

  • Rapid Prototyping: Quickly bootstrap .NET backend services with realistic static data before the physical database is fully implemented.
  • Automated Testing: Generate consistent, relationship-aware mock datasets for unit and integration tests to ensure high code coverage and reliability.
  • Cross-Stack Development: Seamlessly migrate data structures from TypeScript-based ORMs to C# entities when building companion .NET microservices or porting systems.
  • Frontend-Backend Decoupling: Provide frontend teams with a stable C# mock data source to develop against while the real API logic is still under construction.
  • Realistic Data Seeding: Replace generic random strings with domain-appropriate sample data that follows C# naming conventions and strict type safety.
nameln-723-mockdata-migrator
descriptionMigrates mock data from Drizzle ORM schemas to C# MockData classes

ln-723-mockdata-migrator

Type: L3 Worker Category: 7XX Project Bootstrap Parent: ln-720-structure-migrator

Migrates mock data from ORM schemas to .NET MockData classes with realistic sample data.


Purpose & Scope

Aspect Description
Input ORM schema files (Drizzle, Prisma, TypeORM)
Output C# MockData static classes
Primary ORM Drizzle (others supported)

Scope boundaries:

  • Parses ORM schema definitions
  • Generates C# entities and MockData classes
  • Creates realistic sample data
  • Does not generate database migrations or EF Core configs

Workflow

Phase Name Actions Output
1 Parse Schema Read ORM file, extract table definitions Entity model
2 Map Types Apply type mapping rules, detect nullable C# type definitions
3 Generate MockData Create static class, generate sample data MockData.cs files
4 Verify Compile check, relationship validation Valid C# code

Phase 1: Parse Schema

Extract entity definitions from ORM schema.

Step Action Reference
1.1 Locate schema file(s) —
1.2 Identify ORM type (Drizzle/Prisma/TypeORM) Detect by syntax
1.3 Extract table definitions drizzle_patterns.md
1.4 Extract column definitions drizzle_patterns.md
1.5 Identify constraints (PK, FK, nullable) drizzle_patterns.md
1.6 Extract enum definitions drizzle_patterns.md

Output: Entity model with columns, types, and constraints.


Phase 2: Map Types

Convert ORM types to C# types.

Step Action Reference
2.1 Map column types to C# type_mapping.md
2.2 Determine nullable status type_mapping.md
2.3 Identify primary keys type_mapping.md
2.4 Map foreign keys relationship_mapping.md
2.5 Transform names (snake_case → PascalCase) drizzle_patterns.md

Type mapping summary:

ORM Type C# Type Nullable Rule
uuid Guid No (PK), Depends (FK)
varchar string Check .notNull()
integer int No
boolean bool No
timestamp DateTime Depends

Phase 3: Generate MockData

Create C# MockData class with sample data.

Step Action Reference
3.1 Create MockData class data_generation.md
3.2 Generate GUIDs for entities data_generation.md
3.3 Generate sample data per field data_generation.md
3.4 Ensure FK relationships valid relationship_mapping.md
3.5 Create accessor methods data_generation.md

Generation order by dependency:

Order Entity Type Generate After
1 Root entities (no FK) First
2 First-level children Parents exist
3 Second-level children Grandparents exist
N Deepest children All ancestors exist

Phase 4: Verify

Validate generated code.

Check Method Expected
Syntax valid Compile check No errors
FKs valid Cross-reference All FKs point to existing IDs
Types correct Type analysis Proper C# types
Names follow convention Pattern check PascalCase

Supported ORM Detection

ORM Detection Pattern
Drizzle pgTable(), mysqlTable(), sqliteTable()
Prisma model X { syntax
TypeORM @Entity(), @Column() decorators

Entity Transformation Rules

Source Target Transformation
Table name (plural, snake) Class name (singular, Pascal) user_profiles → UserProfile
Column name (snake) Property name (Pascal) created_at → CreatedAt
Enum name Enum type (Pascal) status_enum → StatusEnum
FK column Navigation property user_id → UserId

MockData Class Structure

Component Purpose
Private static list Holds immutable mock data
GetAll() method Returns full list as IEnumerable
GetById(Guid id) Finds single entity by ID
GetBy{FK}Id(Guid id) Filters by foreign key

Sample Data Guidelines

Field Type Sample Count Distribution
Root entities 3-5 items Varied status/priority
Child entities 5-10 items Distributed across parents
Leaf entities 10-20 items Realistic variety

Critical Rules

  • Single Responsibility: Generate only MockData, no database code
  • Idempotent: Can re-run to regenerate
  • Valid Relationships: All FKs must reference existing parent IDs
  • Realistic Data: Use domain-appropriate values, not random strings
  • Generation Order: Parents before children
  • Consistent GUIDs: Use fixed GUIDs for reproducibility

Definition of Done

  • Schema file parsed successfully
  • All tables/entities extracted
  • Type mappings applied correctly
  • MockData class generated per feature/entity group
  • Sample data includes 5-10 items per entity
  • Foreign keys reference valid parent IDs
  • Accessor methods generated (GetAll, GetById)
  • Code compiles without errors

Risk Mitigation

Risk Detection Mitigation
Parse failure Exception during parse Support multiple schema formats
Invalid type mapping Unknown ORM type Log warning, use string as fallback
FK mismatch FK references non-existent ID Generate parents first, validate after
Name collision Duplicate class names Prefix with feature name
Circular references Self-referencing with cycles Limit depth, validate graph

Reference Files

File Purpose
references/type_mapping.md ORM to C# type conversion rules
references/drizzle_patterns.md Drizzle schema parsing patterns
references/data_generation.md Realistic sample data patterns
references/relationship_mapping.md FK handling and generation order

Version: 2.0.0 Last Updated: 2026-01-10