python-fastapi-development
Python FastAPI backend development with async patterns, SQLAlchemy, Pydantic, authentication, and production API patterns.
- License 许可
- MIT
- 最近更新
- 2026-11-10
- Stars
- ★ 1
- Forks
- 0
01 前言 Front Matter
- name
- python-fastapi-development
- risk
- safe
- source
- personal
- category
- granular-workflow-bundle
- date_added
- 2026-02-27
- description
- Python FastAPI backend development with async patterns, SQLAlchemy, Pydantic, authentication, and production API patterns.
03 SKILL.md 正文
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 scaffoldingpython-development-python-scaffold- Python scaffoldingfastapi-templates- FastAPI templatesuv-package-manager- Package management
Actions
- Set up Python environment (uv/poetry)
- Create project structure
- Configure FastAPI app
- Set up logging
- 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 designpostgresql- PostgreSQL setuppydantic-models-py- Pydantic models
Actions
- Design database schema
- Set up SQLAlchemy models
- Create database connection
- Configure migrations (Alembic)
- 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 routersapi-design-principles- API designapi-patterns- API patterns
Actions
- Design API endpoints
- Create API routers
- Implement CRUD operations
- Add request validation
- Configure response models
Copy-Paste Prompts
Use @fastapi-router-py to create API endpoints with CRUD operations
Use @api-design-principles to design RESTful API
Phase 4: Authentication
Skills to Invoke
auth-implementation-patterns- Authenticationapi-security-best-practices- API security
Actions
- Choose auth strategy (JWT, OAuth2)
- Implement user registration
- Set up login endpoints
- Create auth middleware
- Add password hashing
Copy-Paste Prompts
Use @auth-implementation-patterns to implement JWT authentication
Phase 5: Error Handling
Skills to Invoke
fastapi-pro- FastAPI patternserror-handling-patterns- Error handling
Actions
- Create custom exceptions
- Set up exception handlers
- Implement error responses
- Add request logging
- Configure error tracking
Copy-Paste Prompts
Use @fastapi-pro to implement comprehensive error handling
Phase 6: Testing
Skills to Invoke
python-testing-patterns- pytest testingapi-testing-observability-api-mock- API testing
Actions
- Set up pytest
- Create test fixtures
- Write unit tests
- Implement integration tests
- Configure test database
Copy-Paste Prompts
Use @python-testing-patterns to write pytest tests for FastAPI
Phase 7: Documentation
Skills to Invoke
api-documenter- API documentationopenapi-spec-generation- OpenAPI specs
Actions
- Configure OpenAPI schema
- Add endpoint documentation
- Create usage examples
- Set up API versioning
- Generate API docs
Copy-Paste Prompts
Use @api-documenter to generate comprehensive API documentation
Phase 8: Deployment
Skills to Invoke
deployment-engineer- Deploymentdocker-expert- Containerization
Actions
- Create Dockerfile
- Set up docker-compose
- Configure production settings
- Set up reverse proxy
- Deploy to cloud
Copy-Paste Prompts
Use @docker-expert to containerize FastAPI application
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 developmentdatabase- Database operationssecurity-audit- Security testingapi-development- API patterns
Limitations
- Use this skill only when the task clearly matches the scope described above.
- Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
- Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.
04 同仓库更多 Skills
vercel-sandbox
Run agent-browser + Chrome inside Vercel Sandbox microVMs for browser automation from any Vercel-deployed app. Use when the user needs browser automation in a Vercel app (Next.js, SvelteKit, Nuxt, Remix, Astro, etc.), wants to run headless Chrome without binary size limits, needs persistent browser sessions across commands, or wants ephemeral isolated browser environments. Triggers include "Vercel Sandbox browser", "microVM Chrome", "agent-browser in sandbox", "browser automation on Vercel", or any task requiring Chrome in a Vercel Sandbox.
slack
Interact with Slack workspaces using browser automation. Use when the user needs to check unread channels, navigate Slack, send messages, extract data, find information, search conversations, or automate any Slack task. Triggers include "check my Slack", "what channels have unreads", "send a message to", "search Slack for", "extract from Slack", "find who said", or any task requiring programmatic Slack interaction.
electron
Automate Electron desktop apps (VS Code, Slack, Discord, Figma, Notion, Spotify, etc.) using agent-browser via Chrome DevTools Protocol. Use when the user needs to interact with an Electron app, automate a desktop app, connect to a running app, control a native app, or test an Electron application. Triggers include "automate Slack app", "control VS Code", "interact with Discord app", "test this Electron app", "connect to desktop app", or any task requiring automation of a native Electron application.
dogfood
Systematically explore and test a web application to find bugs, UX issues, and other problems. Use when asked to "dogfood", "QA", "exploratory test", "find issues", "bug hunt", "test this app/site/platform", or review the quality of a web application. Produces a structured report with full reproduction evidence -- step-by-step screenshots, repro videos, and detailed repro steps for every issue -- so findings can be handed directly to the responsible teams.
agent-browser
Browser automation CLI for AI agents. Use when the user needs to interact with websites, including navigating pages, filling forms, clicking buttons, taking screenshots, extracting data, testing web apps, or automating any browser task. Triggers include requests to "open a website", "fill out a form", "click a button", "take a screenshot", "scrape data from a page", "test this web app", "login to a site", "automate browser actions", or any task requiring programmatic web interaction.
shadcn
Manages shadcn components and projects — adding, searching, fixing, debugging, styling, and composing UI, including chat interfaces. Provides project context, component docs, and usage examples. Applies when working with shadcn/ui, component registries, presets, --preset codes, or any project with a components.json file. Also triggers for "shadcn init", "create an app with --preset", "switch to --preset", and for building a design system or applying a DESIGN.md or brand spec to shadcn/ui.