Claude Code Plugins

Community-maintained marketplace

Feedback

database-migrations

@matt-riley/mjrwtf
0
0

Create, apply, and rollback goose migrations for SQLite using the embedded migrate tool.

Install Skill

1Download skill
2Enable skills in Claude

Open claude.ai/settings/capabilities and find the "Skills" section

3Upload to Claude

Click "Upload skill" and select the downloaded ZIP file

Note: Please verify skill by going through its instructions before using it.

SKILL.md

name database-migrations
description Create, apply, and rollback goose migrations for SQLite using the embedded migrate tool.
license MIT
compatibility Requires bash, git, Go, make, and DATABASE_URL set.
metadata [object Object]
allowed-tools Bash(git:*) Bash(make:*) Bash(go:*) Bash(curl:*) Read

Key facts for this repo

  • Migrations live in internal/migrations/sqlite/.
  • Migrations are embedded into the bin/migrate tool at build time.
  • DATABASE_URL must point at the SQLite database file you intend to migrate.

Common workflows

Apply migrations

export DATABASE_URL=./database.db
make build-migrate
make migrate-up

Check migration status

make migrate-status

Roll back one migration

make migrate-down

Create a new migration

make migrate-create NAME=add_feature_x

Then implement it in:

  • internal/migrations/sqlite/<timestamp>_add_feature_x.sql

Checklist

  1. Write both Up and Down.
  2. Rebuild migrate tool (make build-migrate).
  3. Verify up and down against a local DB.