Skills Guide

GORM Migration Generator

VerifiedSafe

Generate GORM database migration code for schema changes. Use when modifying database schema.

Download and use
Sby Skills Guide Bot
DevelopmentIntermediate
7/25/2026
Claude Code
#gorm#database-migration#go#schema#postgresql

Recommended for

Backend developerClaude CodeCode reviewFrontend developerFullstack developerRefactoring

Automated summary

Generates GORM migration code (models plus up/down migrations) to evolve a database schema.

Strengths

  • Enforces a precise GORM model convention with UUIDs, indexes and foreign keys
  • Explicitly separates infrastructure models from domain entities
  • Produces both up and down migrations
  • Uses section 8 of docs/REQUIREMENTS.md as the source for the current schema

Limitations

  • Heavily dependent on docs/REQUIREMENTS.md section 8 existing and being well structured
  • Assumes a Go/GORM/PostgreSQL stack with gen_random_uuid() available
  • Does not address backfilling existing data or production rollback strategies
When to use it

Use it when adding or changing tables and columns in a Go project that uses GORM.

When not to use it

Avoid it for complex data-rewrite migrations or when the ORM is not GORM.

Security analysis

Safe
Quality score72/100

This skill only provides instructions for generating GORM migration/model code and reviewing a local requirements document. It does not execute shell commands, access secrets, modify files destructively, or use network/exfiltration behavior.

No concerns found

How this analysis is made

Examples

Add finished date column
/db-migrate Add a finished_at timestamp column to the books table so users can mark a book as finished
New table with index
/db-migrate Create a book_tags table with a foreign key to books and an index on the tag name
Change column type
/db-migrate Change the status column on books to a varchar(50) with a default of 'unread' and add an index

name: db-migrate description: Generate GORM database migration code. Use when modifying database schema. argument-hint: [migration-description]

DB Migration Generator

Generate migration for: $ARGUMENTS

Instructions

  1. Review current schema in docs/REQUIREMENTS.md section 8
  2. Generate GORM AutoMigrate compatible model changes
  3. Handle both up and down migrations

GORM Model Convention

package persistence

import (
    "time"
    "github.com/google/uuid"
    "gorm.io/gorm"
)

// Infrastructure model (NOT domain entity)
type BookModel struct {
    ID         uuid.UUID  `gorm:"type:uuid;primary_key;default:gen_random_uuid()"`
    UserID     uuid.UUID  `gorm:"type:uuid;not null;index"`
    Title      string     `gorm:"type:varchar(255);not null"`
    Author     string     `gorm:"type:varchar(255);not null"`
    Status     string     `gorm:"type:varchar(50);not null;default:'unread'"`
    FinishedAt *time.Time `gorm:"type:timestamp"`
    CreatedAt  time.Time  `gorm:"autoCreateTime"`
    UpdatedAt  time.Time  `gorm:"autoUpdateTime"`
}

func (BookModel) TableName() string {
    return "books"
}

Rules

  • Infrastructure models are SEPARATE from domain entities
  • Include proper indexes for query performance
  • Use UUID for all primary keys
  • Use JSONB for flexible fields (pokemon_types)
  • Add foreign key constraints
  • Consider lock order when adding new tables

From the file to a first result

The download contains exactly the content displayed on this page. This copy may differ from the latest version in the source repository.

View the source and supporting files

This download contains SKILL.md only. Any scripts, references, templates and dependencies are not included. Get the required files from the source, preserving their directory structure, before continuing.

1. Download the file

Download SKILL.md

From the root of a test project, save the file as .skill-downloads/gorm-migration-generator-mrzxur05/SKILL.md, or use the command below. This folder is for inspecting the skill before installation.

Command for macOS/Linux or WSL: requires a POSIX shell and curl. On Windows without WSL, use the download button and create the folder manually.

mkdir -p '.skill-downloads/gorm-migration-generator-mrzxur05' && curl --fail --show-error --location 'https://skills-guides.com/api/skills/gorm-migration-generator-mrzxur05/download' --output '.skill-downloads/gorm-migration-generator-mrzxur05/SKILL.md.part' && mv '.skill-downloads/gorm-migration-generator-mrzxur05/SKILL.md.part' '.skill-downloads/gorm-migration-generator-mrzxur05/SKILL.md'

2. Check prerequisites

Read SKILL.md before using it. If it references scripts or external services, inspect them and prepare the required access in your test environment.

No recognized prerequisites section in this file. This does not mean it is self-contained: libraries, tools and access requirements may be mentioned elsewhere in the content or source repository.

The platforms on this page are catalog indications. The paths below follow tool documentation; they do not prove this skill has been run in those tools. No minimum tool version is confirmed for this listing.

3. Load the skill

After inspection, copy the complete folder into your project using one of the commands below, then open a new tool session. The command stops if a folder with the same name already exists: compare the files before replacing it.

Claude Code
test -f '.skill-downloads/gorm-migration-generator-mrzxur05/SKILL.md' && test -s '.skill-downloads/gorm-migration-generator-mrzxur05/SKILL.md' && mkdir -p '.claude/skills' && test ! -e '.claude/skills/db-migrate' && cp -R '.skill-downloads/gorm-migration-generator-mrzxur05' '.claude/skills/db-migrate'

OpenSkills

OpenSkills must already be installed. The local install/read procedure is checked with OpenSkills 1.5.0, which requires Node.js ≥ 20.6.0. Catalog slugs are not resolved automatically.

Official OpenSkills installation
openskills install './.skill-downloads/gorm-migration-generator-mrzxur05'

openskills read 'gorm-migration-generator-mrzxur05'

Reading should display the installed file content and its base directory. It does not run the skill or install its dependencies.

For an agent that reads AGENTS.md, then sync the index. This command changes AGENTS.md: review the diff before using it.

openskills sync

Manual method or another tool: attach SKILL.md to a conversation, or open it in an agent that can read files. Include any required supporting resources. No universal folder is recognized by every tool.

4. Try a first task

Use a short, synthetic input: an API endpoint, a small document or an interface brief. In a new conversation, attach the file or give the agent its path, then adapt this request:

Read .skill-downloads/gorm-migration-generator-mrzxur05/SKILL.md and apply its instructions to this example: [describe a test input]. Identify any missing files, dependencies or access. Produce the result requested by the skill without inventing data or running unreviewed scripts.

Expected result: output matching the skill instructions, or a precise list of missing prerequisites. A read confirmation alone does not validate a first use. If an external resource is unavailable, that path remains untested.

Related skills

React Hook Form Best Practices

Development

Master React Hook Form: avoid anti-patterns, manage subscriptions, and handle reset, dirty state, and controlled inputs correctly.

Claude CodeCursorWindsurf+2intermediateSafe 108,623
Skills Guide Bot

Emotion to Mantine Migration

Development

Migrate Emotion styled-components to Mantine components with style props and CSS modules. Use when converting .styled.tsx files or removing @emotion imports.

Claude CodeCursorWindsurf+1intermediateSafe 48,981
Skills Guide Bot

Scope Creep Detector

Development

Analyzes git diffs against a stated intent to detect scope creep, unrelated files, broad PRs, and oversized changes, then suggests keep, split, or justify actions.

Claude CodeCursorCodexintermediateSafe 135,015
Skills Guide Bot