From claude-sdlc-team
Design and review relational schemas, MySQL-focused. Use when the design or implementation involves data modeling — tables, keys, relationships, normalization, indexing, constraints, migrations, and query/EXPLAIN optimization. Used by the architect (data model) and implementer (schema/migrations).
How this skill is triggered — by the user, by Claude, or both
Slash command
/claude-sdlc-team:database-designThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
- Normalize to 3NF by default; denormalize only with a measured read-performance reason (note it).
BIGINT UNSIGNED AUTO_INCREMENT (or UUID when distribution requires); always declare them.ON DELETE/ON UPDATE; name constraints.NOT NULL unless null is meaningful; sensible defaults.WHERE, JOIN, ORDER BY. Composite index column order = equality → range → sort.EXPLAIN; look for full scans, filesorts, temporary tables.Flag missing indexes on FK/lookup columns, N+1-prone access patterns (coordinate with performance-and-cost), wrong types, missing constraints.
npx claudepluginhub danniel-isiah-libor/danniel-claude-plugins --plugin claude-sdlc-teamGuides creation, editing, and verification of skills for AI coding agents using test-driven development with subagent scenarios. Use when authoring or debugging skills.