PromptVault is a production-grade AI

PromptVault is a production-grade AI Prompt Lifecycle Management API backend designed to help teams store, organize, evaluate, and monitor AI prompts as structured, testable assets. I built this project as a backend engineering portfolio system using FastAPI, PostgreSQL, async SQLAlchemy, Alembic, Redis, Celery, Apache Airflow, Docker, GitHub Actions, and structured JSON logging. The system provides RESTful APIs for workspace and prompt management, including CRUD operations, Pydantic validation, pagination, soft deletion, and scalable database modeling. PostgreSQL handles persistent storage, while Redis implements a cache-aside strategy for faster API responses, TTL-based expiry, and cache invalidation. PromptVault includes asynchronous background evaluation workflows using Celery with Redis as the broker and result backend. Users can trigger prompt evaluation jobs through the API, receive an immediate job ID, and poll for job status and results. Apache Airflow DAGs automate scheduled prompt regression checks and weekly cleanup workflows. To make the project production-ready, I added async testing with pytest, fakeredis, and integration tests using a dedicated test database, achieving around 63% test coverage. The application is fully containerized with Docker Compose, running FastAPI, PostgreSQL, Redis, and Celery Worker as separate services. Key engineering challenges solved included PostgreSQL enum/default issues, Alembic migration debugging, WSL2 PostgreSQL access configuration, Airflow metadata database separation, SQLAlchemy version conflicts, async pytest connection handling, and Docker dependency separation using requirements.docker.txt. This project demonstrates backend API development, distributed systems, caching, background task processing, workflow orchestration, DevOps, CI/CD, and observability best practices for AI/LLM application infrastructure.