스킬 python-database-patterns

🗄️

python-database-patterns

Name: python-database-patterns
Author: 0xDarkMatter

안전

Implement Python database patterns with SQLAlchemy

또한 다음에서 사용할 수 있습니다: 0xDarkMatter

Writing database code is complex and error-prone. This skill provides battle-tested SQLAlchemy 2.0 patterns for models, queries, async sessions, transactions, and migrations.

지원: Claude Codex Code(CC)

🥉 73 브론즈

스킬 ZIP 다운로드

Claude에서 업로드

설정 → 기능 → 스킬 → 스킬 업로드로 이동

토글을 켜고 사용 시작

테스트해 보기

"python-database-patterns" 사용 중입니다. Create a User model with email unique constraint and a relationship to Post

예상 결과:

- Define User class with mapped columns
- Add unique constraint on email field
- Create one-to-many relationship to Post model
- Use back_populates for bidirectional navigation

보안 감사

안전

v3 • 1/10/2026

Documentation-only skill containing educational SQLAlchemy patterns. No executable code, no network calls, no credential access, no malicious patterns detected.

스캔된 파일

1,473

분석된 줄 수

발견 사항

총 감사 수

보안 문제를 찾지 못했습니다

감사자: claude 감사 이력 보기 →

품질 점수

아키텍처

100

유지보수성

콘텐츠

커뮤니티

100

보안

사양 준수

만들 수 있는 것

Learn SQLAlchemy 2.0

Get started with modern SQLAlchemy patterns for declarative models and type-safe queries

Build async API backends

Implement FastAPI endpoints with async database sessions and transaction management

Manage database schemas

Set up Alembic migrations and configure connection pools for production databases

이 프롬프트를 사용해 보세요

Define a model

Create a SQLAlchemy 2.0 model called Product with id, name, price, and category relationship

Write async query

Write an async function to fetch a user by email with their posts eagerly loaded

Handle transaction

Implement a transfer_funds function with pessimistic locking to prevent race conditions

Configure pool

Show me how to configure connection pool size, overflow, and pre-ping for a production PostgreSQL async engine

모범 사례

Use SQLAlchemy 2.0 declarative style with Mapped and mapped_column for type safety
Prefer session.execute with select() over legacy session.query() method
Configure pool_pre_ping=True to catch stale connections before queries
Use eager loading (selectinload/joinedload) to avoid N+1 queries in async contexts

피하기

Using lazy loading in async sessions causes MissingGreenlet errors
Calling session.commit() inside session.begin() creates nested transaction issues
Hardcoding database URLs instead of using environment configuration
Skipping pool_recycle causing connections to timeout after long queries

자주 묻는 질문

What SQLAlchemy versions are supported?

SQLAlchemy 2.0+ with Python 3.10+. Async requires asyncpg for PostgreSQL or aiosqlite for SQLite.

Can I use this with FastAPI?

Yes. The skill includes FastAPI dependency injection patterns for async database sessions.

How do I size the connection pool?

Start with pool_size=5 and max_overflow=10. Adjust based on concurrent users and query patterns.

Is my data safe with these patterns?

Yes. Patterns include transaction safety, optimistic locking, and proper session lifecycle management.

Why are my async queries failing?

Common causes include lazy loading without eager loading, uncommitted transactions, or connection pool exhaustion.

How does this compare to raw SQL?

SQLAlchemy provides type safety and abstraction while generating optimized SQL. Use text() for raw queries when needed.

개발자 세부 정보

작성자

0xDarkMatter

라이선스

MIT

리포지토리

https://github.com/0xDarkMatter/claude-mods/tree/main/skills/python-database-patterns

참조

main

파일 구조

📁 assets/

📄 alembic.ini.template

📁 references/

📄 connection-pooling.md

📄 migrations.md

📄 sqlalchemy-async.md

📄 transactions.md

📄 SKILL.md