Name: seed
Author: TheSethRose

Prompt file imported from TheSethRose/Parakeet-Realtime-Transcriber (.github/prompts/seed.prompt.md). Copyright stays with the author.

Database Seeding & Test Data Management

Apply the general coding guidelines to all database seeding operations.

Command: /seed

Purpose

Comprehensive database seeding with development, testing, and demo data to support various environments and testing scenarios while maintaining data consistency and referential integrity.

Usage

/seed [environment] [options]

Examples:

/seed development --full-dataset
/seed testing --minimal-data
/seed demo --showcase-features
/seed performance --large-dataset
/seed clean --reset-and-reseed

Methodology

1. Seeding Strategy Framework

Environment-Specific Seeding

Development: Rich, realistic data for development workflow
Testing: Controlled, predictable data for automated tests
Staging: Production-like data for integration testing
Demo: Curated data showcasing application features
Performance: Large datasets for performance testing

Data Categories

Core Data: Essential system data (roles, permissions, settings)
Reference Data: Static lookup data (countries, categories, etc.)
User Data: Sample users, profiles, and authentication data
Business Data: Application-specific entities and relationships
Test Data: Specific scenarios for automated testing

2. Seeding Commands

Basic Seeding Operations

# Seed all environments
npm run db:seed

# Environment-specific seeding
npm run db:seed:dev
npm run db:seed:test
npm run db:seed:staging
npm run db:seed:demo

# Selective seeding
npm run db:seed --tables=users,products
npm run db:seed --categories=core,reference

Advanced Seeding

# Generate large datasets
npm run db:seed:performance --size=large

# Seed with custom data
npm run db:seed:custom --file=custom-data.json

# Incremental seeding
npm run db:seed:incremental

# Seed reset and refresh
npm run db:seed:reset
npm run db:seed:refresh

3. Data Generation Framework

Realistic Data Generation

interface SeedDataGenerator {
  users: UserSeedGenerator;
  products: ProductSeedGenerator;
  orders: OrderSeedGenerator;
  reviews: ReviewSeedGenerator;
}

interface UserSeedGenerator {
  generateUsers(count: number): User[];
  generateProfiles(): UserProfile[];
  generatePreferences(): UserPreferences[];
}

// Example data generation
const generateRealisticUsers = (count: number): User[] => {
  return Array.from({ length: count }, () => ({
    id: faker.datatype.uuid(),
    email: faker.internet.email(),
    firstName: faker.name.firstName(),
    lastName: faker.name.lastName(),
    avatar: faker.image.avatar(),
    createdAt: faker.date.between("2020-01-01", new Date()),
    isActive: faker.datatype.boolean(),
    role: faker.helpers.arrayElement(["user", "admin", "moderator"]),
  }));
};

Relationship Management

interface RelationshipSeeder {
  seedUserOrders(users: User[]): Order[];
  seedProductReviews(products: Product[], users: User[]): Review[];
  seedCategoryProducts(categories: Category[]): Product[];
  ensureReferentialIntegrity(): void;
}

4. Seed Data Organization

Directory Structure

seeds/
├── core/                 # Essential system data
│   ├── roles.json
│   ├── permissions.json
│   └── settings.json
├── reference/            # Static lookup data
│   ├── countries.json
│   ├── categories.json
│   └── currencies.json
├── development/          # Development environment data
│   ├── users.dev.json
│   ├── products.dev.json
│   └── orders.dev.json
├── testing/              # Test-specific data
│   ├── users.test.json
│   ├── scenarios/
│   └── fixtures/
├── demo/                 # Demo presentation data
│   ├── showcase.json
│   └── features.json
└── generators/           # Data generation scripts
    ├── user-generator.ts
    ├── product-generator.ts
    └── order-generator.ts

Seed File Format

{
  "metadata": {
    "version": "1.0.0",
    "environment": ["development", "testing"],
    "dependencies": ["core/roles.json"],
    "description": "Sample user data for development"
  },
  "data": {
    "users": [
      {
        "id": "user_001",
        "email": "john.doe@example.com",
        "firstName": "John",
        "lastName": "Doe",
        "role": "admin"
      }
    ]
  }
}

