minimal-fastapi-postgres-template

Dependency freshness

Declared = lowest version the kit's dependency file (package.json, pyproject.toml or requirements.txt) allows. Latest = the npm "latest" tag or the newest PyPI release. TypeScript, the Stripe SDK, FastAPI and other 0.x packages are shown but not counted in the verdict.

What's in the stack

Framework

FastAPI

Database / ORM

SQLAlchemy, Alembic

API layer

Pydantic

Detected from declared dependencies. A listed package means it's installed, not necessarily fully wired up.

What the README says you get

• API
  CORS configurationincluded in `BACKEND_CORS_ORIGINS` in `.env` file
• API
  Allowed Hosts middlewareThis middleware prevents HTTP Host Headers attack
• API
  Docs at root URLDocs page is simply `/`
• Auth
  JWT and bcrypt authSecure and tested setup for PyJWT and bcrypt.
• Auth
  JWT access tokensuser can exchange username + password for JWT
• Auth
  Database-stored refresh tokensRefresh tokens is saved **in database table**.
• Auth
  Open registrationIs open.
• Auth
  Delete user endpointRethink `delete_current_user`, maybe you don't need it.
• Data
  SQLAlchemy 2.0 asyncSQLAlchemy 2.0, async queries, best possible autocompletion support.
• Data
  PostgreSQL with asyncpgPostgreSQL 18 database under asyncpg interface.
• Data
  Alembic migrationsFull Alembic migrations setup (also in unit tests).
• Deploy
  Dockerfile with UvicornReady to go Dockerfile with uvicorn webserver.
• Other
  Script/cron DB sessionsuse `new_script_async_session` if you need to have access to database outside of FastAPI
• Testing
  Async pytest setupPerfect pytest asynchronous test setup and full coverage.

Extracted from the kit's README by a local AI model (deepseek-flash) on Sep 29, 2026. Every item is checked against an exact README quote. A README claim is the maker's description, not something we tested.