Design database schemas with ER modeling, normalization, and migration planning.
npx skills add https://github.com/I2olanD/dotfiles --skill data-modeling-i2oland
Please help me install this Agent Skill. Skill: data-modeling Source: https://github.com/I2olanD/dotfiles/tree/main/.config/opencode/skill/data-modeling Command: npx skills add https://github.com/I2olanD/dotfiles --skill data-modeling-i2oland
Designing robust, scalable database schemas is hard; this Skill provides structured guidance for data modeling, normalization, and schema evolution to ensure maintainable architectures.
Outline your domain entities and relationships, then draft a schema using the provided templates and guidelines to begin modeling.
High-intent search queries and answers about installing and using this skill.
Designing robust database schemas involves entity-relationship modeling to capture domain concepts, normalization up to 3NF to ensure integrity, and practical denormalization tips to maintain performance as your data scales.
Planning database migrations involves applying schema versioning strategies to safely evolve data models. It enforces structured design rules to safely evolve schemas without disrupting existing domain logic or data integrity.
Yes, this data modeling guidance is applicable to relational, NoSQL, and hybrid stores. It provides a reusable schema template and enforces structured design rules to help teams communicate data architecture decisions across different database architectures.
Normalizing a database schema to 3NF ensures data integrity by reducing redundancy, while practical denormalization tips help maintain query performance. Structured ER modeling captures domain concepts first to balance normalization rules with performance requirements.
Entity-relationship diagrams are used during database architecture to capture domain concepts and lifecycles. ER modeling provides structured guidance to ensure maintainable architectures and clearly communicate data architecture decisions across teams.
Denormalization improves database schema performance by strategically reversing normalization rules. It provides practical denormalization tips to optimize query speed while maintaining the structural integrity established during initial ER modeling and schema design.
SSiertsemaDefine domain entities, relationships, and business rules in plain language.
MicrockPlan and execute database migrations with rollback and integrity validation.
OneWave-AIDesign optimized SQL and NoSQL database schemas with ERDs and migration scripts.
simotaDesign and validate database schemas, migrations, and ER diagrams.
