skill-database-sqlalchemy

To set up asynchronous sessions in SQLAlchemy 2.x, use an async engine and sessionmaker with proper transaction boundaries. This ensures safe commit and rollback handling while maintaining scalable data access in Python.

The best way to manage Alembic migrations with SQLAlchemy 2.x is using repository-style data access patterns. This approach safely evolves schemas by applying typed mappings and enforcing structured migration workflows.

Design robust SQLAlchemy 2.x ORM data models by using a Declarative Base with mixins for common fields and indexes. This pattern enforces typed mappings and reduces boilerplate in Python projects.

Yes, you can use the repository pattern with async SQLAlchemy sessions. This combination enforces scalable, maintainable data access by separating business logic from explicit session management and transaction boundaries.

Yes, SQLAlchemy 2.x supports typed mappings to improve Python code quality. By enforcing typed mappings alongside Declarative Base patterns, you reduce errors and ensure robust model design.