python-fastapi-development

name	python-fastapi-development
description	Python FastAPI backend development with async patterns, SQLAlchemy, Pydantic, authentication, and production API patterns.
type	skill
created	2026-02-27T00:00:00.000Z
domain	software-development
category	backend
risk	safe
source	personal
tags	["skill","software-development","backend","python","fastapi"]

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 schema

Use @pydantic-models-py to create Pydantic models for API

Phase 3: API Routes

Skills to Invoke

• fastapi-router-py - FastAPI routers
• api-design-principles - API design
• api-patterns - API patterns

Actions

1. Design API endpoints