Squashing AdonisJS Migrations: A Tool I Built

#adonisjs #typescript #webdev #database

The Problem

After years of development, AdonisJS projects often accumulate hundreds of migration files:

🐌 Slow fresh deployments (running 100+ migrations)
📂 Cluttered migration folders
🔍 Hard to understand current schema
🧹 No official way to consolidate like Django's squashmigrations

The Solution

I built adonis-lucid-migration-squash to solve this!

What it does:

Takes your PostgreSQL schema dump and converts it to a clean, single Knex migration with:

✅ Smart enum detection
✅ Proper foreign keys & constraints
✅ Automated verification
✅ Complete up() and down() methods

Quick Start:

# 1. Dump your production schema
pg_dump -s --no-owner --no-acl > schema.sql

# 2. Convert to Knex migration
python -m pg_to_knex schema.sql baseline_migration.ts

# 3. Archive old migrations, use the baseline!
mv database/migrations/*.ts database/archive/
mv baseline.ts database/migrations/1_baseline.ts

Example Output:
Instead of raw SQL, you get clean Knex code:

export async function up(knex: Knex) {
  await knex.schema.createTable('users', (table) => {
    table.uuid('id').primary()
    table.string('email').notNullable().unique()
    table.enum('role', ['admin', 'user']).defaultTo('user')
    table.timestamps(true, true)
  })
}

When to use it?

✅ Before major version releases
✅ When you have 50+ migrations
✅ Creating a clean foundation
✅ All environments are on the same version

Check it out!

🔗 GitHub Would love to hear feedback from the AdonisJS community! 🚀 #adonisjs #nodejs #typescript #database #migrations

DEV Community