What problem does it solve? Choosing the wrong database technology or designing a poor schema early leads to costly rework, performance bottlenecks, and painful migrations. This Skill provides expert-level data layer architecture guidance, from technology selection through schema design, indexing, caching, and zero-downtime migration planning. ## Core Features & Use Cases - Technology Selection: Evaluates relational, NoSQL, time-series, graph, and NewSQL databases with clear trade-off analysis based on your access patterns and scale targets. - Schema & Index Design: Produces conceptual, logical, and physical data models with normalization strategies, index plans, and multi-tenancy patterns. - Migration & Scaling Planning: Designs zero-downtime migration strategies, sharding plans, replication topologies, and caching architectures. - Use Case: Ask it to design a multi-tenant SaaS e-commerce schema, and it will recommend a database engine, produce table designs with indexes, plan a caching layer, and outline a phased migration with rollback procedures. ## Quick Start Ask the assistant to design a database schema and migration plan for your application, describing your data domain, access patterns, and expected scale.
