Database migration rollback in Python: dblift undo
Roll back SQL migrations in Python with undo files: see which versions are undoable, preview the exact SQL with a dry run, then undo to a target version.
Add migrations to an existing database: baseline
Add versioned SQL migrations to a PostgreSQL database that already has tables and data: check state, record a baseline, then apply only the next change.
Django raw SQL migrations next to the ORM: views, indexes, rollback
Keep Django's ORM migrations. Version the SQL it does not own, views, indexes, reference data, next to them with a manage.py check warning. Real output, one failure, one rollback.
dblift speaks MCP
Claude Code, Cursor, and Copilot can now call DBLift directly — validate, diff, and preflight as tools, not shell commands the agent hopes it ran right.
MongoDB migrations in Python with DBLift
Run MongoDB migrations in Python with DBLift and PyMongo: create indexes, backfill documents, track versions, and write an explicit undo with clear limits.
DBLift vs Alembic: pick by how you write schema changes
Looking for an Alembic alternative? Alembic diffs your models into Python revisions; DBLift runs the SQL you wrote, in version order. Where each one fits, with the two-heads merge case worked through.
Flyway for Python: migrate versioned SQL with DBLift
Using Flyway with Python? Compare the workflows, keep versioned SQL, import migration history into DBLift, and handle Java migrations before switching.
Python database migrations: a SQL and Python tutorial
Learn Python database migrations with DBLift: version SQL and Python files, preview and apply changes on SQLite, validate checksums, and undo a migration.
SQL quality with DBLift: catch issues before production
Use validate-sql for offline SQL policy checks, SARIF and GitHub Actions output, and team-specific rules before a database connection is required in CI.
Database migration best practices for production teams
Keep migrations small, test rollbacks, establish baselines on existing schemas, and add plan/preflight evidence before high-risk production releases.
Database engine coverage: DuckDB, PostgreSQL clouds, and analytics platforms
How DBLift’s open core covers traditional RDBMS, DuckDB, PostgreSQL-compatible clouds, and related analytics targets — and which pip extras to install.