Entity relationship diagram

The following diagram is intentionally abstract. It shows the relationships that are relevant for understanding the extension, not every database field.

erDiagram
    AI_CONNECTION ||--o{ ASSISTANT_PROFILE : used_by
    VECTOR_STORE_CONNECTION ||--o{ ASSISTANT_PROFILE : used_by
    ASSISTANT_PROFILE ||--o{ PIPELINE_STEP : contains
    AI_CONNECTION ||--o{ INDEXER_CONFIG : creates_embeddings
    VECTOR_STORE_CONNECTION ||--o{ INDEXER_CONFIG : stores_vectors
    INDEXER_CONFIG ||--o{ INDEXER_RUN : creates
    INDEXER_CONFIG ||--o{ INDEXER_SOURCE : tracks
    ASSISTANT_PROFILE ||--o{ PIPELINE_TRACE : writes
    PIPELINE_STEP ||--o{ PIPELINE_TRACE : writes

Conceptual tables

Assistant configuration: Assistant profiles and pipeline steps.
Connection configuration: AI and vector store connections.
Indexing configuration: Indexer configurations, external connector settings, indexer runs and source states.
Runtime diagnostics: Pipeline traces and backend diagnostics.