What common mistakes does this skill help avoid?

It actively prevents common async anti-patterns like blocking the event loop with synchronous calls, sharing sessions across tasks, and improper cancellation handling.

Does this skill support the latest Python features?

Yes, it specifically leverages Python 3.11+ features such as TaskGroup for structured concurrency and ExceptionGroups for robust error handling.

Can I use this for FastAPI dependency injection?

Absolutely. It includes patterns for class-based services and dependency injection to manage database sessions and external resource lifecycles cleanly.

How does it improve database performance?

It provides optimized SQLAlchemy 2.0 patterns including 'selectinload' for eager loading, 'lazy="raise"' to detect N+1 issues, and specific pooling formulas for high-load scenarios.

Python Backend Patterns

Name: Python Backend Patterns
Author: yonatangross

byyonatangross

•

116

•

API 开发

Builds high-performance, asynchronous Python services using FastAPI, SQLAlchemy 2.0, and modern asyncio patterns.

This skill provides a comprehensive suite of production-ready patterns for developing scalable Python backends. It focuses on structured concurrency with asyncio TaskGroups, optimized database interactions using SQLAlchemy 2.0 async sessions, and robust FastAPI service architectures. By enforcing best practices like dependency injection, connection pooling tuning, and anti-pattern prevention, it ensures your backend services are thread-safe, efficient, and ready for high-concurrency production environments.

主要功能

01FastAPI production setup with Lifespan management and dependency injection.

02Automated enforcement of async best practices to prevent event loop blocking.

03Detailed connection pooling configurations for databases and HTTP sessions.

04116 GitHub stars

05Modern asyncio patterns leveraging TaskGroups and structured concurrency.

06SQLAlchemy 2.0 async integration with N+1 query prevention and repository patterns.

使用场景

01Architecting high-concurrency RESTful APIs with FastAPI and PostgreSQL.

02Optimizing database performance and connection management in distributed services.

03Migrating synchronous Python codebases to modern asynchronous architectures.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add yonatangross/orchestkit python-backend

For use in Claude.ai and ChatGPT

Download Skill