AI agents for data · open-source platform · any source, warehouse or BI tool

One sentence in.
Certified pipeline and dashboard out.

AI agents that build, run, check and fix governed data pipelines, then answer the questions the data was for. You write one sentence. They ask one question back.

Skip to the failure
odf/studio kernel · ready replay paused
Watch as
CodePreviewFlow
session files
Studio agent · acts only through typed, approval-gated tools
stage 1 / 10
Recorded session · real lineage and error logs · timings compressed · data loaded 5 Nov 2026
Built from skills, not scripts

The agent knows the job because the platform encodes it.

Each stage is backed by a skill: reviewable knowledge the agent loads before it acts. Skills are data, not code.

01 · ingestion

Source skills

One card per system: auth, limits, watermarks and the few questions only you can answer. Four connectors proven end to end, two scaffolded, 31 more cards ready.

  • Postgres
  • Oracle
  • SQL Server
  • SEC EDGAR
  • Zuora
  • any JDBC database
  • + 31 more
02 · modeling

Modeling skills

Star schemas, SCD2 history and metrics defined once. You approve the design before any table exists.

  • grain
  • dimensions
  • SCD2
  • metrics
03 · operations

QA & debug skills

Full, incremental, updates, deletes, drift and re-runs, each checked against the lineage log, not task status.

  • lineage
  • error log
  • task logs
  • drift
04 · insight

Analytics skills

Read-only SQL, a Python kernel and published dashboards. Every number ships with its query and source.

  • SQL
  • Python
  • Superset or your BI tool
  • notebooks
Why you can let an agent build pipelines

The agent fills in a contract. The engine enforces the rules.

A pipeline is a typed contract with a small set of allowed choices. The guarantees live in the engine, so they hold no matter who wrote the contract.

{ }

A constrained action space

Invalid options are rejected when the contract is built, before anything runs.

⛨

Governance is not optional

Lineage, drift detection and error capture run for every pipeline. A contract can't switch them off.

◫

Plan before anything runs

plan() shows exactly what will change. Writes, runs and publishing wait for a person to approve.

✓

Evidence, not task status

Done means Airflow, the lineage log and the warehouse row counts all agree.

⇄

Any source, any warehouse

A new source is three small files. A new warehouse is one adapter. No vendor lock-in.

⌂

Runs where your data lives

Airflow, PostgreSQL, Superset and JupyterHub in your own cloud. Credentials never pass through chat.

Lineage · data quality · governance, built in

How you know the data landed correctly.

Every table goes through extract, validate and store, and the engine records each step. "It ran" is never the claim. "It reconciles" is.

01 · EXTRACT

Read the source, protect it

  • Schema checked against the registry before any rows are read
  • Drift handled the way the contract declares
  • Batched reads that don't overload the source
  • Rows counted in the lineage log
02 · VALIDATE

Gate before anything is stored

  • Missing or duplicate keys fail the load
  • Your own rule: validate_sql must return 0
  • A sharp drop in row count raises an alert
03 · STORE

Merge by hash, keep history

  • Only changed rows are touched
  • Deletes are stamped, never silently lost
  • SCD2 history in the same transaction
  • Counts and failures logged
gate: stops the loadalertrecorded automatically
The reconciliation from the session aboveodf_data_lineage_log vs. the warehouse
tableextractedvalidatedstoredwarehouse
Run 1: stopped, not certified
companies1111✓
filings4040——✕
facts6,2476,247——✕
documents4343——✕
Run 2: after the fix
companies1111✓
filings40404040✓
facts6,2476,2476,2476,247✓
documents43434343✓
Run 1: three tables never stored, and odf_error_log said why. The agent fixed the contract and re-ran. Run 2 certified only when every count agreed.

Every row can explain itself

Governance columns on every row trace any dashboard value back to its run and source.

odf_job_idthe run that wrote it
odf_row_keythe business key
odf_row_hashcontent fingerprint for change detection
odf_extracted_atfreshness
odf_deleted_atwhen it left the source
lineage logparameters logschema registryschema change logerror log
One platform, four perspectives

Engineers, analysts, scientists and leaders on the same governed tables.

The pipeline, the notebook and the dashboard all read the same certified data, with lineage back to the source.

Data engineer

Pipelines on Airflow

Per-table tasks, plans and approvals before deploy, and agent-led debugging with evidence.

Watch as an engineer
Analyst

Dashboards & SQL

Metrics defined once, dashboards with definitions and lineage, and the SQL behind every answer.

Watch as an analyst
Data scientist

Notebooks & Python

Notebooks on the same workspace and kernel as the agent, so its work can be re-run.

Watch as a data scientist
Business leader

Control & time to insight

Every action approved and audited, one governance standard, and answers with their evidence.

Watch as a business leader

More pipelines. Fewer tickets. Nothing you can't trace.

Bring one system and one question. We'll take it to a certified dashboard in one session.

Book a demo