kata-schema-design

What problem does it solve?

It solves the challenge of designing new database schemas (or evolving existing ones) that are correct, scalable, auditable, and compliant with data retention and PII requirements.

Core Features & Use Cases

• Entity-Relationship Modeling: Identify entities, value objects, aggregates, and model relationships/cardinalities with clear ER diagrams.
• DB Technology Decisioning: Choose relational vs. NoSQL based on access patterns, and document non-trivial choices via ADRs.
• Schema-Quality Guarantees: Define strong types/constraints, justified indexes, and explicit PII classification with retention policies, plus reversible migration strategies.
• Artifacts & Outputs: Produce a structured schema markdown document, update retention YAML, and reference ADRs when needed.

Quick Start

Use the kata-schema-design skill to create a schema document for a new domain entity or an expansion to an existing model, including indexes, PII classification, retention rules, and (when relevant) an expand-contract migration plan.