backend-data-patterns

What problem does it solve?

This Skill provides a standardized approach to designing database models and managing schema changes, ensuring consistency, maintainability, and safety across projects.

Core Features & Use Cases

• Model Design: Defines conventions for table naming, timestamping, and constraints.
• Relationship Management: Illustrates how to define foreign keys and relationships between models.
• Migration Best Practices: Covers Alembic migrations, zero-downtime deployments, and idempotent data updates.
• Use Case: When creating a new feature that requires a database table, use this Skill to ensure the model adheres to established patterns and that its migration is safe and reversible.

Quick Start

Use the backend-data-patterns skill to define a new SQLAlchemy model for a 'Product' with 'name' and 'price' fields, including created_at and updated_at timestamps.