A comprehensive database design skill that provides expert-level analysis, optimization, and migration capabilities for modern database systems. This skill combines theoretical principles with practical tools to help architects and developers create scalable, performant, and maintainable database schemas.
Core Competencies
Schema Design & Analysis
Normalization Analysis
Automated detection of normalization levels (1NF through BCNF)
Denormalization Strategy
Smart recommendations for performance optimization
Data Type Optimization
Identification of inappropriate types and size issues
Constraint Analysis
Missing foreign keys, unique constraints, and null checks
Naming Convention Validation
Consistent table and column naming patterns
ERD Generation
Automatic Mermaid diagram creation from DDL
Show more