What does sqlalchemy/alembic do?

Alembic is a database schema versioning system and migration tool for SQLAlchemy. It manages incremental updates to database structures using versioned scripts that support both upgrading and downgrading to keep the database and code in sync.

What are the main features of sqlalchemy/alembic?

The main features of sqlalchemy/alembic are: Database Schema Migrations, Database Schema Version Control, Transactional DDL Execution, Schema State Diffing, Schema Version Tracking, Migration Script Generators, SQLAlchemy Schema Migrations, Database Schema Diffing Tools.

What are some open-source alternatives to sqlalchemy/alembic?

Open-source alternatives to sqlalchemy/alembic include: doctrine/doctrinemigrationsbundle — DoctrineMigrationsBundle is a database schema migration tool and a Symfony framework integration for managing and… doctrine/migrations — This project is a database version control system and schema evolution manager designed to track and apply incremental… ariga/atlas — Atlas is a SQL database schema management tool and database infrastructure as code framework. It provides a… xataio/pgroll — pgroll is a PostgreSQL migration framework designed for zero-downtime schema changes. It applies non-blocking DDL… cakephp/phinx — Phinx is a PHP database migration and versioning tool used to track and deploy structural changes to database schemas… doctrine/persistence — This project is an object persistence library and data mapper abstraction layer. It provides a set of shared…

Alembic - manage SQLAlchemy database migratio…

Features

Database Schema Migrations - Provides a comprehensive system for the automated versioning and updating of database structures to maintain consistency across environments.
Database Schema Version Control - Provides a complete system for tracking and managing incremental updates to database schemas.
Transactional DDL Execution - Wraps schema changes in database transactions to ensure atomic updates and prevent partial corruption.
Schema State Diffing - Provides algorithmic calculation of changes needed to transform a live database schema to match a model definition.
Schema Version Tracking - Maintains a dedicated database table to record the current version ID and track applied migrations.
Migration Script Generators - Automatically produces candidate migration directives by comparing data models to live database states.
SQLAlchemy Schema Migrations - Specifically designed to handle schema migrations for databases defined by SQLAlchemy ORM models.
Database Schema Diffing Tools - Includes a utility to identify discrepancies between a live database schema and model metadata.
Migration State Tracking - Uses a dedicated database table to track which schema versions have been applied.
Non-Linear Migration Versioning - Implements a graph-based version tracking system that supports branching and merging of database schema updates.
Transactional Migration Managers - Executes schema migrations within atomic transactions to maintain data integrity during updates.
Database Transactions - Ensures database consistency by executing schema updates within atomic transactions.
SQL String Compilations - Translates high-level Python migration directives into raw SQL strings for auditing and manual execution.
Migration Directive Rendering - Converts high-level Python migration directives into raw SQL strings for auditing.
Migration Script Templates - Generates Python scripts from templates to define explicit database upgrade and downgrade paths.
Directed Acyclic Graph Models - Implements migration tracking as a graph to support complex branching and merging of schema versions.
Database Clients - Database migration tool for SQLAlchemy.

Open-source alternatives to Alembic

Similar open-source projects, ranked by how many features they share with Alembic.

doctrine/doctrinemigrationsbundle
doctrine/DoctrineMigrationsBundle
4,311View on GitHub
DoctrineMigrationsBundle is a database schema migration tool and a Symfony framework integration for managing and versioning database changes using the Doctrine Migrations library. It functions as a bridge connecting the Symfony service container to Doctrine database migration workflows. The project provides a system for tracking and applying incremental changes to a database schema, ensuring consistent states across development, staging, and production environments. It automates schema updates to maintain data structures without manual SQL execution. The tool integrates with the framework t
PHP
View on GitHub4,311
doctrine/migrations
doctrine/migrations
4,770View on GitHub
This project is a database version control system and schema evolution manager designed to track and apply incremental changes to database structures. It serves as a tool for versioning SQL database migrations using both programmatic PHP classes and SQL scripts. The system is designed specifically for integration with the Doctrine Object Relational Mapper for PHP, allowing database schemas to evolve incrementally without data loss through reversible migration steps. It covers capabilities for automated database migrations, environment synchronization, and schema versioning. These features fa
PHP
View on GitHub4,770
ariga/atlas
ariga/atlas
8,096View on GitHub
Atlas is a SQL database schema management tool and database infrastructure as code framework. It provides a declarative database migration engine that computes the difference between a desired schema state and the current database state to automatically generate the necessary SQL for transitions. The project distinguishes itself through a comprehensive suite of analysis and visualization tools, including a database schema linter that detects destructive changes and data loss risks. It also features a SQL schema visualization tool capable of generating entity-relationship diagrams from extract
Go
View on GitHub8,096
cakephp/phinx
cakephp/phinx
4,537View on GitHub
Phinx is a PHP database migration and versioning tool used to track and deploy structural changes to database schemas across different environments. It functions as a version control system for databases, allowing structural modifications to be defined and managed through PHP code. The tool provides mechanisms for database schema versioning and rollback, enabling users to undo previously applied migrations and restore a database to a specific previous state. Additionally, it includes a database seeder for populating tables with initial baseline records or dummy data. The system operates as a
PHP
View on GitHub4,537

See all 30 alternatives to Alembic

Alembic - manage SQLAlchemy database migratio… | Awesome Repos

sqlalchemyalembic

Alembic

Features

Open-source alternatives to Alembic

doctrine/DoctrineMigrationsBundle

doctrine/migrations

ariga/atlas

cakephp/phinx

Frequently asked questions

Star history

Open-source alternatives to Alembic

doctrine/DoctrineMigrationsBundle

doctrine/migrations

ariga/atlas

cakephp/phinx

Frequently asked questions