# Notion DB Audit & Restructuring Plan
**Date:** 2026-02-23 | **Auditor:** Kitt

---

## Current State: 22 Databases

### Active & Valuable (keep)
| DB | Entries | Last Edit | Notes |
|----|---------|-----------|-------|
| **Projects** | 29 | Feb 13 | Core. 12 properties. Good schema. |
| **Tasks** | 100+ | Feb 16 | Core. Linked to Projects. Active use. |
| **People Directory** | 100+ | Feb 1 | Primary contacts DB. 14 properties. |
| **Inspiration Library** | 100+ | Feb 21 | Active. Used by taste board pipeline. |
| **Meetings** | has entries | Feb 9 | Useful for client history. |
| **Brand Strategy Applicants** | 13 | Feb 9 | Active project-specific DB. |
| **Trend Intelligence** | has entries | Feb 21 | Active. Julia's intelligence pipeline. |
| **Qualified Sources** | has entries | Feb 21 | Active. Source tier framework. |

### Redundant (merge or delete)
| DB | Issue | Recommendation |
|----|-------|----------------|
| **Contacts CRM** (2 entries) | Duplicates People Directory | **MERGE into People Directory, DELETE** |
| **Contacts Inbox** (0 entries) | Empty, redundant with CRM | **DELETE** |
| **Authorized Contacts** (has entries) | Subset of People Directory | **Add "Authorized" tag to People Directory, MERGE, DELETE** |
| **To-Dos** (has entries) | Duplicates Tasks DB | **MERGE into Tasks, DELETE** |
| **Ideas** (has entries) | Overlaps Planning & Ideas | **MERGE into Planning & Ideas, DELETE** |
| **Quick Capture** (0 entries) | Empty, overlaps Ideas | **DELETE** |
| **Expenses/Licenses Spoken** (has entries) | Overlaps Expenses | **MERGE into Expenses, DELETE** |

### Stale / Never Used (delete or archive)
| DB | Entries | Last Edit | Recommendation |
|----|---------|-----------|----------------|
| **Family Calendar** | 0 | Jan 21 | **DELETE** — use Google Calendar |
| **Budget Limits** | 0 | Jan 21 | **DELETE** — never populated |
| **Expenses** | 0 | Jan 21 | **DELETE** — never used, merge Spoken into a new one if needed |
| **Goals & Habits** | 0 | Jan 21 | **DELETE** — never populated |
| **Chores** | 1 | Jan 21 | **DELETE** — not used |
| **Shopping List** | 1 | Jan 21 | **DELETE** — not used |
| **Planning & Ideas** | has entries | Jan 23 | **KEEP** after merging Ideas into it |

---

## Problems Summary

### 1. Contact Fragmentation (Critical)
4 separate databases for people/contacts. This means:
- No single source of truth for "who do we know"
- Bot can't reliably look up a contact
- Risk of outdated info in one DB contradicting another

### 2. Task Fragmentation
Tasks DB + To-Dos = two places to track work. Confusing for both humans and bots.

### 3. Dead Weight
6 databases with 0 entries, never used since creation (Jan 21). They clutter the workspace and confuse navigation.

### 4. No Emergency/Security Infrastructure
Zero databases or pages for:
- Emergency protocols
- Server credentials & access
- Backup status
- Incident logs

### 5. No Agent/Resource Registry
No structured DB for:
- Agent roster (who does what, which model, status)
- API keys & service inventory
- Infrastructure map (servers, domains, services)

---

## Recommended Structure: Agency Brain

### Tier 1: Operations (daily use)
| DB | Purpose | Status |
|----|---------|--------|
| **Projects** | All client & internal projects | ✅ Keep as-is |
| **Tasks** | All actionable work items | ✅ Keep, absorb To-Dos |
| **People Directory** | ALL contacts (clients, team, family, authorized) | ✅ Keep, absorb 3 other contact DBs |
| **Meetings** | Meeting notes & action items | ✅ Keep as-is |

### Tier 2: Intelligence (weekly use)
| DB | Purpose | Status |
|----|---------|--------|
| **Inspiration Library** | Visual references & taste | ✅ Keep as-is |
| **Trend Intelligence** | Market signals | ✅ Keep as-is |
| **Qualified Sources** | Source credibility tiers | ✅ Keep as-is |
| **Planning & Ideas** | Ideas backlog | ✅ Keep, absorb Ideas + Quick Capture |

### Tier 3: Agency Infrastructure (NEW)
| DB | Purpose | Action |
|----|---------|--------|
| **🔒 Emergency Protocols** | Incident response, contacts, procedures | **CREATE** |
| **🤖 Agent Registry** | All agents, models, roles, status | **CREATE** |
| **🔑 Service Inventory** | APIs, servers, domains, credentials locations | **CREATE** |
| **📋 Incident Log** | Past incidents, what happened, resolution | **CREATE** |

### Archive or Delete
Everything else (13 databases) gets merged or deleted.

---

## Cleanup Plan (Step by Step)

### Phase 1: Merge Contacts (30 min)
1. Export Contacts CRM → merge into People Directory
2. Export Authorized Contacts → add "Authorized" property to People Directory
3. Delete: Contacts CRM, Contacts Inbox, Authorized Contacts

### Phase 2: Merge Tasks & Ideas (20 min)
1. Move To-Dos entries → Tasks DB
2. Move Ideas entries → Planning & Ideas
3. Delete: To-Dos, Ideas, Quick Capture

### Phase 3: Delete Dead Weight (5 min)
Delete: Family Calendar, Budget Limits, Expenses, Goals & Habits, Chores, Shopping List
(If Expenses/Licenses Spoken has useful data, migrate to a clean Expenses DB first)

### Phase 4: Create Agency Infrastructure (1 hour)
1. Create **🔒 Emergency Protocols** DB
   - Properties: Protocol Name, Type (fire/server/medical/security), Steps, Contacts, Last Tested, Priority
2. Create **🤖 Agent Registry** DB
   - Properties: Agent Name, Role, Model, Status, Capabilities, Spawn Command, Notes
3. Create **🔑 Service Inventory** DB
   - Properties: Service, Type (API/Server/Domain), Access (key location), Status, Monthly Cost, Owner
4. Create **📋 Incident Log** DB
   - Properties: Date, Type, Severity, Description, Resolution, Duration, Lessons Learned

### Phase 5: Populate Infrastructure (ongoing)
- Fill Agent Registry with current 8 agents
- Fill Service Inventory with GitHub, Notion, Gmail, Gemini, server details
- Write emergency protocols (security plan — separate task)
- Log last night's incident as first entry

---

## Result: 22 → 12 Databases
Clean, purposeful, no redundancy. Every DB has a clear owner and use case.

### Final Structure
1. Projects
2. Tasks
3. People Directory
4. Meetings
5. Inspiration Library
6. Trend Intelligence
7. Qualified Sources
8. Planning & Ideas
9. Brand Strategy Applicants
10. 🔒 Emergency Protocols (new)
11. 🤖 Agent Registry (new)
12. 🔑 Service Inventory (new)
+ Incident Log (new, could be a page instead of DB)