AGENT SKILL

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 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
  2. Create API routers
  3. Implement CRUD operations
  4. Add request validation
  5. 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 - 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

Use @auth-implementation-patterns to implement JWT authentication

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

Use @fastapi-pro to implement comprehensive error handling

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

Use @python-testing-patterns to write pytest tests for FastAPI

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

Use @api-documenter to generate comprehensive API documentation

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

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 development
  • database - Database operations
  • security-audit - Security testing
  • api-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

YYC-Cube
YYC-Cube/YYC3-Knowledge-Base

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.

★ 1
YYC-Cube
YYC-Cube/YYC3-Knowledge-Base

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.

★ 1
YYC-Cube
YYC-Cube/YYC3-Knowledge-Base

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.

★ 1
YYC-Cube
YYC-Cube/YYC3-Knowledge-Base

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.

★ 1
YYC-Cube
YYC-Cube/YYC3-Knowledge-Base

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.

★ 1
YYC-Cube
YYC-Cube/YYC3-Knowledge-Base

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.

★ 1