Agent skill · software engineering · jiatastic
python-backend
Python backend development expertise for FastAPI, security patterns, database operations, Upstash integrations, and code quality. Use when: (1) Building REST APIs with FastAPI, (2) Implementing JWT/OAuth2 authentication, (3) Setting up SQLAlchemy/async databases, (4) Integrating Redis/Upstash caching, (5) Refactoring AI-generated Python code (deslopification), (6) Designing API patterns, or (7) Optimizing backend performance.
Why this skill is useful
Provides specific patterns and integrations for FastAPI, SQLAlchemy, and Upstash that the AI wouldn't reliably generate on its own.
What it needs
Requires upstash_ratelimit, upstash_redis installed locally. About 2k tokens when loaded. Last updated 2026-01-25. 7 stars on the source repository.
What this skill does
python-backend Production-ready Python backend patterns for FastAPI, SQLAlchemy, and Upstash. When to Use This Skill Building REST APIs with FastAPI Implementing JWT/OAuth2 authentication Setting up SQLAlchemy async databases Integrating Redis/Upstash caching and rate limiting Refactoring AI-generated Python code Designing API patterns and project structure Core Principles 1. Async-first - Use async/await for I/O operations 2. Type everything - Pydantic models for validation 3. Dependency injection - Use FastAPI's Depends() 4. Fail fast - Validate early, use HTTPException 5. Security by default - Never trust user input Quick Patterns Project Structure Async Routes Pydantic Validation Dependency Injection SQLAlchemy Async Redis Caching Rate Limiting Reference Documents For detailed patterns, see: Document Content ---------- --------- references/fastapipatterns.md Project structure, async, Pydantic, dependencies, testing references/securitypatterns.md JWT, OAuth2, password hashing, CORS, API keys references/databasepatterns.md SQLAlchemy async, transactions, eager loading, migrations references/upstashpatterns.md Redis, rate limiting, QStash background jobs Resources FastAPI Documentation SQLAlchemy 2.0 Documentation Upstash Documentation Pydantic Documentation
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills jiatastic/fastapi-design