Architecture draft

Architecture Overview

Metoriq is a metadata-driven integration platform designed to define, govern, and execute data integrations from a server-side runtime.

Product direction

Metoriq treats integrations as governed metadata instead of scattered scripts or isolated jobs.

The current product is still in active development. The foundation is focused on the control plane and metadata catalog before real data movement and flow execution are introduced.

Core principles

Server-side execution

CLI, scripts, and future UI surfaces are clients. Integrations are intended to run on the Metoriq server.

Metadata-driven design

Relevant configuration should be represented as metadata that can be versioned, audited, and governed.

PostgreSQL as initial engine

PostgreSQL is the initial foundation for internal metadata and future execution workspace.

Extensible connectors

Sources and destinations should be added through contracts, SDKs, and plugins.

Conceptual shape

CLI / VS Code / future Web UI
        |
        v
Metoriq Server
  + Metadata Catalog
  + Runtime / Orchestrator
  + Connector Contracts
  + PostgreSQL Workspace
  + Logs / Audit / Docs

Important boundaries

Entity Framework Core is reserved for the internal metadata/control database.
RAW data, staging tables, dynamic transformations, and bulk data movement are part of the data plane and should not use EF Core.
The metadata database belongs to the Metoriq installation, not to a single tenant or environment.
Tenants and environments are logical entities inside the metadata database.