{"slug":"business/STORE_ACCESS_MAP","title":"Store Access Pattern Map — IntegrateWise Services","section":"business","sectionLabel":"Business","status":"unclassified","type":"document","path":"business/STORE_ACCESS_MAP.mdx","bytes":42901,"description":null,"updated":null,"source":"integratewise/Integratewise-docs-wiki","content":"\n> Generated 2026-07-31. Covers: spine, pipeline, knowledge, intelligence, mcp-connector, continuity, workflow.\n\n## D1 Database Inventory\n\n| Database Name                 | Binding Name       | DB ID       | Used By                                                                |\n| ----------------------------- | ------------------ | ----------- | ---------------------------------------------------------------------- |\n| integratewise-spine-staging   | DB                 | 6a8b5b3c... | spine (dev/test)                                                       |\n| integratewise-spine-prod      | DB                 | 08d9f306... | spine (prod)                                                           |\n| integratewise-spine-cache     | DB/CACHE_DB/D1     | ed1f534a... | pipeline, knowledge, intelligence, mcp-connector, continuity, workflow |\n| integratewise-canonical-spine | CANONICAL_SPINE_DB | PLACEHOLDER | pipeline (not yet created)                                             |\n| integratewise-analytics       | ANALYTICS_DB       | b829f7b0... | workflow                                                               |\n\n---\n\n## Per-Service Store Map\n\n### SPINE (`services/spine/`)\n\n| Service | Store Type                                 | Table/Namespace               | R/W | Status                        |\n| ------- | ------------------------------------------ | ----------------------------- | --- | ----------------------------- |\n| spine   | D1 (DB → integratewise-spine-staging/prod) | connections                   | R/W | **wired**                     |\n| spine   | D1 (DB)                                    | connectors                    | R/W | **wired**                     |\n| spine   | D1 (DB)                                    | sync-jobs                     | R/W | **wired**                     |\n| spine   | D1 (DB)                                    | webhooks                      | R/W | **wired**                     |\n| spine   | D1 (DB)                                    | schemas                       | R/W | **wired**                     |\n| spine   | D1 (DB)                                    | capabilities                  | R/W | **wired**                     |\n| spine   | D1 (DB)                                    | timeline-events               | R/W | **wired**                     |\n| spine   | Neon (FORTRESS_DATABASE_URL)               | product.workbench_overview    | R   | **wired**                     |\n| spine   | Neon                                       | product.workbench_definitions | R   | **wired**                     |\n| spine   | Neon                                       | spine.activities              | R/W | **wired**                     |\n| spine   | Neon                                       | spine.current_entities        | R   | **wired**                     |\n| spine   | Neon                                       | knowledge.documents           | R   | **wired** (cross-schema read) |\n| spine   | Neon                                       | continuity.memories           | R   | **wired** (cross-schema read) |\n| spine   | Neon                                       | spine_connector_catalog       | R   | **placeholder** (test only)   |\n| spine   | Neon                                       | spine_connector_installations | R   | **placeholder** (test only)   |\n| spine   | Neon                                       | governance_proposals          | R   | **placeholder** (test only)   |\n| spine   | Neon                                       | marketplace_packages          | R   | **placeholder** (test only)   |\n| spine   | Neon                                       | marketplace_package_versions  | R   | **placeholder** (test only)   |\n| spine   | Neon                                       | marketplace_installations     | R   | **placeholder** (test only)   |\n\n**Service Bindings:** None\n\n---\n\n### PIPELINE (`services/pipeline/`)\n\n| Service  | Store Type                                     | Table/Namespace            | R/W             | Status                                         |\n| -------- | ---------------------------------------------- | -------------------------- | --------------- | ---------------------------------------------- |\n| pipeline | D1 (CACHE_DB → spine-cache)                    | tenants                    | R               | **wired**                                      |\n| pipeline | D1 (CANONICAL_SPINE_DB → canonical-spine)      | spine_entities             | R/W             | **placeholder** (DB ID not created)            |\n| pipeline | D1                                             | spine_timeline             | W               | **placeholder**                                |\n| pipeline | D1                                             | spine_relationships        | W               | **placeholder**                                |\n| pipeline | D1 (DB — **NO TOML BINDING**)                  | entity_cache               | R/W             | **broken** (env.DB not bound in wrangler.toml) |\n| pipeline | D1                                             | signal_cache               | R/W             | **broken**                                     |\n| pipeline | D1                                             | cross_data                 | R               | **broken**                                     |\n| pipeline | D1                                             | decide_data                | R               | **broken**                                     |\n| pipeline | D1                                             | governance_data            | R/W             | **broken**                                     |\n| pipeline | D1                                             | merge_candidates           | R/W             | **broken**                                     |\n| pipeline | D1                                             | entity_signatures          | R               | **broken**                                     |\n| pipeline | D1                                             | agent_memory               | R/W             | **broken**                                     |\n| pipeline | D1                                             | signals                    | R/W             | **broken**                                     |\n| pipeline | D1                                             | approval_queue             | R/W             | **broken**                                     |\n| pipeline | D1                                             | audit_log                  | W               | **broken**                                     |\n| pipeline | D1                                             | spine_schema_registry      | W               | **broken**                                     |\n| pipeline | D1                                             | spine_vault                | R/W             | **broken**                                     |\n| pipeline | D1                                             | entities                   | R               | **broken**                                     |\n| pipeline | Neon (FORTRESS_DATABASE_URL via Supabase REST) | entities                   | R               | **wired**                                      |\n| pipeline | Neon                                           | entity_merges              | W               | **wired**                                      |\n| pipeline | Neon                                           | normalization_errors       | W               | **wired**                                      |\n| pipeline | KV (CACHE)                                     | entity:{tid}:{source}:{id} | R/W             | **wired**                                      |\n| pipeline | KV (CACHE)                                     | agent:memory:\\*            | R/W             | **wired**                                      |\n| pipeline | KV (SIGNAL_CACHE)                              | signal:\\*                  | W               | **wired**                                      |\n| pipeline | KV (METRICS)                                   | last_pipeline              | W               | **wired**                                      |\n| pipeline | KV (SCHEMA_CACHE)                              | —                          | —               | **wired** (same ns as CACHE)                   |\n| pipeline | Queue                                          | pipeline-process           | Produce+Consume | **wired**                                      |\n| pipeline | Queue                                          | knowledge-ingest           | Produce         | **wired**                                      |\n| pipeline | Queue                                          | accelerator-trigger        | Produce+Consume | **wired**                                      |\n| pipeline | Queue                                          | intelligence-events        | Produce         | **wired**                                      |\n| pipeline | Queue                                          | ops-dlq                    | Produce         | **wired**                                      |\n| pipeline | Queue                                          | signals                    | Produce         | **wired**                                      |\n| pipeline | Queue                                          | memory-promote             | Produce+Consume | **wired**                                      |\n| pipeline | Workers AI (AI)                                | —                          | —               | **wired**                                      |\n\n**Service Bindings:** KNOWLEDGE, MCP (mcp-connector), INTELLIGENCE, SPINE (self in test/prod), BFF (workflow)\n\n---\n\n### KNOWLEDGE (`services/knowledge/`)\n\n| Service   | Store Type                                            | Table/Namespace            | R/W             | Status    |\n| --------- | ----------------------------------------------------- | -------------------------- | --------------- | --------- |\n| knowledge | D1 (DB → spine-cache)                                 | document_chunks            | R/W             | **wired** |\n| knowledge | D1 (DB)                                               | search_history             | W               | **wired** |\n| knowledge | D1 (DB)                                               | consolidated_memories      | R/W             | **wired** |\n| knowledge | D1 (DB)                                               | embeddings                 | R/W             | **wired** |\n| knowledge | D1 (DB)                                               | ai_sessions                | R/W             | **wired** |\n| knowledge | D1 (DB)                                               | ai_session_memories        | R/W             | **wired** |\n| knowledge | D1 (DB)                                               | ai_conversations           | R/W             | **wired** |\n| knowledge | D1 (DB)                                               | ai_messages                | R/W             | **wired** |\n| knowledge | D1 (DB)                                               | ai_memories                | R/W             | **wired** |\n| knowledge | D1 (DB)                                               | org_memory                 | R               | **wired** |\n| knowledge | D1 (DB)                                               | personal_memory            | R               | **wired** |\n| knowledge | D1 (DB)                                               | conversational_memory      | R               | **wired** |\n| knowledge | D1 (DB)                                               | triage_results             | W               | **wired** |\n| knowledge | D1 (DB)                                               | tenant_spine_config        | R               | **wired** |\n| knowledge | R2 (FILES → integratewise-files-prod)                 | file blobs                 | R/W             | **wired** |\n| knowledge | KV (STATE → d546c00b...)                              | consolidator state         | R/W             | **wired** |\n| knowledge | AI Search (VECTORIZE_INDEX → integratewise-knowledge) | vector index               | R/W             | **wired** |\n| knowledge | Workers AI (AI)                                       | embeddings                 | —               | **wired** |\n| knowledge | Queue                                                 | knowledge-ingest           | Consume         | **wired** |\n| knowledge | Queue                                                 | memory-consolidation-tasks | Consume+Produce | **wired** |\n| knowledge | DO (CONSOLIDATOR — MemoryConsolidator)                | coordination               | R/W             | **wired** |\n\n**Service Bindings:** PIPELINE, THINK (intelligence), IQ_HUB (self)\n\n---\n\n### INTELLIGENCE (`services/intelligence/`)\n\n| Service      | Store Type                                         | Table/Namespace            | R/W             | Status    |\n| ------------ | -------------------------------------------------- | -------------------------- | --------------- | --------- |\n| intelligence | D1 (D1 → spine-cache)                              | cross_data                 | R               | **wired** |\n| intelligence | D1                                                 | governance_data            | R/W             | **wired** |\n| intelligence | D1                                                 | continuity_loop            | R/W             | **wired** |\n| intelligence | D1                                                 | agent_decisions            | W               | **wired** |\n| intelligence | D1                                                 | audit_logs                 | W               | **wired** |\n| intelligence | D1                                                 | dlq_entries                | W               | **wired** |\n| intelligence | D1                                                 | conversational_memory      | R/W             | **wired** |\n| intelligence | D1                                                 | personal_memory            | R               | **wired** |\n| intelligence | D1                                                 | signal_rules               | R               | **wired** |\n| intelligence | D1                                                 | situation_escalation_rules | R               | **wired** |\n| intelligence | D1                                                 | ai_insights_buffer         | R               | **wired** |\n| intelligence | D1                                                 | evidence_refs              | W               | **wired** |\n| intelligence | D1                                                 | signals                    | R/W             | **wired** |\n| intelligence | D1                                                 | spine_metrics              | R               | **wired** |\n| intelligence | D1                                                 | events                     | R               | **wired** |\n| intelligence | D1                                                 | artifact_links             | R               | **wired** |\n| intelligence | D1                                                 | emails                     | R               | **wired** |\n| intelligence | D1                                                 | drive_files                | R               | **wired** |\n| intelligence | D1                                                 | brainstorm_sessions        | R               | **wired** |\n| intelligence | D1                                                 | brainstorm_insights        | R               | **wired** |\n| intelligence | D1                                                 | situations                 | W               | **wired** |\n| intelligence | D1                                                 | action_proposals           | W               | **wired** |\n| intelligence | D1                                                 | decision_memory            | R/W             | **wired** |\n| intelligence | D1                                                 | decision_patterns          | R               | **wired** |\n| intelligence | D1                                                 | source_reliability         | R/W             | **wired** |\n| intelligence | D1                                                 | trust_scores               | R               | **wired** |\n| intelligence | D1                                                 | autonomy_overrides         | R/W             | **wired** |\n| intelligence | D1                                                 | ai_session_memories        | R               | **wired** |\n| intelligence | D1                                                 | document_chunks            | R               | **wired** |\n| intelligence | D1                                                 | ai_sessions                | R               | **wired** |\n| intelligence | D1                                                 | session_entity_links       | W               | **wired** |\n| intelligence | Neon (DATABASE_URL via @neondatabase/serverless)   | governance_policies        | R/W             | **wired** |\n| intelligence | Neon                                               | actions                    | R/W             | **wired** |\n| intelligence | Neon (FORTRESS_DATABASE_URL via Supabase REST)     | tenant_spine_config        | R               | **wired** |\n| intelligence | Supabase REST                                      | audit_log                  | W               | **wired** |\n| intelligence | Supabase REST                                      | ai_config                  | R/W             | **wired** |\n| intelligence | Supabase REST                                      | decision_memory            | W               | **wired** |\n| intelligence | Supabase REST                                      | rule_effectiveness         | R/W             | **wired** |\n| intelligence | Supabase REST                                      | drift_events               | W               | **wired** |\n| intelligence | R2 (FILES → integratewise-files-prod)              | memory content             | R/W             | **wired** |\n| intelligence | AI Search (AI_SEARCH → integratewise-intelligence) | semantic index             | R/W             | **wired** |\n| intelligence | Workers AI (AI)                                    | inference                  | —               | **wired** |\n| intelligence | Queue                                              | pipeline-process           | Produce         | **wired** |\n| intelligence | Queue                                              | intelligence-act           | Produce+Consume | **wired** |\n| intelligence | Queue                                              | ops-dlq                    | Produce+Consume | **wired** |\n| intelligence | Queue                                              | signals                    | Consume         | **wired** |\n| intelligence | Queue                                              | memory-promote             | Produce         | **wired** |\n| intelligence | DO (HANDOFF_TIMEOUT — HandoffTimeoutDO)            | timeout tracking           | R/W             | **wired** |\n| intelligence | Workflow (TRIAGE_WORKFLOW)                         | TriageWorkflow             | —               | **wired** |\n| intelligence | Workflow (AGENT_COLONY)                            | BulkCleanupSwarm           | —               | **wired** |\n\n**Service Bindings:** CONNECTOR, WORKFLOW, KNOWLEDGE, PIPELINE\n\n---\n\n### MCP-CONNECTOR (`services/mcp-connector/`)\n\n| Service       | Store Type                         | Table/Namespace                 | R/W     | Status    |\n| ------------- | ---------------------------------- | ------------------------------- | ------- | --------- |\n| mcp-connector | D1 (DB → spine-cache)              | users                           | R       | **wired** |\n| mcp-connector | D1 (DB)                            | tenant_spine_config             | R/W     | **wired** |\n| mcp-connector | D1 (DB)                            | agent_registry                  | R/W     | **wired** |\n| mcp-connector | D1 (DB)                            | connector_catalog               | R       | **wired** |\n| mcp-connector | D1 (DB)                            | context_boundaries              | W       | **wired** |\n| mcp-connector | D1 (DB)                            | context_exchange_log            | W       | **wired** |\n| mcp-connector | D1 (DB)                            | active_work_context             | R/W     | **wired** |\n| mcp-connector | D1 (DB)                            | agent_communication_log         | R/W     | **wired** |\n| mcp-connector | D1 (DB)                            | handoff_packages                | W       | **wired** |\n| mcp-connector | D1 (DB)                            | handoff_state_log               | W       | **wired** |\n| mcp-connector | D1 (DB)                            | proposals                       | R/W     | **wired** |\n| mcp-connector | D1 (DB)                            | oauth_refresh_tokens            | R/W     | **wired** |\n| mcp-connector | D1 (DB)                            | oauth_clients                   | R/W     | **wired** |\n| mcp-connector | D1 (DB)                            | spine_entities                  | R       | **wired** |\n| mcp-connector | D1 (DB)                            | signals                         | R       | **wired** |\n| mcp-connector | D1 (DB)                            | kb_artifacts                    | R       | **wired** |\n| mcp-connector | D1 (DB)                            | kb_topic_policies               | R/W     | **wired** |\n| mcp-connector | D1 (DB)                            | spine_events                    | W       | **wired** |\n| mcp-connector | D1 (DB)                            | ai_sessions                     | R/W     | **wired** |\n| mcp-connector | D1 (DB)                            | ai_session_memories             | W       | **wired** |\n| mcp-connector | D1 (DB)                            | session_entity_links            | W       | **wired** |\n| mcp-connector | KV (MCP_IDEMPOTENCY → 16510bf2...) | idempotency keys                | R/W     | **wired** |\n| mcp-connector | Queue                              | knowledge-ingest                | Produce | **wired** |\n| mcp-connector | Queue                              | pipeline-process                | Produce | **wired** |\n| mcp-connector | Neon (FORTRESS_DATABASE_URL)       | auth/v1/jwks (JWT verification) | R       | **wired** |\n\n**Service Bindings:** KNOWLEDGE, CONTINUITY, PIPELINE, INTELLIGENCE, AGENT_RUNTIME\n\n---\n\n### CONTINUITY (`services/continuity/`)\n\n| Service    | Store Type                            | Table/Namespace     | R/W             | Status                                           |\n| ---------- | ------------------------------------- | ------------------- | --------------- | ------------------------------------------------ |\n| continuity | D1 (DB → spine-cache)                 | tenant_spine_config | R               | **wired**                                        |\n| continuity | D1 (DB)                               | org_memory          | R               | **wired**                                        |\n| continuity | D1 (DB)                               | personal_memory     | R               | **wired**                                        |\n| continuity | R2 (FILES → integratewise-files-prod) | backup blobs        | R/W             | **placeholder** (D1→R2 export pending migration) |\n| continuity | Queue (continuity-triage)             | TASKS_QUEUE         | Produce+Consume | **wired**                                        |\n\n**Service Bindings:** KNOWLEDGE, PIPELINE\n\n---\n\n### WORKFLOW (`services/workflow/`)\n\n| Service  | Store Type                                  | Table/Namespace             | R/W     | Status                       |\n| -------- | ------------------------------------------- | --------------------------- | ------- | ---------------------------- |\n| workflow | D1 (DB → spine-cache)                       | tenant_spine_config         | R/W     | **wired**                    |\n| workflow | D1 (DB)                                     | spine_schema_registry       | R       | **wired**                    |\n| workflow | D1 (DB)                                     | connectors                  | R       | **wired**                    |\n| workflow | D1 (DB)                                     | actions                     | R       | **wired**                    |\n| workflow | D1 (DB)                                     | approval_queue              | R/W     | **wired**                    |\n| workflow | D1 (DB)                                     | audit_log                   | R/W     | **wired**                    |\n| workflow | D1 (DB)                                     | tenant_onboarding_state     | R/W     | **wired**                    |\n| workflow | D1 (DB)                                     | sync_jobs                   | R       | **wired**                    |\n| workflow | D1 (DB)                                     | entities                    | R       | **wired**                    |\n| workflow | D1 (DB)                                     | decide_data                 | R       | **wired**                    |\n| workflow | D1 (DB)                                     | bi_department_health        | R       | **wired**                    |\n| workflow | D1 (DB)                                     | bi_executive_metrics        | R       | **wired**                    |\n| workflow | D1 (DB)                                     | bi_founder_dashboard        | R       | **wired**                    |\n| workflow | D1 (DB)                                     | bi_cross_department_signals | R/W     | **wired**                    |\n| workflow | D1 (DB)                                     | bi_strategic_decisions      | R       | **wired**                    |\n| workflow | D1 (ANALYTICS_DB → integratewise-analytics) | conversion_events           | R/W     | **wired**                    |\n| workflow | D1 (ANALYTICS_DB)                           | performance_metrics         | R/W     | **wired**                    |\n| workflow | D1 (ANALYTICS_DB)                           | daily_aggregates            | R/W     | **wired**                    |\n| workflow | D1 (ANALYTICS_DB)                           | funnel_sessions             | R       | **wired**                    |\n| workflow | D1 (ANALYTICS_DB)                           | ab_test_assignments         | R       | **wired**                    |\n| workflow | KV (CONNECTION_META → 39608aa6...)          | WebSocket metadata          | R/W     | **wired**                    |\n| workflow | KV (RATE_LIMIT → 8f61d841...)               | rate limiting               | R/W     | **wired**                    |\n| workflow | KV (VIEW_CACHE — **NOT IN WRANGLER.TOML**)  | view cache                  | R/W     | **broken** (binding missing) |\n| workflow | DO (HITL_GATE)                              | HITL approval state         | R/W     | **wired**                    |\n| workflow | DO (SIGNAL_STREAM)                          | real-time signals           | R/W     | **wired**                    |\n| workflow | DO (PRESENCE)                               | user presence               | R/W     | **wired**                    |\n| workflow | DO (ROOM)                                   | room state                  | R/W     | **wired**                    |\n| workflow | Neon (FORTRESS_DATABASE_URL)                | Supabase auth/v1/user       | R       | **wired**                    |\n| workflow | Queue                                       | intelligence-act            | Produce | **wired**                    |\n\n**Service Bindings:** SPINE (→ pipeline), CONNECTOR, CONNECTOR_SYNC, KNOWLEDGE, THINK (→ intelligence), ACT (→ intelligence)\n\n---\n\n## Cross-Service D1 Table Ownership\n\n| D1 Table                                | Writers                           | Readers                             | Notes                            |\n| --------------------------------------- | --------------------------------- | ----------------------------------- | -------------------------------- |\n| spine-cache.tenant_spine_config         | pipeline, workflow, mcp-connector | continuity, knowledge, intelligence | Multi-writer conflict risk       |\n| spine-cache.entities                    | pipeline                          | workflow                            |                                  |\n| spine-cache.signals                     | pipeline, intelligence            | mcp-connector, pipeline             |                                  |\n| spine-cache.approval_queue              | pipeline, intelligence            | workflow, mcp-connector             |                                  |\n| spine-cache.audit_log                   | pipeline, intelligence, workflow  | workflow                            |                                  |\n| spine-cache.governance_data             | pipeline, intelligence            | workflow, mcp-connector             |                                  |\n| spine-cache.cross_data                  | pipeline                          | intelligence                        |                                  |\n| spine-cache.decide_data                 | pipeline                          | intelligence, workflow              |                                  |\n| spine-cache.document_chunks             | knowledge                         | intelligence                        |                                  |\n| spine-cache.ai_sessions                 | knowledge, mcp-connector          | intelligence, knowledge             |                                  |\n| spine-cache.ai_session_memories         | knowledge, mcp-connector          | intelligence, knowledge             |                                  |\n| spine-cache.conversational_memory       | intelligence                      | knowledge                           |                                  |\n| spine-cache.personal_memory             | — (placeholder?)                  | continuity, intelligence            | No active writer found           |\n| spine-cache.org_memory                  | — (placeholder?)                  | continuity, knowledge               | No active writer found           |\n| spine-cache.agent_registry              | mcp-connector                     | mcp-connector                       |                                  |\n| spine-cache.connector_catalog           | — (placeholder?)                  | workflow, mcp-connector             | No active writer found           |\n| spine-cache.context_boundaries          | mcp-connector                     | mcp-connector                       |                                  |\n| spine-cache.kb_artifacts                | — (placeholder?)                  | mcp-connector                       | No active writer found           |\n| spine-cache.kb_topic_policies           | mcp-connector                     | mcp-connector                       |                                  |\n| spine-cache.oauth_clients               | mcp-connector                     | mcp-connector                       |                                  |\n| spine-cache.oauth_refresh_tokens        | mcp-connector                     | mcp-connector                       |                                  |\n| spine-cache.spine_events                | mcp-connector                     | mcp-connector                       |                                  |\n| spine-cache.spine_entities              | pipeline (canonical)              | mcp-connector                       |                                  |\n| spine-cache.spine_schema_registry       | pipeline                          | workflow                            |                                  |\n| spine-cache.merge_candidates            | pipeline                          | pipeline                            |                                  |\n| spine-cache.entity_signatures           | pipeline                          | pipeline                            |                                  |\n| spine-cache.entity_cache                | pipeline                          | pipeline                            |                                  |\n| spine-cache.signal_cache                | pipeline                          | pipeline, intelligence              |                                  |\n| spine-cache.agent_memory                | pipeline                          | pipeline                            |                                  |\n| spine-cache.spine_vault                 | pipeline                          | pipeline                            |                                  |\n| spine-cache.actions                     | intelligence (govern)             | workflow, intelligence              |                                  |\n| spine-cache.evidence_refs               | intelligence                      | intelligence                        |                                  |\n| spine-cache.situations                  | intelligence                      | intelligence                        |                                  |\n| spine-cache.action_proposals            | intelligence                      | intelligence                        |                                  |\n| spine-cache.agent_decisions             | intelligence                      | intelligence                        |                                  |\n| spine-cache.continuity_loop             | intelligence                      | intelligence                        |                                  |\n| spine-cache.decision_memory             | intelligence                      | intelligence                        |                                  |\n| spine-cache.source_reliability          | intelligence                      | intelligence                        |                                  |\n| spine-cache.trust_scores                | intelligence                      | intelligence                        |                                  |\n| spine-cache.autonomy_overrides          | intelligence                      | intelligence                        |                                  |\n| spine-cache.signal_rules                | intelligence                      | intelligence                        |                                  |\n| spine-cache.situation_escalation_rules  | intelligence                      | intelligence                        |                                  |\n| spine-cache.ai_insights_buffer          | intelligence                      | intelligence                        |                                  |\n| spine-cache.dlq_entries                 | intelligence                      | intelligence                        |                                  |\n| spine-cache.spine_metrics               | — (placeholder?)                  | intelligence                        | No active writer found           |\n| spine-cache.events                      | — (placeholder?)                  | intelligence                        | No active writer found           |\n| spine-cache.artifact_links              | — (placeholder?)                  | intelligence                        | No active writer found           |\n| spine-cache.emails                      | — (placeholder?)                  | intelligence                        | No active writer found           |\n| spine-cache.drive_files                 | — (placeholder?)                  | intelligence                        | No active writer found           |\n| spine-cache.brainstorm_sessions         | — (placeholder?)                  | intelligence                        | No active writer found           |\n| spine-cache.brainstorm_insights         | — (placeholder?)                  | intelligence                        | No active writer found           |\n| spine-cache.session_entity_links        | mcp-connector, intelligence       | —                                   |                                  |\n| spine-cache.tenant_onboarding_state     | workflow                          | workflow                            |                                  |\n| spine-cache.sync_jobs                   | — (placeholder?)                  | workflow                            | No active writer found           |\n| spine-cache.bi_department_health        | — (placeholder?)                  | workflow                            | No active writer found           |\n| spine-cache.bi_executive_metrics        | — (placeholder?)                  | workflow                            | No active writer found           |\n| spine-cache.bi_founder_dashboard        | — (placeholder?)                  | workflow                            | No active writer found           |\n| spine-cache.bi_cross_department_signals | — (placeholder?)                  | workflow                            | No active writer found           |\n| spine-cache.bi_strategic_decisions      | — (placeholder?)                  | workflow                            | No active writer found           |\n| spine-cache.document_chunks             | knowledge                         | knowledge, intelligence             |                                  |\n| spine-cache.search_history              | knowledge                         | knowledge                           |                                  |\n| spine-cache.consolidated_memories       | knowledge                         | knowledge                           |                                  |\n| spine-cache.embeddings                  | knowledge                         | knowledge                           |                                  |\n| spine-cache.ai_conversations            | knowledge                         | knowledge                           |                                  |\n| spine-cache.ai_messages                 | knowledge                         | knowledge                           |                                  |\n| spine-cache.ai_memories                 | knowledge                         | knowledge                           |                                  |\n| spine-cache.triage_results              | knowledge                         | knowledge                           |                                  |\n| canonical-spine.spine_entities          | pipeline                          | pipeline                            | **PLACEHOLDER** — DB not created |\n| canonical-spine.spine_timeline          | pipeline                          | pipeline                            | **PLACEHOLDER**                  |\n| canonical-spine.spine_relationships     | pipeline                          | pipeline                            | **PLACEHOLDER**                  |\n| spine.productions.connections           | spine                             | spine                               |                                  |\n| spine.productions.connectors            | spine                             | spine                               |                                  |\n| spine.productions.sync-jobs             | spine                             | spine                               |                                  |\n| spine.productions.webhooks              | spine                             | spine                               |                                  |\n| spine.productions.schemas               | spine                             | spine                               |                                  |\n| spine.productions.capabilities          | spine                             | spine                               |                                  |\n| spine.productions.timeline-events       | spine                             | spine                               |                                  |\n| analytics.conversion_events             | workflow                          | workflow                            |                                  |\n| analytics.performance_metrics           | workflow                          | workflow                            |                                  |\n| analytics.daily_aggregates              | workflow                          | workflow                            |                                  |\n| analytics.funnel_sessions               | — (placeholder?)                  | workflow                            | No active writer found           |\n| analytics.ab_test_assignments           | — (placeholder?)                  | workflow                            | No active writer found           |\n| Neon.governance_policies                | intelligence                      | intelligence                        |                                  |\n| Neon.actions                            | intelligence                      | intelligence                        |                                  |\n\n---\n\n## Issues Found\n\n1. **PIPELINE `env.DB` — BROKEN BINDING**: pipeline/src/spine/index.ts and entity360-assembler.ts reference `env.DB` but wrangler.toml only defines `CACHE_DB` and `CANONICAL_SPINE_DB`. The `DB` binding for D1 is missing → entity_cache, signal_cache, cross_data, and 10+ other tables are inaccessible.\n\n2. **PIPELINE CANONICAL_SPINE_DB — PLACEHOLDER**: database_id = \"YOUR_D1_DATABASE_ID_HERE\" — the canonical spine D1 was never created.\n\n3. **WORKFLOW `VIEW_CACHE` — BROKEN BINDING**: views.ts uses `env.VIEW_CACHE.get/put` but wrangler.toml has no VIEW_CACHE KV binding.\n\n4. **MULTI-WRITER CONFLICT on `tenant_spine_config`**: pipeline, workflow, and mcp-connector all write to the same D1 table. No locking or conflict resolution strategy visible.\n\n5. **ORPHAN TABLE READERS**: Multiple tables have readers but no visible writers (spine*metrics, events, artifact_links, emails, drive_files, brainstorm*\\_, bi\\_\\_, sync_jobs, funnel_sessions, ab_test_assignments, org_memory, personal_memory, connector_catalog, kb_artifacts). These are either populated by external processes, migrations not yet run, or are dead code.\n\n6. **CONTINUITY R2 — PLACEHOLDER**: The R2 backup export is commented as \"pending AI Search migration\" (line 735 of continuity/src/index.ts).\n\n7. **SHARED D1 DATABASE**: 6 of 7 services share the same `integratewise-spine-cache` D1 database, creating contention and making table ownership unclear.\n"}