manage-database

Use this skill when running Hanami 2.x database CLI commands.

Core principle: Database commands are environment-aware. Always confirm HANAMI_ENV and DATABASE_URL before running destructive commands.

Commands

Usage examples

Create the database:

DATABASE_URL=postgres://localhost/my_app_development hanami db create

Run migrations (validate with hanami db version - prints timestamp of last applied migration):

hanami db migrate
hanami db version

Roll back the last migration (only works if migration is reversible - change block, or explicit up/down; drop_column/rename_column require explicit up/down):

hanami db rollback
hanami db version  # Should print the previous migration's timestamp

Run seed data (db/seeds.rb is executed):

hanami db seed

# db/seeds.rb
# frozen_string_literal: true

rom = Hanami.app["db.rom"]
users = rom.relations[:users]

users.insert(email: "admin@example.com", first_name: "Admin", role: "admin")

Prepare the database:

hanami db prepare

Destructive Operations

hanami db drop deletes all data and cannot be undone. Always validate before proceeding.

Safe drop procedure:

echo $HANAMI_ENV   # Must output "development" or "test" - never "production"
hanami db drop     # Only proceed if environment is confirmed

Preconditions for all commands:

• DATABASE_URL environment variable is set
• Database server is running (for PostgreSQL/MySQL)
• User has permissions to create/drop databases (for db create / db drop)

Common Mistakes

Integration