What problem does it solve? Designing a database schema from scratch involves many decisions—normalization levels, data types, indexing, foreign key strategies, and migration safety—that are easy to get wrong and costly to fix later. This Skill guides the full schema design process so the resulting data model maintains integrity and query performance. ## Core Features & Use Cases - Schema Generation: Produces complete SQL table definitions with primary keys, foreign keys, constraints, and indexes from a plain-language description of entities and relationships. - Normalization & Optimization Guidance: Applies 1NF through 3NF rules, advises when denormalization is justified, and plans composite index strategies based on access patterns. - Migration Planning: Generates reversible up/down migration scripts with zero-downtime patterns like nullable-column-first rollouts. - Use Case: Describe an e-commerce platform with users, products, and orders, and receive a complete SQL schema with indexed foreign keys, DECIMAL money columns, and timestamps, plus a checklist to verify the design. ## Quick Start Ask the assistant to design a schema for your application domain, listing the main entities, their relationships, and whether the workload is read-heavy or write-heavy.
