database-schema-designer

Describe your entities, relationships, and access patterns, and the skill generates normalized CREATE TABLE statements with primary keys, foreign keys, constraints, and indexes. It defaults to SQL but supports MongoDB document modeling when requested.

The choice depends on access patterns: SQL with 3NF normalization suits write-heavy OLTP workloads, while NoSQL embedding suits read-together document data. The skill analyzes your read/write ratio and relationship cardinality to recommend an approach.

Add the column as nullable first, deploy code that writes to it, backfill existing rows, then add the NOT NULL constraint. The skill generates reversible up and down migration scripts following this zero-downtime pattern.

Index all foreign keys, columns used in WHERE clauses, and ORDER BY columns. For composite indexes, place the most selective or most-queried-alone column first, and avoid over-indexing since each index slows writes.

Denormalize only after normalizing to 3NF, typically for read-heavy reporting, expensive JOINs, or analytics dashboards. Common strategies include pre-calculated aggregates, cached derived columns, and materialized views.