Design Database Schema Curated Resource and Installation Guide CookApps CookApps Marketplace

Design Database Schema

Design optimized database schemas with comprehensive data modeling: $ARGUMENTS

Application type: Based on $ARGUMENTS or codebase analysis

Data requirements: @requirements/ or project documentation

Existing schema: @prisma/schema.prisma or @migrations/ or database dumps

Performance needs: Expected scale, query patterns, and data volume

Design comprehensive database schema with optimal structure and performance:

Schema Type: Use $ARGUMENTS to specify relational, NoSQL, hybrid approach, or normalization level

Design Framework:

Requirements Analysis - Business entities, relationships, data flow, and access patterns

Entity Modeling - Tables/collections, attributes, primary/foreign keys, constraints

Relationship Design - One-to-one, one-to-many, many-to-many associations

Normalization Strategy - Data consistency vs performance trade-offs

Performance Optimization - Indexing strategy, query optimization, partitioning

Security Design - Access control, data encryption, audit trails

Advanced Patterns: Implement temporal data, soft deletes, JSONB fields, full-text search, audit logging, and scalability patterns.

Validation: Ensure referential integrity, data consistency, query performance, and future extensibility.

Output: Complete schema design with DDL scripts, ER diagrams, performance analysis, and migration strategy.