Skip to main content
ZICQ

Skills ZICQ category:Agent Workflows python-fastapi-development

Python Fastapi Development

Python FastAPI backend development with async patterns, SQLAlchemy, Pydantic, authentication, and production API patterns.

501 installs

Official URL:skills.sh

What this skill does

Intro in this page language first. The official description stays in its original wording; we do not rewrite SKILL.md.

What it does

Python FastAPI backend development with async patterns, SQLAlchemy, Pydantic, authentication, and production API patterns.

When to use it

This Workflow

How agents load it

Per Agent Skills progressive disclosure: name and description load at startup (~100 tokens); the full SKILL.md body loads when the skill activates; scripts/, references/, and assets/ load only as needed. This file's sections: Python/FastAPI Development Workflow; Overview; When to Use This Workflow; Workflow Phases; Phase 1: Project Setup; Phase 2: Database Setup. It includes spec-recommended sections: step-by-step instructions.

File analysis

File analysis: instruction-only skill (SKILL.md). The agent loads the full body when activated.

Python/FastAPI Development WorkflowOverviewWhen to Use This WorkflowWorkflow PhasesPhase 1: Project SetupPhase 2: Database SetupPhase 3: API RoutesPhase 4: AuthenticationPhase 5: Error HandlingPhase 6: TestingPhase 7: DocumentationPhase 8: Deployment

Source category:skills.sh agent-skill

SKILL.md & Agent activation

Official spec ↗
name
python-fastapi-development
description
Python FastAPI backend development with async patterns, SQLAlchemy, Pydantic, authentication, and production API patterns.
  1. DiscoverThe client exposes names and descriptions to the agent.
  2. ActivateYour request or the task context selects the skill and loads its instructions.
  3. Load resourcesReferenced scripts, documentation and assets are used when needed.

Invocation syntax and available tools depend on your Agent client. Client integration guide ↗

Install this skill

Skills CLI ↗

Choose the target agent and installation scope, keep referenced package files, then verify the skill appears in the client's catalog.

Ask your Agent to install

Copy these instructions to a compatible agent and confirm the target directory matches your client.

Install the agent skill "python-fastapi-development" into my project. The full SKILL.md and official description are at https://zicq.com/en/skills/skl-9f3b1c376e17f20d-Python-Fastapi-Development.html
Save it as .cursor/skills/python-fastapi-development/SKILL.md or .claude/skills/python-fastapi-development/SKILL.md and keep the frontmatter name and description exactly as-is.

Full package on GitHub ↗

Install from the terminal · Skills CLI

Requires Node.js and npx. First inspect the repository's skill list to confirm the name.

npx skills add 'https://github.com/sickn33/agentic-awesome-skills' --list

npx skills add 'https://github.com/sickn33/agentic-awesome-skills' --skill 'python-fastapi-development'

The CLI lets you choose the agent interactively. The default scope is the project; use -g for user scope. Confirm package availability with the discovery command, then use npx skills list to inspect installed skills.

Readable layout

name: python-fastapi-development description: "Python FastAPI backend development with async patterns, SQLAlchemy, Pydantic, authentication, and production API patterns." category: granular-workflow-bundle risk: safe source: personal date_added: "2026-02-27"

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.

Related skills

Agent Workflows

Skill Creator

Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that exte…

Agent Workflows

Clawdhub

Use the ClawdHub CLI to search, install, update, and publish agent skills from clawdhub.com. Use when you need to fetch new skills on the fl…

Agent Workflows

Agent Team Orchestration

Orchestrate multi-agent teams with defined roles, task lifecycles, handoff protocols, and review workflows. Use when: (1) Setting up a team …

Agent Workflows

Superpowers

Spec-first, TDD, subagent-driven software development workflow. Use when: (1) building any new feature or app — triggers brainstorm → plan →…