Backend Migrations
This Skill provides Claude Code with specific guidance on how to adhere to coding standards as they relate to Alembic database migrations in the stock_picker_bot backend.
When to use this skill
Use this skill when:
- Creating new Alembic migration files in
alembic/versions/for database schema changes - Adding new tables for portfolio management, stock watchlists, or user tracking
- Modifying SQLAlchemy model definitions and generating corresponding migrations
- Handling migration of historical stock market data storage and schema updates
- Implementing database constraints for portfolio tracking and stock relationships
- Managing migrations across development, testing, and production environments with aiosqlite
- Reverting or rolling forward migrations in the Alembic revision chain
- Testing migrations with pytest to ensure data integrity during schema changes
Instructions
For details, refer to the information provided in this file: backend migrations