AgentSkillsCN

postgres-migrations

针对 Go 项目中的数据库 Schema 变更与 SQLC 查询生成/维护，提供详尽的数据库迁移操作手册与 checklist。

SKILL.md
--- frontmatter
name: postgres-migrations
description: Database migration playbook/checklist for schema changes and sqlc query generation/maintenance in Go projects.
license: MIT
compatibility: opencode
metadata:
  audience: backend-dev
  workflow: db+sqlc

What I do

  • •Summarize steps for creating .up.sql/.down.sql migrations, using golang-migrate
  • •Provide guidance for keeping sqlc queries (queries.sql) in sync with DB state
  • •Highlight test patterns for migrations to avoid accidental destructive changes

When to use me

Use when growing/changing your schema or when generating new go types with sqlc. Ensures teamwide discipline and repeatability in DB evolution.

Example Usage

Reference when editing files in backend/internal/db/migrations/ and regenerating code with sqlc after migration deployment.