vargasjona/fastapi-alembic-sqlmodel-async

Health v2 · maintenance only

Flags: no_releases

Adoption not part of the score

1269 stars · 171 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

A production-oriented FastAPI project template combining async SQLModel as the ORM, Alembic migrations, Pydantic v2, JWT authentication, and role-based access control in a complete async CRUD example. It ships with Docker Compose (including Caddy and PostgreSQL), Celery for background and scheduled tasks, pytest-based automated tests, and code-quality tooling.

Use cases

• start a new async FastAPI REST API project from a template
• fastapi crud boilerplate with jwt authentication and roles
• async postgres crud api using sqlmodel and alembic migrations
• fastapi project template with docker compose and celery tasks
• role based access control example for fastapi apis
• pydantic v2 and sqlalchemy 2.0 async api starter

When to choose

• you are starting a new async FastAPI backend from scratch and want auth, RBAC, migrations, and tests prewired
• you want an async PostgreSQL stack built on SQLModel, Pydantic v2, and SQLAlchemy 2.0
• you need a Docker Compose deployment layout with background jobs via Celery
• you want a reference implementation of async CRUD patterns in FastAPI

When to avoid

• you need an installable library or framework rather than a forkable starter application
• your project uses a synchronous ORM, a database other than PostgreSQL, or a different auth scheme
• you want a minimal microservice without authentication, Celery, or the included tooling
• you are not targeting Python 3.10+ or do not want an opinionated project structure

Facets

application · maturity active

web-framework api-framework auth authorization orm database testing deployment web-development backend apis databases developer-tools python self-hosted cross-platform fastapi sqlmodel alembic boilerplate project-template crud jwt-authentication role-based-access-control celery pydantic-v2 postgresql async docker-compose caddy starter-template docker web-server

Member repositories

For agents

markdown · JSON · MCP: product_card(name="vargasjona/fastapi-alembic-sqlmodel-async")