How Orloi works ​

Orloi watches selected Airtable activity, processes it into durable operational history, and writes that history to your Postgres database.

text
Airtable base
  |
Orloi capture service
  |
Postgres orloi schema
  |
Dashboard, SQL, BI, AI agents

Your Postgres database is the durable system of record for Orloi output. The dashboard and agent workflows read from the same stored history.

Data flow ​

Orloi starts with the Airtable base and scope you select. Scope can include the base, selected tables, and field-level exclusions where configured.

After activation, Orloi captures new source activity and stores raw changelog events in the dedicated orloi schema. It then creates more readable compacted events and derived layers such as reports, metrics, process summaries, and dashboard signals.

Orloi only starts capture after the Postgres destination has been installed and verified.

If Postgres installation or verification fails, Orloi does not start capture.

AI path ​

AI features use stored operational history to generate reports, summaries, and interpretation. They are not required for raw capture or deterministic metrics.

text
Compacted events and context
  |
Configured AI provider and privacy mode
  |
Reports and derived views
  |
Stored back in your Postgres database

AI is not required for the core changelog. Raw events, compacted events, and deterministic metrics remain useful when AI features are disabled.

Ways to use the stored history ​

Most teams start with the dashboard. It shows freshness, recent activity, metrics, reports, alerts, and process signals without requiring SQL.

Teams that want more control can query Postgres directly, connect BI tools, or give an AI agent read-only access to selected orloi objects.

What Orloi does not do by default ​

  • Orloi does not capture activity before activation.
  • Orloi does not backfill historical Airtable activity unless separately imported.
  • Orloi does not modify your existing application tables.
  • Orloi does not write back to Airtable.
  • Orloi does not require the default dashboard to be used.