5. Seeding Execution Pipeline

Pre-Seeding Validation

# Validate seed data integrity
npm run db:seed:validate

# Check database schema compatibility
npm run db:seed:check-schema

# Verify dependencies and order
npm run db:seed:validate-deps

# Test data generation
npm run db:seed:test-generation

Seeding Process

# Execute seeding pipeline
npm run db:seed:pipeline

# Monitor seeding progress
npm run db:seed:monitor

# Verify seeding results
npm run db:seed:verify

# Generate seeding report
npm run db:seed:report

6. Data Consistency & Integrity

Referential Integrity

class SeedIntegrityManager {
  validateForeignKeys(): ValidationResult;
  ensureUniqueConstraints(): void;
  checkDataConsistency(): ConsistencyReport;
  repairInconsistencies(): RepairResult;
}

Data Validation

# Validate seeded data
npm run db:seed:validate-data

# Check business rules compliance
npm run db:seed:validate-rules

# Verify data relationships
npm run db:seed:validate-relationships

# Test data accessibility
npm run db:seed:test-access

7. Performance Considerations

Bulk Operations

interface BulkSeedOperations {
  bulkInsertUsers(users: User[], batchSize?: number): Promise<void>;
  bulkInsertProducts(products: Product[]): Promise<void>;
  bulkUpdateRelationships(): Promise<void>;
  optimizeForPerformance(): void;
}

Large Dataset Handling

# Generate large datasets efficiently
npm run db:seed:bulk --size=10000

# Streaming data insertion
npm run db:seed:stream --file=large-dataset.json

# Parallel seeding
npm run db:seed:parallel --workers=4

# Memory-optimized seeding
npm run db:seed:memory-optimized

8. Testing Support

Test Data Scenarios

interface TestScenarios {
  userRegistrationFlow: TestData;
  orderProcessingFlow: TestData;
  paymentFailureScenario: TestData;
  adminWorkflowTest: TestData;
  edgeCaseScenarios: TestData[];
}

Fixture Management

# Generate test fixtures
npm run db:seed:fixtures

# Load scenario-specific data
npm run db:seed:scenario --name=payment-flow

# Reset to clean test state
npm run db:seed:test-reset

# Seed specific test cases
npm run db:seed:test-case --id=TC001

9. Environment Management

Development Environment

# Rich development data
npm run db:seed:dev:full

# Minimal development data
npm run db:seed:dev:minimal

# User-specific development data
npm run db:seed:dev:user --email=developer@company.com

Production-like Data

# Generate production-scale data
npm run db:seed:prod-like --scale=medium

# Anonymized production data
npm run db:seed:anonymized

# Compliance-safe seeding
npm run db:seed:gdpr-compliant

10. Monitoring & Reporting

Seeding Metrics

interface SeedingMetrics {
  recordsInserted: Record<string, number>;
  executionTime: number;
  memoryUsage: number;
  errorCount: number;
  warningCount: number;
  validationResults: ValidationSummary;
}

Seed Report Format

## Database Seeding Report

### Summary

- Environment: [target environment]
- Execution Time: [duration]
- Records Processed: [total count]
- Success Rate: [percentage]
- Status: [success/partial/failed]

### Data Categories

| Category       | Records | Status     | Notes   |
| -------------- | ------- | ---------- | ------- |
| Core Data      | [count] | ✅ Success | [notes] |
| Reference Data | [count] | ✅ Success | [notes] |
| User Data      | [count] | ⚠️ Warning | [notes] |

### Performance Metrics

- Total Execution Time: [duration]
- Average Insert Rate: [records/second]
- Memory Peak Usage: [MB]
- Database Size After Seeding: [MB]

### Validation Results

- Referential Integrity: [✅/❌]
- Unique Constraints: [✅/❌]
- Business Rules: [✅/❌]
- Data Quality Score: [percentage]

