Backend Models Standards

What problem does it solve?

This Skill addresses the challenge of inconsistent, error-prone database models that lead to data integrity issues, performance bottlenecks, and difficult maintenance. It ensures that all data models adhere to best practices, promoting reliability and scalability.

Core Features & Use Cases

• Standardized Model Definition: Guides on clear naming conventions, appropriate data types, and mandatory fields (e.g., timestamps, primary keys) for consistent model structures.
• Data Integrity Enforcement: Emphasizes the use of database-level constraints (NOT NULL, UNIQUE, Foreign Keys) and model-level validation to prevent data corruption.
• Optimized Relationships & Indexing: Provides best practices for defining explicit relationships between models and creating performance-critical indexes for efficient querying.
• Use Case: When building a new e-commerce platform, use this skill to ensure all product, order, and user models are consistently defined, validated, and indexed for optimal performance and data integrity from day one.

Quick Start

Apply the Backend Models Standards skill to define the 'Product' model, ensuring it includes 'name', 'description', 'price', 'category_id', and 'created_at' fields with appropriate types and constraints.