This is a comprehensive FastAPI skill that goes heavy on security and async patterns. It enforces TDD with pytest-asyncio and httpx, covers SQLAlchemy 2.0 async operations, and implements OAuth2/JWT authentication with refresh tokens. The skill really emphasizes OWASP Top 10 protections and production concerns like connection pooling, structured logging, and rate limiting. It's marked high risk because it's handling auth and database operations where mistakes hurt. Use this when you're building authenticated APIs that need to scale and can't afford security gaps. The TDD workflow is structured around writing failing tests first, which is good discipline but might feel heavy if you're prototyping.

skills.sh installs
265
GitHub stars
48
last updated
Aug 21, 2026

Install

$ npx -y skills add martinholovsky/claude-skills-generator --skill fastapi-expert --agent claude-code

Installs into .claude/skills of the current project.

Files

FastAPI Development Expert

1. Overview

You are an elite FastAPI developer with deep expertise in:

  • FastAPI Core: Async/await, dependency injection, path operations, request/response models
  • Pydantic v2: Advanced validation, custom validators, field serialization, model composition
  • SQLAlchemy 2.0: Async engines, ORM models, migrations with Alembic, query optimization
  • Authentication: OAuth2 password flow, JWT tokens with refresh, role-based access control
  • Security: CORS, rate limiting, SQL injection prevention, input sanitization, OWASP Top 10
  • Database: AsyncPG, async sessions, connection pooling, transaction management
  • Performance: Background tasks, async queries, caching strategies
  • Testing: pytest with TestClient, async tests, comprehensive coverage
  • API Documentation: Auto-generated OpenAPI 3.1, Swagger UI customization

Sponsors

Details

Repository
github.com/martinholovsky/claude-skills-generator
Categories
Backend & APIs, Security, Debugging, Automation & Workflows, Python, Databases
First seen
Jun 3, 2026

More from martinholovsky/claude-skills-generator

All 50
1martinholovsky avatarfastapimartinholovsky/claude-skills-generatorREST API and WebSocket development with FastAPI emphasizing security, performance, and async patterns264skills.sh installs
2patricio0312rev avatarintegration-test-builderpatricio0312rev/skillsCreates integration tests for API endpoints with database flows, including test harness setup, fixtures, setup/teardown, database seeding, and CI-friendly strat263skills.sh installs
3patricio0312rev avatarcaching-cdn-strategy-plannerpatricio0312rev/skillsDesigns multi-layer caching strategy with edge CDN, server-side caching, cache invalidation, and CDN configuration. Use for "caching strategy", "CDN setup", "ca258skills.sh installs
4personamanagmentlayer avatarsql-expertpersonamanagmentlayer/pclExpert-level SQL database design, querying, optimization, and administration across PostgreSQL, MySQL, and SQL Server257skills.sh installs
5qodex-ai avatargenerate-swagger-docsqodex-ai/ai-agent-skillsGenerate OpenAPI documentation from source code. Analyzes repository to automatically discover API endpoints and create swagger.json and interactive HTML docume255skills.sh installs
6davila7 avatarshopify-appsdavila7/claude-code-templatesExpert patterns for Shopify app development including Remix/React Router apps, embedded apps with App Bridge, webhook handling, GraphQL Admin API, Polaris compo254skills.sh installs