### Issues & Warnings

- [List any issues encountered]
- [List any warnings or recommendations]

### Next Steps

- [Recommended actions or follow-ups]

11. Automation & Scheduling

Automated Seeding

# GitHub Actions workflow
name: Database Seeding
on:
  schedule:
    - cron: "0 6 * * 1" # Weekly on Monday
  workflow_dispatch:
    inputs:
      environment:
        description: "Target environment"
        required: true
        default: "development"

jobs:
  seed:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v3
      - run: npm run db:seed:${{ github.event.inputs.environment }}

CI/CD Integration

# Pre-test seeding
npm run db:seed:test:before

# Post-deployment seeding
npm run db:seed:staging:after

# Development environment refresh
npm run db:seed:dev:refresh

Implementation Workflow

1. Setup Phase

# Initialize seeding infrastructure
npm run db:seed:init

# Create seed templates
npm run db:seed:templates

# Configure environments
npm run db:seed:config

2. Data Preparation

# Generate seed data
npm run db:seed:generate

# Validate seed files
npm run db:seed:validate

# Test data generation
npm run db:seed:test

3. Execution Phase

# Execute seeding
npm run db:seed:execute

# Monitor progress
npm run db:seed:monitor

# Verify results
npm run db:seed:verify

Success Criteria

All target environments successfully seeded with appropriate data
Data integrity and referential consistency maintained
Seeding performance meets acceptable thresholds
Test scenarios have reliable, predictable data
Development workflow supported with realistic data
Documentation covers all seeding procedures
Automation reduces manual seeding overhead
Rollback and cleanup procedures are tested and documented

Install seed and it becomes one more candidate the router can pick - when it fits.

A listing is a routing target with a manifest: what it does, which domains it covers, what it costs and who publishes it. Once installed it sits beside your own models and tools, is scored like any other candidate for each request, and shows up in the trace when it wins. Ratings come from workspaces that installed it, one per account.

