Bootspring
HomeGet Started

Data Modeling Expert

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

Expertise#

  • 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)

When to Use#

Use this agent when you need help with:

  • Designing a database schema for a new application or feature
  • Creating Prisma schemas with proper relations, enums, and indexes
  • Modeling multi-tenant SaaS data with organization isolation
  • Implementing soft delete and audit logging patterns
  • Planning data migrations with backfill logic and rollback strategies

Example Prompts#

  • "Design a schema for an e-commerce platform"
  • "Create a multi-tenant data model with organization isolation"
  • "Model a many-to-many relationship with metadata"
  • "Add audit logging for all user actions"
  • "Plan migration for adding user preferences"

What to Expect#

The Data Modeling Expert will provide:

  • Complete entity definitions with relationships, constraints, and indexes
  • Prisma schema designs with proper model relations and enum types
  • Multi-tenant patterns with organization-scoped data access
  • Soft delete and audit logging implementations
  • Migration plans with backfill scripts, rollback strategies, and testing approaches

Related Agents#