async-sqlalchemy-patterns
Provides production-ready patterns for async database operations, ORM models, and migration workflows in FastAPI.
Install
mkdir -p .claude/skills/async-sqlalchemy-patterns && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/14385" && unzip -o skill.zip -d .claude/skills/async-sqlalchemy-patterns && rm skill.zipInstalls to .claude/skills/async-sqlalchemy-patterns
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Async SQLAlchemy 2.0+ database patterns for FastAPI including session management, connection pooling, Alembic migrations, relationship loading strategies, and query optimization. Use when implementing database models, configuring async sessions, setting up migrations, optimizing queries, managing relationships, or when user mentions SQLAlchemy, async database, ORM, Alembic, database performance, or connection pooling.Key capabilities
- →Set up async database engines and session factories
- →Manage database sessions using FastAPI dependency injection
- →Implement base models with UUID primary keys and timestamps
- →Configure Alembic for database migrations
- →Optimize relationship loading with selectinload and joinedload
- →Perform basic CRUD operations asynchronously
How it works
This skill configures SQLAlchemy 2.0+ for asynchronous operations within FastAPI, providing patterns for session management, model definition, and query optimization.
Inputs & outputs
When to use async-sqlalchemy-patterns
- →Configure async SQLAlchemy sessions
- →Set up Alembic migrations
- →Optimize database model performance
About this skill
async-sqlalchemy-patterns
This page used to hold an archived copy of this skill. The archive now lives in the registry's data repository.
- Archived SKILL.md (snapshot from 2026-10-08)
- Find this skill in Claude Skills Registry
- Request removal
This pointer keeps old links working. It is not an installable skill.
When not to use it
- →When working with synchronous database operations
- →When the project does not use SQLAlchemy 2.0+ or FastAPI
- →When a different ORM or database access layer is preferred
Limitations
- →Requires SQLAlchemy 2.0+ for async features
- →Optimizations like eager loading must be explicitly configured
- →Troubleshooting N+1 problems requires SQL logging and specific loading strategies
How it compares
This approach provides structured patterns for async SQLAlchemy in FastAPI, including dependency injection and optimized relationship loading, which differs from manual setup that may lack these best practices.
Compared to similar skills
async-sqlalchemy-patterns side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| async-sqlalchemy-patterns (this skill) | 0 | 7mo | Review | Advanced |
| supabase-python | 0 | 7mo | Review | Advanced |
| junta-leiloeiros | 0 | 7mo | Review | Intermediate |
| DB Schema Surgeon | 0 | 9mo | No flags | Advanced |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by majiayu000
View all by majiayu000 →You might also like
supabase-python
alinaqi
FastAPI with Supabase and SQLAlchemy/SQLModel
junta-leiloeiros
wegonbeok45
Coleta e consulta dados de leiloeiros oficiais de todas as 27 Juntas Comerciais do Brasil. Scraper multi-UF, banco SQLite, API FastAPI e exportacao CSV/JSON.
DB Schema Surgeon
adriangmrraa
Gestión del esquema PostgreSQL, Auto-Healing y arquitectura RAG híbrida.
db-migration
Diwas2055
Safely generates, reviews, and applies Alembic database migrations.
senior-data-engineer
davila7
World-class data engineering skill for building scalable data pipelines, ETL/ELT systems, and data infrastructure. Expertise in Python, SQL, Spark, Airflow, dbt, Kafka, and modern data stack. Includes data modeling, pipeline orchestration, data quality, and DataOps. Use when designing data architectures, building data pipelines, optimizing data workflows, or implementing data governance.
fastapi-templates
wshobson
Create production-ready FastAPI projects with async patterns, dependency injection, and comprehensive error handling. Use when building new FastAPI applications or setting up backend API projects.