Can it handle data migrations as well as schema changes?

Yes, it includes patterns for batch updates and copying data between tables to ensure large-scale data migrations don't exhaust system resources.

Does this work with databases other than PostgreSQL?

While Sequelize supports multiple dialects, this skill specifically focuses on PostgreSQL-optimized patterns like GIN indexes and JSONB handling.

How do I use the concurrent index feature?

The skill provides specific raw SQL templates for concurrent operations since these operations must be executed outside of standard Sequelize transactions.

Does it provide rollback (down) migration logic?

Every pattern included in this skill provides both 'up' and 'down' migration functions to ensure your database changes remain reversible.

How does this skill help with production database safety?

It provides specific patterns like concurrent indexing and multi-step column additions to minimize table locking and prevent downtime during migrations.

Sequelize Migration Expert

Name: Sequelize Migration Expert
Author: francanete

byfrancanete

データベース管理

Provides battle-tested Sequelize migration patterns and best practices for safe PostgreSQL schema changes.

概要

The Sequelize Migration Expert skill equips Claude with specialized knowledge for managing database schema evolutions using the Sequelize ORM. It offers standardized guidance on creating tables, managing complex indexes (including GIN and Concurrent), handling foreign key constraints, and performing safe data migrations on production databases. By implementing established patterns for non-blocking index creation and multi-step column modifications, this skill ensures that your database changes are reliable, reversible, and optimized for PostgreSQL performance.

主な機能

Batch data migration strategies to prevent production table locking
Safe patterns for adding NOT NULL columns to existing tables
Standardized templates for table creation and foreign key management
0 GitHub stars
Complex column type modifications using PostgreSQL USING clauses
Advanced index management including GIN, expression, and concurrent indexing

ユースケース

Designing and implementing new database schemas for Node.js applications
Optimizing query performance through specialized PostgreSQL indexing patterns
Refactoring production database columns without downtime or data loss

概要

主な機能

Batch data migration strategies to prevent production table locking
Safe patterns for adding NOT NULL columns to existing tables
Standardized templates for table creation and foreign key management
0 GitHub stars
Complex column type modifications using PostgreSQL USING clauses
Advanced index management including GIN, expression, and concurrent indexing

ユースケース

Designing and implementing new database schemas for Node.js applications
Optimizing query performance through specialized PostgreSQL indexing patterns
Refactoring production database columns without downtime or data loss