database-design

Database schema design for transactional systems involves selecting appropriate models, applying normalization, and optimizing read paths. This skill generates production-grade schemas and indexing strategies based on your specific workload requirements.

Choosing between OLTP, OLAP, and NoSQL models depends on workload characteristics like data size, velocity, variety, and consistency. This skill automatically selects the optimal storage model by evaluating these constraints against your project requirements.

Indexing strategy for query optimization requires evaluating data models and schema structures to accelerate read paths. This skill provides indexing guidelines and enforces validation rules through a parameterized workflow to ensure reliable performance.

Database normalization versus denormalization depends on whether your workload prioritizes transactional consistency or flexible analytics. This skill provides schema design guidance by balancing normalization and denormalization based on your data size and consistency constraints.

You can use YAML to define project data and constraints for database design. This skill processes YAML dependencies to structure a complete database design plan, enforcing validation rules and recommended schemas through a parameterized workflow.