スキルを検索.../

Add Database Migration | Skills Pool

Skill ファイル

Add Database Migration

Author, validate, and document Postgres schema migrations in this monorepo. Use when asked to add tables/columns/indexes, modify schema, or prepare rollback-safe DB changes.

namuan0 スター2026/03/02

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

スキル内容

Use this skill for all schema changes in db/migrations.

1) Treat migrations as cross-service changes

This repo uses a shared Postgres schema used by both APIs.

Go API and Java API are both impacted by schema changes.
Prefer additive, phased changes to keep compatibility during rollout.

2) Create migration files with strict naming

Create paired files in db/migrations:

NNNNNN_description.up.sql
NNNNNN_description.down.sql

Rules:

6-digit zero-padded increasing prefix
lowercase snake_case description
never edit already committed migrations; create a new corrective migration instead

Reference: docs/db-migrations.md

3) Write safe SQL

Keep each migration focused on one logical change.

関連 Skill

クイックインストール

Add Database Migration

npx skills add namuan/nx-multi-repo-template

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

作者: namuan
スター: 0
更新日: 2026/03/02
職業

このページの内容

011) Treat migrations as cross-service changes

Prefer additive changes first (columns, tables, indexes).

For destructive changes, split into phased migrations where possible.

Ensure down migration reverses dependency order (children before parents) when feasible.

4) Update dependent code/contracts when needed

If schema changes affect API payloads or behavior:

update owning service code (Java/Go)
update OpenAPI files (docs/openapi/api-java.yaml or docs/openapi/api-go.yaml)
update related E2E tests in same change

5) Validate locally

Run migration and seed flow from repo root:

npm run db:migrate
npm run db:seed

Then run relevant tests:

npm run test:e2e:backend for cross-service confidence
targeted service tests/lint as needed

6) Keep demo/test data separation

Put schema changes in migrations only.
Put demo data in db/seeds/demo.sql (or other seed files), not migration files.

02

2) Create migration files with strict naming

033) Write safe SQL

044) Update dependent code/contracts when needed

055) Validate locally

066) Keep demo/test data separation

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

SQL データベース

Postgres Patterns

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

SQL データベース

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.

SQL データベース

Database Migrations

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.

SQL データベース

Postgres Patterns

쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.

データエンジニアリング

Postgres Patterns

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

SQL データベース

Jpa Patterns

Spring Boot中的JPA/Hibernate模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。

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