fastapi-backend-template

FastAPI with PostgreSQL, async SQLAlchemy 2.0, Alembic, and Docker.

⭐5stars🔀1forks📁View on GitHub🕐Updated Jan 11, 2026⬇️1downloads

When & Why to Use This Skill

This Claude skill provides a production-ready FastAPI backend template designed to accelerate web development. It integrates a modern tech stack featuring FastAPI, PostgreSQL, and asynchronous SQLAlchemy 2.0, ensuring high performance and scalability. By incorporating Alembic for database migrations and Docker for containerization, it offers a standardized architecture that simplifies project initialization and deployment workflows.

Use Cases

  • Rapidly bootstrapping a new Python-based web service with a pre-configured asynchronous database layer.
  • Implementing scalable API architectures using SQLAlchemy 2.0's latest async patterns and best practices.
  • Streamlining development-to-production pipelines using Docker containerization and automated Alembic migrations.
  • Setting up a robust foundation for microservices that require high-concurrency and reliable PostgreSQL integration.
namefastapi-backend-template
descriptionFastAPI with PostgreSQL, async SQLAlchemy 2.0, Alembic, and Docker.

FastAPI Backend Template

FastAPI with PostgreSQL, async SQLAlchemy 2.0, Alembic migrations, and Docker.

Tech Stack

  • Framework: FastAPI
  • Language: Python
  • ORM: SQLAlchemy 2.0 (async)
  • Migrations: Alembic
  • Database: PostgreSQL

Prerequisites

  • Python 3.11+
  • Docker (recommended)
  • PostgreSQL

Setup

1. Clone the Template

git clone --depth 1 https://github.com/Aeternalis-Ingenium/FastAPI-Backend-Template.git .

If the directory is not empty:

git clone --depth 1 https://github.com/Aeternalis-Ingenium/FastAPI-Backend-Template.git _temp_template
mv _temp_template/* _temp_template/.* . 2>/dev/null || true
rm -rf _temp_template

2. Remove Git History (Optional)

rm -rf .git
git init

3. Setup Virtual Environment

python -m venv venv
source venv/bin/activate  # or venv\Scripts\activate on Windows
pip install -r requirements.txt

4. Setup Database

Configure PostgreSQL and run Alembic migrations.

Development

uvicorn main:app --reload