How I Built a Lightweight PostgreSQL Schema Drift Detector and Migration Generator in Python

说明与用途

schemadrift 检测 PostgreSQL 生产与预发布数据库之间的模式漂移，并生成安全的迁移脚本，支持在 GitHub Actions 中集成检查。

问题

Manual hotfix queries in production can silently drift schemas, causing deployment pipeline failures and live endpoint crashes.

结果

schemadrift provides zero-downtime indexing, safe dependency ordering, and interactive audit reports, allowing teams to detect and fix schema drift before deployment failures.

工作流

• Install schemadrift via pip
• Run schemadrift diff with source and target database URLs
• Optionally output migration SQL or an HTML audit report
• Integrate schemadrift into GitHub Actions to gate PRs and block breaking drift

证据

Most teams only catch this after a table lock or a missing column crashes a live endpoint.

来源

I wanted a clean tool that can run inside a lightweight GitHub Action runner or terminal without managing proprietary state files.

来源

schemadrift is officially published on the GitHub Marketplace. You can gate your pull requests and block breaking schema drift automatically.

来源