database-design

Database schema design for new projects involves evaluating context to choose a database and ORM, then defining naming conventions, primary keys, timestamps, and relationships. This skill guides those decisions to produce a schema design plan with a migration strategy.

Normalization vs denormalization in SQL schema design depends on your application context and scale. This skill guides you through evaluating your context to make principled choices between normalized and denormalized structures rather than blindly copying patterns.

Planning indexing strategies for a scalable database requires evaluating query patterns and relationship modeling. This skill recommends indexing decisions and migration considerations to ensure performance as part of the schema design process.

Database schema design for serverless and embedded databases is explicitly supported. The skill covers considerations for these environments alongside web, mobile, and enterprise contexts, helping you choose appropriate primary keys and ORM compatibility.

Choosing an ORM compatible with your database schema design requires evaluating how primary keys, relationships, and timestamp conventions map to ORM expectations. This skill includes ORM compatibility as a key part of the schema design checklist.