capysquash-cli EXAMPLES

Real-world examples for common capysquash-cli use cases.

💡 Looking for easier workflows? CAPYSQUASH Platform provides one-click squashing without command-line complexity. These examples are for CLI users.

GETTING STARTED

First-Time Analysis

# See what you're working with
capysquash analyze migrations/*.sql

# Preview consolidation
capysquash squash migrations/*.sql --dry-run

# Run it!
capysquash squash migrations/*.sql --output clean/

# Validate
capysquash validate migrations/ clean/

BY USE CASE

Solo Developer

Quick cleanup:

capysquash squash migrations/*.sql --safety standard --output clean/

Maximum optimization:

capysquash squash migrations/*.sql --safety aggressive --output dev-clean/

Team / Production

Safe for production:

capysquash squash migrations/*.sql \
  --safety conservative \
  --output production/ \
  --preserve-comments \
  --validate

Large Projects (500+ migrations)

Memory-efficient:

capysquash squash migrations/*.sql \
  --streaming \
  --memory-limit 512 \
  --parallel 4 \
  --output clean/

BY PLATFORM

Supabase

capysquash squash supabase/migrations/*.sql \
  --safety conservative \
  --output supabase/migrations_clean/

Prisma

capysquash squash prisma/migrations/*/migration.sql \
  --safety standard \
  --output prisma/migrations_consolidated/

Custom Migrations

capysquash squash db/migrate/*.sql \
  --safety standard \
  --output db/migrate_clean/

ADVANCED WORKFLOWS

CI/CD Pipeline

#!/bin/bash
set -e

# Analyze
capysquash analyze migrations/*.sql || exit 1

# Squash
capysquash squash migrations/*.sql --output clean/ || exit 1

# Validate
capysquash validate migrations/ clean/ || exit 1

# Commit
git add clean/
git commit -m "chore: consolidate migrations"

Pre-Deployment Check

# Before deploying, verify migrations are clean
capysquash analyze migrations/*.sql --report-format json > analysis.json

# Check consolidation potential
if jq '.consolidation_percentage > 50' analysis.json; then
  echo "Consider consolidating migrations"
fi

Regular Maintenance

# Monthly consolidation
capysquash squash migrations/*.sql \
  --safety conservative \
  --output "migrations_$(date +%Y%m)/" \
  --validate

TROUBLESHOOTING EXAMPLES

Debug Parse Errors

capysquash analyze migrations/*.sql --verbose

Find Circular Dependencies

capysquash squash migrations/*.sql --detect-cycles --cycle-details

Test Different Safety Levels

for safety in paranoid conservative standard aggressive; do
  echo "Testing $safety..."
  capysquash squash migrations/*.sql \
    --safety $safety \
    --output "test_$safety/" \
    --dry-run
done

capysquash-cli Examples