CIOS Brain schema upgrades:
CIOS Brain schema upgrades: live migration + init.sql dual-write pattern. When adding tables/columns to Brain PostgreSQL, apply in TWO places: (1) docker exec paperclip-postgres psql for immediate live effect, (2) /opt/paperclip/init.sql for reproducibility. Init.sql uses ALTER TABLE (not modifying CREATE TABLE) so diff shows what was added. Views: CREATE OR REPLACE VIEW. After schema changes, rebuild MCP container. Rule: Never modify init.sql without applying live, and vice versa.