Agent skill
alembic
Generates and manages database migrations with Alembic for the Bookkeep backend. Use when: creating database migrations, modifying models, adding columns, creating tables, or running schema changes.
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/other/other/alembic-boludo00-bookkeep
SKILL.md
Alembic Skill
Alembic manages schema migrations for Bookkeep's SQLAlchemy models. Migrations live in backend/alembic/versions/ with numeric prefixes (001, 002, etc.). The project supports both PostgreSQL (production) and SQLite (development) with idempotent migrations using existence checks.
Quick Start
Generate Migration
cd backend
alembic revision --autogenerate -m "add_column_to_table"
Apply Migrations
cd backend
alembic upgrade head # Apply all pending
alembic upgrade +1 # Apply next migration only
alembic downgrade -1 # Roll back one migration
Check Status
cd backend
alembic current # Show current revision
alembic history # List all migrations
Key Concepts
| Concept | Usage | Example |
|---|---|---|
| Numeric prefix | Sequential ordering | 022_add_download_system.py |
| Idempotent checks | Safe reruns | if not table_exists('download_tasks'): |
| batch_alter_table | SQLite compatibility | with op.batch_alter_table('books'): |
| Data migrations | Transform existing data | op.execute("UPDATE books SET ...") |
Project Configuration
- alembic.ini:
backend/alembic.ini - env.py:
backend/alembic/env.py(loadsDATABASE_URLfromapp.database) - versions:
backend/alembic/versions/(30 migrations) - Models:
backend/app/models.py
Common Patterns
Add Column with Default
if not column_exists('users', 'can_download'):
op.add_column('users', sa.Column(
'can_download',
sa.Boolean(),
nullable=True,
server_default='true'
))
Create Table with Indexes
if not table_exists('download_tasks'):
op.create_table('download_tasks',
sa.Column('id', sa.Integer(), primary_key=True),
sa.Column('book_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['book_id'], ['books.id']),
)
if not index_exists('download_tasks', 'ix_download_tasks_book_id'):
op.create_index('ix_download_tasks_book_id', 'download_tasks', ['book_id'])
See Also
- patterns - Migration patterns and helper functions
- workflows - Common migration workflows
Related Skills
- See the sqlalchemy skill for model definitions
- See the python skill for Python backend conventions
- See the fastapi skill for API integration after migrations
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?