data-modeling - Design and review database schemas and entity models.
Designs data schemas, entities, relationships, tenancy, indexes, audit logging, and migrations using Drizzle conventions.
Tags
Updated: 2026-09-23Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Identify entities and relationships
- Select database store engine
- Design prefixed ULID identifiers
- Define standard schema columns
- Configure multi-tenant data isolation
- Establish audit logging rules
- Review schemas for deviations
- Plan database migration strategies
Inputs
- Domain entities and requirements
- Existing Drizzle schema files
- Architecture documentation
Outputs
- Architecture design documents
- Drizzle schema code files
- SQL migration files
Requirements
- File system tools (Read, Write, Edit, Grep, Glob, Bash)
- AskUserQuestion interaction tool
- Drizzle ORM and TypeScript workspace
- SQLite (D1) or Postgres (Neon) database