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

# Ontology View, Agentic Workflows, PostgreSQL Migration, and Automation Renaming

> Interactive graph visualization of your entire data project:

<Icon icon="calendar" iconType="regular" size={16} /> **December 18, 2025**

### New Features

#### Ontology View

Interactive graph visualization of your entire data project:

* **Asset Mapping** - Visual representation of all project components: data assets (tables, views, topics, entities), AI assets (agents), automation assets (workflows, apps), and SQL queries
* **Relationship Discovery** - See how data flows through your system from database tables → views → topics → agents/automations
* **Quick Navigation** - Click any node to view details and jump directly to the file in the IDE
* **Impact Analysis** - Understand dependencies before making changes to avoid breaking connections
* **Focused Filtering** - Filter by specific asset types to isolate particular areas of your project
  The Ontology view provides a complete visual index of your Oxygen project, making it easier to understand, navigate, and maintain your data infrastructure. It's essentially a "map" of your entire data ecosystem showing how AI agents, automations, and data models work together.

<img src="https://mintcdn.com/oxy-internal/qygWo0nXJD2A89_J/changelog/images/2025-12-18/24698.png?fit=max&auto=format&n=qygWo0nXJD2A89_J&q=85&s=1bfa45359149c9f781bcb2b54e4cea6c" alt="Image" width="2844" height="2576" data-path="changelog/images/2025-12-18/24698.png" />

<img src="https://mintcdn.com/oxy-internal/qygWo0nXJD2A89_J/changelog/images/2025-12-18/38442.png?fit=max&auto=format&n=qygWo0nXJD2A89_J&q=85&s=88cafeea132546f1f07a13465fe0b073" alt="Image" width="2344" height="2546" data-path="changelog/images/2025-12-18/38442.png" />

#### Agentic Workflows

Autonomous agent-driven workflows with dynamic decision making:

* **Finite State Machine Architecture** - Structured state transitions with start, end, and intermediate states instead of fixed task sequences
* **Autonomous Decision Making** - Agents select which transition to execute based on context and LLM reasoning
* **Multi-Step Reasoning** - Iterative reasoning with plan revision and error recovery capabilities
* **Dynamic Execution** - Non-linear flow based on agent intelligence rather than predefined sequences
  **File Extension**: `.aw.yml`

**Available Transitions**: Query execution, visualization creation, insight generation, data app building, and sub-workflow execution

Agentic workflows enable interactive data exploration, adaptive dashboards, multi-step analytics, and natural language question answering over data. Unlike traditional workflows (DAGs), agentic workflows use FSM architecture allowing agents to autonomously navigate complex processes.

Example configuration:

yaml

`start:  mode: plan  instruction: |    You are a Data Analyst expert...  next: [query, visualize, insight, data_app]transitions:  - type: query  - type: visualize  - type: insightend:  mode: synthesize  output_artifact: app`

<img src="https://mintcdn.com/oxy-internal/qygWo0nXJD2A89_J/changelog/images/2025-12-18/57527.png?fit=max&auto=format&n=qygWo0nXJD2A89_J&q=85&s=5ff1fee0c013e973180da0f5490e6765" alt="Image" width="2326" height="2056" data-path="changelog/images/2025-12-18/57527.png" />

<img src="https://mintcdn.com/oxy-internal/qygWo0nXJD2A89_J/changelog/images/2025-12-18/11338.png?fit=max&auto=format&n=qygWo0nXJD2A89_J&q=85&s=34d7303ccaac76d5e13e426367633e1e" alt="Image" width="2338" height="2496" data-path="changelog/images/2025-12-18/11338.png" />

#### PostgreSQL as the exclusive database solution

Full transition from SQLite to PostgreSQL as the exclusive database solution:

* **Zero-Config Local Development** - New `oxy start` command manages PostgreSQL in Docker with no manual setup required
* **Docker Abstraction** - Docker runtime fully abstracted away (only requirement: Docker installation)
* **Migration Tooling** - Comprehensive `oxy migrate-sqlite` command for seamless transition from existing SQLite databases
* **Status Monitoring** - New `oxy status` command to check PostgreSQL service health
* **Backward Compatible** - `oxy serve` continues to work as usual, but we heavily encourage users to migrate to PostgreSQL as soon as possible
  The PostgreSQL setup runs inside Docker while `oxy serve` runs on the host machine, providing enterprise-grade database capabilities with the simplicity of SQLite

<img src="https://mintcdn.com/oxy-internal/qygWo0nXJD2A89_J/changelog/images/2025-12-18/25977.png?fit=max&auto=format&n=qygWo0nXJD2A89_J&q=85&s=deddc9c62c54fcb143c248e8daeb78b9" alt="Image" width="1160" height="710" data-path="changelog/images/2025-12-18/25977.png" />

#### Automation Renaming

Conceptual update for clarity:

* **Workflows → Automations** - Workflows are now called automations to better reflect their purpose
* **File Extension Change** - `.workflow.yml` is now `.automation.yml`
* **Consistent Terminology** - Updated documentation and UI to reflect automation terminology

### Platform Improvements

* **Dependencies Update** - Updated all dependencies and rust to latest versions for improved performance and security
