prisma-schema-builder_skill

Overview

This skill generates complete Prisma schema.prisma files tailored for TypeScript projects using Prisma 5.x. It produces models, relations, enums, indexes, and datasource/generator blocks ready for immediate use. The output focuses on practical, production-ready patterns for authentication, e-commerce, and common domain models.

How this skill works

Provide the domain or trigger phrase (for example: "create Prisma schema" or "prisma.schema for e-commerce") and the skill builds a full Prisma Schema Language file. It chooses appropriate scalar and database-specific types, maps fields and column names, defines relations (one-to-many, many-to-many explicit/implicit), and adds indexes and constraints. The result is a single schema.prisma compatible with PostgreSQL or MySQL with Prisma client generator configured.

When to use it

• Bootstrapping a new TypeScript backend with Prisma ORM
• Generating domain schemas for authentication, e-commerce, CMS, or custom models
• Creating reference schemas for database migrations and typesafe client generation
• Speeding up prototyping by producing ready-to-run schema.prisma files
• Standardizing schema patterns across projects or teams

Best practices

• Specify provider and DATABASE_URL environment variable in the datasource block
• Use cuid()/autoincrement() and appropriate unique constraints for stable identifiers
• Add @@index and @@unique directives for query-critical fields (email, sku, orderNumber)
• Map database column names with @map for backward compatibility when needed
• Prefer explicit join tables for many-to-many when you need extra metadata on relationships

Example use cases

• Generate a complete authentication schema with User, Session, Account, PasswordReset, and VerificationToken models
• Create an e-commerce schema including Product, Category, Variant, Cart, Order, and Review models with enums for statuses
• Produce a simple blog schema with Post, Author, Tag and PostTag join table
• Convert a domain description (fields and relations) into a ready-to-run schema.prisma file