Skip to content

Pgmig

Relational Databases

Generate SQL migrations to make one Postgres database match another

Python Latest v1.0.1 · 6d ago Security brief →

Features

  • Compare two PostgreSQL schemas and output the required migration SQL
  • Read‑only connections – never applies changes automatically
  • Supports Postgres versions 14–18 with CI testing
  • Usable as a command‑line tool or Python library
  • Fine‑grained options (concurrent indexes, ownership, grants, etc.)

Recent releases

View all 14 releases →
No immediate action
v1.0.1 New feature

--ignore-schema flag

Review required
v1.0.0 New feature
RBAC

Privilege diffing

Review required
v0.2.0 Breaking risk
Auth RBAC

Release notes preview, enum rename, DB reset

No immediate action
v0.1.1 Mixed

Exclusion constraints + UNLOGGED sync + generated columns + perf

No immediate action
v0.1.0 Breaking risk

API refactor + matview index fix + unsupported change error

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.

About

Stars
11
Forks
1
Languages
Python PLSQL

Install & Platforms

Install via
pip

Beta — feedback welcome: [email protected]