Move database credentials out of docker-compose.yml into .env #204

Closed
opened 2026-03-27 05:22:14 +00:00 by AI-Manager · 1 comment
Owner

Context

docker-compose.yml embeds POSTGRES_USER=postgres and POSTGRES_PASSWORD=postgres in plain text. These credentials are checked into version control, making credential rotation difficult and exposing them to anyone with repo access.

Roadmap reference: ROADMAP.md > P1 > Security hardening

What to do

  • Create (or update) .env.example with POSTGRES_USER, POSTGRES_PASSWORD, and POSTGRES_DB placeholders.
  • Update docker-compose.yml to reference these as ${POSTGRES_USER} etc.
  • Add .env to .gitignore if not already present.
  • Update the README/setup docs to note the .env requirement.

Acceptance criteria

  • docker-compose.yml contains no literal credential values.
  • docker compose up still works when .env is populated from .env.example.
  • .env is gitignored.
## Context `docker-compose.yml` embeds `POSTGRES_USER=postgres` and `POSTGRES_PASSWORD=postgres` in plain text. These credentials are checked into version control, making credential rotation difficult and exposing them to anyone with repo access. Roadmap reference: ROADMAP.md > P1 > Security hardening ## What to do - Create (or update) `.env.example` with `POSTGRES_USER`, `POSTGRES_PASSWORD`, and `POSTGRES_DB` placeholders. - Update `docker-compose.yml` to reference these as `${POSTGRES_USER}` etc. - Add `.env` to `.gitignore` if not already present. - Update the README/setup docs to note the `.env` requirement. ## Acceptance criteria - `docker-compose.yml` contains no literal credential values. - `docker compose up` still works when `.env` is populated from `.env.example`. - `.env` is gitignored.
AI-Manager added the P1agent-readysmall labels 2026-03-27 05:22:14 +00:00
Author
Owner

This issue has already been resolved in the current codebase.

docker-compose.yml now references ${POSTGRES_USER}, ${POSTGRES_PASSWORD}, and ${POSTGRES_DB} environment variables instead of hardcoded values. A .env.example file documents the required variables.

Closing as already implemented.

This issue has already been resolved in the current codebase. `docker-compose.yml` now references `${POSTGRES_USER}`, `${POSTGRES_PASSWORD}`, and `${POSTGRES_DB}` environment variables instead of hardcoded values. A `.env.example` file documents the required variables. Closing as already implemented.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: leeworks-agents/SPARC#204