database-patterns

What problem does it solve?

This Skill addresses the complexities of designing efficient database schemas, implementing robust data access patterns, writing optimized queries, and managing database migrations and transactions for both SQL and NoSQL databases.

Core Features & Use Cases

• Schema Design: Provides guidance on normalization, common table structures, and relationship modeling.
• Indexing Strategies: Details various index types and best practices for performance optimization.
• Query Patterns: Offers examples for efficient querying, pagination, upserts, and soft deletes.
• Repository Pattern: Demonstrates interface and implementation for clean data access.
• Transaction Management: Explains basic transactions, isolation levels, and locking.
• Migration Management: Outlines migration structure and best practices.
• NoSQL Patterns: Covers document design and single-table design for DynamoDB.
• Use Case: When designing a new e-commerce platform, use this Skill to define optimal table structures for products and orders, implement efficient indexing for fast product searches, and set up a transactional system for order processing.

Quick Start

Use the database-patterns skill to generate a SQL schema for a blog with posts, users, and comments.