Version database schema changes with Alembic and SQLAlchemy for PostgreSQL.
npx skills add https://github.com/farhaduneci/url-shortener --skill alembic-farhaduneci
Please help me install this Agent Skill. Skill: alembic Source: https://github.com/farhaduneci/url-shortener/tree/main/.agents/skills/alembic Command: npx skills add https://github.com/farhaduneci/url-shortener --skill alembic-farhaduneci
Alembic provides a disciplined approach to evolving a database schema, enabling safe upgrades, rollbacks, and auditability for production systems.
High-intent search queries and answers about installing and using this skill.
Database migrations are managed by versioning schema changes with Alembic, enabling safe upgrades, rollbacks, and auditability across PostgreSQL environments. It supports auto-generated and manual scripts to ensure reliable development and deployment.
Database schema branching and merging is handled using Alembic workflows that coordinate migrations across teams and databases. This approach supports cross-branch collaboration and merge scenarios to maintain schema integrity during development.
Yes, data migrations can run inline with schema changes. Alembic allows you to generate migration scripts automatically from models or write custom scripts for complex data transformations alongside standard schema updates.
Testing database migrations for reliability is done using pytest. Writing and running migration tests with pytest ensures that schema upgrades, rollbacks, and data migrations perform safely before reaching production environments.
Zero-downtime database version control is set up by installing Alembic with SQLAlchemy and psycopg2, initializing the environment, configuring the database URL, and running migration tests with pytest to guarantee safe deployment.
Yes, Alembic supports auto-generated migration scripts from SQLAlchemy models. It tracks schema changes across development, staging, and production environments, and also allows writing custom scripts for complex modifications.
bswrundquistManage database schema migrations with Alembic and SQLAlchemy.
ricardorocheAutomate Alembic database migrations with reversible upgrade and downgrade scripts.
TorbenMerraldDefine and enforce database models and entity schemas across ORM and migration scripts.
Ayub-KhanPlan and validate zero-downtime database migrations with rollback safety.
