persistence-adapter

What problem does it solve?

This Skill streamlines database interactions, ensuring efficient data access, robust schema management, and optimized query performance across various programming languages and frameworks.

Core Features & Use Cases

• Data Access Patterns: Implement the Repository and Query Object patterns for clean data separation.
• Schema Management: Create and manage database migrations with rollback capabilities.
• Query Optimization: Prevent N+1 queries, optimize indexing, and analyze query performance.
• Use Case: When developing a new feature that requires fetching user data along with their associated posts and comments, use this Skill to define an efficient repository method that uses eager loading to avoid multiple database round trips.

Quick Start

Use the persistence-adapter skill to create a new database migration for adding a 'status' column to the 'users' table.