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

0•

Gestión de Bases de Datos

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.

Características Principales

01Standardized Base Model patterns featuring UUIDs and automated timestamps

02Automated Alembic migration setup with full async support

030 GitHub stars

04Async engine and session factory configuration with production pooling settings

05Advanced relationship loading strategies to optimize query performance

06Comprehensive CRUD and complex query patterns including bulk operations

Casos de Uso

01Setting up a new FastAPI project with a scalable asynchronous database backend

02Implementing robust transaction management and soft-delete logic

03Optimizing existing ORM queries to resolve performance bottlenecks or N+1 issues

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add vanman2024/ai-dev-marketplace async-sqlalchemy-patterns

For use in Claude.ai and ChatGPT

Download Skill