skills.rest
autorundev
autorundevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

db-migrations

Automate database migrations for Python applications using Alembic and raw SQL.

1|Updated Apr 14, 2026
Search Tags:#database migration#Alembic#schema change#database rollback#raw SQL
One-click install
npx skills add https://github.com/autorundev/autorun-skills --skill db-migrations-autorundev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-migrations
Source: https://github.com/autorundev/autorun-skills/tree/main/db-migrations
Command: npx skills add https://github.com/autorundev/autorun-skills --skill db-migrations-autorundev

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires alembic, sqlalchemy, psycopg2-binary, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

Manages database schema changes, migrations, and rollbacks in Python projects using Alembic or raw SQL for SQLite and PostgreSQL.

Core Features & Use Cases

  • Alembic Support: Automate migrations with SQLAlchemy-based Alembic for schema changes and rollback strategies.
  • Raw SQL Migrations: Handle custom migrations with plain SQL scripts.
  • Zero-Downtime Patterns: Apply schema changes without interrupting service with careful planning and rollback capabilities.
  • Use Case: If you're managing a database for a Python application and need to alter the schema or migrate data, this skill can automate and simplify the process.

Quick Start

Initialize the skill with the command 'db-migrations init'.

Frequently Asked Questions about db-migrations

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate database migrations and rollbacks for a Python application?▼

You can automate database migrations and rollbacks for Python applications using Alembic with SQLAlchemy. This approach supports schema changes and rollback strategies for SQLite and PostgreSQL databases.

Can I run raw SQL scripts for database schema changes instead of using an ORM?▼

Yes, you can execute raw SQL scripts to handle custom database migrations. This allows you to manage schema changes directly without relying solely on SQLAlchemy or Alembic ORM operations.

How do I apply zero-downtime database migrations to PostgreSQL?▼

Zero-downtime database migrations for PostgreSQL are achieved through careful planning and rollback capabilities. This pattern applies schema changes without interrupting your active service.

Do I need SQLAlchemy and a database instance to use Alembic for schema migrations?▼

Yes, you need SQLAlchemy installed for Alembic migrations, along with an active SQLite or PostgreSQL database instance. These dependencies are required to automate and manage schema changes.

What is the best way to initialize database migration scripts in a Python project?▼

The best way to initialize database migration scripts in a Python project is using the 'db-migrations init' command. This sets up the necessary automation environment for Alembic and raw SQL.

Related Skills

Explore More Software Engineering Skills→
NelkitNelkit
1

alembic-migration

Automate PostgreSQL schema changes with SQLAlchemy ORM and Alembic migrations.

Community
Intermediate
Greenmamba29Greenmamba29

database-migrator

Migrate data and schemas between PostgreSQL, MySQL, SQLite, Supabase, and MongoDB.

Community
Advanced
boludo00boludo00
80

postgresql

Manage PostgreSQL schemas, migrations, and queries with SQLAlchemy and Alembic.

Community
Advanced
shredbxshredbx

devops-database

Automate PostgreSQL migrations, backups, and pgvector management with Alembic.

Community
Intermediate