Can I use this for non-FastAPI projects?

While it features specialized FastAPI logic, the asyncio and SQLAlchemy patterns are highly applicable to any modern asynchronous Python backend.

What Python versions does this skill support?

The skill is optimized for modern Python 3.11 and newer to fully utilize structured concurrency features like TaskGroups and ExceptionGroups.

How does it handle database connection pooling?

It provides specific sizing formulas and configuration patterns for SQLAlchemy engines to ensure stable performance under high loads.

Does it include database migration patterns?

Yes, it provides best practices for SQLAlchemy 2.0 async sessions which are essential for robust migrations and database interactions.

How does this prevent common async bugs?

It explicitly forbids anti-patterns like blocking the event loop with sync calls and provides patterns for safe cancellation and timeout handling.

Python Backend Architect

Name: Python Backend Architect
Author: yonatangross

byyonatangross

•

116

•

API 开发

Implements production-ready asynchronous Python backends using FastAPI, SQLAlchemy 2.0, and modern asyncio patterns.

The Python Backend Architect skill provides a comprehensive toolkit for building high-performance, scalable backend services. It focuses on modern asynchronous development standards, leveraging Python 3.11+ features like TaskGroups and structured concurrency. This skill ensures your projects follow industry best practices for FastAPI application structure, SQLAlchemy 2.0 database management, and efficient connection pooling. Whether you are architecting a new microservice or refactoring legacy code, this skill helps prevent common async pitfalls while optimizing for performance and maintainability.

主要功能

01High-performance connection pooling for databases and HTTP clients

02Production-grade FastAPI structures with lifespan and dependency injection

03Comprehensive anti-pattern prevention for asynchronous execution

04116 GitHub stars

05SQLAlchemy 2.0 async session management and eager loading patterns

06Modern asyncio patterns including TaskGroups and structured concurrency

使用场景

01Architecting high-concurrency REST APIs with FastAPI and PostgreSQL

02Optimizing backend performance through structured task management and pool tuning

03Refactoring synchronous database logic to SQLAlchemy 2.0 async patterns

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