스킬 파일

Create Flyway Migration

Name: Create Flyway Migration
Author: rasterwebapps

Create a new Flyway SQL migration file for OneBook with proper naming convention, RLS policies, tenant isolation, and PostgreSQL 17 best practices.

rasterwebapps0 스타2026. 4. 9.

직업
카테고리: 데이터베이스 도구

스킬 내용

Create a new Flyway database migration following OneBook conventions.

When to Use

Adding a new database table
Modifying an existing table (columns, constraints, indexes)
Adding or updating RLS policies
Creating database functions or triggers
Adding seed/reference data

Steps

1. Determine the Next Migration Version

Check existing migrations to find the next available version number:

ls backend/src/main/resources/db/migration/ | sort -V | tail -5

Current migrations: V1–V14 (V12 intentionally skipped). Next available: V15.

2. Create the Migration File

File naming convention: V{N}__{description}.sql (two underscores).

Create the file at:

관련 스킬

Create Flyway Migration | Skills Pool

backend/src/main/resources/db/migration/V{N}__{description}.sql

-- V{N}: {Description}
-- Tables: {list of tables created/modified}
-- RLS: yes
-- Author: @database agent

CREATE TABLE {table_name} (
    id BIGSERIAL PRIMARY KEY,
    tenant_id VARCHAR(255) NOT NULL,
    -- domain-specific columns here
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

-- Multi-tenant isolation (REQUIRED for every tenant-scoped table)
ALTER TABLE {table_name} ENABLE ROW LEVEL SECURITY;
CREATE POLICY {table_name}_tenant_isolation ON {table_name}
    USING (tenant_id = current_setting('app.tenant_id', true));

-- Indexes
CREATE INDEX idx_{table_name}_tenant ON {table_name}(tenant_id);

Data Type	SQL Type	Notes
Money/amounts	`NUMERIC(19,4)`	Never FLOAT/DOUBLE
Timestamps	`TIMESTAMPTZ`	Never TIMESTAMP without TZ
Tenant ID	`VARCHAR(255) NOT NULL`	Every table
Primary key	`BIGSERIAL`	Auto-increment
Encrypted text	`TEXT`	Stores Base64 ciphertext
Metadata	`JSONB`	Flexible JSON
Status/enums	`VARCHAR(50)`	Short strings

Create Flyway Migration

When to Use

Steps

1. Determine the Next Migration Version

2. Create the Migration File

Create Flyway Migration

When to Use

Steps

1. Determine the Next Migration Version

2. Create the Migration File

3. Use the Standard Table Template

4. Column Type Rules

5. Validate

References

Database Migrations

Database Migrations

Postgres Patterns

Frontend Query & Mutation

Db Migrations

Drizzle