burntop

Configure Alembic for async SQLAlchemy migrations with PostgreSQL

Create FastAPI application factory with lifespan, middleware, pagination, and router configuration

Implement session-based authentication in FastAPI applications. Use when building login/logout flows, protecting endpoints with auth dependencies, creating user models with password hashing, managing sessions in database, or implementing auth exceptions. Covers HTTPBearer token validation, Argon2 password hashing, session repository/service patterns, and route protection with dependency injection.

Overview and guidelines for FastAPI 3-layer architecture with async SQLAlchemy, Pydantic v2, and best practices

Create SQLAlchemy base model with UUID, timestamp, and soft delete mixins for FastAPI

Create abstract base repository interface with CRUD, pagination, filtering, bulk operations, and soft delete

Create Pydantic v2 base schemas for request validation and response serialization in FastAPI

Create base service class that wraps repository operations and provides business logic hooks

Configure async SQLAlchemy 2.0 engine, session factory, and database dependency for FastAPI

Create a new entity with model, schemas, repository, service, router, dependencies, and filters

Create custom exceptions, error response schemas, and centralized exception handlers for FastAPI

Configure structured JSON logging with correlation IDs and request context for FastAPI

Implement PostgreSQL repository with bulk upsert, soft delete filtering, and fastapi-pagination/filter integration

Initialize FastAPI project with uv, pyproject.toml, ruff configuration, and environment files

Configure pytest-asyncio with test database fixtures and integration tests for FastAPI routers

OpenProse is a programming language for AI sessions. An AI session is a Turing-complete computer; OpenProse structures English into unambiguous control flow. More pattern than framework—it ships as a skill with no dependencies. Activate when: running .prose files, mentioning OpenProse, or orchestrating multi-agent workflows from a script. Use this skill if you ever want to kick off more than one subagent at a time, or orchestrate anything interesting between more than one subagent. Write a .prose file and save it in the .claude-plugin/ directory. Then embody the OpenProse VM, as described in prose.md, and execute it.

Configure Alembic for async SQLAlchemy migrations with PostgreSQL

Create FastAPI application factory with lifespan, middleware, pagination, and router configuration

Overview and guidelines for FastAPI 3-layer architecture with async SQLAlchemy, Pydantic v2, and best practices

Create SQLAlchemy base model with UUID, timestamp, and soft delete mixins for FastAPI

Create abstract base repository interface with CRUD, pagination, filtering, bulk operations, and soft delete

Create Pydantic v2 base schemas for request validation and response serialization in FastAPI

Create base service class that wraps repository operations and provides business logic hooks

Configure async SQLAlchemy 2.0 engine, session factory, and database dependency for FastAPI

Create a new entity with model, schemas, repository, service, router, dependencies, and filters

Create custom exceptions, error response schemas, and centralized exception handlers for FastAPI

Configure structured JSON logging with correlation IDs and request context for FastAPI

Implement PostgreSQL repository with bulk upsert, soft delete filtering, and fastapi-pagination/filter integration

Initialize FastAPI project with uv, pyproject.toml, ruff configuration, and environment files

Configure pytest-asyncio with test database fixtures and integration tests for FastAPI routers