Overview

The ecto-migration skill generates new Ecto migration files for the Blockscout project using the Mix task. Migrations are used to evolve the database schema over time in a versioned and controlled manner.

When to Use

When creating new database tables
When modifying existing table structures (add/remove/change columns)
When adding or removing database indexes
When performing data migrations or transformations
When implementing database constraints or relationships

How to Apply

Run the following command from the workspace root:

mix ecto.gen.migration [migration_name] -r Explorer.Repo

Replace [migration_name] with a descriptive name for your migration using snake_case (e.g., add_users_table, alter_transactions_status).

mix ecto.gen.migration add_metadata_to_blocks -r Explorer.Repo

defmodule Explorer.Repo.Migrations.AddMetadataToBlocks do
  use Ecto.Migration

  def change do
    alter table(:blocks) do
      add :metadata, :jsonb
    end
  end
end

Ecto Migration | Skills Pool

Ecto Migration

Ecto Migration

Overview

When to Use

How to Apply

What It Does

Example Usage

Notes

Database Migrations

Database Migrations

Postgres Patterns

Frontend Query & Mutation

Db Migrations

Drizzle