feat: Add migration check script and docs

Commit notes

Adds a script to check for pending migrations and comprehensive documentation on migration strategies.

Co-authored-by: armin.naimi <[email redacted]>