python-fastapi-development

# Python/FastAPI Development Workflow ## Overview Specialized workflow for building production-ready Python backends with FastAPI, featuring async patterns, SQLAlchemy ORM, Pydantic validation, and comprehensive API patterns. ## When to Use This Workflow Use this workflow when: - Building new REST APIs with FastAPI - Creating async Python backends - Implementing database integration with SQLAlchemy - Setting up API authentication - Developing microservices ## Workflow Phases ### Phase 1: Project Setup #### Skills to Invoke - `app-builder` - Application scaffolding - `python-development-python-scaffold` - Python scaffolding - `fastapi-templates` - FastAPI templates - `uv-package-manager` - Package management #### Actions 1. Set up Python environment (uv/poetry) 2. Create project structure 3. Configure FastAPI app 4. Set up logging 5. Configure environment variables #### Copy-Paste Prompts ``` Use @fastapi-templates to scaffold a new FastAPI project ``` ``` Use @python-development-python-scaffold to set up Python project structure ``` ### Phase 2: Database Setup #### Skills to Invoke - `prisma-expert` - Prisma ORM (alternative) - `database-design` - Schema design - `postgresql` - PostgreSQL setup - `pydantic-models-py` - Pydantic models #### Actions 1. Design database schema 2. Set up SQLAlchemy models 3. Create database connection 4. Configure migrations (Alembic) 5. Set up session management #### Copy-Paste Prompts ``` Use @database-design to design PostgreSQL s...