Skill ファイル

Create Migration

Name: Create Migration
Author: dpovey

Create a database migration with schema and type updates. Use when modifying the database schema, adding tables, columns, or indexes.

dpovey0 スター2026/02/07

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

スキル内容

Create Database Migration

Step-by-step process for making database schema changes.

When to Use

Adding, removing, or modifying database tables or columns
Adding indexes or constraints
Any change to the database schema

Instructions

1. Create the Migration File

pnpm migrate:create {description}

Example: pnpm migrate:create add-foo-column

This creates a timestamped file in migrations/.

2. Edit the Migration

Open migrations/TIMESTAMP_{description}.js and add your SQL:

関連 Skill

Create Migration | Skills Pool

exports.up = async (db) => {
  await db.query(`
    ALTER TABLE your_table
    ADD COLUMN new_column TEXT
  `)
}

exports.down = async (db) => {
  await db.query(`
    ALTER TABLE your_table
    DROP COLUMN new_column
  `)
}

pnpm migrate

File	Purpose
`migrations/*.js`	Production migration files
`src/lib/schema.sql`	Full schema for fresh test DBs
`src/lib/db-types.ts`	TypeScript types for DB entities
`src/lib/db.ts`	Query functions

Create Migration

Create Database Migration

When to Use

Instructions

1. Create the Migration File

2. Edit the Migration

Create Migration

Create Database Migration

When to Use

Instructions

1. Create the Migration File

2. Edit the Migration

3. Update Schema File

4. Update TypeScript Types

5. Update Query Functions

6. Run the Migration

7. Verify

Key Files

Reference

Database Migrations

Database Migrations

Postgres Patterns

Frontend Query & Mutation

Db Migrations

Drizzle