> ## 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.

# PostgreSQL-Only Architecture, Enhanced Oxygen Start, and Developer Portal Improvements

> Streamlined database backend with enterprise mode for local development and improved settings navigation

<Icon icon="calendar" iconType="regular" size={16} /> **January 29, 2026**

### New Features

#### Enhanced Oxygen Start Command

Comprehensive improvements to local development environment management:

* **Clean Start Option** - New `--clean` flag removes all Oxygen-managed Docker containers, volumes, and networks before starting fresh
* **Enterprise Mode** - New `--enterprise` flag automatically starts additional services: ClickHouse for observability, OpenTelemetry Collector for tracing, and Cube.js semantic engine for analytics
* **Parallel Service Startup** - All Docker services start in parallel with automatic environment variable configuration
* **Lifecycle Management** - Proper shutdown and cleanup for all enterprise containers
* **Pinned Dependencies** - OpenTelemetry Collector image pinned to version 0.144.0 for consistency

Example usage:

```bash theme={null}
oxy start --enterprise --clean  # Fresh enterprise environment
```

#### Migrated Settings to Developer Portal

Improved navigation and discoverability for key platform features:

* **Dedicated IDE Pages** - Database management and activity logs moved from modal-based settings to full pages in the developer portal
* **New Settings Section** - Added Settings section to IDE sidebar with Databases and Activity Logs navigation
* **Consistent Page Headers** - New reusable `PageHeader` component standardizes headers across IDE sections including observability pages
* **Better User Experience** - Enhanced discoverability and more space for detailed management interfaces

***

### Breaking Changes

#### PostgreSQL-Only Database Support

Complete removal of SQLite support to streamline the platform:

* **PostgreSQL Required** - PostgreSQL is now the only supported database backend
* **Simplified Codebase** - Removed all SQLite-related code paths from SeaORM configs, SQLx implementations, and migration logic
* **Removed Migration Tools** - SQLite-to-PostgreSQL migration tooling removed; users must complete migration before upgrading
* **Updated Documentation** - All references to SQLite removed from docs, CI workflows, and configuration examples

**Migration Options:**

Users have two options for running Oxygen with PostgreSQL:

1. **Use `oxy start`** - Automatically manages PostgreSQL in Docker with all environment variables configured
2. **Use `oxy serve`** - Connect to external PostgreSQL by setting `OXY_DATABASE_URL` environment variable

PostgreSQL provides enterprise-grade capabilities with better performance, reliability, and feature support for production deployments.

***

### Platform Improvements

#### Semantic Query Artifact Handling

* **Streamlined Artifact Flow** - Semantic Query artifacts now driven by `Output::SemanticQuery` / `Content::SemanticQuery` directly instead of reconstructing from SQL/Table events
* **Simplified Event Model** - Removed `SemanticQueryGenerated` event and related parameter tracking
* **Consistent Display** - Updated core/app block handlers, artifact tracker, and web UI to align with new artifact payload structure

#### Build Command Fixes

* **Fixed `oxy build` Execution** - Resolved build failures by avoiding unnecessary `RunsManager` initialization during Omni sync
* **Regression Tests** - Added CLI integration tests to verify `oxy build` succeeds and creates expected `.semantics` output
* **Flag Coverage** - Added test case for `--drop-all-tables` build flag

#### Observability UI Improvements

* **Bug Fixes** - Addressed various UI issues in observability pages
* **Enhanced Charts** - Improved chart display and visualization components

#### Dependencies Update

* **Latest Versions** - Updated Rust and all dependencies to latest versions for improved performance and security