Database Schema Designer

Design well-normalized database schemas with proper relationships, constraints, and data types for your applications.

Usage

Describe your application's data model and this skill will design an appropriate database schema.

Examples

• "Design a schema for an e-commerce platform with products, orders, and users"
• "Create a schema for a multi-tenant SaaS application"
• "Model a social network with users, posts, comments, and follows"

Guidelines

• Start with 3NF and denormalize only when performance requires it
• Use appropriate data types to save storage and improve performance
• Add foreign key constraints to maintain referential integrity
• Plan for schema migration from the beginning
• Include created_at and updated_at timestamps on all tables