> ## Documentation Index
> Fetch the complete documentation index at: https://schemabrain.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# list_joins

> Every confirmed canonical relationship with the entity pair it connects.

<Note>
  **Layer:** Semantic layer
</Note>

Returns every confirmed canonical relationship with the entity pair it connects and its provenance. The agent uses this to discover available bridges across the semantic layer.

```json theme={null}
{
  "name": "customer_orders",
  "description": "Each order belongs to the customer who placed it.",
  "source_entity": "customer",
  "target_entity": "order",
  "origin": "suggested",
  "via_junction": null,
  "via_joins": []
}
```

Returns `status="empty"` with `follow_up_hints: ["find_relevant_tables"]` when no canonical joins exist in the store. Actionable next step is physical schema discovery.