Skip to content

v0.1.0: Forward-only migration diagrams

Choose a tag to compare

View all tags
@fightingBald fightingBald released this 21 Sep 16:17
v0.1.0
f53ff8e

PostgreSQL migrations can now generate forward-only ER diagrams from sql-migrate/goose Up sections and separate .up.sql files. Rollback sections and .down.sql files are skipped, preventing rollback DDL from silently removing tables, columns, indexes or relationships from the diagram.

  • Direction markers inside strings, dollar-quoted blocks, comments and SQL routine bodies stay literal. Ambiguous directions produce diagnostics with original file line numbers.
  • Existing plain SQL, partial previews and the direct codegen entrypoint are preserved. No new command-line options or runtime dependencies.
  • The attached PNG and SVG show an entirely fictional library: 16 tables, 15 foreign keys and four automatically inferred groups. Generated with the default command and D2 0.7.1/ELK, without layout overrides.

Regenerate existing diagrams after upgrading. The preview images are Release assets; generated SQL and diagrams are not included in the Git tree.

Validation: 548 tests passed, including real D2/ELK rendering; Python compilation, Ruff checks and formatting passed. The attached SVG passed table, grouping and FK geometry checks, and its PNG was visually inspected.

Assets 4
Loading