菜单
Database migration tools for Go projects. Use when writing migrations, running sql-migrate CLI, embedding migrations in Go apps, or setting up new database schemas. Covers PostgreSQL, MySQL/MariaDB, SQLite, SQL Server.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
| name | use-sqlmigrate |
| description | Database migration tools for Go projects. Use when writing migrations, running sql-migrate CLI, embedding migrations in Go apps, or setting up new database schemas. Covers PostgreSQL, MySQL/MariaDB, SQLite, SQL Server. |
| depends | ["go-stack"] |
sqlmigrate is a feature-branch-friendly SQL migration system with two modes:
sql-migrate) — generates shell scripts that pipe to shsqlmigrate + backend) — embed migrations in Go binariesBoth use the same migration file format and _migrations tracking table.
| Skill | When to use |
|---|---|
use-sql-migrate-cli | CLI tool: init, create, up, down, sync, status |
use-sql-migrate-golang | Go library: embed migrations, Migrator interface, auto-migrate on startup |
use-sql-migrate-postgres | PostgreSQL: pgx connection, schema multi-tenancy, PGOPTIONS |
use-sql-migrate-mysql | MySQL/MariaDB: multiStatements DSN, MY_CNF, mariadb vs mysql |
use-sql-migrate-sqlite | SQLite: foreign keys pragma, modernc.org/sqlite driver |
use-sql-migrate-sqlserver | SQL Server: sqlcmd, TDS 8.0 encryption, SQLCMD* env vars |
<yyyy-mm-dd>-<number>_<name>.<up|down>.sql
2026-04-05-001000_create-todos.up.sql
2026-04-05-001000_create-todos.down.sql
0001-01-01-001000_init-migrations.up.sql MUST end with INSERT INTO _migrations (name, id) VALUES ('<name>', '<8-hex-id>');.down.sql MUST end with DELETE FROM _migrations WHERE id = '<8-hex-id>';PostgreSQL migrations with sql-migrate and pgmigrate. Use when setting up PostgreSQL migrations, schema multi-tenancy, or pgx connection for migrations.
sql-migrate CLI tool for database migrations. Use when initializing migrations, creating migration files, running up/down, checking status, or generating migration scripts. Covers psql, mariadb, mysql, sqlite, sqlcmd.
Embed SQL migrations in Go applications using sqlmigrate library. Use when writing Go code that runs migrations on startup, implements auto-migrate, or uses the Migrator interface. Covers pgmigrate, mymigrate, litemigrate, msmigrate.
MySQL and MariaDB migrations with sql-migrate and mymigrate. Use when setting up MySQL/MariaDB migrations, configuring multiStatements, or MY_CNF credentials.
SQLite migrations with sql-migrate and litemigrate. Use when setting up SQLite migrations, configuring foreign keys, or using modernc.org/sqlite driver.
SQL Server migrations with sql-migrate and msmigrate. Use when setting up SQL Server migrations, configuring sqlcmd, TDS 8.0 encryption, or SQLCMD environment variables.