04/Knowledge (RAG)

Datasources & Relations

Connecting databases and defining relations between them.

You can connect PostgreSQL, MySQL or ClickHouse datasources to a project. Schema introspection extracts tables/fields. On the canvas in the Datasources tab you draw relations (field↔field, table↔table, DB↔DB) by dragging between tables.

Each relation is assigned a type (one-to-one, one-to-many, many-to-many, semantic) and a description. These relations are used in the RAG build and the MCP server.

The relation canvas can be worked on in fullscreen; the "Relation type" picker in the relation editor opens correctly in fullscreen too.