搵技能.../

Migrate Check | Skills Pool

技能檔案

Migrate Check

This skill should be used when the user creates or edits a database migration, mentions "migration safety", "schema change", "database migration", "add column", "drop column", "rename table", "migration review", or discusses database schema changes. Provides automatic safety analysis of migration files.

a-abdellatif980 星標2026年3月10日

職業
分類: 數據庫工具

技能內容

Migration Safety Check Skill

This skill automatically activates when database migration files are being created or modified, providing real-time safety guidance.

When This Skill Applies

This skill activates when:

The user creates a new migration file
The user edits an existing migration
The user asks about migration safety or best practices
Schema change operations are being planned
The user mentions dropping, renaming, or altering database columns/tables

Safety Rules

Always Apply These Checks

When a migration file is created or edited, automatically check for:

Destructive operations: DROP, remove_column, drop_table, RemoveField, DeleteModel

相關技能

快速安裝

Migrate Check

npx skills add a-abdellatif98/db-migration-guard

下載 Skill 打開源碼倉庫

作者: a-abdellatif98
星標: 0
更新時間: 2026年3月10日
職業

本頁內容

01Migration Safety Check Skill

Warn the user about data loss

Suggest the phased removal pattern (stop writing, stop reading, then remove)

Rename operations: rename_column, rename_table, RenameField

Warn about deployment downtime
Suggest add/backfill/swap/drop pattern

Type changes: change_column, AlterField, ALTER COLUMN TYPE

Warn about data compatibility and table locks
Suggest testing with production-like data

NOT NULL without defaults: null: false / NOT NULL without default:

Warn this will fail on populated tables
Suggest adding nullable first, then backfilling

Non-concurrent indexes (PostgreSQL): add_index without algorithm: :concurrently

Warn about table write locks
Provide the concurrent alternative with disable_ddl_transaction!

Mixed data and schema changes

Warn about partial failure risks
Suggest splitting into separate migrations

Framework-Specific Guidance

Rails:

Recommend strong_migrations gem for automated checks
Use safety_assured blocks only when risk is understood
Ensure disable_ddl_transaction! is used with concurrent operations

Django:

Use AddIndexConcurrently from django.contrib.postgres.operations
Separate RunPython data migrations from schema operations
Use SeparateDatabaseAndState for complex changes

Laravel:

Use doctrine/dbal for column modifications
Test migrations with --pretend flag first
Use Schema::hasColumn guards for safety

Prisma:

Check prisma migrate diff output before applying
Use @default for new required fields
Be cautious with @map and @@map renames

Response Format

When this skill activates, prepend the migration analysis before any other response:

**Migration Safety Analysis**
Risk Level: SAFE / WARNING / DANGEROUS

[List of issues found, if any]
[Suggested fixes, if any]

02

When This Skill Applies

04Always Apply These Checks

05Framework-Specific Guidance

06Response Format

資料庫架構師

數據庫工具

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.

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.

資料庫架構師