data-access

What problem does it solve?

This Skill addresses the complexities of implementing efficient and maintainable data access layers, ensuring clean separation of concerns and preventing common performance pitfalls like N+1 queries.

Core Features & Use Cases

• Repository Pattern Implementation: Scaffolds interfaces and implementations for data entities.
• N+1 Query Prevention: Detects and resolves inefficient data fetching patterns.
• Transaction Management: Ensures data integrity for multi-entity operations.
• Query Optimization: Improves read performance by analyzing and refining queries.
• Use Case: When developing a new feature that requires saving user profile updates and associated preferences, this Skill will generate the necessary repository methods, wrap the operations in a transaction, and optimize the queries to prevent performance issues.

Quick Start

Implement a repository for the 'User' entity using the project's ORM.