Python FastAPI Development
Python FastAPI backend development with async patterns, SQLAlchemy, Pydantic, authentication, and production API patterns.
Content
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
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
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
2. Create API routers
3. Implement CRUD operations
4. Add request validation
5. Configure response models
#### Copy-Paste Prompts
Phase 4: Authentication
#### Skills to Invoke
- -
auth-implementation-patterns- Authentication - -
api-security-best-practices- API security
#### Actions
1. Choose auth strategy (JWT, OAuth2)
2. Implement user registration
3. Set up login endpoints
4. Create auth middleware
5. Add password hashing
#### Copy-Paste Prompts
Phase 5: Error Handling
#### Skills to Invoke
- -
fastapi-pro- FastAPI patterns - -
error-handling-patterns- Error handling
#### Actions
1. Create custom exceptions
2. Set up exception handlers
3. Implement error responses
4. Add request logging
5. Configure error tracking
#### Copy-Paste Prompts
Phase 6: Testing
#### Skills to Invoke
- -
python-testing-patterns- pytest testing - -
api-testing-observability-api-mock- API testing
#### Actions
1. Set up pytest
2. Create test fixtures
3. Write unit tests
4. Implement integration tests
5. Configure test database
#### Copy-Paste Prompts
Phase 7: Documentation
#### Skills to Invoke
- -
api-documenter- API documentation - -
openapi-spec-generation- OpenAPI specs
#### Actions
1. Configure OpenAPI schema
2. Add endpoint documentation
3. Create usage examples
4. Set up API versioning
5. Generate API docs
#### Copy-Paste Prompts
Phase 8: Deployment
#### Skills to Invoke
- -
deployment-engineer- Deployment - -
docker-expert- Containerization
#### Actions
1. Create Dockerfile
2. Set up docker-compose
3. Configure production settings
4. Set up reverse proxy
5. Deploy to cloud
#### Copy-Paste Prompts
Technology Stack
| Category | Technology |
|---|---|
| Framework | FastAPI |
| Language | Python 3.11+ |
| ORM | SQLAlchemy 2.0 |
| Validation | Pydantic v2 |
| Database | PostgreSQL |
| Migrations | Alembic |
| Auth | JWT, OAuth2 |
| Testing | pytest |
Quality Gates
- -[ ] All tests passing (>80% coverage)
- -[ ] Type checking passes (mypy)
- -[ ] Linting clean (ruff, black)
- -[ ] API documentation complete
- -[ ] Security scan passed
- -[ ] Performance benchmarks met
Related Workflow Bundles
- -
development- General development - -
database- Database operations - -
security-audit- Security testing - -
api-development- API patterns
FAQ
Discussion
Loading comments...