[T3] PostgreSQL database for shared state #6

New Issue

kaykayyali · 2026-05-21T13:05:21Z

kaykayyali commented

2026-05-21 13:05:21 +00:00

Goal

Replace per-agent JSON files with a shared PostgreSQL database so all agents see the same project state.

Implementation

Add Postgres service to docker-compose.yml
Create schema migration file: db/schema.sql
- projects table (id, name, status, created_at, ...)
- deliverables table (id, project_id, agent, type, status, ...)
- decisions table (id, project_id, decided_by, decision, ...)
- conversations table (id, thread_id, participants, ...)
Add db/connection.py — singleton connection manager, used by all agents
Replace self._load_state() / self._save_state() in BaseAgent with DB calls
Add ProjectManager class that provides:
- create_project(name)
- get_project_status(project_id)
- update_project_phase(project_id, phase)
- list_active_projects()
All agents write to the same database — VP gets instant visibility into all work

Files

docker-compose.yml — add postgres service
db/schema.sql — new
db/connection.py — new
db/project_manager.py — new
agents/base_agent.py — replace JSON state with DB

Acceptance

VP can query project_manager.list_active_projects() and see all work
Engineer marks deliverable as "done" → VP instantly sees it
Database survives container restarts (volume mount)

## Goal Replace per-agent JSON files with a shared PostgreSQL database so all agents see the same project state. ## Implementation 1. Add Postgres service to docker-compose.yml 2. Create schema migration file: `db/schema.sql` - `projects` table (id, name, status, created_at, ...) - `deliverables` table (id, project_id, agent, type, status, ...) - `decisions` table (id, project_id, decided_by, decision, ...) - `conversations` table (id, thread_id, participants, ...) 3. Add `db/connection.py` — singleton connection manager, used by all agents 4. Replace `self._load_state()` / `self._save_state()` in BaseAgent with DB calls 5. Add `ProjectManager` class that provides: - `create_project(name)` - `get_project_status(project_id)` - `update_project_phase(project_id, phase)` - `list_active_projects()` 6. All agents write to the same database — VP gets instant visibility into all work ## Files - `docker-compose.yml` — add postgres service - `db/schema.sql` — new - `db/connection.py` — new - `db/project_manager.py` — new - `agents/base_agent.py` — replace JSON state with DB ## Acceptance - VP can query `project_manager.list_active_projects()` and see all work - Engineer marks deliverable as "done" → VP instantly sees it - Database survives container restarts (volume mount)

kaykayyali added this to the v2.0 Tier 3 — Project State & Management milestone 2026-05-21 13:05:21 +00:00

kaykayyali referenced this issue from a commit

2026-05-21 14:59:59 +00:00

feat: add PostgreSQL shared state (Issue #6)

kaykayyali referenced this issue

2026-05-21 15:00:39 +00:00

feat: PostgreSQL shared state for multi-agent coordination (Issue #6) #15

kaykayyali referenced this issue from a commit

2026-05-21 15:05:00 +00:00

Merge pull request 'feat: PostgreSQL shared state for multi-agent coordination (Issue #6)' (#15) from t3-postgres-state into master

This repo is archived. You cannot comment on issues.