{"repo":"justyn-clark/fastapi-sqlalchemy-starter","free":true,"listed":false,"github":"https://github.com/justyn-clark/fastapi-sqlalchemy-starter","clone":"git clone https://github.com/justyn-clark/fastapi-sqlalchemy-starter.git","description":"FastAPI SQLAlchemy 2.0 Async Starter Template with PostgreSQL, JWT Authentication, Alembic Migrations, Docker Support and Pydantic Validation. Complete Python web API boilerplate featuring async database operations, user management, comprehensive testing, and production-ready configuration.","language":"Python","stars":10,"topics":[],"license":"MIT","category":"saas-starters-boilerplates","readme_excerpt":"FastAPI + SQLAlchemy 2.0 (async) + Alembic + PostgreSQL Minimal starter API built with FastAPI, async SQLAlchemy, Alembic migrations, and PostgreSQL. What is in this starter - FastAPI app with /docs and /openapi.json - Async SQLAlchemy setup for runtime database access - Alembic migrations using a sync PostgreSQL driver - User model plus auth and user-management routes - JWT token issuance for login - Ruff, mypy, pytest, pre-commit, and GitHub Actions CI - Docker Compose setup for API + PostgreSQL + Adminer (+ Redis container scaffolded but unused by the app) - Makefile and justfile task runners Current status This repo is a starter template, not a finished product. A few things are intentionally minimal right now: - Auth endpoints exist and JWTs are issued, but the /users routes are not currently protected by an auth dependency. - GET /users/search currently returns all users; real query filtering is not implemented yet. - The Docker Compose stack includes Redis, but the application code does not use Redis yet. Stack - Python 3.11+ - FastAPI - SQLAlchemy 2.x (async) - Alembic - PostgreSQL 16 - Pydantic Settings - Ruff - mypy - pytest Project layout Quick start Option A: local Python + local PostgreSQL Option B: Docker Compose Services exposed by the default compose stack: - API: - Swagger UI: - PostgreSQL: localhost:5434 ( postgres / postgres , database mydb ) - Adminer: - Redis: localhost:6379 Stop and remove volumes: Environment configuration Copy .env.example to .env for ","default_branch":null,"files":null,"tree":[],"storefront":"/r/justyn-clark","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/justyn-clark/fastapi-sqlalchemy-starter/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}