Claude Code Plugins

Community-maintained marketplace

Feedback

ln-723-mockdata-migrator

@levnikolaevich/claude-code-skills
25
0

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

Install Skill

1Download skill
2Enable skills in Claude

Open claude.ai/settings/capabilities and find the "Skills" section

3Upload to Claude

Click "Upload skill" and select the downloaded ZIP file

Note: Please verify skill by going through its instructions before using it.

SKILL.md

name ln-723-mockdata-migrator
description Migrates 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