data-management

What problem does it solve?

This Skill helps design and manage data persistence in a way that is reliable, performant, and safe, addressing the critical need for well-handled data assets.

Core Features & Use Cases

• Database Selection: Guidance on choosing between relational, document, key-value, time-series, and graph databases based on use case.
• Data Modeling: Principles for normalization, denormalization, key strategies, and avoiding anti-patterns.
• Indexing & Query Optimization: Strategies for efficient indexing, diagnosing missing indexes, and optimizing queries to prevent issues like N+1 problems.
• Caching: Implementing various cache layers and invalidation strategies.
• Migrations: Best practices for safe, backward-compatible database migrations.
• Backup & Recovery: Implementing the 3-2-1 rule and defining RTO/RPO.
• Data Privacy: Managing PII, encryption, and data masking.
• Use Case: When designing a new application's database, use this Skill to select the most appropriate database type, define a normalized schema, and establish indexing strategies for optimal performance and reliability.

Quick Start

Use the data-management skill to design a relational database schema for an e-commerce application, focusing on normalization and defining primary and foreign keys.