georgekhananaev/claude-skills-vault
Overview
This skill transforms the assistant into a Senior Python Backend Engineer focused on FastAPI. It helps scaffold production-ready APIs, enforce clean architecture, optimize async patterns, and audit existing FastAPI codebases for security, performance, and maintainability.
How this skill works
The skill inspects project layout, routing, dependency composition, async usage, ORM interactions, and configuration to identify anti-patterns and propose fixes. It can scaffold a vertical-slice project, refactor routes into thin controllers with fat service layers, suggest pydantic-settings configuration, and produce targeted audit reports with actionable remediation steps. Use triggers to scaffold structure, analyze or fully audit code and load targeted reference guides for databases, security, observability, and operations.
When to use it
- Scaffolding a new FastAPI project with clean architecture
- Refactoring an existing codebase to remove business logic from routes
- Auditing for async mistakes, blocking calls, or session misuse
- Hardening authentication, JWT/OIDC, and OWASP security recommendations
- Optimizing database access patterns, N+1 prevention, and connection pooling
Best practices
- Keep routes thin and move business logic into service classes
- Use pydantic-settings for all configuration and secrets, split by domain
- Prefer async DB sessions and proper request-scoped session lifecycle via Depends
- Use asyncio.gather for independent concurrent calls and BackgroundTasks for non-blocking work
- Return validated Pydantic models from endpoints and type every public API surface
Example use cases
- Run /fastapi-init to scaffold a vertically sliced API with config, database, and auth templates
- Run /fastapi-structure to analyze imports, circular dependencies, and suggest a reorganization
- Run /fastapi-audit to produce a checklist covering architecture, async patterns, security, DB, and observability
- Convert blocking third-party calls to httpx.AsyncClient and replace time.sleep with asyncio.sleep
- Add token rotation, HttpOnly refresh cookies, and rate limiting to authentication endpoints
FAQ
A prioritized checklist covering architecture, async correctness, security (OWASP), DB patterns, observability, and concrete code snippets to fix issues.
Can it scaffold migrations and containers?
Yes. It generates async-aware migration wrappers and Docker/Docker Compose assets for Postgres, Redis, and the API with production-ready multi-stage Dockerfile.
18 skills
This skill helps you scaffold production-ready FastAPI projects, enforce clean architecture, and optimize async patterns for scalable, secure APIs.
This skill automates and simplifies tabular data manipulation across CSV, Excel, JSON, and Parquet, boosting data cleaning, transformation, and formatting
This skill performs a comprehensive UX/UI evaluation across visual, accessibility, usability, and design system domains to improve interfaces and user flows.
This skill helps transform ideas into fully formed designs through collaborative dialogue and phased validation.
This skill manages Monday.com workspaces via MCP, enabling item, board, and column operations, comments, and data queries to streamline collaboration.
This skill automates Supabase development workflows with CLI tooling for migrations, edge functions, secrets, and type generation, boosting safety and speed.
This skill reduces token count in prompts, docs, and prose while preserving meaning, improving LLM context and readability.
This skill clarifies unit, integration, and end-to-end testing with a car analogy and guides when to use each in projects.
This skill safely wraps gh commands to perform GitHub operations with risk-based prompts and mandatory confirmations for destructive actions.
This skill safely upgrades JavaScript packages across npm/pnpm/yarn with breaking-change detection, migration guidance, and codemod-driven code updates.
This skill enforces multi-language code quality standards for TypeScript, Python, Go, and Rust, guiding writing, review, and refactoring.
This skill converts and transforms files across formats and media, enabling batch processing and consistent outputs for workflows.
This skill helps you generate clean, well-structured markdown that passes IDE and linter checks for documentation, READMEs, and code samples.
This skill designs scalable test strategies for Python and TypeScript apps, covering unit to E2E testing, contract, mutation, and CI/CD integration.
This skill helps you build production-grade data tables with MRT V3 and MUI, covering server-side ops, CRUD, virtualization, and advanced filtering.
This skill helps you implement Pydantic v2 models for travel panel endpoints, enforcing validation, DTOs, and MongoDB conversion.
This skill helps reduce token counts by compressing markdown and text into token-efficient formats for LLM contexts.
This skill enables systematic UX evaluation across accessibility, usability, and design systems to improve user flows and cross-device satisfaction.
