database-model

What problem does it solve?

This Skill streamlines the process of designing and implementing database schemas by generating Prisma schema models with correct relations, indexes, and conventions, preventing common errors and ensuring consistency.

Core Features & Use Cases

• Model Generation: Creates prisma/schema.prisma models following best practices.
• Relation Definition: Supports one-to-many, one-to-one, and many-to-many relationships.
• Index Creation: Automatically adds necessary @@index directives for foreign keys and common query fields.
• Use Case: When adding a new feature that requires storing user profiles and their associated posts, this Skill can generate the User, Profile, and Post models with the correct relational links and indexes.

Quick Start

Use the database-model skill to create a Prisma schema model for a 'Category' with a 'name' field and a one-to-many relation to a 'Product' model.