Sqlalchemy Alembic Expert Best Practices Code Review

What it does

This skill enables AI agents to perform expert-level code reviews specifically for SQLAlchemy and Alembic database migration projects. It ensures migrations follow best practices, maintain data integrity, and adhere to established industry standards for schema evolution.

When to use it

• Reviewing complex Alembic migration scripts before merging into a production branch.
• Validating that new database models correctly map to SQLAlchemy ORM definitions.
• Checking for common pitfalls like missing autogenerate flags or unsafe data type changes.
• Ensuring backward compatibility in multi-environment deployment pipelines.

Key capabilities

• Identifies violations of Alembic best practices in migration files.
• Validates SQLAlchemy model definitions against migration logic.
• Flags potential data loss risks during schema alterations.
• Suggests improvements for migration script readability and maintainability.

Example prompts

• "Review this Alembic migration file for best practice compliance and potential data integrity issues."
• "Analyze these SQLAlchemy models and their corresponding migrations to ensure consistency."
• "Check if this migration script follows industry standards for backward compatibility and safety."

Tips & gotchas

Ensure your codebase includes both the current SQLAlchemy models and the target Alembic migration files before requesting a review. The skill focuses on structural correctness and best practices rather than runtime performance optimization.