# Database Seeding & Test Data Management Apply the [general coding guidelines](./general.instructions.md) to all database seeding operations. **Command:** `/seed` ## Purpose Comprehensive database seeding with development, testing, and demo data to support various environments and testing scenarios while maintaining data consistency and referential integrity. ## Usage ``` /seed [environment] [options] ``` **Examples:** - `/seed development --full-dataset` - `/seed testing --minimal-data` - `/seed demo --showcase-features` - `/seed performance --large-dataset` - `/seed clean --reset-and-reseed` ## Methodology ### 1. Seeding Strategy Framework #### Environment-Specific Seeding - **Development**: Rich, realistic data for development workflow - **Testing**: Controlled, predictable data for automated tests - **Staging**: Production-like data for integration testing - **Demo**: Curated data showcasing application features - **Performance**: Large datasets for performance testing #### Data Categories - **Core Data**: Essential system data (roles, permissions, settings) - **Reference Data**: Static lookup data (countries, categories, etc.) - **User Data**: Sample users, profiles, and authentication data - **Business Data**: Application-specific entities and relationships - **Test Data**: Specific scenarios for automated testing ### 2. Seeding Commands #### Basic Seeding Operations ```bash # Seed all environments npm run db:seed # Environment-specific seeding npm run db:seed:dev npm run db:seed:test npm run db:seed:staging npm run db:seed:demo # Selective seeding npm run db:seed --tables=users,products npm run db:seed --categories=core,reference ``` #### Advanced Seeding ```bash # Generate large datasets npm run db:seed:performance --size=large # Seed with custom data npm run db:seed:custom --file=custom-data.json # Incremental seeding npm run db:seed:incremental # Seed reset and refresh npm run db:seed:reset npm run db:seed:refresh ``` ### 3. Data Generation Framework #### Realistic Data Generation ```typescript interface SeedDataGenerator { users: UserSeedGenerator; products: ProductSeedGenerator; orders: OrderSeedGenerator; reviews: ReviewSeedGenerator; } interface UserSeedGenerator { generateUsers(count: number): User[]; generateProfiles(): UserProfile[]; generatePreferences(): UserPreferences[]; } // Example data generation const generateRealisticUsers = (count: number): User[] => { return Array.from({ length: count }, () => ({ id: faker.datatype.uuid(), email: faker.internet.email(), firstName: faker.name.firstName(), lastName: faker.name.lastName(), avatar: faker.image.avatar(), createdAt: faker.date.between("2020-01-01", new Date()), isActive: faker.datatype.boolean(), role: faker.helpers.arrayElement(["user", "admin", "moderator"]), })); }; ``` #### Relationship Management ```typescript interface RelationshipSeeder { seedUserOrders(users: User[]): Order[]; seedProductReviews(products: Product[], users: User[]): Review[]; seedCategoryProducts(categories: Category[]): Product[]; ensureReferentialIntegrity(): void; } ``` ### 4. Seed Data Organization #### Directory Structure ``` seeds/ ├── core/ # Essential system data │ ├── roles.json │ ├── permissions.json │ └── settings.json ├── reference/ # Static lookup data │ ├── countries.json │ ├── categories.json │ └── currencies.json ├── development/ # Development environment data │ ├── users.dev.json │ ├── products.dev.json │ └── orders.dev.json ├── testing/ # Test-specific data │ ├── users.test.json │ ├── scenarios/ │ └── fixtures/ ├── demo/ # Demo presentation data │ ├── showcase.json │ └── features.json └── generators/ # Data generation scripts ├── user-generator.ts ├── product-generator.ts └── order-generator.ts ``` #### Seed File Format ```json { "metadata": { "version": "1.0.0", "environment": ["development", "testing"], "dependencies": ["core/roles.json"], "description": "Sample user data for development" }, "data": { "users": [ { "id": "user_001", "email": "john.doe@example.com", "firstName": "John", "lastName": "Doe", "role": "admin" } ] } } ``` ### 5. Seeding Execution Pipeline #### Pre-Seeding Validation ```bash # Validate seed data integrity npm run db:seed:validate # Check database schema compatibility npm run db:seed:check-schema # Verify dependencies and order npm run db:seed:validate-deps # Test data generation npm run db:seed:test-generation ``` #### Seeding Process ```bash # Execute seeding pipeline npm run db:seed:pipeline # Monitor seeding progress npm run db:seed:monitor # Verify seeding results npm run db:seed:verify # Generate seeding report npm run db:seed:report ``` ### 6. Data Consistency & Integrity #### Referential Integrity ```typescript class SeedIntegrityManager { validateForeignKeys(): ValidationResult; ensureUniqueConstraints(): void; checkDataConsistency(): ConsistencyReport; repairInconsistencies(): RepairResult; } ``` #### Data Validation ```bash # Validate seeded data npm run db:seed:validate-data # Check business rules compliance npm run db:seed:validate-rules # Verify data relationships npm run db:seed:validate-relationships # Test data accessibility npm run db:seed:test-access ``` ### 7. Performance Considerations #### Bulk Operations ```typescript interface BulkSeedOperations { bulkInsertUsers(users: User[], batchSize?: number): Promise<void>; bulkInsertProducts(products: Product[]): Promise<void>; bulkUpdateRelationships(): Promise<void>; optimizeForPerformance(): void; } ``` #### Large Dataset Handling ```bash # Generate large datasets efficiently npm run db:seed:bulk --size=10000 # Streaming data insertion npm run db:seed:stream --file=large-dataset.json # Parallel seeding npm run db:seed:parallel --workers=4 # Memory-optimized seeding npm run db:seed:memory-optimized ``` ### 8. Testing Support #### Test Data Scenarios ```typescript interface TestScenarios { userRegistrationFlow: TestData; orderProcessingFlow: TestData; paymentFailureScenario: TestData; adminWorkflowTest: TestData; edgeCaseScenarios: TestData[]; } ``` #### Fixture Management ```bash # Generate test fixtures npm run db:seed:fixtures # Load scenario-specific data npm run db:seed:scenario --name=payment-flow # Reset to clean test state npm run db:seed:test-reset # Seed specific test cases npm run db:seed:test-case --id=TC001 ``` ### 9. Environment Management #### Development Environment ```bash # Rich development data npm run db:seed:dev:full # Minimal development data npm run db:seed:dev:minimal # User-specific development data npm run db:seed:dev:user --email=developer@company.com ``` #### Production-like Data ```bash # Generate production-scale data npm run db:seed:prod-like --scale=medium # Anonymized production data npm run db:seed:anonymized # Compliance-safe seeding npm run db:seed:gdpr-compliant ``` ### 10. Monitoring & Reporting #### Seeding Metrics ```typescript interface SeedingMetrics { recordsInserted: Record<string, number>; executionTime: number; memoryUsage: number; errorCount: number; warningCount: number; validationResults: ValidationSummary; } ``` #### Seed Report Format ```markdown ## Database Seeding Report ### Summary - Environment: [target environment] - Execution Time: [duration] - Records Processed: [total count] - Success Rate: [percentage] - Status: [success/partial/failed] ### Data Categories | Category | Records | Status | Notes | | -------------- | ------- | ---------- | ------- | | Core Data | [count] | ✅ Success | [notes] | | Reference Data | [count] | ✅ Success | [notes] | | User Data | [count] | ⚠️ Warning | [notes] | ### Performance Metrics - Total Execution Time: [duration] - Average Insert Rate: [records/second] - Memory Peak Usage: [MB] - Database Size After Seeding: [MB] ### Validation Results - Referential Integrity: [✅/❌] - Unique Constraints: [✅/❌] - Business Rules: [✅/❌] - Data Quality Score: [percentage] ### Issues & Warnings - [List any issues encountered] - [List any warnings or recommendations] ### Next Steps - [Recommended actions or follow-ups] ``` ### 11. Automation & Scheduling #### Automated Seeding ```yaml # GitHub Actions workflow name: Database Seeding on: schedule: - cron: "0 6 * * 1" # Weekly on Monday workflow_dispatch: inputs: environment: description: "Target environment" required: true default: "development" jobs: seed: runs-on: ubuntu-latest steps: - uses: actions/checkout@v3 - run: npm run db:seed:${{ github.event.inputs.environment }} ``` #### CI/CD Integration ```bash # Pre-test seeding npm run db:seed:test:before # Post-deployment seeding npm run db:seed:staging:after # Development environment refresh npm run db:seed:dev:refresh ``` ## Implementation Workflow ### 1. Setup Phase ```bash # Initialize seeding infrastructure npm run db:seed:init # Create seed templates npm run db:seed:templates # Configure environments npm run db:seed:config ``` ### 2. Data Preparation ```bash # Generate seed data npm run db:seed:generate # Validate seed files npm run db:seed:validate # Test data generation npm run db:seed:test ``` ### 3. Execution Phase ```bash # Execute seeding npm run db:seed:execute # Monitor progress npm run db:seed:monitor # Verify results npm run db:seed:verify ``` ## Success Criteria - All target environments successfully seeded with appropriate data - Data integrity and referential consistency maintained - Seeding performance meets acceptable thresholds - Test scenarios have reliable, predictable data - Development workflow supported with realistic data - Documentation covers all seeding procedures - Automation reduces manual seeding overhead - Rollback and cleanup procedures are tested and documented

