搜索技能.../

Sqlalchemy | Skills Pool

技能档案

Sqlalchemy

Applies when building or reviewing SQLAlchemy data layers. Covers session lifecycle, eager loading, connection pooling, 2.0 style, and Alembic migrations.

BillSchumacher0 星标2026年4月12日

职业
分类: SQL 数据库

技能内容

2.0 style

Use 2.0-style queries. select(), Session.execute(), Session.scalars(). Legacy Query is deprecated.
Mapped[] type annotations with mapped_column().
relationship with back_populates, not backref. Explicit, type-checkable.

Session lifecycle

One session per request, closed at end. Middleware or dependency. Never share across threads.
expire_on_commit=False when reading after commit. Default expires attributes, causing extra SELECTs.
Never commit inside a loop. Batch changes, commit once.

Eager loading

Prevent N+1 with explicit eager loading. Default lazy fires a query per relationship access.

相关技能

快速安装

Sqlalchemy

npx skills add BillSchumacher/claude_stuff

下载 Skill 打开源码仓库

作者: BillSchumacher
星标: 0
更新时间: 2026年4月12日
职业

本页内容

joinedload few parents/few children. selectinload many parents. subqueryload complex filters.

No lazy loading in async. Triggers implicit I/O, fails with MissingGreenlet.

Pooling and async

Configure pooling: pool_size, max_overflow, pool_pre_ping=True, pool_recycle=1800.
Async engine for async frameworks. create_async_engine("postgresql+asyncpg://...").

Bulk and migrations

Bulk operations for batches. session.execute(insert(User), [{...}]) not looped session.add().
server_default for DB-level defaults, not default (Python-side, skipped in bulk).
Alembic for all schema changes. Never metadata.create_all() in production.

02

Session lifecycle

03Eager loading

04Pooling and async

05Bulk and migrations

软件开发人员

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.

Database Migrations

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.

Postgres Patterns

쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Jpa Patterns

Spring Boot中的JPA/Hibernate模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。

软件开发人员