fastapi-sqlmodel-arq-backend

What problem does it solve?

Provides a clear, production-oriented blueprint to build or refactor asynchronous backends using FastAPI together with SQLModel and Arq, removing common pitfalls around async database access, background task orchestration, authentication, and migrations.

Core Features & Use Cases

• Asynchronous Persistence Layer: Patterns for SQLModel entities, AsyncEngine/AsyncSession usage, relationships, and typed schemas.
• Background Processing: Integration patterns for Arq workers and Redis-backed task queues to offload long-running operations.
• Authentication & Security: OAuth2 password flow with JWT issuance, Argon2 password hashing, token validation, and current-user dependency examples.
• Operational Guidance: loguru logging conventions, pydantic-settings configuration from environment, and Alembic migration hints plus uv command suggestions.
• Use Case: Ideal for adding async endpoints to an existing monolith or creating a new microservice that requires reliable background tasks, secure auth, and database migrations.

Quick Start

Create an async FastAPI module with SQLModel models and async sessions, implement OAuth2 password flow with JWT and Argon2 hashing, wire an Arq worker backed by Redis for background tasks, adopt loguru for logging, and include Alembic migration hints and uv commands.