Design database schemas with entities, relationships, and indexing strategies.
npx skills add https://github.com/vndee/engineering-skills --skill data-model-vndee
Please help me install this Agent Skill. Skill: data-model Source: https://github.com/vndee/engineering-skills/tree/main/.claude/skills/data-model Command: npx skills add https://github.com/vndee/engineering-skills --skill data-model-vndee
Designing robust database schemas upfront prevents painful migrations, refactors, and performance pitfalls that frequently arise when data models evolve in production.
List the core entities and their key attributes for the domain you are modeling.
High-intent search queries and answers about installing and using this skill.
Design robust database schemas before migrations by explicitly defining entities, attributes, and relationships upfront. This prevents painful refactors and performance pitfalls by enforcing naming conventions, data types, and indexing decisions early.
Model entity relationships by identifying core domain entities and mapping their connections to shape tables and foreign keys. Use explicit entity definitions and recommended data-type conventions to structure attributes and constraints effectively.
Plan indexing strategies by evaluating access patterns to support scalable queries. Define sensible data types, constraints, and explicit indexing decisions during schema design to optimize performance before executing migrations.
Consider soft-delete conventions during database schema design when planning for domain expansions or redesigns. Enforce explicit entity definitions and relationship modeling to handle data retention without costly production refactors.
This schema design approach is applicable to both new projects and existing domain expansions or redesigns. It guides entities, attributes, relationships, and indexing decisions to prevent performance pitfalls when data models evolve.
ITSaltTranslate BA artifacts into Neo4j DomainEntity, DomainAttribute, and Enumeration structures.
kingmacthGenerate idempotent database migrations with clear naming and safe SQL patterns.
EmeaAppGbbExtract database entities, relationships, and constraints from ORM models into Mermaid ERDs.
edulazaroGenerate Mermaid Entity-Relationship diagrams from Eloquent models and migrations.
