FastAPI + PostgreSQL boilerplate

Lightweight async Python API with a Postgres database. One click generates a complete, runnable bootstrap — docker-compose, Makefile, Dockerfile, CI and more.

Use this template Browse all templates

The stack

Python 3.12 PostgreSQL 5432

docker-compose.yml preview

# docker-compose.yml — generated by Stacktora
services:
  api:
    image: python:3.12-slim
    command: uvicorn app.main:app --reload --host 0.0.0.0
    ports:
      - "8000:8000"
    env_file: [ .env ]
  postgres:
    image: postgres:18-alpine
    ports:
      - "5432:5432"

What you get

docker-compose.ymlMakefileDockerfileREADME.md.env.example.gitignore.dockerignore.github/workflows/ci.yml.tool-versions.editorconfigProcfile … and more

Quickstart

# clone, then one command to a running stack
git clone … && cd api
$ make setup   # install toolchain + deps, build images
$ make dev     # boot the full stack
# → api live at localhost:8000

Related templates

Go API + PostgreSQL

Compiled Go HTTP API with a Postgres database.

Gopostgres

.NET API + PostgreSQL

ASP.NET Core Web API backed by Postgres.

.NETpostgres

Rust API + PostgreSQL

Rust HTTP API (Axum-style) with a Postgres database.

Rustpostgres

Bun API + PostgreSQL

Ultra-fast Bun HTTP API with a Postgres database.

Bunpostgres

Open FastAPI + PostgreSQL in Stacktora