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.

Источник