Menu
Create, apply, and rollback goose migrations for SQLite using the embedded migrate tool.
Run mjr.wtf locally using Docker Compose (SQLite), including migrations, logs, and teardown.
Operate and validate mjr.wtf observability endpoints (/health, /metrics) and logging-related behavior. Use when adding metrics, changing auth around metrics, or debugging production-like issues.
Apply project-specific security and privacy guardrails (auth, headers, rate limiting, logging). Use when touching authentication, request handling, metrics exposure, or anything that could leak sensitive data.
Run, debug, and structure tests for this Go project (unit + integration), including generation prerequisites. Use when changing domain logic, repositories, HTTP handlers, or migrations.
Run and extend the end-to-end HTTP integration tests (SQLite in-memory) for mjr.wtf, covering auth, create/list/delete, redirects, and analytics. Use when changing handlers, middleware, or API contracts.
Run and troubleshoot project code generation (sqlc + templ).
| 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 | {"repo":"mjrwtf","runner":"github-copilot-cli","version":1.2} |
| allowed-tools | Bash(git:*) Bash(make:*) Bash(go:*) Bash(curl:*) Read |
internal/migrations/sqlite/.bin/migrate tool at build time.DATABASE_URL must point at the SQLite database file you intend to migrate.export DATABASE_URL=./database.db
make build-migrate
make migrate-up
make migrate-status
make migrate-down
make migrate-create NAME=add_feature_x
Then implement it in:
internal/migrations/sqlite/<timestamp>_add_feature_x.sqlmake build-migrate).up and down against a local DB.