Can this skill help with production migrations?

Yes, it provides a standardized workflow distinguishing between development migrations (migrate dev) and safe, non-generative production deployments (migrate deploy).

Does it support raw SQL queries?

Yes, the skill guides the use of $queryRaw and $executeRaw while ensuring protection against SQL injection by enforcing the use of tagged template literals.

How does this skill help with database performance?

It enforces the use of indexes on foreign keys, promotes cursor-based pagination, and provides structural checks to replace N+1 queries with efficient batched operations or includes.

What validation checks are included in this skill?

It automatically verifies that foreign keys are indexed, multi-table writes use transactions, and that migration files haven't been manually edited in ways that could break environments.

Prisma Schema & Database Patterns

Name: Prisma Schema & Database Patterns
Author: hjemmesidekongen

byhjemmesidekongen

0•

データベース管理

Optimizes Prisma ORM workflows by enforcing best practices for schema design, migrations, and high-performance query patterns.

Prisma Patterns is a specialized skill for Claude Code designed to streamline database engineering using the Prisma ORM. It provides deep domain expertise in modeling complex relations, managing safe migration lifecycles, and optimizing database performance through efficient indexing and query strategies. The skill includes automated validation checks to prevent common pitfalls such as N+1 query issues, missing foreign key indexes, and unsafe raw SQL execution, ensuring your data layer is scalable, secure, and maintainable.

主な機能

01Safe raw SQL execution patterns with injection protection

02Performance optimization to eliminate N+1 queries and full table scans

03Expert schema modeling with explicit relations and automated indexing

040 GitHub stars

05Standardized migration workflows for development and production environments

06Atomic transaction management for multi-table data integrity

ユースケース

01Refactoring inefficient Prisma queries to resolve performance bottlenecks

02Designing scalable database schemas for new TypeScript and Node.js applications

03Establishing safe CI/CD pipelines for database migrations and state management

主な機能

01Safe raw SQL execution patterns with injection protection

02Performance optimization to eliminate N+1 queries and full table scans

03Expert schema modeling with explicit relations and automated indexing

040 GitHub stars

05Standardized migration workflows for development and production environments

06Atomic transaction management for multi-table data integrity

ユースケース

01Refactoring inefficient Prisma queries to resolve performance bottlenecks

02Designing scalable database schemas for new TypeScript and Node.js applications

03Establishing safe CI/CD pipelines for database migrations and state management