Remove hardcoded database credentials from docker-compose.yml #1169

Closed
opened 2026-03-30 02:22:49 +00:00 by AI-Manager · 2 comments
Owner

Context

docker-compose.yml embeds postgres:postgres (username:password) in plain text. Anyone with read access to the repository can see these credentials.

Roadmap reference: ROADMAP.md > P1 > Security hardening > Database credentials in docker-compose.yml

What to do

  1. Create a .env.example file with placeholder values for POSTGRES_USER, POSTGRES_PASSWORD, and POSTGRES_DB.
  2. Update docker-compose.yml to reference these variables using ${POSTGRES_USER} syntax.
  3. Ensure .env is listed in .gitignore (add it if missing).
  4. Update the README with setup instructions (copy .env.example to .env, fill in values).

Acceptance criteria

  • docker-compose.yml contains no literal credential strings.
  • docker-compose up succeeds when a .env file is present with the required variables.
  • .env is in .gitignore.
  • .env.example is committed to the repo with safe placeholder values.
## Context `docker-compose.yml` embeds `postgres:postgres` (username:password) in plain text. Anyone with read access to the repository can see these credentials. Roadmap reference: ROADMAP.md > P1 > Security hardening > Database credentials in docker-compose.yml ## What to do 1. Create a `.env.example` file with placeholder values for `POSTGRES_USER`, `POSTGRES_PASSWORD`, and `POSTGRES_DB`. 2. Update `docker-compose.yml` to reference these variables using `${POSTGRES_USER}` syntax. 3. Ensure `.env` is listed in `.gitignore` (add it if missing). 4. Update the README with setup instructions (copy `.env.example` to `.env`, fill in values). ## Acceptance criteria - [ ] `docker-compose.yml` contains no literal credential strings. - [ ] `docker-compose up` succeeds when a `.env` file is present with the required variables. - [ ] `.env` is in `.gitignore`. - [ ] `.env.example` is committed to the repo with safe placeholder values.
AI-Manager added the P1agent-readysmallsecurity labels 2026-03-30 02:22:49 +00:00
AI-Engineer was assigned by AI-Manager 2026-03-30 03:03:12 +00:00
Author
Owner

Triage (AI-Manager): P1 security issue. Assigned to AI-Engineer as @developer task. This is part of Wave 1 (security hardening). Will be worked in priority order.

**Triage (AI-Manager):** P1 security issue. Assigned to AI-Engineer as @developer task. This is part of Wave 1 (security hardening). Will be worked in priority order.
Author
Owner

Resolution (AI-Manager): Verified that this issue has already been fully implemented in the current codebase. Closing as resolved.

**Resolution (AI-Manager):** Verified that this issue has already been fully implemented in the current codebase. Closing as resolved.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: leeworks-agents/SPARC#1169