{ "prompt": "# Database Seeding & Test Data Management\n\nApply the [general coding guidelines](./general.instructions.md) to all database seeding operations.\n\n**Command:** `/seed`\n\n## Purpose\n\nComprehensive database seeding with development, testing, and demo data to support various environments and testing scenarios while maintaining data consistency and referential integrity.\n\n## Usage\n\n```\n/seed [environment] [options]\n```\n\n**Examples:**\n\n- `/seed development --full-dataset`\n- `/seed testing --minimal-data`\n- `/seed demo --showcase-features`\n- `/seed performance --large-dataset`\n- `/seed clean --reset-and-reseed`\n\n## Methodology\n\n### 1. Seeding Strategy Framework\n\n#### Environment-Specific Seeding\n\n- **Development**: Rich, realistic data for development workflow\n- **Testing**: Controlled, predictable data for automated tests\n- **Staging**: Production-like data for integration testing\n- **Demo**: Curated data showcasing application features\n- **Performance**: Large datasets for performance testing\n\n#### Data Categories\n\n- **Core Data**: Essential system data (roles, permissions, settings)\n- **Reference Data**: Static lookup data (countries, categories, etc.)\n- **User Data**: Sample users, profiles, and authentication data\n- **Business Data**: Application-specific entities and relationships\n- **Test Data**: Specific scenarios for automated testing\n\n### 2. Seeding Commands\n\n#### Basic Seeding Operations\n\n```bash\n# Seed all environments\nnpm run db:seed\n\n# Environment-specific seeding\nnpm run db:seed:dev\nnpm run db:seed:test\nnpm run db:seed:staging\nnpm run db:seed:demo\n\n# Selective seeding\nnpm run db:seed --tables=users,products\nnpm run db:seed --categories=core,reference\n```\n\n#### Advanced Seeding\n\n```bash\n# Generate large datasets\nnpm run db:seed:performance --size=large\n\n# Seed with custom data\nnpm run db:seed:custom --file=custom-data.json\n\n# Incremental seeding\nnpm run db:seed:incremental\n\n# Seed reset and refresh\nnpm run db:seed:reset\nnpm run db:seed:refresh\n```\n\n### 3. Data Generation Framework\n\n#### Realistic Data Generation\n\n```typescript\ninterface SeedDataGenerator {\n users: UserSeedGenerator;\n products: ProductSeedGenerator;\n orders: OrderSeedGenerator;\n reviews: ReviewSeedGenerator;\n}\n\ninterface UserSeedGenerator {\n generateUsers(count: number): User[];\n generateProfiles(): UserProfile[];\n generatePreferences(): UserPreferences[];\n}\n\n// Example data generation\nconst generateRealisticUsers = (count: number): User[] => {\n return Array.from({ length: count }, () => ({\n id: faker.datatype.uuid(),\n email: faker.internet.email(),\n firstName: faker.name.firstName(),\n lastName: faker.name.lastName(),\n avatar: faker.image.avatar(),\n createdAt: faker.date.between(\"2020-01-01\", new Date()),\n isActive: faker.datatype.boolean(),\n role: faker.helpers.arrayElement([\"user\", \"admin\", \"moderator\"]),\n }));\n};\n```\n\n#### Relationship Management\n\n```typescript\ninterface RelationshipSeeder {\n seedUserOrders(users: User[]): Order[];\n seedProductReviews(products: Product[], users: User[]): Review[];\n seedCategoryProducts(categories: Category[]): Product[];\n ensureReferentialIntegrity(): void;\n}\n```\n\n### 4. Seed Data Organization\n\n#### Directory Structure\n\n```\nseeds/\n├── core/ # Essential system data\n│ ├── roles.json\n│ ├── permissions.json\n│ └── settings.json\n├── reference/ # Static lookup data\n│ ├── countries.json\n│ ├── categories.json\n│ └── currencies.json\n├── development/ # Development environment data\n│ ├── users.dev.json\n│ ├── products.dev.json\n│ └── orders.dev.json\n├── testing/ # Test-specific data\n│ ├── users.test.json\n│ ├── scenarios/\n│ └── fixtures/\n├── demo/ # Demo presentation data\n│ ├── showcase.json\n│ └── features.json\n└── generators/ # Data generation scripts\n ├── user-generator.ts\n ├── product-generator.ts\n └── order-generator.ts\n```\n\n#### Seed File Format\n\n```json\n{\n \"metadata\": {\n \"version\": \"1.0.0\",\n \"environment\": [\"development\", \"testing\"],\n \"dependencies\": [\"core/roles.json\"],\n \"description\": \"Sample user data for development\"\n },\n \"data\": {\n \"users\": [\n {\n \"id\": \"user_001\",\n \"email\": \"john.doe@example.com\",\n \"firstName\": \"John\",\n \"lastName\": \"Doe\",\n \"role\": \"admin\"\n }\n ]\n }\n}\n```\n\n### 5. Seeding Execution Pipeline\n\n#### Pre-Seeding Validation\n\n```bash\n# Validate seed data integrity\nnpm run db:seed:validate\n\n# Check database schema compatibility\nnpm run db:seed:check-schema\n\n# Verify dependencies and order\nnpm run db:seed:validate-deps\n\n# Test data generation\nnpm run db:seed:test-generation\n```\n\n#### Seeding Process\n\n```bash\n# Execute seeding pipeline\nnpm run db:seed:pipeline\n\n# Monitor seeding progress\nnpm run db:seed:monitor\n\n# Verify seeding results\nnpm run db:seed:verify\n\n# Generate seeding report\nnpm run db:seed:report\n```\n\n### 6. Data Consistency & Integrity\n\n#### Referential Integrity\n\n```typescript\nclass SeedIntegrityManager {\n validateForeignKeys(): ValidationResult;\n ensureUniqueConstraints(): void;\n checkDataConsistency(): ConsistencyReport;\n repairInconsistencies(): RepairResult;\n}\n```\n\n#### Data Validation\n\n```bash\n# Validate seeded data\nnpm run db:seed:validate-data\n\n# Check business rules compliance\nnpm run db:seed:validate-rules\n\n# Verify data relationships\nnpm run db:seed:validate-relationships\n\n# Test data accessibility\nnpm run db:seed:test-access\n```\n\n### 7. Performance Considerations\n\n#### Bulk Operations\n\n```typescript\ninterface BulkSeedOperations {\n bulkInsertUsers(users: User[], batchSize?: number): Promise<void>;\n bulkInsertProducts(products: Product[]): Promise<void>;\n bulkUpdateRelationships(): Promise<void>;\n optimizeForPerformance(): void;\n}\n```\n\n#### Large Dataset Handling\n\n```bash\n# Generate large datasets efficiently\nnpm run db:seed:bulk --size=10000\n\n# Streaming data insertion\nnpm run db:seed:stream --file=large-dataset.json\n\n# Parallel seeding\nnpm run db:seed:parallel --workers=4\n\n# Memory-optimized seeding\nnpm run db:seed:memory-optimized\n```\n\n### 8. Testing Support\n\n#### Test Data Scenarios\n\n```typescript\ninterface TestScenarios {\n userRegistrationFlow: TestData;\n orderProcessingFlow: TestData;\n paymentFailureScenario: TestData;\n adminWorkflowTest: TestData;\n edgeCaseScenarios: TestData[];\n}\n```\n\n#### Fixture Management\n\n```bash\n# Generate test fixtures\nnpm run db:seed:fixtures\n\n# Load scenario-specific data\nnpm run db:seed:scenario --name=payment-flow\n\n# Reset to clean test state\nnpm run db:seed:test-reset\n\n# Seed specific test cases\nnpm run db:seed:test-case --id=TC001\n```\n\n### 9. Environment Management\n\n#### Development Environment\n\n```bash\n# Rich development data\nnpm run db:seed:dev:full\n\n# Minimal development data\nnpm run db:seed:dev:minimal\n\n# User-specific development data\nnpm run db:seed:dev:user --email=developer@company.com\n```\n\n#### Production-like Data\n\n```bash\n# Generate production-scale data\nnpm run db:seed:prod-like --scale=medium\n\n# Anonymized production data\nnpm run db:seed:anonymized\n\n# Compliance-safe seeding\nnpm run db:seed:gdpr-compliant\n```\n\n### 10. Monitoring & Reporting\n\n#### Seeding Metrics\n\n```typescript\ninterface SeedingMetrics {\n recordsInserted: Record<string, number>;\n executionTime: number;\n memoryUsage: number;\n errorCount: number;\n warningCount: number;\n validationResults: ValidationSummary;\n}\n```\n\n#### Seed Report Format\n\n```markdown\n## Database Seeding Report\n\n### Summary\n\n- Environment: [target environment]\n- Execution Time: [duration]\n- Records Processed: [total count]\n- Success Rate: [percentage]\n- Status: [success/partial/failed]\n\n### Data Categories\n\n| Category | Records | Status | Notes |\n| -------------- | ------- | ---------- | ------- |\n| Core Data | [count] | ✅ Success | [notes] |\n| Reference Data | [count] | ✅ Success | [notes] |\n| User Data | [count] | ⚠️ Warning | [notes] |\n\n### Performance Metrics\n\n- Total Execution Time: [duration]\n- Average Insert Rate: [records/second]\n- Memory Peak Usage: [MB]\n- Database Size After Seeding: [MB]\n\n### Validation Results\n\n- Referential Integrity: [✅/❌]\n- Unique Constraints: [✅/❌]\n- Business Rules: [✅/❌]\n- Data Quality Score: [percentage]\n\n### Issues & Warnings\n\n- [List any issues encountered]\n- [List any warnings or recommendations]\n\n### Next Steps\n\n- [Recommended actions or follow-ups]\n```\n\n### 11. Automation & Scheduling\n\n#### Automated Seeding\n\n```yaml\n# GitHub Actions workflow\nname: Database Seeding\non:\n schedule:\n - cron: \"0 6 * * 1\" # Weekly on Monday\n workflow_dispatch:\n inputs:\n environment:\n description: \"Target environment\"\n required: true\n default: \"development\"\n\njobs:\n seed:\n runs-on: ubuntu-latest\n steps:\n - uses: actions/checkout@v3\n - run: npm run db:seed:${{ github.event.inputs.environment }}\n```\n\n#### CI/CD Integration\n\n```bash\n# Pre-test seeding\nnpm run db:seed:test:before\n\n# Post-deployment seeding\nnpm run db:seed:staging:after\n\n# Development environment refresh\nnpm run db:seed:dev:refresh\n```\n\n## Implementation Workflow\n\n### 1. Setup Phase\n\n```bash\n# Initialize seeding infrastructure\nnpm run db:seed:init\n\n# Create seed templates\nnpm run db:seed:templates\n\n# Configure environments\nnpm run db:seed:config\n```\n\n### 2. Data Preparation\n\n```bash\n# Generate seed data\nnpm run db:seed:generate\n\n# Validate seed files\nnpm run db:seed:validate\n\n# Test data generation\nnpm run db:seed:test\n```\n\n### 3. Execution Phase\n\n```bash\n# Execute seeding\nnpm run db:seed:execute\n\n# Monitor progress\nnpm run db:seed:monitor\n\n# Verify results\nnpm run db:seed:verify\n```\n\n## Success Criteria\n\n- All target environments successfully seeded with appropriate data\n- Data integrity and referential consistency maintained\n- Seeding performance meets acceptable thresholds\n- Test scenarios have reliable, predictable data\n- Development workflow supported with realistic data\n- Documentation covers all seeding procedures\n- Automation reduces manual seeding overhead\n- Rollback and cleanup procedures are tested and documented", "variables": [], "notes": "Database seeding and test data management for development, testing, and demo environments with referential integrity", "metadata": { "source": { "provider": "github-prompts", "repository": "https://github.com/TheSethRose/Parakeet-Realtime-Transcriber", "path": ".github/prompts/seed.prompt.md", "ref": "8dc2786aac897a3261164f164e77ce224ad1fba5", "url": "https://github.com/TheSethRose/Parakeet-Realtime-Transcriber/blob/8dc2786aac897a3261164f164e77ce224ad1fba5/.github/prompts/seed.prompt.md", "key": "TheSethRose/Parakeet-Realtime-Transcriber/.github/prompts/seed.prompt.md" } } }

About