Cosmos DB schema migrations with DBLift
Cosmos DB schema migrations with DBLift are Python files for the Azure Cosmos DB for NoSQL API. Open source, no licence. DBLift does not copy data between databases.
Check pending database migrations with info and validate
Check pending database migrations with dblift info, then confirm applied history with dblift validate. Real output from DBLift 4.11.1 on SQLite, open source.
Python database migrations: preview the SQL before it runs
Preview SQL for Python database migrations before it runs. A dry run with dblift migrate --dry-run --show-sql, real output from DBLift 4.11.1 on SQLite, open source.
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.