backend-fastapi-python

What problem does it solve?

This Skill reduces inconsistent, ad-hoc backend patterns and repetitive prompt work by giving clear, project-specific conventions and troubleshooting guidance for building Python APIs with FastAPI, SQLModel, and async SQLAlchemy.

Core Features & Use Cases

• Consistent service signatures: Enforce stateless service functions with AsyncSession as the first parameter to standardize database access.
• API response and error conventions: Use ApiResponse[T] wrappers, AppException with machine-readable error_code, and centralized exception handlers for predictable frontend integration.
• Auth, dependencies, and middleware patterns: Provide chainable auth dependencies (get_current_user → require_auth → require_admin), cookie or bearer strategies, request-id and logging middleware, and background task guidance.
• Database and migration guidance: Async engine/session setup, expire_on_commit recommendations, query patterns, and Alembic autogenerate caveats for production-safe migrations.

Quick Start

Use the backend-fastapi-python skill to implement a new FastAPI endpoint with AsyncSession injection, a Pydantic response schema, and the appropriate authentication dependency.