スキルを検索.../

Backend Prisma Migrations Safe | Skills Pool

Skill ファイル

Backend Prisma Migrations Safe

Execute safe Prisma schema and migration changes for ERP environments, including drift handling, immutable applied migrations, dev/prod rollout sequence, and rollback-safe practices. Use when changing Prisma models or migration history.

kr4ge0 スター2026/03/30

職業
カテゴリ: データベースツール

スキル内容

Goal

Ship schema changes without breaking migration history or requiring destructive resets.

Rules

Never edit an already-applied migration in shared environments.
Create a new migration for every schema evolution.
Keep schema and generated client consistent.

Workflow

Plan the change.

Confirm nullability/default/index/unique behavior.
Evaluate impact on existing data.

Create migration in dev.

Update schema.prisma.
Generate a new migration file.
Apply migration locally.

Validate behavior.

Build API after migration.
Test the affected queries/writes.

Promote to production safely.

Use deploy-time migration command that applies pending migrations only.

関連 Skill

クイックインストール

Backend Prisma Migrations Safe

npx skills add kr4ge/erp-nextbigmove

Skill をダウンロードリポジトリを開く

作者: kr4ge
スター: 0
更新日: 2026/03/30
職業

このページの内容

Do not use destructive reset flows on production.

Drift Handling

If drift is reported, inspect migration history and DB schema mismatch.
Do not fix drift by rewriting old migration files.
Resolve by creating forward migration or aligning DB manually with explicit SQL, then mark migration state correctly.

References

Use references/prisma-migration-checklist.md before finalizing.

02

Rules

04Drift Handling

データベースアーキテクト

データベースツール

Database Migrations

数据库迁移最佳实践，涵盖模式变更、数据迁移、回滚以及零停机部署，适用于PostgreSQL、MySQL及常用ORM（Prisma、Drizzle、Django、TypeORM、golang-migrate）。

データベースツール

Database Migrations

Şema değişiklikleri, veri migration'ları, rollback'ler ve PostgreSQL, MySQL ve yaygın ORM'ler (Prisma, Drizzle, Django, TypeORM, golang-migrate) arasında sıfır kesinti deployment'ları için veritabanı migration en iyi uygulamaları.

データエンジニアリング

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

データベースツール

Frontend Query & Mutation

Guide for implementing Dify frontend query and mutation patterns with TanStack Query and oRPC. Trigger when creating or updating contracts in web/contract, wiring router composition, consuming consoleQuery or marketplaceQuery in components or services, deciding whether to call queryOptions() directly or extract a helper or use-* hook, handling conditional queries, cache invalidation, mutation error handling, or migrating legacy service calls to contract-first query and mutation helpers.

langgenius138.3k

データベースツール

Db Migrations

Use when generating or regenerating Drizzle migration files, changing database schema tables or columns, resolving migration sequence conflicts after rebase, reviewing migration SQL for idempotent patterns, or renaming migration files.

CMS・プラットフォーム

Drizzle

Drizzle ORM schema and database guide. Use when working with database schemas (src/database/schemas/*), defining tables, creating migrations, or database model code. Triggers on Drizzle schema definition, database migrations, or ORM usage questions.

データベースアーキテクト