How does it handle migration generation?

It includes scripts to initialize Alembic with an async template and commands to auto-generate migrations from your model changes.

Does this skill support SQLAlchemy 1.4?

While focused on 2.0+ patterns, many concepts apply, but it specifically emphasizes the newer 2.0 style syntax and async_sessionmaker.

Can I use this for both PostgreSQL and SQLite?

Yes, it provides configuration patterns compatible with various drivers, including specific tips for batch operations in SQLite.

What is the recommended loading strategy for relationships?

The skill suggests selectinload for one-to-many and joinedload for many-to-one relationships to ensure optimal performance.

Async SQLAlchemy Patterns for FastAPI

Name: Async SQLAlchemy Patterns for FastAPI
Author: vanman2024

byvanman2024

데이터베이스 관리

Implements production-grade asynchronous SQLAlchemy 2.0+ database patterns and migrations for FastAPI applications.

소개

This skill provides standardized, efficient patterns for integrating SQLAlchemy 2.0+ into asynchronous FastAPI backends. It covers essential database workflows including robust session management with dependency injection, connection pool optimization, and advanced relationship loading strategies to prevent N+1 query issues. Additionally, it streamlines database schema management through pre-configured Alembic migrations, providing a complete toolkit for building scalable, high-performance database layers in modern Python applications.

주요 기능

Standardized Base Model patterns featuring UUIDs and automated timestamps
Automated Alembic migration setup with full async support
0 GitHub stars
Async engine and session factory configuration with production pooling settings
Advanced relationship loading strategies to optimize query performance
Comprehensive CRUD and complex query patterns including bulk operations

사용 사례

Setting up a new FastAPI project with a scalable asynchronous database backend
Implementing robust transaction management and soft-delete logic
Optimizing existing ORM queries to resolve performance bottlenecks or N+1 issues

소개

주요 기능

Standardized Base Model patterns featuring UUIDs and automated timestamps
Automated Alembic migration setup with full async support
0 GitHub stars
Async engine and session factory configuration with production pooling settings
Advanced relationship loading strategies to optimize query performance
Comprehensive CRUD and complex query patterns including bulk operations

사용 사례

Setting up a new FastAPI project with a scalable asynchronous database backend
Implementing robust transaction management and soft-delete logic
Optimizing existing ORM queries to resolve performance bottlenecks or N+1 issues