Designs optimized database schemas and indexing strategies tailored to specific application access patterns.
This skill empowers Claude to architect efficient, scalable data structures for both relational and document-based databases. It provides a structured approach to system design by first identifying critical access patterns and then translating them into optimized schemas. Whether you are working with PostgreSQL normalization, implementing advanced indexing like GIN or BRIN, or deciding between embedding and referencing in MongoDB, this skill ensures your database architecture remains performant and avoids common pitfalls like N+1 queries or unbounded arrays.
Key Features
01Relational schema design (1NF, 2NF, 3NF) and strategic denormalization
02Access pattern analysis and latency targeting
03Advanced indexing strategies including partial and composite indexes
040 GitHub stars
05NoSQL document modeling with embed vs. reference decision logic
06Detection and mitigation of N+1 queries and data integrity issues
Use Cases
01Architecting data models during the initial system design phase of a new project
02Designing a high-performance backend for complex applications like social networks or e-commerce
03Refactoring existing database schemas to resolve slow query performance and technical debt
