MigraDiff now diffs COMMENT ON metadata across all major PostgreSQL object types — tables, columns, views, materialized views, functions, sequences, types, indexes, constraints, and schemas.
Why this matters
If you store schema documentation, AI context, or compliance metadata in COMMENT ON blocks, MigraDiff no longer silently drops it during migrations. Added, changed, and removed comments all generate the correct COMMENT ON (or COMMENT ON ... IS NULL) SQL.
AI integration
--explain and --generate now read your COMMENT ON metadata as schema context. The AI knows not just that a column is text, but what it's for — richer explanations, more accurate generated migrations.
Works everywhere
- Live connections: queries
pg_catalog.pg_descriptiondirectly --from-filemode: works automatically with pg_dump output--output json: all comment changes classified assaferisk
190 tests passing. No new dependencies.
pip install --upgrade migradiff