Implements modern SQLAlchemy 2.0 patterns and asynchronous database workflows for Python applications.
This skill provides Claude with domain-specific knowledge to architect robust database layers using SQLAlchemy 2.0 and Python 3.10+. It covers essential patterns including Declarative Base mapping with type safety, high-performance asynchronous session management, and complex relationship handling. By providing standardized implementation patterns for query construction, eager loading, and migration strategies with Alembic, this skill ensures your data layer is efficient, maintainable, and integrates seamlessly with modern frameworks like FastAPI.
Key Features
01SQLAlchemy 2.0 Declarative Mapping using Mapped types and annotations
02Asynchronous database session management for PostgreSQL and SQLite
033 GitHub stars
04Standardized FastAPI dependency injection for database sessions
05Advanced query patterns including eager loading, joins, and aggregates
06Optimized relationship mapping for one-to-many and many-to-one patterns
Use Cases
01Refactoring legacy SQLAlchemy code to follow 2.0 standards and modern Python typing
02Architecting high-concurrency async database layers for backend services
03Configuring automated database migrations and connection pooling for production environments
