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

# SQL IDE, Enhanced Query Execution, and Strict YAML Validation

> Comprehensive SQL development environment with keyboard shortcuts and improved configuration validation

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

### New Features

#### SQL IDE

Comprehensive SQL development environment integrated into the Oxygen IDE:

* **Multi-Tab Query Editor** - Monaco-based SQL editor with syntax highlighting and multi-tab support for managing multiple queries simultaneously
* **Database Client Store** - Centralized database connection management with query workspace state
* **Schema Browser** - Explore database schemas, tables, and columns directly in the sidebar
* **Restructured IDE Navigation** - Separate sections for Files, Database, Settings, and Observability with dedicated routing
* **Backend Execution** - New endpoints for SQL query execution and cached database metadata retrieval

<img src="https://mintcdn.com/oxy-internal/R76n0IeoaiNFtOa4/changelog/images/2026-02-05/sql-ide.png?fit=max&auto=format&n=R76n0IeoaiNFtOa4&q=85&s=04e751fbf62daac3a1c211e81885a191" alt="" width="2052" height="2584" data-path="changelog/images/2026-02-05/sql-ide.png" />

#### Execute SQL Query Shortcut

Keyboard shortcut for faster query execution:

* **Cmd/Ctrl+Enter Keybinding** - Execute SQL queries directly from the Monaco editor without clicking Run button
* **Proper Cleanup** - Monaco command and keybinding registrations properly cleaned up on component unmount
* **Integrated Workflow** - Keyboard shortcut wired to existing Run behavior for seamless experience

#### Strict YAML Validation

Enhanced configuration validation to catch errors early:

* **Deny Unknown Fields** - Added `#[serde(deny_unknown_fields)]` to Config, Workflow, AppConfig, and Semantics structs to reject typos at parse time
* **Common Error Prevention** - Catches mistakes like using `steps:` instead of `tasks:` in workflow files
* **Enhanced CLI Validation** - `oxy validate` command now supports `--file` flag for single-file validation with improved error reporting that continues after errors
* **Simplified Parsing** - Removed redundant intermediate structs for cleaner configuration loading

***

### Platform Improvements

#### SQL Query Result Handling

* **Forced Parquet Format** - All SQL query results now use Parquet format instead of optional JSON, enabling VirtualizedTable with built-in paging and sorting
* **Result Table State Reset** - Added `key` prop to VirtualizedTable to properly reset state (page, sort, selections, column widths) when displaying new results
* **Timezone Support** - Extended dayjs with timezone and UTC plugins for proper handling of Arrow timestamp types with timezone information

#### Semantic Query Improvements

* **Execution Error Clearing** - Fixed issue where execution errors persisted after query became valid by clearing error state on successful execution

#### Semantic Engine Container Management

* **Volume Mount Validation** - Cube.js container startup now validates and reconciles existing volume mounts, recreating container if binds don't match
* **Database URL Requirement** - `oxy semantic-engine` command now requires `OXY_DATABASE_URL` environment variable with earlier runtime availability check
* **Improved Reliability** - Better container lifecycle management prevents configuration drift

#### Dependencies Update

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