Stacktora / Templates / AI / pgvector + Postgres

AI / pgvector + Postgres boilerplate

Python API storing and querying embeddings in Postgres via pgvector. 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 Postgres + pgvector 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 ]
  pgvector:
    image: pgvector/pgvector:pg17
    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

Next.js + PostgreSQL

React framework with a Postgres database — the classic full-stack starting point.

Node.jspostgres

Django + Postgres + Redis

Django with Postgres and a Redis-backed Celery worker for background jobs.

Pythonpostgresredis

FastAPI + PostgreSQL

Lightweight async Python API with a Postgres database.

Pythonpostgres

Rails + Postgres + Sidekiq

Ruby on Rails with Postgres and a Redis-backed Sidekiq worker.

Rubypostgresredis

Open AI / pgvector + Postgres in Stacktora