Skip to content

MigraDiff

v1.5.0 Breaking

This release includes breaking changes for platform teams planning a safe upgrade.

Published 2d Relational Databases
✓ No known CVEs patched
Read the diff → Tool health → What is this tool? →

✓ No known CVEs patched in this version

ReleasePort's take

Light signal
editorial:auto 2d

MigraDiff v1.5.0 now diffs COMMENT ON metadata for all PostgreSQL object types and leverages comments to generate AI‑driven explanations.

Why it matters: Enables richer, AI‑assisted schema change documentation directly within MigraDiff outputs.

Summary

AI summary

MigraDiff now diffs COMMENT ON metadata across PostgreSQL object types and uses comments for AI‑driven explanations.

Changes in this release

Feature Medium

Adds diffing of COMMENT ON metadata for all PostgreSQL object types

Adds diffing of COMMENT ON metadata for all PostgreSQL object types

Source: llm_adapter@2026-06-02

Confidence: high

Feature Low

`--explain` and `--generate` now use `COMMENT ON` metadata as AI context.

`--explain` and `--generate` now use `COMMENT ON` metadata as AI context.

Source: granite4.1:30b@2026-06-02-audit

Confidence: low

Feature Low

Supports live connections by querying `pg_catalog.pg_description` directly.

Supports live connections by querying `pg_catalog.pg_description` directly.

Source: granite4.1:30b@2026-06-02-audit

Confidence: low

Feature Low

Automatically handles `COMMENT ON` metadata in `--from-file` mode with pg_dump output.

Automatically handles `COMMENT ON` metadata in `--from-file` mode with pg_dump output.

Source: granite4.1:30b@2026-06-02-audit

Confidence: low

Feature Low

`--output json` classifies all comment changes as `safe` risk.

`--output json` classifies all comment changes as `safe` risk.

Source: granite4.1:30b@2026-06-02-audit

Confidence: low

Dependency Low

No new dependencies were added.

No new dependencies were added.

Source: granite4.1:30b@2026-06-02-audit

Confidence: low

Performance Low

190 tests are passing.

190 tests are passing.

Source: granite4.1:30b@2026-06-02-audit

Confidence: low

Full changelog

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_description directly
  • --from-file mode: works automatically with pg_dump output
  • --output json: all comment changes classified as safe risk

190 tests passing. No new dependencies.

pip install --upgrade migradiff

Weekly OSS security release digest.

The CVE patches and breaking changes that affected production tools this week. One email, every Sunday.

No spam, unsubscribe anytime.

Share this release

Track MigraDiff

Get notified when new releases ship.

Sign up free

About MigraDiff

All releases →

Related context

Earlier breaking changes

  • v1.1.0 Requires uninstalling original migra before installing migradiff

Beta — feedback welcome: [email protected]