Data Modeling Expert | Bootspring Docs

The Data Modeling Expert agent specializes in database design, entity relationship modeling, schema design, and data architecture for applications.

Expertise Areas#

Entity Relationship Design - ERD planning and optimization
Prisma Schema Patterns - ORM schema best practices
SaaS Data Models - Multi-tenant architectures
Soft Delete Pattern - Non-destructive deletion
Audit Logging - Change tracking systems
Indexing Strategy - Performance optimization
Data Migration - Schema evolution patterns

Usage Examples#

Schema Design#

Use the data-modeling-expert agent to design a database schema for a multi-tenant SaaS application.

Response includes:

Entity definitions
Relationship mapping
Tenant isolation strategy
Index recommendations

Prisma Schema#

Use the data-modeling-expert agent to create a Prisma schema for a project management application.

Response includes:

Model definitions
Relations setup
Enum types
Index decorators

Migration Strategy#

Use the data-modeling-expert agent to plan a data migration for adding user roles to an existing system.

Response includes:

Migration script
Backfill logic
Rollback plan
Testing approach

Best Practices Applied#

1. Schema Design#

Proper normalization
Clear relationships
Consistent naming
Appropriate constraints

2. Performance#

Strategic indexing
Query optimization
Covering indexes
Partial indexes

3. Data Integrity#

Foreign key constraints
Check constraints
Unique constraints
Default values

4. Operations#

Soft delete patterns
Audit logging
Migration strategies
Backup considerations

Common Patterns#

User with Relations#

model User {
  id        String   @id @default(cuid())
  email     String   @unique
  name      String?
  role      Role     @default(USER)
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  profile   Profile?
  posts     Post[]
  teams     TeamMember[]

  @@index([email])
}

model Profile {
  id     String @id @default(cuid())
  bio    String?
  avatar String?
  userId String @unique
  user   User   @relation(fields: [userId], references: [id], onDelete: Cascade)
}

Multi-Tenant SaaS Schema#

model Organization {
  id          String   @id @default(cuid())
  name        String
  slug        String   @unique
  plan        Plan     @default(FREE)
  stripeId    String?  @unique
  members     OrganizationMember[]
  projects    Project[]
  subscription Subscription?
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt

  @@index([slug])
}

model OrganizationMember {
  id             String       @id @default(cuid())
  organizationId String
  userId         String
  role           OrgRole      @default(MEMBER)
  organization   Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  user           User         @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@unique([organizationId, userId])
}

enum Plan {
  FREE
  PRO
  TEAM
  ENTERPRISE
}

enum OrgRole {
  OWNER
  ADMIN
  MEMBER
}

Soft Delete Pattern#

model Document {
  id        String    @id @default(cuid())
  title     String
  content   String?
  deletedAt DateTime?
  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt

  @@index([deletedAt])
}

// Prisma middleware for soft delete
prisma.$use(async (params, next) => {
  if (params.model === 'Document') {
    if (params.action === 'findMany' || params.action === 'findFirst') {
      params.args.where = {
        ...params.args.where,
        deletedAt: null,
      };
    }

    if (params.action === 'delete') {
      params.action = 'update';
      params.args.data = { deletedAt: new Date() };
    }
  }
  return next(params);
});

Audit Log Pattern#

model AuditLog {
  id         String   @id @default(cuid())
  entityType String
  entityId   String
  action     String
  changes    Json?
  userId     String?
  user       User?    @relation(fields: [userId], references: [id])
  ipAddress  String?
  createdAt  DateTime @default(now())

  @@index([entityType, entityId])
  @@index([userId])
  @@index([createdAt])
}

Sample Prompts#

Task	Prompt
Schema design	"Design a schema for an e-commerce platform"
Multi-tenant	"Create a multi-tenant data model with organization isolation"
Relationships	"Model a many-to-many relationship with metadata"
Audit log	"Add audit logging for all user actions"
Migration	"Plan migration for adding user preferences"

Configuration#

// bootspring.config.js
module.exports = {
  agents: {
    customInstructions: {
      'data-modeling-expert': `
        - Use Prisma for schema definition
        - Implement soft delete for important entities
        - Add audit logging for sensitive operations
        - Design for multi-tenancy from the start
        - Include proper indexing strategy
      `,
    },
  },
  database: {
    provider: 'postgresql',
    orm: 'prisma',
  },
};

Database Expert - Query optimization
Backend Expert - API integration
Architecture Expert - System design